Advanced Excel Zero to Expert

Learn step by step MS Excel 24 (equivalent to 365) Full Notes https://ztechmanagement.in/wp-content/uploads/2026/04/MS-EXCEL-ADVANCED-NOTES-FULL.pdf Any one can be Master in Excel if you watch this video All Menus and commands are covered. STEPS TO FOLLOW: 00:00 – Excel Introduction & Worksheet Basics 01:30 – Rows, Columns & Data Entry 07:25 – Basic Excel Formulas 12:00 – Cell Formatting & Table Design 12:40 – Table Editing, Alignment & Insert Options 17:18 – Fonts, Zoom & Formatting Tools 29:18 – Conditional Formatting (Rules, Colors, Data Bars) 42:04 – Tables, Filters & Sorting 49:41 – Insert, Delete, Hide & Sheet Management 01:01:43 – Sheet Protection & Cell Locking 01:05:49 – Printing Basics & Page Layout 01:10:01 – Important Functions (SUM, COUNT, ROUND etc.) 01:19:22 – Fill, Series & AutoFill 01:32:58 – Flash Fill (Most Important Feature) 01:43:37 – Pivot Table (Analysis & Reports) 01:55:18 – Pivot Charts & Visualization 02:06:00 – Sparklines & Performance Charts 02:16:11 – Hyperlink & Email Linking 02:17:03 – Comments & Notes 02:19:31 – Text Box & Design Elements 02:23:54 – Header & Footer 02:32:52 – Insert Symbols (Wingdings, CHAR) 02:38:55 – Page Layout Complete Guide 02:54:13 – Print Area & Repeating Rows/Columns 03:00:38 – Gridlines, B/W & Draft Printing 03:04:17 – Scale to Fit & One Page Print 03:09:55 – Themes & Layout Summary 03:11:36 – Excel Skills Roadmap 03:12:30 – Arithmetic Operations 03:13:55 – Text Functions (UPPER, LOWER, PROPER, Paste Values) 03:16:22 – CONCATENATE & TEXTJOIN 03:18:55 – LEFT, RIGHT, MID, LEN, TRIM 03:21:09 – TEXT, Date & Time Functions 03:23:29 – DATEDIF (Date Difference) 03:25:13 – Logical Functions (IF, Nested IF, IFERROR) 03:32:52 – AND, OR, NOT 03:37:04 – Math Functions (SUM, COUNT, ROUND, SQRT, MOD) 03:46:34 – Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP) 03:57:00 – INDEX, MATCH & OFFSET 04:04:51 – PMT Function (Loan EMI Calculation) 04:17:28 – Name Manager & Named Ranges 04:27:24 – Formula Auditing & Watch Window 04:36:08 – Calculation Options 04:41:14 – Data Menu & Get Data 04:44:18 – Import Text, CSV, XML, PDF, Folder & Database 04:47:49 – Queries, Connections & Power Query Intro 04:57:06 – What-If Analysis (Scenario Manager, Data Table) 05:03:48 – Group/Ungroup & SUBTOTAL Function 05:08:02 – Review Tools (Spelling, Thesaurus, Translate) 05:12:38 – Workbook Statistics & Change Tracking 05:17:51 – Sheet & Workbook Protection 05:22:15 – Allow Edit Ranges & Sharing (Microsoft 365) 05:30:46 – View Tab (Freeze Panes, Split, Multiple Windows) 05:44:36 – Macros (Record, Run & Automation Basics)