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 Etc.
Day 4: Page Setup, Print Settings, Headers/Footers & Data Validation Basics
Day 5: 🔁 Practice Session – Foundations Recap & Hands-On Exercises
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
Day 9: Named Ranges, Dynamic Ranges & Advanced Data Validation
Day 10: 🔁 Practice Session – Functions & Tools Comprehensive Review
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
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
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
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
Day 30: 🔁 MCQ Quiz – Charts, Dashboards & Conditional Formatting Review
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
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
Day 46: 🏗️ Classwork – Build Your Own Automation System (Attendance / Payroll / Report)

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

Who Is This For

Yo Course Kasko Lagi Ho ?

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.

Excel Instructor - Excel Point Nepal
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 certificate, recorded classes ra community access included cha.

Live Online

Rs. 52000

NPR 26,000

50% Early Bird Discount — Rs. 26,000 OFF!

Recorded Videos Only

Rs. 26000

NPR. 19500

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

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.

Course primarily Microsoft 365 (Office 365) ma base gareko cha — XLOOKUP, Dynamic Arrays, Office Scripts, ra Copilot features ko lagi 365 recommended cha. Tara Excel 2019 bhaneko pani 90% content apply hunchha. VBA, Power Query, Dashboards — sabai versions ma kaam garcha.

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 Nabataunus!

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