-
Duration – 15 hours
Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly.Â
Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
All MS EXCEL Courses bundle
$40
Tables and Formulas with Excel
Introduction
Â
 Overview of Tables and Formulas in Excel
Â
 Introduction
Â
Tables
Â
 Overview of Tables
Â
 Employee Master
Â
 Create a Table
Â
 Filtering Text Tables
Â
 Filtering Numeric Tables
Â
 Date Filters in Excel
Â
 Aggregating Data in Tables
Â
 Slicers with Tables
Â
 Sales Data
Â
 Practical Activity Tables
Â
 Practical Activity Tables
Â
Conditional Formatting
Â
 Overview of Conditional Formatting
Â
 Highlight Cell Rules
Â
 Conditional Formatting Top  Analysis
Â
 Data Bars Colour Scales and Icons
Â
 Manage Rules
Â
 Practical Activity Conditional Formatting
Â
 Practical Activities Conditional Formatting
Â
SUMIF, AVERAGEIF and COUNTIF Formulas
Â
 Introduction to SUMIF Formulas
Â
 SumIf Formulas
Â
 Sumifs CountIfs and AverageIfs
Â
 Practical Activity SUMIF
Â
 SUMIF Practical Activity
Â
Date Formulas
Â
 Introduction to Date Formulas
Â
 Year Month and Day
Â
 WeekDay and WeekNum Formulas
Â
 Date and Today Formulas
Â
 Formula File
Â
 WorkDay and NetWorkDays Formulas
Â
 How to Correct a Date Field in Excel
Â
 Practical Activity Date Formulas
Â
 Practical Activity Date Formulas – Answers Â
Â
 Practical Activity Date Formulas – Answers Â
Â
Text Formulas
Â
 Working with Text Formulas
Â
IF, HLOOKUP and VLOOKUP Formulas
Â
 Introduction to IF HLookUP and VLookUP
Â
 IF Formula
Â
 The VLOOKUP and HLOOKUP Formulas
Â
 An Example of VLOOKUP Formula
Â
 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.
