Advanced Excel

From pivot tables to dashboards & VBA basics

intermediate en 10h 15m 61 lectures
Vaibhav Sharma

Created by

Vaibhav Sharma

Advanced Excel
₹8,000 ₹10,000 20% OFF
Buy Now — Enrol

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

4.9
(7 reviews)
V

Vikas Pandey

3 months ago

Power Query seekhne ke baad realize hua ki kitna manual kaam karta tha! Career-changing!

Chat on WhatsApp