Inside Excel - Learn 23 Essential Excel Skills the Pros Know | Steve McDonald | Skillshare

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

About This Class

You don't have to know everything there is to know about Excel. But, there are a few things the pros know that you'll want to know, too.

Most of these skills are easy to learn and they will enable you to use Excel in a much more powerful way.

If you use Excel regularly but you don't feel the sense of confidence and efficiency that you wish you did, this course is for you. It's designed to teach you the 23 Excel skills that will give you the biggest advantage with the least amount of effort when you use Excel.

Based on my research and experience, these 23 Excel skills are the most important and useful skills you can learn beyond the basics of creating a spreadsheet.

Most of them are easy to learn, and offer huge returns in efficiency for the small time they take to learn.

A few of them will take a little more practice, but I've included them because they can be immensely powerful in ways that many experienced Excel users don't realize.

You know how to use Excel. You've get the basics down.

Now it's time to learn the 23 essential skills the Excel Pros know!