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
9 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
Thank you so much9 months ago
Ranjita Chaudhary
9 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!
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
Thank you so much9 months ago
Rabindra Shrestha
9 months ago
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
Thank you so much9 months ago
Pooja Sharma
10 months ago
Excellent service! it was professional, responsive, and delivered exactly what i expected . Highly satisfied
Response from the owner
Thank you so much9 months ago
Ang Kusang Sherpa
10 months ago
Excellent learning experience in very minimal price. Strongly recommended for all.
Response from the owner
Thank you so much9 months ago
Lal bahadur Thapa
10 months ago
i loved teaching technique.
Response from the owner
Thank you so much9 months ago
Dipak Charchit
10 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
Thank you so much9 months ago
Usha Budhathoki
10 months ago
Bal Krishna
10 months ago
Impressive
Thank you sir for wonderful classes
Thank you sir for wonderful classes
Response from the owner
Thank you so much9 months ago
--------- 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.
