Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)

Become the master of Excel Pivot Tables | MS Excel | 2021 course


What you’ll learn

  • Learn about PivotTable and use it for analysis.
  • Learn Excel by doing using practical examples.
  • Learn how to perform basic calculations.

Course Content

  • Getting Started with Excel –> 4 lectures • 20min.
  • Data entry, Editing and AutoFill –> 2 lectures • 12min.
  • Formulas and Functions –> 4 lectures • 24min.
  • PivotTables in Excel –> 5 lectures • 26min.
  • Summarizing PivotTable Data –> 10 lectures • 35min.

Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)


  • Basic understanding of Formulas using Excel will be helpful, but not a must.


This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time.

This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.

What makes me qualified to teach you?

My name is Mozn and I’ve been a professional instructor for over a decade. Plus I’m the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:

***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. – Diana

***** Simple quick into to excel. Please add some more lectures similar to this :). – Geraldine

***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. – Dianne

What is this Excel course about?

In this guide to Microsoft Excel course, you’ll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.

This course will cover Beginners, Intermediate and Advanced levels of Excel, including:

  • The basics of MS Excel
  • The powerful tool of PivotTables
  • Creating and Managing PivotTablesLearn from someone who is currently working in the industry, who knows the most current teaching techniques.

By the end of this course, your confidence as Data analyst using Excel will soar. You’ll have a thorough understanding of how to use Excel in a business or personal environment.

Go ahead and click the enroll button, and I’ll see you in lesson 1!

I wish you an enjoyable journey with us.

Shukran! Mozn