Excel Automation Masterclass

Nepal Ko Sabse Complete Excel Automation Course — Power Query, DAX, VBA, Dashboard Design ra AI+Excel sabai ek course ma siknuhos.

26

Days of Training

8

Modules

100+

Real Projects

Live

+ Recorded

26H

Total Content

500+

Students Trained

Certificate of Completion

Recorded Classes Access

Real Business Projects

Lifetime Community Access

Nepali + English Medium

What You Will Learn

Course Sakepachi Tpain Ke Garna Saknu Huncha

Yo course le tapailai real-world Excel automation skills dinchhha — jo Nepal ka companies ma direct kaam auncha.

💡 Nepal ma yesro complete Excel course chaina. Basic to VBA + AI — sab ek thau ma. Yo nai tapailako competitive advantage ho.

Repetitive Tasks Auto garnus

Data cleaning, report generation — 90% time bachaunu hola

Power Query Master

Messy data lai 1-click ma clean gari dashboards ready garnus

Professional Dashboards

Auto-update hune KPI dashboards banaunus — job-ready skill

DAX Measures

YTD, MTD, Achievement %, Ranking — complex calculations

VBA Automation

Email pathaunu, PDF save garnu, UserForms — sab automatic

AI + Excel

ChatGPT bata formulas + VBA code generate garnus instantly

Data Entry Systems

Professional UserForms bata HR, Inventory entry systems

Freelancing

Upwork/Fiverr ma NPR 5,000–50,000 per project kamaunus

Who Is This For

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

Prerequisite: Excel Basic to Advanced course complete gareko hunu parchha. SUMIFS, VLOOKUP, PivotTable basic knowledge chahiyo. Basic to Advanced course hernus →

Students & Freshers

Job market ma competitive advantage chaahine students — Excel professional skill le resume strengthen garcha.

Office Professionals

Daily Excel use garunuhune professionals — automation ra dashboards le kaam ghantaabaata minutema sampanna.

Accountants & Finance Teams

Financial modeling, EMI calculators, payroll automation — practical finance-focused Excel skills siknuhos.

Business Owners

Aafno business data manage garna, reports banauna ra data-driven decisions lina Excel master garnus.

Data Analysts (Aspiring)

Power Query, Power Pivot ra DAX — data analytics career start garna perfect foundation.

Career Switchers

New field ma jaana chahne professionals — Excel + AI skills le instantly employable banaaucha.

Course Curriculum

26-Day Detailed Syllabus

8 structured modules — Automation Foundation dekhi VBA, AI ra Career guidance samma

