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

10 months ago

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

10 months ago

Thank you so much

Ranjita Chaudhary

10 months ago

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

10 months ago

Thank you so much

Rabindra Shrestha

10 months ago

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

Response from the owner

10 months ago

Thank you so much

Pooja Sharma

11 months ago

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

Response from the owner

10 months ago

Thank you so much

Ang Kusang Sherpa

11 months ago

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

Response from the owner

10 months ago

Thank you so much

Lal bahadur Thapa

11 months ago

i loved teaching technique.

Response from the owner

10 months ago

Thank you so much

Bimal Chapagai

11 months ago

Good one

Response from the owner

10 months ago

Thank you so much

Dipak Charchit

11 months ago

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

10 months ago

Thank you so much