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
12 students are watching this class

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!

65

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

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.

Steve McDonald

Author, Instructor, Digital Entrepreneur

I believe that learning can be easy if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.

Whether I am teaching How I Retired Early Publishing Kindle eBooks or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.

For over 10 years I have studied strategies to create pa...

See full profile

Report class