Mastering Excel Reports and Data Analysis

Welcome to this course on Tables, Conditional Formatting and Excel formulas.  This course is for all Excel users who want to take their Excel skills and capabilities to the next level. 

This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets.  The course is presented in an easy to follow step by step approach.  The course also includes practical activities for you to practice the skills that you have been learnt on the course.

Mastering Excel Reports and Data Analysis



 Introduction to Pivot Tables


 Introduction to the Course


 Training Data


 Correctly Structure Data


 Using Tables as a Data Source


Creating Excel Pivot Tables


 Introduction to Creating your First Pivot Table


 Create a Pivot Table


 Create PivotTable with More Than One Dimension


 More than One Measure


 Change Number Formats


 Changing the Custom Number Format


 Change Region and Language


Pivot Table Menu Options


 Introduction to Pivot Table Menu Options


 Pivot Table Menu Options


 Pivot Table Design


Changing the Method of Aggregation


 Changing the Method of Aggregation


 Method of Aggregation


 Sorting Data in a Pivot Table


Trend – Time Analysis with Pivot Tables


 Introduction to Time Analysis


 Time Analysis with Pivot Tables


 Create Management Reports


 Custom Time Formulas


 Using Sparklines to Analyse trends


Filtering Pivot Tables


 Introduction to Filtering Data


 Filter Text Fields


 Top  Analysis


 Using the Report Filter


 Using Slicers to Filter Data


 Using Slicers to Filter Multiple Pivot Tables


Show Value As Calculations


 The Show Value As Calculations


 Percentage Calculation


 Show Value As Percentage of Parent Row Total


 Difference From and Ranking


 Pareto Analysis


 Percentage of Calculation


Frequency Analysis


 Introduction to Frequency Analysis


 Employee Master


 Frequency Analysis


Custom Calculations


 Creating Custom Calculations


 Create a Custom Calculation




More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us