Advanced Excel Professional - Excel Point Nepal Pvt. Ltd.

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.

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

Section 4: Document Setup and Printing

Section 5: Logical Functions

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

Section 9: Financial Functions

Section 10: Conditional Formatting (Basic to Advanced)

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

Section 13: Creating an Interactive Sales Dashboard

Section 14: Elements & Controls for Interactive Dashboard

Section 15: Creating an Interactive HR Dashboard

Section 16: Power Pivot and Advanced Data Modeling in Excel

Section 17: Macro & VBA for Beginners

Section 18: Power Query Transformations

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

What is Excel and Why You Should Learn It

What is Excel and Why You Should Learn It

Excel Interface, Workbook Basics & How to Get Excel Software (Free or Paid?)

Tabs, Ribbons, and Quick Access Toolbar

Worksheet Navigation and Shortcut Tips

Saving, Opening & Using Templates

Section 1 (MCQs)

Section 2: Formatting, Autofill, and Functions Basics

Excel Fill Techniques: Fill Handle, Custom Fill & Flash Fill Mastery

Excel Formatting Essentials: Text, Numbers, and Beyond

Create a Professional Invoice Template in Excel

Cell References (Relative, Absolute, Mixed)

Essential Excel Functions for Everyday Use

Mastering ‘Format as Table’ in Excel: Smart Data Management & Dynamic Analysis

Mastering Paste Special in Excel

Design Smart Ledger Layouts in Excel Using Formatting Tools

Excel Formulas for Ledger: Accurate and Dynamic Calculations

Protect Your Excel Ledger: Lock Cells, Sheet, and Workbook

Section 3: Data Summarization Tools

Master Excel Summarizing Functions: COUNTIF, SUMIF, SUBTOTAL with Filter Basics

Advanced Excel Summarization with SUMIFS, COUNTIFS, Wildcards & Smart Filters

Section 4: Document Setup and Printing

Preparing Worksheets for Printing: Mastering Page Layout Settings

Adding Professional Headers and Footers in Excel

Finalizing Print Settings: Preview, Adjustments, and Best Practices

Section 5: Logical Functions

IF, Nested IF Examples

IFs Function

Switch Function

Excel Nested IF Formula with Multiple Logic | Practical HR Example

Mastering IF Function Combinations in Excel AND, OR, COUNTIF, MIN & Join Operator

Section 6: Lookup & Reference Functions

VLOOKUP & HLOOKUP in Excel: Exact vs Approximate Lookup Explained

Make VLOOKUP Dynamic: Replace Column Index with ROW, COUNTA, SEQUENCE

INDEX, MATCH & XLOOKUP in Excel: Upgrade Your Lookup Skills

Transfer Selected Records Across Sheets using VLOOKUP, IF, ROW & MATCH

Excel Lookup Project: Build a Dynamic Tracker using UNIQUE, INDIRECT & HYPERLINK

Excel Data Validation | Dropdown, Rules, Custom Formulas & More

Dependent Drop-Down List with Data Validation and Named Ranges

Searchable Drop-Down List Using Formulas Dynamic List with IF, SEARCH, OFFSET

2nd Easy Method to Make Searchable Drop-Down List in Excel

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