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

 

 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

 

 Conclusion

 

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