-
Duration – 15 hours

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.
All MS EXCEL Courses bundle
$40
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
Â
300+ Courses
After your course completion, we provide course completion certificate as well.
Lifetime Access
All courses are for lifetime access.
Priority Support
All queries are answered 24/7.
What People Are Saying

Abhilash -
A very good match. i am enjoying every bit.

Sonal-
Experience was quite good and it was very useful and well elaborated course.

Karan-
I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-
I find that the explanation is good and also understandable.

Seyed-
Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-
I really like this course, it was a good match for me :))

Mahesh-
Standard process and hands on covered nicely.

Emily-
Perfect, with complete hands on. Well structured and nicely covered.

Kevin-
Great Content, nice and up to the mark course.

Mayuresh-
Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-
A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-
Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-
This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -
A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-
Yes lessons are very good. Not so fast, well explained

Kishore-
Worth course for the beginner to invest their time to learn this demanding skills.
