Preview Advanced Excel Formulas

Excel Introduction - Beginning of the Story

1 - Excel Course Introduction in English

2 - Introduction to Excel in English - V2

3 - Entering Data into Excel for the First Time - English

Filtering and Sorting

Practice File : Applying Filter and Sorting on a Dataset - Question

4- Sorting and Filtering in Excel

Basic Formulas

Formulas - Practice File - Basic Formulas

5 - Basic Excel Formula and sum Function

6 - Average and Count and CountA

7 - Max and Min Formula

8- IF Formula

Text Formulas

9 - Left Right and Mid Formulas

10 - Upper Lower and Proper

11 - Concat and TextJoin

IF Family of Formulas

Formulas - Practice File - Advanced Formulas

12 - Sum IF

13 - SumIf with Wild Cards

14-Average IF and CountIF Formulas

IFS Family of Formulas

15 - IFS and SUMIFS

16 - SumIFS with Wildcards

17 - AverageIFS and Average IFS with Wild Cards

18 - MaxIFS

19 - MinIFS

Assignment

Applying the Learnings on Real World Dataset

Pivot Tables

Practice File for Pivot Tables

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