Learn to use Microsoft Excel like a Pro – Advanced Level

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

If you already have some intermediate knowledge of Microsoft Excel, or just completed the “Learn to use Microsoft Excel like a Pro” at the Intermediate Level, take this course “Learn to use Microsoft Excel like a Pro” at the Advanced Level to:

  •     Learn To Use Excel Like The Professionals
  •     VLookUp and Advanced VLookUps.
  •     Index and Match and Advanced Index and Match
  •     Track workbooks between teams
  •     Automate, streamline, and completely revolutionize your workflow with Excel

What Will You Learn?

  • Excel - Advanced
  • Working with Multiple Workbooks
  • Protecting Worksheets and Workbooks
  • Conditional Formulas
  • Advanced Functions
  • Text Based Functions
  • What IF Tools
  • Excel Advanced - Conclusion
  • Bonus # 1 - Advanced Pivot Tables

Course Content

Excel – Advanced

  • Excel Advanced Introduction
    01:40
  • Advanced Shortcut Keys
    02:58
  • Excel Advanced Resources
    10:00

Working with Multiple Workbooks

Protecting Worksheets and Workbooks

Conditional Formulas

Advanced Functions

Text Based Functions

What IF Tools

Excel Advanced – Conclusion

Bonus # 1 – Advanced Pivot Tables

Earn a certificate

Add this certificate to your resume to demonstrate your skills & to boost your expertise gained.

selected template