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-----
तपाईंलाई कसले पढाउँछ?
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 के भन्छन्?
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!
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!
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
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
04:26 13 Oct 25
Bal Krishna
02:44 13 Oct 25
Impressive
Thank you sir for wonderful classes
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.
