Advanced Excel Professional
About Course
This all-in-one Excel course takes you from essential foundations to advanced business automation. Learn practical skills in Excel formatting, functions, PivotTables, dashboards, Power Query, Power Pivot, and VBA. Perfect for professionals, accountants, and data enthusiasts seeking to boost productivity, automate tasks, and build real-world reports. Delivered via recorded lessons with hands-on classwork and projects.
What Will You Learn?
- Excel formatting, functions & analysis tools
- PivotTables, Charts & Interactive Dashboards
- Power Query & Power Pivot integration
- DAX basics for advanced modeling
- Automate repetitive tasks using VBA
- Build business-ready Excel projects
- Clean, combine, and transform raw data
- Prepare reports, summaries, and dynamic templates
Course Content
What is Excel and Why You Should Learn It
-
What is Excel and Why You Should Learn It
01:35 -
Excel Interface, Workbook Basics & How to Get Excel Software (Free or Paid?)
14:41 -
Tabs, Ribbons, and Quick Access Toolbar
08:15 -
Worksheet Navigation and Shortcut Tips
09:13 -
Saving, Opening & Using Templates
02:58 -
Section 1 (MCQs)
Section 2: Formatting, Autofill, and Functions Basics
-
Excel Fill Techniques: Fill Handle, Custom Fill & Flash Fill Mastery
11:38 -
Excel Formatting Essentials: Text, Numbers, and Beyond
13:34 -
Create a Professional Invoice Template in Excel
18:33 -
Cell References (Relative, Absolute, Mixed)
09:28 -
Essential Excel Functions for Everyday Use
15:36 -
Mastering ‘Format as Table’ in Excel: Smart Data Management & Dynamic Analysis
13:57 -
Mastering Paste Special in Excel
13:47 -
Design Smart Ledger Layouts in Excel Using Formatting Tools
07:31 -
Excel Formulas for Ledger: Accurate and Dynamic Calculations
12:31 -
Protect Your Excel Ledger: Lock Cells, Sheet, and Workbook
05:18
Section 3: Data Summarization Tools
-
Master Excel Summarizing Functions: COUNTIF, SUMIF, SUBTOTAL with Filter Basics
16:32 -
Advanced Excel Summarization with SUMIFS, COUNTIFS, Wildcards & Smart Filters
20:38
Section 4: Document Setup and Printing
-
Preparing Worksheets for Printing: Mastering Page Layout Settings
13:12 -
Adding Professional Headers and Footers in Excel
12:21 -
Finalizing Print Settings: Preview, Adjustments, and Best Practices
11:39
Section 5: Logical Functions
-
IF, Nested IF Examples
11:12 -
IFs Function
03:06 -
Switch Function
04:51 -
Excel Nested IF Formula with Multiple Logic | Practical HR Example
06:52 -
Mastering IF Function Combinations in Excel AND, OR, COUNTIF, MIN & Join Operator
07:56
Section 6: Lookup & Reference Functions
-
VLOOKUP & HLOOKUP in Excel: Exact vs Approximate Lookup Explained
14:23 -
Make VLOOKUP Dynamic: Replace Column Index with ROW, COUNTA, SEQUENCE
04:05 -
INDEX, MATCH & XLOOKUP in Excel: Upgrade Your Lookup Skills
14:41 -
Transfer Selected Records Across Sheets using VLOOKUP, IF, ROW & MATCH
10:28 -
Excel Lookup Project: Build a Dynamic Tracker using UNIQUE, INDIRECT & HYPERLINK
12:12 -
Excel Data Validation | Dropdown, Rules, Custom Formulas & More
19:15 -
Dependent Drop-Down List with Data Validation and Named Ranges
15:00 -
Searchable Drop-Down List Using Formulas Dynamic List with IF, SEARCH, OFFSET
25:15 -
2nd Easy Method to Make Searchable Drop-Down List in Excel
07:23
Section 7: Date & Time Functions
-
Fix Broken Date Format in Excel Text to Columns + Year, Month, Day Functions Explained
-
How to Break Down Dates in Excel Year, Month, Quarter, Weekday, Weekend Explained
-
Understand YEARFRAC & DATEDIF Functions in Excel with Practical Use Cases
-
Excel DAYS vs DAYS360 Functions Explained with Real-Life Examples
-
WORKDAY & WORKDAY.INTL in Excel | Skip Weekends & Holidays Easily
-
NETWORKDAYS & NETWORKDAYS.INTL for Smart Working Days Calculation
-
Create a Simple Dynamic Attendance Sheet in Excel (Step-by-Step Guide)
-
Excel Time Calculations for Payroll: Shift, Break & Overtime Logic
-
How to Insert Timestamps in Excel Automatically (No VBA Needed)
Section 8: Master Excel Text Functions – Clean, Extract, Format & Automate with Real Examples
-
Understanding Numeric Text Handling
-
Cleaning Messy Text Data
-
Splitting Full Names Smartly
-
Generate Structured Codes with Leading Zeros
-
Create In-cell Charts & Ratings with REPT
Section 9: Financial Functions
-
EMI Calculation (PMT)
-
IPMT and PPMT
-
Data Table & Goal Seek
-
FV Function
Section 10: Conditional Formatting (Basic to Advanced)
-
Mastering Conditional Formatting Basics: Highlight Cells Rule Explained (All Types)
-
Top & Bottom Rules in Conditional Formatting: Find Extremes in Your Data
-
Visualizing Data with Bars, Colors & Icons: Smart Formatting Techniques
-
Advanced Conditional Formatting with Formulas: Highlight Rows, Columns & More
-
Expiry Status Highlight: Color-Coded Alerts for Expired & Expiring Dates
Section 11: Analyzing Data with Pivot Table
-
Pivot Table Essentials: What, Why & How to Build Your First Report in Excel
-
Customizing Pivot Table Layout with Design Tools in Excel
-
Summarize, Format & Group Data in Pivot Tables like a Pro
-
Enhance Pivot Reports with Interactive Slicers and Timelines
-
Advanced Pivot Features: Calculated Fields, Filter Pages & Drill Down Data
-
Calculating % of Grand Total in Pivot Reports
-
Analyzing Data with % of Column Total and % of Row Total
-
Understanding % Of and Parent Totals in Pivot Tables
-
Comparing Values with Difference From and % Difference From
-
Tracking Progress with Running Total and % Running Total
-
Ranking Items Dynamically with Show Values As
-
Using Index to Analyze Relative Importance in Pivot Tables
Section 12: Excel Charts
-
Excel Chart Basics: Types, Insertion, and Custom Design Techniques
-
Excel Combo Charts: Visualize Multiple Data Series in One Chart
-
Create & Format Pie Charts in Excel: Highlight Percentages and Categories
-
Chart Settings in Excel: Hidden Data, Default Chart & Series Control
Section 13: Creating an Interactive Sales Dashboard
-
Building Dynamic Pivot Tables
-
Creating Interactive Charts from Pivot Tables
-
Aligning and Arranging Charts and Visual Elements in Dashboards
-
Using Slicers to Add Interactivity to Pivot Dashboards
-
Adding KPI Cards, Using Formulas, and Final Dashboard Testing
Section 14: Elements & Controls for Interactive Dashboard
-
Create Dynamic Charts with Combo Box and VLOOKUP
-
Use Scroll & Spin Button for Scrollable Data and Dynamic Charts
-
Target vs Sales Dashboard Using Check Boxes
-
List Box Selection with Chart: Visualize Score by Name
-
Group and Option Buttons for Report Controls
Section 15: Creating an Interactive HR Dashboard
-
Job Title Analysis using UNIQUE, FILTER, SORT & TRANSPOSE
-
Create Department-Wise Filter with Option Buttons (Form Controls)
-
Dynamic Job Title Dropdown using ComboBox & CHOOSE Formula
-
Top 10 Salary Employees Bar Chart Visualization
-
Add Key HR Metrics as KPIs (Gender Ratio, Avg Age, Attrition Rate)
-
Add Advanced HR Charts (Pie, Histogram, Doughnut, Line)
-
Final Dashboard Formatting, Protection & Sheet Locking
Section 16: Power Pivot and Advanced Data Modeling in Excel
-
Power Pivot Introduction and Data Model Creation
-
Data Modeling with Power Pivot: Relationships & Pivot Tables
-
Basic DAX Formulas in Power Pivot
Section 17: Macro & VBA for Beginners
-
Getting Started with Excel Macros: Record, Run, Edit & Use Relative References
-
Real-Life Macro Example Using Advanced Filter
Section 18: Automation Foundation
-
Automation Mindset & 13 Components
-
Formula Automation — Dynamic References
-
Advanced Formula — LAMBDA, LET & Spill
Section 19: Formatting & Template Automation
-
Formatting Automation System
-
Template Design & Data Validation
Section 20: Data Automation
-
Multi-Sheet Data Automation
-
Data Cleaning Automation
-
Data Preparation Layer — Star Schema
Section 21: Power Query — M Language
-
Power Query Introduction & Data Import
-
Data Cleaning & Text Transformation
-
Advanced Transformations
-
Merge & Append Queries
-
Power Query End-to-End Project
Section 22: Power Pivot & DAX
-
Data Model & Relationships
-
DAX Fundamentals
-
Advanced DAX + Class Assignment
Section 23: Dashboard & Visualization
-
Dashboard Design & KPI Cards
-
Dynamic Charts & Interactive Controls
-
End-to-End Dashboard Project
Section 24: Macro & VBA Automation (Most Important)
-
Introduction to VBA & Macro Recorder
-
VBA Editor & Code Structure
-
Variables, Data Types, MsgBox & InputBox
-
Smart Decision Making with VBA
-
Object Hierarchy & Loop Automation
-
Range & Cells Automation Project
-
Worksheet & Workbook Events
-
Office Automation Project
-
Excel Tables & Search Automation
-
Sorting & Filtering Automation
-
Crash-Proof Sales Report Generator
-
Introduction to UserForm
-
UserForm Automation Project
-
Dashboard Automation using VBA
-
Dashboard Automation using VBA
-
Real Office End-to-End Automation Project
Student Ratings & Reviews
No Review Yet
