Section 1: Excel Basic Concepts
Section 2: Formula Writing Concepts
Section 3: Name Ranges and Excel Tables
Section 4: Aggregation Functions
Section 5: Date Functions
-
Download Me First: Practice File
-
Extract Parts of a Date: Day, Month , Year (4:55)
-
How to get Year End and Year Start Date (2:38)
-
Text Function for Date Parts (1:17)
-
Over Time Calculations (7:17)
-
NETWORKDAYS.INTL : Calculate Working Days between 2 Dates (1:58)
-
WORKDAY.INTL : Calculate End Date from Start and Working Days (1:50)
-
Duration between Dates in Years Month and Days (4:20)
-
EDATE Function : Get Expected End Date (1:33)
-
List Dates between two Dates : SEQUENCE (1:48)
Section 6: Logical Functions
Section 7: Data Validation : Minimize Data Entry Errors
Section 8: Data Cleaning : Text Functions
-
Text Case : LOWER, UPPER, PROPER, TRIM (8:24)
-
Text to Columns Feature to Split Text (4:27)
-
LEFT, RIGHT, MID, LEN : Split Data (4:45)
-
FIND, SEARCH Function: Position of any Character (5:24)
-
SUBSTITUTE: Similar to Find and Replace of Excel (1:31)
-
REPLACE Function : Replace Text based on Number of Characters (3:04)
-
5 Ways to Split Text (6:04)
-
Joining Text from Multiple Cells (6:26)
Section 9: LOOKUP Functions
Section 10: Conditional Formatting
-
Types of Conditional Formatting (4:39)
-
Data Bars in other column (1:12)
-
Conditional Formatting in Pivot Tables (1:27)
-
Icon sets with Customized Rules (2:05)
-
Highlight Dates with Custom Conditions (2:53)
-
Highlight Upcoming Birth Dates (5:55)
-
Advanced CF: Dynamic Borders/ Background Color Around Data (3:01)
Section 11: Charts & Visualization
Pivot Tables 12: Key to Interactive Reports and Dashboards
Bonus : Excel Key Board Shortcuts
Bonus: Tools of Interactivity for Advance Dashboards
-
Interactive Report Option Buttons (6:47)
-
Interactive Dashboard Check Boxes (6:58)
-
Interactive Report Camera Tool Option Buttons (7:15)
-
Interactive Report Offset and Spin Button (9:39)
-
Interactive Dashboards Scroll Bar (11:13)
-
Interactive Dashboards Part-1 (102:01)
-
Interactive Dashboards Part-2 (95:30)
Bonus: Macros and AI with Excel
