arrow_back
Introduction
Excel Course Introduction
Excel Basics
Introduction to Excel in English
Entering Data into Excel for the First Time
4- Sorting and Filtering in Excel
PRACTICE FILE: Applying Filter and Sorting on a Dataset - Question
Working with Cell References - Relative
Working with Cell References - Multiple Cells
Relative Vs Fixed Referencing
Basic Excel Formulas
PRACTICE FILE: Applying Basic Formulas on Real World Dataset - Question
5 - Basic Excel Formula and sum Function
6 - Average and Count and CountA
7 - Max and Min Formula
Logical Formulas
8- IF Formula
Text Formulas
9 - Left Right and Mid Formulas
10 - Upper Lower and Proper
11 - Concat and TextJoin
IF Family of Formulas
PRACTICE FILE: Applying Advanced Formulas on Real World Dataset - Question
12 - Sum IF
13 - SumIf with Wild Cards
14-Average IF and CountIF Formulas
15 - IFS and SUMIFS
16 - SumIFS with Wildcards
17 - AverageIFS and Average IFS with Wild Cards
18 - MaxIFS
19 - MinIFS
Lookup Formulas
VLookup Formula - Practice File - Your Excel Guy
Introduction to VLookup
VLOOKUP() For Text Information
VLOOKUP() on Date Information
VLOOKUP() with two or more Excel Files
VLOOKUP() on Complex Dataset
Common Mistakes and Errors when using Lookup Formulas
VLOOKUP() with Approximate Match
Introduction to XLookup
XLookup Formula - Practice File - Your Excel Guy
XLOOKUP() on Simple Data
XLOOKUP() on Multiple Files of reference
XLOOKUP() on Date and Horizontal Data
XLOOKUP() with Match mode of Higher Value
XLOOKUP() with Match mode of Lower Value
XLOOKUP() with Match mode of Wildcard Characters
Pivot Tables
Practice File : Pivot Tables - QUESTION
20 - Pivot Table Section Introdcution
21 - Understanding Pivot Tables
22 - How Pivot Tables work and our First Pivot Table
23 - Changing Values in Pivot Tables
24 - Pivot Tables - Changing Calculations to Max and Min
25 - Using Rows and Columns for Optimal Analytical View
26 - Pivot Tables - Calculations with Views
Dashboarding
PRACTICE FILE: Dashboarding Project File
27 - Dashboarding - Importance of Dashboard
28 - Dashboarding - Creating and Managing Business Questions
29 - Dashboarding - Setting up the Environment
30 - Dashboarding Generating Business Answers and Questions
31 - Dashboarding - Choosing Charts - Version
32 - Dashboarding - Removing Distractions
33 - Dashboarding - Bringing the Insights Out
34 - Dashboarding - Slicers and Timelines
35 - Dashboarding - Coloring and Theming
36 - Dashboarding Final Touches before Publishing
Advanced Dashboarding
37 - Dashboarding - Managing Blanks and Views
38 - Dashboarding - Aligning Complex Chart and Customizing Slicers
39 - Dashboarding - Grouping
40 - Dashboarding Contextual Charting
41 - Dashboarding - Customizing Everything and Hidden Chart Options