1.1. Typing Inside Cell
1.2. Typing inside Formula Bar
1.3. Drag Formula
1.4. Typing Functions

2.1. Absolute Reference
2.2. Relative Reference
2.3. Mixed Reference
2.4. Changing References

3.1. Total
3.2. Inside Formula
3.3. Outside Formula

This can make your formulas more readable and easier to manage. Named ranges allow you to refer to a cell or group of cells by a meaningful name instead of just the cell references.

5.1. Sum
5.2. Average
5.3. Count
5.4. Countblank
5.5. Max
5.6. Min
5.7. Subtotal

6.1. Adjust Decimals
6.2. Nearest Digit
6.3. Odd-Even Number

7.1. Joining Text Data
7.2. Cleaning Text Data
7.3. Count Characters in String
7.4. Change Text Case
7.5. Extract Simple Text Data
7.6. Extract Complex Text Data

8.1. Current Day & Time
8.2. Calculate the Number of Days, Working Days, Weeks, Months, Quarters, and Years Between 2 Dates
8.3. Extract Date Values from Date
8.4. Extract Time Values from Date
8.5. Add Hours, Minutes, Seconds to a Time – Time

9.1. Simple Condition – If
9.2. Multiple Condition – Ifs & Nested If
9.3. If Condition with AND
9.4. If Condition with OR

10.1. Find Exact Value Based on Left Lookup Column – Vlookup
10.2. Find Exact Value Based on Any Lookup Column – Index & Match
10.3. Find Exact Value Based on Horizontal Lookup Row – Hlookup
10.4. Finding Exact Value Based on Flexible Function – Xlookup
10.5. 2-Way Lookup Based on Row & Column – Xlookup
10.6. 2-Way Lookup Based on Row & Column – Index & Match
10.7. Find Multiple Records Based on Criteria – Filter
10.8. Find Unique List of Values & Sorting Ascending – Unique & Sort
10.9. Sorting Data – Sort
10.10. Sorting Data – Sortby

11.1. Sum Based on Single Criteria – Sumif
11.2. Sum Based on Multiple Criteria – Sumifs
11.3. Count Based on Multiple Criteria – Countifs
11.4. Average Based on Multiple Criteria – Averageifs
11.5. Max Based on Multiple Criteria – Maxifs
11.6. Min Based on Multiple Criteria – Minifs
11.7. Assign a Rank Value – Rank

12.1. Compare 2 List via Conditional Formatting – Match
12.2. Compare 2 List via Conditional Formatting – No Match

13.1. ToCol
13.2. ToRow
13.3. VStack
13.4. Text Before
13.5. Text After
13.6. Text Split

14.1. What is an Array Formula?
14.2 Array Formula 1
14.3 Array Formula 2

15.1. Lambda 1
15.2. Lambda 2
15.3. Lambda 3

16.1. Formula Errors
16.2. Audit Tools

17.1. Intro to Error Handling
17.2. Iferror

18.1. AutoSum Calculation
18.2. Status Bar Calculation

19.1. Calculate Fields
19.2. Get Pivot Data Function

20.1. Text Entries
20.2. Text Length
20.3. Prevent Duplicate Entries