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