Excel PRO TIPS Part 1: Productivity

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Lessons (1h 45m)
    • 1. Course Structure & Outline

      1:58
    • 2. Setting Expectations

      1:45
    • 3. Productivity Tips Intro

      0:29
    • 4. Customizing the Footer

      4:03
    • 5. CTRL Shortcuts

      8:01
    • 6. ALT Key Tips

      6:53
    • 7. "Go To" Special Options

      4:36
    • 8. Removing Blank Rows

      3:17
    • 9. Data Validation Drop-Downs

      7:11
    • 10. Autofill & Flash Fill

      8:26
    • 11. Customizing the Ribbon

      6:53
    • 12. Splitting Text to Columns

      7:39
    • 13. Synchronous Scrolling

      2:58
    • 14. Extracting Unique Values

      4:06
    • 15. Named Range & Table References

      8:12
    • 16. Protecting Cells & Formulas

      8:09
    • 17. Multi-Level Row & Column Sorting

      10:54
    • 18. Advanced Filter Criteria

      9:27
14 students are watching this class

Project Description

You may follow along with the demos using the attached PDF file (Excel Pro Tips for Power Users). To access the Excel project files and source data, please consider enrolling in the full course at courses.excelmaven.com.

Student Projects