Advanced Excel
From pivot tables to dashboards & VBA basics
Created by
Vaibhav Sharma
Please log in first
- Lifetime access
- Mobile + desktop access
- Certificate of completion
About this course
From pivot tables to dashboards & VBA basics. Comprehensive practical training by Vidya Group of Institutions.
Curriculum
12 modules • 61 lectures • 5h 6m
- Introduction to Advanced Excel 8:28
- Excel Interface & Professional Workflow 8:03
- Essential Excel Functions & Calculations 5:54
- Statistical Functions for Data Analysis 6:29
- Home Tab: Formatting & Cell Management 7:26
- Home Tab: Alignment, Styles & Number Formatting 8:18
- Home Tab: Editing & Advanced Formatting Tools 9:00
- Conditional Calculations with SUMIF & COUNTIF 8:06
- Text Functions for Data Processing 8:05
- Practice Set – Text Functions
- Essential Excel Shortcuts for Productivity 5:32
- VLOOKUP: Data Retrieval Fundamentals 8:05
- Advanced VLOOKUP Techniques 6:09
- HLOOKUP & XLOOKUP: Advanced Lookup Strategies 11:02
- Pivot Tables: Interactive Data Analysis 5:20
- Logical Operators & AND Function 5:29
- OR Function for Multiple Conditions 3:44
- NOT Function & Logical Reversal 2:42
- XOR Function & Exclusive Conditions 2:30
- Advanced Logical Functions: AND, OR, NOT & XOR 9:23
- PMT Function: Loan & EMI Calculations 4:24
- IPMT Function: Interest Payment Analysis 1:54
- PPMT Function: Principal Payment Analysis 2:03
- Loan Statement Analysis with PMT, IPMT & PPMT 8:44
- Sparklines: Compact Data Visualization 7:42
- Data Consolidation for Multi-Source Analysis 8:19
- 3D SUM: Cross-Sheet Data Analysis 3:26
- Text to Columns: Data Separation & Cleanup 3:16
- CONCATENATE: Combining Text Data 2:03
- Flash Fill: Intelligent Data Transformation 6:07
- ROUND Function: Precision in Calculations 2:47
- MROUND Function: Multiple-Based Rounding 2:24
- ROUNDDOWN Function: Controlled Rounding 2:15
- ROUNDUP Function: Upward Rounding 2:09
- FACT & POWER Functions: Advanced Mathematical Calculations 2:01
- RAND & RANDBETWEEN: Random Number Generation 3:50
- INDEX Function: Flexible Data Retrieval 4:27
- MATCH Function: Dynamic Position Matching 1:38
- REPT, CODE, ROMAN & CHAR Functions 5:06
- SMALL & LARGE: Value-Based Data Analysis 2:52
- RANK Function: Ranking & Performance Analysis 1:41
- MODE & MEDIAN: Statistical Data Analysis 2:17
- CONVERT Function & Unit Conversion Analysis 4:59
- Date & Time Calculations in Excel 3:42
- Understanding Excel Errors & Error Handling 7:04
- Dynamic Serial Numbers & Automated Sequences 7:34
- Custom Number Formats & Unit Display 5:21
- VBA Automation: AutoFit Columns 4:43
- Building an Automated Attendance System 12:19
- Running Total & Progressive Data Analysis 1:40
- Data Validation: Complete Data Entry Control 9:41
- Speak Cells: Excel Accessibility & Productivity 2:35
- Custom Lists & Automated Data Entry 4:00
- Data Tables for What-If Analysis 3:50
- Defined Names & Cell References 3:19
- INDIRECT Function & Dynamic Data Access 6:57
- Hyperlinks & Workbook Navigation 6:03
- Freeze Panes & Worksheet Navigation 2:50
- Professional Printing, Page Setup & Worksheet Properties 8:28
- Employee Salary Analysis
- Sales Data Analysis
Student Reviews
Chanchal
LMS par ye Advanced Excel course waqayi mein bohot deep aur detailed tha. Maine isme Pivot Tables, Pivot chart, aur complex formulas ke baare mein itni gehraai se seekha. Content ekdum up-to-date hai aur har module ke baad hone wale quizzes ne meri understanding ko aur mazboot banaya. Best Course.
Himanshi
Course bhot acha hai lectures mei bhot deep padhaya gya hai.
Vaibhav Sharma
Best Course
Priya Agarwal
Advanced Excel ne salary badha di! VLOOKUP, Pivot Tables — office kaam bahut fast ho gaya!
Arvind Kumar Gupta
2 ghante ka kaam ab 15 minute mein Macros se hota hai. Trainer amazing hai!
Deepak Tiwari
Excel ke sab advanced features clearly sikhaye. Dashboard module impressive tha.