Microsoft Excel Masterclass: Complete and Concise

The most comprehensive Excel course, covering important topics such as Pivots, Data visualization, Macros & Analytics

What You'll Learn

• Solid understanding of Microsoft Excel
• Knowledge of all the essential Excel formulas
• Become proficient in data tools like Sorting, Filtering, Data validations and Data importing
• Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
• Harness full potential of Excel by creating Pivot tables with slicers
• Make great presentations using the Conditional and Table formatting options

Requirements

• You will need a PC with any version of Excel installed in it

Welcome to the Microsoft Excel Masterclass course.

The course is created on the basis of three pillars of learning:

1. Know (Study)

2. Do (Practice)

3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.

Do

With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.

Apart from this, explore fun and exciting use cases of Excel in our bonus videos.

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of Excel in today's corporate world.