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.
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
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.
