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