Day 1
Automation Mindset & 13 Components
Excel Automation kya ho · Manual vs Automated comparison · 13 component framework · Automation roadmap overview
Day 2
Formula Automation — Dynamic References
INDIRECT · OFFSET · Dynamic Named Ranges · Structured References · CHOOSE+INDEX · IFERROR bulletproofing
Day 3
Advanced Formula — LAMBDA, LET & Spill
LET variables · LAMBDA custom functions · BYROW/BYCOL · MAP/REDUCE · XLOOKUP advanced spill behavior
Day 4
Formatting Automation System
Custom Number Format (NPR, Lakhs/Crore) · Cell Styles system · Table Styles · Conditional Formatting formula-based · Icon Sets · Theme automation
Day 5
Template Design & Data Validation
Template .xltx design · Dependent dropdown lists · Province → District automation · Invoice template · Payslip XLOOKUP project
Day 6
Multi-Sheet Data Automation
3D References · SUMIF across sheets · Branch data consolidation (New Road, Bhaktapur, Pokhara) · Monthly auto-combine
Day 7
Data Cleaning Automation
Flash Fill · Go To Special · Remove Duplicates · Text to Columns · Find & Replace wildcards · TRIM/CLEAN/PROPER in bulk
Day 8
Data Preparation Layer — Star Schema
Data modeling concept · Fact Table + Dimension design · Star Schema · Primary/Foreign Keys · Real shoe company sales project
Day 9
Power Query Introduction & Data Import
Query Editor tour · Import from Excel/CSV/Web/API (JSON/XML) · Applied Steps · Data types at source
Day 10
Data Cleaning & Text Transformation
Trim/Clean/Proper · Replace Values · Split/Merge columns · Extract text · Remove blanks/errors/duplicates · Fill Down
Day 11
Advanced Transformations
Group By · Pivot/Unpivot · Custom Column (M language) · Conditional Column · Date/Time extraction
Day 12
Merge & Append Queries
Append — combine 12 monthly files · Combine from folder · Merge (VLOOKUP alternative) · All Join types · Load to Data Model
Day 13
Power Query End-to-End Project
Shoe Company data: Import → Clean → Merge → Net Revenue → Load to Model · Review + Q&A
Day 14
Data Model & Relationships
Power Pivot window · Import from PQ · Create relationships · Star Schema diagram · Calendar Table · Mark as Date Table
Day 15
DAX Fundamentals
CALCULATE · FILTER/ALL/ALLEXCEPT · SUMX/COUNTROWS · RANKX · RELATED · AllMeasures table creation
Day 16
Advanced DAX + Class Assignment
TOTALYTD/MTD/QTD · SAMEPERIODLASTYEAR · Achievement % · Practical assignment with 4 real business measures
Day 17
Dashboard Design & KPI Cards
5 design rules · Layout planning · KPI cards · Slicer + Timeline · Brand color system
Day 18
Dynamic Charts & Interactive Controls
Column/Bar/Combo/Waterfall/Donut · Dynamic chart titles · Form Controls · INDEX+MATCH chart range · Sparklines
Day 19
End-to-End Dashboard Project
Nepal Sales: Raw Data → PQ Clean → Data Model → DAX → Pivot → Dashboard KPIs + Charts + Slicer + Timeline
Day 20
Macro Recording & VBA Introduction
Developer tab · Record/Edit/Run · Assign to button · VBA Editor tour · First Sub procedure · Save as .xlsm
Day 21
VBA Basics — Variables, Conditions, Loops
Dim + data types · IF/ElseIF · Select Case · For/For Each loops · Do While/Until · MsgBox/InputBox
Day 22
VBA Objects, Properties & Events
Workbook/Worksheet/Range objects · Cells vs Range · With…End With · Events: _Open, _Change, _SelectionChange
Day 23
VBA Projects — Data Cleaning & Reports
Data cleaning VBA · Loop all rows · Auto-format cleaned data · Report generator · PDF save with date filename
Day 24
UserForms — Professional Data Entry
UserForm design · TextBox/ComboBox/Button · Add/Edit/Delete · Validation · HR Employee Entry System project
Day 25
Advanced VBA — Email, PDF, Error Handling
Outlook email automation · PDF export · File operations · On Error GoTo · Arrays · Dictionary · WhatsApp API intro

Day 26

Office Scripts + AI + Excel + Career
Office Scripts vs VBA · ChatGPT formula/VBA prompts · Copilot in Excel · Career roadmap · Freelancing on Upwork/Fiverr · Certificate ceremony
-----YOUR INSTRUCTOR-----

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

Excel Instructor - Excel Point Nepal

Sanjay Shrestha

Excel & AI Trainer | Founder, Excel Point Nepal

Nepal मा Excel, VBA, Power BI र AI+Excel integration को expert trainer। Practical, real-world approach मा हजारौं students लाई पढाइसकेको अनुभव।

10K+

Students

100K+

YouTube Views

13+

Years Exp.

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

Students के भन्छन्?

Excel Point Nepal Pvt. Ltd. place picture
4.9
Based on 217 reviews
powered by Google
Suvash Chaudhary profile picture
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 profile picture
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 profile picture
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 profile picture
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 profile picture
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 profile picture
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 profile picture
Bimal Chapagai
05:55 13 Oct 25
Good one
Response from the owner 14:30 04 Nov 25
Thank you so much
Dipak Charchit profile picture
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
Usha Budhathoki profile picture
Usha Budhathoki
04:26 13 Oct 25
Bal Krishna profile picture
Bal Krishna
02:44 13 Oct 25
Impressive
Thank you sir for wonderful classes
Response from the owner 14:31 04 Nov 25
Thank you so much
--------- ENROLL NOW ---------

Course Fee

EARLY BIRD — Limited Seats

Rs. 13000

Rs. 2490

तपाईंले NPR 10,510 बचाउनुभयो!

ONLINE LIVE CLASS

⏱ Duration: 26 Days (1 Hour/Day)
🕖 Fixed Time: 8:00 PM to 9:00 PM
👥 WhatsApp Support Group
🎥 Class Recordings
📜 Course Complete Certificate Included
✔ Practice Files & Resources
✔ Real-world Projects
RECORDED VIDEO CLASS

Rs. 13000

Rs. 1990

तपाईंले NPR 11,010 बचाउनुभयो!

Recorded Video Class (Min. 2 year Access)

⏱ Duration: 26 Hours
🕖 24 Hours available
👥 WhatsApp Support Group
🎥 Original Live Class Videos
📜 Course Complete Certificate Included
✔ Practice Files & Resources
✔ Real-world Projects

Excel ma Expert banne Mauqa Nachhutaunus!

Nepal ma Excel ra AI integration sika ra career ma agi badhnuhos. Limited seats available — aaja nai join garnus.