Advanced Excel Course in Nepal (22 Days)

22 दिनमा Excel Expert बन्नुस्

Beginner देखि Advanced सम्म

Live Classes + Recorded + Real-world Projects

Live + Recorded

Certificate Included

WhatsApp Support

Nepali Medium

LIVE CLASS PROOF

हाम्रो Live Class हेर्नुस्

हरेक दिन 49+ students live join गरेर सिक्छन्

Live Class

49+ Students Online

Excel Online Class — 2083.01.02

Excel Point Nepal Pvt. Ltd. | Sanjay Shrestha

तपाईं पनि यो Live Community को part बन्न तयार हुनुहुन्छ?

यो Course कसको लागि हो?

Students

Practice र revision सहित detail training चाहिने

Job Seekers

Accounting, MIS, Analyst role को तयारी

Professionals

Step-by-step learning prefer गर्ने

Business Owners

Reports, records, analysis गर्ने accountants

--------- WHAT YOU'LL ACHIEVE ---------

Course पछि के पाउनुहुन्छ?

01

Excel Beginner देखि Expert Level सम्म master गर्नुस्

02

Business मा real-world applicable skills

03

Dashboard, Automation, Data Analysis

04

Career opportunities boost हुन्छ

--------- COURSE CURRICULUM ---------

के-के सिक्नुहुन्छ?

Module 1: Excel fundamentals — laying the groundwork

Day 1: Getting started with Microsoft Excel

Introduction to Excel interface & powerful tools
Key features & tools for efficiency
Customizing Ribbon & Quick Access Toolbar
Workbooks, Worksheets & Cell Navigation

Day 2: Auto Fill, Formatting & Invoice designing

Automate data entry with Auto Fill
Professional Text & Number Formatting
Create an Invoice Template step-by-step
Enhance tables for better readability

Day 3: Cell References & Ledger Accounts

Absolute, Relative & Mixed Cell References
Using references effectively in formulas
Create Ledger Accounts with Excel Tables

Day 4: Hands-on classwork session

Guided practice of all Day 1–3 concepts with exercises

Module 2: Smart data handling & visualization

Day 5: Home Tab, Paste Special & Conditional Formatting

Deep dive into Home Tab functions
Paste Special — advanced copy-paste tricks
Conditional Formatting to highlight key data patterns

Day 6: Classwork & practical examples

Apply Conditional Formatting in real-world scenarios
Paste Special tricks in business use cases

Day 7: Data summarization functions

SUM, AVERAGE, COUNT, MIN, MAX, SUBTOTAL, AGGREGATE
SUMIF, COUNTIF, AVERAGEIF — single condition
SUMIFS, COUNTIFS, AVERAGEIFS — multiple conditions

Day 8: Hands-on summarization exercises

Solve real-world data analysis problems

Day 9: Preparing for printing

Optimize print settings for reports
Set up headers, footers & page numbers
Configure print areas for large datasets

Module 3: Logical & Lookup mastery Nested IF focus

Day 10: Logical functions — IF, AND, OR, Nested IF, IFS, SWITCH

IF, AND, OR — foundation of conditional logic
Nested IF — step-by-step multi-level conditions
IFS — cleaner alternative to Nested IF
SWITCH — elegant multi-case logic in one formula

Day 11: Nested IF — deep dive practical session

Complex multi-condition real-world problems
Grade calculator, salary slab, discount logic — real projects
Debugging Nested IF — common mistakes & how to fix
IFS vs Nested IF — when to use which

Day 12: Lookup & Reference functions

VLOOKUP, HLOOKUP — classic lookup functions
XLOOKUP — modern powerful replacement for VLOOKUP
INDEX & MATCH — the most powerful lookup combo

Day 13: Hands-on lookup classwork

Solve real-world lookup problems & dynamic references
Two-way lookup, approximate match real scenarios

Module 4: Excel 365 & Dynamic Array functions 365 NEW

Day 14: Named Ranges, Dynamic Ranges & Data Validation

Create Named Ranges for better formula readability
Dynamic Ranges using OFFSET & Excel Tables
Data Validation — dropdown lists & custom input rules

Day 15: Dynamic Array functions — FILTER, UNIQUE, SORT, SORTBY

FILTER — extract data dynamically with conditions
UNIQUE — automatically remove duplicates
SORT & SORTBY — dynamic sorting without manual effort
INDIRECT & HYPERLINK for dynamic sheet linking
Excel 365 — Brand new functions
SEQUENCE — generate number series automatically
LET — define variables inside a formula (game changer)
LAMBDA — create your own custom reusable functions
BYROW / BYCOL — apply calculations row-by-row or column-by-column
MAP, REDUCE, MAKEARRAY — advanced array manipulation
XLOOKUP advanced — multiple return columns & spill

