Menu
Show Content List

1-1 - About the Instructor
1-2 - How to get MS 365

1-2 - How to get MS 365

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

1-3 - Create New Excel File
1-4 - How to use the Resource Folder
2-0 - Getting to Know Excel

2-0 - Getting to Know Excel

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

2-1 - Understand Column - Row - Cell
2-2 - Active Cells - Range - On Cell - In Cell
2-3 - Data Type - Create a Basic Table
2-4 - Changing Data in a Cell
2-5 - Move between the cells
2-6 - Move between the cells Practice
2-7 - Data Selection
2-8 - Data Selection - Go To
2-9 - Undersand the Search Bar
2-10 - Understand the Name Box and Name Manager
2-11 - Understanding the Formula Bar
2-12 - Tabs - Groups - Sliders - Zoom - Quick Access
3-0 - Dealing with Cell Values - Introduction
3-1 - Simple Copy, Cut and Drag
3-2 - Copy Cut and Drag - Range
3-3 - Drag ad Drop - Detailed shortcut
3-4 - Fill Handle

3-4 - Fill Handle

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

3-5 - Insert and Delete Rows and Columns
3-6 - Adjusting the size of the Rows and Column
3-7 - Hide and Unhide Rows - Columns - Sheet
3-8 - Up - Down - Right - Left
3-9 - Simple Formulas
4-0 - Math and Statitical Functions - Introduction
4-1 - Clipboad in Detail
4-2 - Understand the Font Group
4-3 - Calculation vs Formulas vs Function
4-4 - Sum Function
4-5 - Min - Max - Average - Small - Large
4-6 - Number format in Detail
4-7 - Sparkline and Column

4-7 - Sparkline and Column

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

4-8 - Round - Roundup, Rounddown, Int, Abs Functions
4-9 - Product Function
4-10 - SumProduct Fuction
4-11 - Suntotal - Filter - Introduction to Conditional Formatting
4-12 - Filter In Detail
4-13 - Filter Function

4-13 - Filter Function

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

4-14 - Table, Filter and Slicer
4-15 - Quotient and Mod Functions
4-16 - Absolute vs Relative Cell References
4-17 - Rank Functions

4-17 - Rank Functions

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

4-18 - Absolute Function
5-0 - Introduction to Text Functions - Introduction

5-0 - Introduction to Text Functions - Introduction

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

5-1 - Right Function - Flash Fill - Text to Column
5-2 - Left Function - Flash Fill - Text to Column
5-3 - Mid Function - Flah Fill - Text to Column
5-4 - Len Function
5-5 - Len + Left and Right Functions

5-5 - Len + Left and Right Functions

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

5-6 - Text to Column in Detail
5-7 - Flash Fill in Detail
5-8 - Concat and TextJojn Function
5-9 - Trim Function
5-10 - Choose Function
5-11 - Case Functions
5-12 - Find and Search Functions
5-13 - Substitute Function
5-14 - Replace Function
5-15 - Rept Function
5-16 - Text Function
6-0 - Introduction to Date and Time Functions
6-1 - Understanding Date and Time in Excel
6-2 - Date Formatting
6-3 - Current Date and Time - Function and Shortcuts
6-4 - Construct Date and Time using Functions
6-5 - DeConstruct Date and Time
6-6 - Datedif Function in detail
6-7 - Other Date Functions
7-0 - Introduction to Financial and Other Functions
7-1 - Loan Amortization Calculation
7-2 - PV and FV
7-3 - NPV - IRR and RATE Functions
7-4 - Information Functions
7-5 - Unique Fuction in Detail

7-5 - Unique Fuction in Detail

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

