Learn Excel Free, Excel for Nepalese, Excel course free, Excel formulas, Excel practice files

Why Excel matters for Nepalese worldwide

Whether you’re in Dubai, Doha, Kathmandu, Tokyo, Sydney, London, or New York—Excel is a universal work skill. It helps you track expenses, analyze sales, prepare reports, and impress employers. Excel सिकेपछि—रिपोर्ट बनाउन, data बुझ्न, र office efficiency बढाउन सजिलो हुन्छ।

• Better jobs & promotions: Admin, accounts, sales, HR, logistics—Excel is everywhere.
• Personal finance: Budget, savings, loan schedules—stay in control.
• Business: Inventory, billing, profit tracking—even if you run a small store or online shop.
• Free tools available: You can learn using Excel (desktop/web) or even start in Google Sheets.

What you’ll learn (syllabus)

• Navigation, selection, tables, sorting & filtering
• Essential formulas: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, SUMIF, COUNTIF, lookups (VLOOKUP or XLOOKUP)
• Formatting for readability and print-ready reports
• Cleaning data: TRIM, text dates to real dates, fixing errors
• Quick analysis with PivotTables (intro)
• Real-life mini projects for work & personal life

Free downloads: practice data & cheat-sheet

Use these files for all exercises in this article.

• Practice Dataset (.xlsx) — Sales (30 rows) + Expenses (12 rows)
• Practice Dataset (.csv)
• Excel Basics Cheat-Sheet (PDF)

10-Day Plan: From Zero to Confident

1. Day 1: Interface tour, cells/rows/columns, saving, Ctrl+T to create a Table. Practice: open Sales sheet & turn it into a Table.
2. Day 2: Sorting & filtering; freeze panes; basic formatting (bold, number, date). Practice: show top 10 largest Total values.
3. Day 3: Math functions: SUM, AVERAGE, MIN, MAX. Practice: average UnitPrice by product.
4. Day 4: Counting: COUNT vs COUNTA; COUNTIF. Practice: how many sales in “Dubai”.
5. Day 5: Conditions: IF, SUMIF. Practice: total revenue for “Headset”.
6. Day 6: Text basics: CONCAT/&, LEFT, RIGHT, TRIM. Practice: merge Region + Product as a label.
7. Day 7: Dates: DATE, TODAY, TEXT. Practice: show sales by month name.
8. Day 8: Lookups: VLOOKUP (or XLOOKUP if available). Practice: lookup price by product.
9. Day 9: Quick analysis: Insert PivotTable; summarize revenue by Region and Product.
10. Day 10: Print setup, page layout, and a mini report. Practice: create a one-page sales summary PDF.

Tip: Study 30–40 minutes a day. छोटो तर नियमित अभ्यास—सबैभन्दा प्रभावकारी।

Core skills you must master

1) Essential formulas

=SUM(B2:B31)
=AVERAGE(C2:C31)
=MIN(D2:D31)   =MAX(D2:D31)
=COUNT(A2:A31) =COUNTA(A2:A31)
=IF(E2>=1000,"High","Normal")
=SUMIF(B:B,"Headset",F:F)
=COUNTIF(E:E,"Dubai")
=VLOOKUP("Mouse",B:F,4,FALSE)   
=XLOOKUP("Mouse",B:B,F:F)       
=TEXT(A2,"dd-mmm-yyyy")
=CONCAT(B2," - ",E2)  =B2 & " - " & E2
=TRIM(G2)

2) Formatting that makes reports readable

• Use Number formats (not text); align currency and decimals.
• Apply conditional formatting for top performers, negatives, or dates about to expire.
• Use Wrap Text and Auto-fit (Alt → H → O → I) to tidy columns.

3) Cleaning data (quick wins)

• Remove extra spaces with TRIM; convert text numbers to real numbers.
• Fix common errors: #N/A (lookup not found), #DIV/0!, #VALUE!.
• Split combined values with Text to Columns or text functions (LEFT, RIGHT, MID).

Mini projects (real-life)

1. Monthly Expense Tracker: Use the Expenses sheet; sum by category, highlight overspend.
2. Simple Sales Dashboard: Pivot sales by Region and Product; add a slicer for Region.
3. Invoice Template: Build an invoice with auto totals (Qty*UnitPrice) and print setup.
4. Attendance Sheet: Mark P/A/L; count monthly presence using COUNTIF.
5. Basic Stock List: Use conditional formatting to flag low stock (<=5).

यी मिनी प्रोजेक्टहरूले जागिरका दैनिक काम सजिलो बनाउँछन् र portfolio पनि तयार हुन्छ।

Career impact + CV lines you can use

• Admin/Coordinator: “Prepared weekly Excel reports with sorting, filtering, and PivotTables to summarize KPIs.”
• Sales/Store: “Tracked daily sales & inventory using Excel tables, formulas (SUMIF/COUNTIF), and print-ready summaries.”
• Accounts/Finance (entry): “Cleaned and reconciled data with TRIM, text-to-columns, and date formats; automated totals with IF and SUMIF.”

CV मा यस्ता ठोस बुँदा राख्दा recruiter ले तुरुन्त skill देख्छ।

Ready to start?

Join the free starter course and learn with step-by-step videos and assignments.

Start the Free Course Get the Practice Files

FAQs