Mastering Excel Reports and Data Analysis

  • 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

 

Complete End to End Job Oriented Courses.

Best self paced courses created by industry experts & 24/7 support.

Knowasap Features 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

Human Resources

Get connected to more than 50000+ recruiters helping you with job opening and yes they are key decision makers.

Resume and LinkedIn Profile Makeover

Our experts will make your resume professionally with key makeovers, Also changing your linkedIn profile according to your skill set and high ranking keywords.

Interview Questions Blueprint

Did you know interviewer decides you will get "HIRED OR NOT" in first 3 minutes. Well dont worry we will provide you exact blueprint about how to "Introduce yourself" and other personality based interview questions which gives you the result you wanted for sure. Its a proven formula our premium students are using it and got hired.

Recent Students got hired after learning from our courses

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.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us