7-6 - Sort and Sortby Functions
7-7 - Sequence Function
7-8 - Random Functions
8-0 - Introduction to Logical Functions
8-1 - Simple If Function
8-2 - Absolute Cell Reference in Detail
8-3 - If Function Next Step
8-4 - Ifs Function
8-5 - AND & OR
8-6 - If + AND & OR
8-7 - Sumif - SumIfs - AverageIf - AverageIFS
8-8 - Count - Counta - CountBlank Functions
8-9 - Countif - Countifs Functions
8-10 - IfError
8-11 - NOT Function
9-0 - Introduction to Lookup Functions
9-1 - V-Lookup Simple
9-2 - V-Lookup Detailed
9-3 - V-Lookup Exercise Solution
9-4 - Simple X-Lookup
9-5 - X-Lookup in Detail
9-6 - X-Lookup Exercise
9-7 - X-Lookup vs V-Lookup & Grouping
9-8 - Index - Match Functions
9-9 - Offset Function
9-10 - Transpose Paste and Function
9-11 - Row - Column - Rows - Columns Functions
9-12 - Address Function
9-13 - Indirect Function
9-14 - Hyperlink Feature and Hyperlink Function
10-0 - Introduction to Other Features and Areas
10-1 - Conditional Formatting Ultimate Lesson
10-2 - Conditional Formatting - Automatic Bordering
10-3 - Charts - Column - Pie - Line Charts
10-4 - Introduction to Simple Pivot Table
10-5 - Pivot Table from Range vs Table
10-6 - Pivot Table with Dashboard
10-7 - Insert Shape - Picture and Icon
10-8 - SmartArt - Process - Hyrarchy - Cycle
10-9 - Insert Sparklines - Win or Loss
10-10 - Slicer in Detail
10-11 - Print Title
10-12 - Get Data from Different Sources
10-13 - Remove Duplicates
10-14 - Data Validation
10-15 - Dropdown and Dependent Drop Down list
10-16 - Consolidate Data
10-17 - Goal Seek Option
10-18 - Data Table
10-19 - Group and Ungroup
10-20 - Freeze Pane
10-21 - Formula Auditing
11-0 - Introduction to Newer Functions
11-1 - Image Function
11-2 - Let Function
11-3 - TextSplit Function
11-4 - TextBefore - TextAfter Functions
11-5 - ArrayToText Function
11-6 - Regular Expressions RegExTest - RegExExtract and RegExReplace
11-7 - Regular Expressions RegExExtract - Date
11-8 - Regular Expressions RegExExtract - EmailE
11-9 - Regular Expressions RegExExtract - Multiple Data
11-10 - ChooseCols - ChooseRows Functions
11-11 - Understanding ChooseCols and Choose
11-12 - ChooseCols and ChooseRows Advanced
11-13 - Understanding the Take Function
11-14 - Take Function Advanced Examples
11-15 - Drop Function
11-16 - Understanding Vstack Function
11-17 - VStack Function in Details
11-18 - ToCol and ToRow Functions
11-19 - WrapRows Function
11-20 - WrapCols Function
11-21 - Xmatch Function
11-22 - Understanding Lambda Function
11-23 - Lambda Function Paye Tax Calculation
11-24 - Lambda Function Advanced Usage
11-25 - Map Function with LAMBDA
11-26 - Scan Function
11-27 - ByCol and ByRow Functions
12-0 - Introduction to Ai and Excel

Ai Developments in MS Excel

12-1 - Ai in Excel - Flash Fill
12-2 - Ai in Excel - Forecast
12-3 - Ai in Excel - Recommended PivotTables
12-4 - Ai in Excel Recommended Charts
12-5 - Ai in Excel - Analyze Data
12-6 - Ai in Excel - Data from images

Excel - Get help from Ai - LLMs (ChatGPT)

13-1 - ChatGPT - Simple Function help
13-2 - ChatGPT - Error Handling
13-3 - ChatGPT - Step-by-Step Guide to break the Formula
13-4 - ChatGPT - Find Shortcuts
13-5 - ChatGPT - Split Text
13-6 - ChatGPT - Help wth Complex Formulas

Ai and Excel - ChatGPT for Excel Add-in

14-1 - ChatGPT for Excel - Ai.ASK
14-2 - ChatGPT for Excel - Ai.LIST
14-3 - ChatGPT for Excel - Ai.TABLE
14-4 - ChatGPT for Excel - Ai.TRANSLATE
14-5 - ChatGPT for Excel - Ai.FILL
14-6 - ChatGPT for Excel - Ai.EXTRACT
14-7 - ChatGPT for Excel - Ai.CHOICE

The Bricks - Fully Ai Magical Spreadsheet Tool

15-1 - TheBricks - Magical AI Excel Tool
16-1 - Commission Calculation - Excercise Overview
16-2 - Commission Calculation - Solution Simple Example
16-3 - Commission Calculation - Solution to Complex Example
17-1 - Final Exercise Overview
17-2 - Final Exercise Solution
Telegram