Inside Excel - Learn 23 Essential Excel Skills the Pros Know

Steve McDonald, Author, Instructor, Digital Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Lessons (2h 15m)
    • 1. Intro - Know What the Pros Know

      1:35
    • 2. Quick Calculations with the Status Bar

      3:38
    • 3. Insert Multiple Rows or Columns Easily

      4:52
    • 4. Hide and Show Rows, Columns and Entire Worksheets

      3:00
    • 5. Freeze the Top Row of Your Spreadsheet

      3:11
    • 6. Sort and Filter

      4:44
    • 7. Flash Fill and Auto Fill for Fast Data Entry

      5:25
    • 8. Shortcut Keystrokes the Pros Know

      8:47
    • 9. Shortcut Keystrokes Using the ALT Key

      4:57
    • 10. Absolute vs. Relative Cell References

      6:46
    • 11. Paste Special

      16:24
    • 12. Conditional Formatting

      8:46
    • 13. Layout Pages and Print Like a Boss

      4:38
    • 14. Find and Delete Empty Cells Located Outside of Your Data

      5:46
    • 15. Use ROUND to Fix Money Math Errors

      13:23
    • 16. Use Tables Like a Pro

      19:58
    • 17. Use INDEX/MATCH Instead of VLOOKUP

      9:37
    • 18. Mail Merge with MS Word and Excel

      9:19
14 students are watching this class
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!