Preview Advanced Excel for Beginners to Pro

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

Preview - Advanced Excel for Beginners to Pro