Module 5: Data mastery — Date, Text & Advanced PivotTables Advanced

Day 16: Mastering Date & Time functions — 26 functions

DATEDIF, NETWORKDAYS, WORKDAY — business calculations
YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
DATE, EDATE, EOMONTH, TODAY, NOW, WEEKDAY & more

Day 17: File Security & 23+ Essential Text functions

Secure Excel files with passwords & sheet protection
LEFT, RIGHT, MID, TRIM, LEN — text extraction
SEARCH, FIND, SUBSTITUTE, REPLACE — text manipulation
CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, TEXT

Day 18: Data analysis with PivotTables

Create & customize PivotTables from scratch
Sorting, filtering & grouping for deeper insights
Value Field Settings — Sum, Count, % of total, Average

Day 19: Hands-on business reports with PivotTables

Generate professional business reports
Multi-table analysis using PivotTable relationships
Advanced PivotTable — Bonus
Calculated Fields & Calculated Items in PivotTable
Slicers & Timeline — interactive filtering for reports
Group by date — Year, Quarter, Month automatically
PowerPivot intro — handle large datasets beyond Excel limits

Module 6: Dashboards, VBA & AI+Excel AI NEW

Day 20: Data visualization with Charts & Dashboards

Create dynamic dashboards with charts & slicers
Chart types — Bar, Line, Pie, Combo, Waterfall
Professional dashboard design for reporting

Day 21: Advanced Dashboard design

INDEX, MATCH, INDIRECT for powerful dashboard features
Dynamic chart titles & interactive dropdown controls
KPI cards & summary metrics design

Day 22: Excel Macros & VBA for automation

Introduction to Macros & real-world applications
Record, edit & execute Macros to automate repetitive tasks
Basic VBA — variables, loops & conditions
Automate reports & data entry with VBA code
AI + Excel — Bonus Module
ChatGPT for formula generation — describe & get formula instantly
AI-powered data cleaning & analysis workflows
Copilot in Excel — Microsoft's built-in AI assistant
Generate VBA code using AI — automate 10x faster
Real-world AI + Excel business project

-----YOUR INSTRUCTOR-----

तपाईंलाई कसले पढाउँछ?

10K+

Students

100K+

YouTube Views

13+

Years Exp.

-----STUDENT REVIEWS-----

Students के भन्छन्?

Excel Point Nepal Pvt. Ltd.

4.9

Based on 217 reviews

review us on

Suvash Chaudhary

15:47 09 Nov 25

Sir's class is very good. I thought he would teach me anything for Rs. 500, but it turns out he teaches me very deep things.

Response from the owner 14:30 04 Nov 25

Thank you so much

Ranjita Chaudhary

02:12 02 Nov 25

Excel Point is an excellent place with truly professional service. The best part is Mr. Sanjay Kumar Shrestha — he is extremely reliable, knowledgeable, and always ready to help with a smile. His dedication and commitment make every experience smooth and trustworthy.
If you’re looking for quality, honesty, and excellent customer care, Excel Point — especially Sanjay Kumar Shrestha — is the best choice! Highly recommended!

Response from the owner 14:29 04 Nov 25

Thank you so much

Rabindra Shrestha

01:06 02 Nov 25

Great Excel virtual class!
Very clear, practical, and easy to follow. Learned a lot and highly recommend!

Response from the owner 14:30 04 Nov 25

Thank you so much

Pooja Sharma

14:27 15 Oct 25

Excellent service! it was professional, responsive, and delivered exactly what i expected . Highly satisfied

Response from the owner 14:29 04 Nov 25

Thank you so much

Ang Kusang Sherpa

07:55 15 Oct 25

Excellent learning experience in very minimal price. Strongly recommended for all.

Response from the owner 14:30 04 Nov 25

Thank you so much

Lal bahadur Thapa

14:12 14 Oct 25

i loved teaching technique.

Response from the owner 14:30 04 Nov 25

Thank you so much

Bimal Chapagai

05:55 13 Oct 25

Good one

Response from the owner 14:30 04 Nov 25

Thank you so much

Dipak Charchit

04:34 13 Oct 25

Class is very fruitful and interactive. Excel Point Nepal is not only a training center it is an institutions. One of the best institutions for Excel for beginers to all.

Response from the owner 14:31 04 Nov 25

Thank you so much