Basic to Advanced Excel
Professional Course – 52 Days
Nepal ma sabai bhandaa complete Excel program. Formulas, Dashboards, Power Query, VBA Automation, Office Scripts, ra Excel + AI integration — ek nai course ma sab kei siknuhos.
52
Days
10
Modules
80+
Real Projects
Live
+ Recorded
Certificate of Completion
Recorded Classes Access
Real Business Projects
Lifetime Community Access
Nepali + English Medium
Why This Course
Nepal ko Sabai Bhandaa Complete Excel Program
Yo course sanga, tpain ek job-ready Excel Professional banauna saknu huncha — basic dekhi automation ra AI integration samma.
Foundations to Advanced
Step-by-step approach — khaali haatbata basic formula dekhi advanced DAX ra dynamic arrays samma.
VBA + Automation
Non-programmer lai pani bujhne gari VBA sikaunchha. Real tasks automate garnu — click bata kaam sampanna.
Office Scripts
Modern cloud automation — Excel Online ma script lekher sab kei automate garnus.
Excel + AI Integration
ChatGPT, Copilot ra Python in Excel use garera future-ready Excel workflows banaunus.
Real-World Projects
HR Dashboard, Payroll System, Sales Report, EMI Calculator — actual business scenarios ma kaam garnus.
Certified Program
Course complete garepachi Excel Point Nepal certified certificate paaunu huncha — job application ma kaam lagcha.
Learning Outcomes
Course Sakepachi Tpain Ke Garna Saknu Huncha
52 dina pachhi tpain Excel ma complete professional banaunu huncha — yaha kehi major outcomes chhan:
Advanced formulas (XLOOKUP, LAMBDA, LET, Dynamic Arrays) confidently lekna saknu huncha
Interactive Business Dashboards — charts, slicers, form controls samet banaunus
Power Query le multiple sources bata data clean ra merge garnu huncha automatically
Power Pivot ra DAX measures le data model banaunus — advanced BI analysis garnu huncha
VBA Macros lekher repetitive kaam automate garnu huncha — PDF, email, reports sab
Office Scripts le Excel Online automate garnu huncha — cloud ma pani automation
ChatGPT + Copilot use garera formula generate, data analyze ra reports banaunus
Real-world HR, Finance, Sales Excel systems banaunus — directly job ma apply garnu huncha
Course Curriculum
10 Modules · 52 Days · Complete Roadmap
Har module professionally designed cha — foundational skills dekhi cutting-edge automation samma. Day-by-day structured learning journey.
Day 1
Excel Interface, Ribbon, Navigation & Workbook Basics
Day 2
Cell Formatting – Styles, Borders, Number Formats & Fill Options
Day 3
Cell References (Relative, Absolute, Mixed) & Core Functions: SUM, AVERAGE, COUNT, MIN, MAX
Day 4
Page Setup, Print Settings, Headers/Footers & Data Validation Basics
Day 5
🔁 Practice Session – Foundations Recap & Hands-On Exercises
Practice Day
Day 6
Excel Home Tab Deep Dive – Clipboard, Font, Alignment, Styles & Editing Tools
Day 7
Data Summarization – SUMIF, COUNTIF, AVERAGEIF, SUBTOTAL & AGGREGATE
Day 8
🔁 Classwork – Real-World Data Summary Problems
Practice Day
Day 9
Named Ranges, Dynamic Ranges & Advanced Data Validation
Day 10
🔁 Practice Session – Functions & Tools Comprehensive Review
Practice Day
Day 11
Logical Functions – IF, AND, OR, IFS, SWITCH & Nested Logic
Day 12
Error Handling – IFERROR, ISERROR, IFNA & Information Functions
Day 13
🔁 Classwork – Logical Function Real-World Problems
Practice Day
Day 14
Lookup & Reference – VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH
Day 15
Dynamic Arrays – FILTER, SORT, UNIQUE, SEQUENCE & XMATCH
Day 16
Advanced Reference – INDIRECT, OFFSET, ROWS, COLUMNS & HYPERLINK
Day 17
🔁 Classwork – Lookup & Dynamic Array Projects with Real Datasets
Practice Day
Day 18
Date & Time Functions – WORKDAY, NETWORKDAYS, EDATE, DATEDIF, YEAR, MONTH
Day 19
Text Functions – LEFT, RIGHT, MID, TRIM, SUBSTITUTE, SEARCH & TEXTJOIN
Day 20
💰 Financial Functions – PMT, RATE, NPV, FV, IRR with EMI Calculator Project
Mini Project
Day 21
Advanced Formula Techniques – LET, LAMBDA, MAP & REDUCE Functions
Day 22
PivotTables Mastery – Create, Filter, Group, Sort & Analyze Large Datasets
Day 23
Advanced PivotTables – Show Values As, Calculated Fields, Slicers & Timelines
Day 24
Chart Fundamentals – Column, Line, Pie, Bar, Combo & Advanced Formatting
Day 25
Advanced Charts – Waterfall, Funnel, Dynamic & Scrollable Charts
Day 26
Advanced Conditional Formatting – Formula-Based Rules, Data Bars & Icon Sets
Day 27
Dashboard Design Principles – Layout, Color Psychology & UX for Excel
Day 28
Interactive Controls – Form Controls, Drop-downs, Scroll Bars & Checkboxes
Day 29
🏗️ Project – Build a Complete Business Dashboard from Scratch
Major Project Day
Day 30
🔁 MCQ Quiz – Charts, Dashboards & Conditional Formatting Review
Assessment Day
Day 31
Power Query Introduction – What, Why & When to Use It
Day 32
Data Cleaning in Power Query – Duplicates, Errors, Blanks & Transformations
Day 33
Combining Data – Append & Merge Queries from Multiple Sheets, Workbooks & Folders
Day 34
Power Query Calculations – Custom Columns & M-Code Basics
Day 35
Reusable Templates – Parameterized Queries & Dynamic Folder Automation
Day 36
Power Pivot & Data Model – Relationships, Hierarchies & Star Schema Design
Day 37
DAX Basics – Measures, Calculated Columns, Filter Context & Key Patterns
Day 38
🏗️ Full Project – Data Model + Power Query + Dashboard Integration
Capstone Mini Project
Day 39
Introduction to Macros – Recording, Editing, Running & Saving Macros Safely
Day 40
VBA Editor Tour – Modules, Procedures, MsgBox & InputBox Basics
Day 41
Variables, Data Types & Basic Logic – For Non-Programmers (Zero Experience OK)
Day 42
Loops & Conditions – For Loop, If-Then-Else, Do While in Real Scenarios
Day 43
Working with Sheets, Cells & Ranges – Navigate & Manipulate Data with VBA
Day 44
UserForms & Data Entry Automation – Build GUI Forms for Data Collection
Day 45
🏗️ Real-World Projects – Auto PDF Export, Outlook Email Automation via VBA
Project Day
Day 46
🏗️ Classwork – Build Your Own Automation System (Attendance / Payroll / Report)
Build Day
Day 47
Office Scripts – Automate Excel Online with JavaScript-Based Scripts | Power Automate Integration | VBA vs Office Scripts Comparison
Day 48
ChatGPT + Excel – AI Formula Generation, Data Analysis & Automation Prompts
Day 49
AI-Powered Data Cleaning & Transformation Workflows – Real Business Use Cases
Day 50
Excel Copilot – AI-Assisted Dashboards, Reports & Insights in Microsoft 365
Day 51
Python in Excel, Future AI Trends & Your Excel Career Roadmap in 2025–2030
Day 52
🏆 Grand Finale – Final Capstone Project Presentation, Individual Assessment & Official Certificate Award Ceremony | Career Guidance Session
Certification Day
Who Is This For
यो Course कसको लागि हो?
Beginner hoos vaa Excel already use garnuhuney — yo course sabaikao lagi value add garcha.
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.
Your Instructor
Sanjay Shrestha
Founder & Lead Instructor — Excel Point Nepal Pvt. Ltd.
Nepal ma Excel education lai professional level ma laan ko lagi Excel Point Nepal sthapana gareka Sanjay Shrestha — Advanced Excel, VBA Automation, Power BI ra AI+Excel integration ka specialist hun. Corporate training dekhi individual coaching samma, practical ra real-world approach le Excel sikaaucha. YouTube channel ma Nepali ra English ma Excel tutorials banaucha — beginner dekhi expert level ka students lai guide garcha.
10K+
Students
100K+
YouTube Views
13+
Years Exp.
Enrollment
Choose Your Learning Mode
Sabai options ma Course Complete certificate, recorded classes ra community access included cha.
ONLINE LIVE
Rs. 52000
Rs. 26000
तपाईंले NPR 26,000 बचाउनुभयो!
One-time payment · 52-day full access
- Online Live Classes
- Flexible Time
- Recorded Class Backup Access
- Practice Files & Templates
- Email & Community Support
- Certificate of Completion
RECORD VIDEOS CLASS
Rs. 26000
Rs. 19500
तपाईंले NPR 6,500 बचाउनुभयो!
One-time payment · Min. 2 years Access
- Online Live Classes
- Flexible Time
- Recorded Class Backup Access
- Practice Files & Templates
- Email & Community Support
- Certificate of Completion
FAQ
Frequently Asked Questions
Kehi questions cha bhane tala herne garnuhos — najhetay contact garnus!
Haa! Yo course Day 1 bata suru huncha — bilkul beginner level bata. Excel nai najanney manchhepani confidently join garna saknu huncha. Step-by-step sikaaune style le koi pani pachi nai parcha.
Bilkul garo hudaina! VBA module (Module 7) specifically non-programmers ko lagi design gareko cha. Variables dekhi loops samma — sab kei zero programming background bata sikaunchha. Practical approach le garda jochai le bujhna sakcha.
Chinta nagarnuhos! Sabai live classes record huncha ra enrolled students lai access dine garcha. Tpain aafno time ma replay garera padna saknu huncha. Important practice sessions pani download garna milcha.
Haa! Day 52 ma final assessment ra project presentation pachhi Excel Point Nepal ko official Certificate of Completion dine garcha. Yo certificate job application, LinkedIn, ra corporate interviews ma present garna milcha.
Haa! Company-specific curriculum customize garnu sakcha. Tpainko team ko needs herar specific modules ma focus garnu sakcha — HR automation, Finance dashboards, Sales reporting, etc. 5+ employees bhayeko companies lai special pricing available cha.
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.
