Description

Advanced MS Excel (Professional Mode)

The Only Skill That Guarantees a Job in ANY Office.

Duration: 1 Month (Fast-Track & Intensive) Course Fee: DM for Enquiry Location: Easy Computer Education, Dhangadhi–7, Kailali

Course Overview

“Do you know Excel?” is the first question asked in any job interview for a Bank Teller, Storekeeper, or Accountant. 90% of people know how to open Excel, but only 10% know how to use VLOOKUP, Pivot Tables, and Macros to finish 5 hours of work in 5 minutes.

This 1-Month Professional Course is designed to make you that top 10%. We move beyond simple tables and teach you how to build Automatic Invoices, Salary Sheets, and Inventory Systems used in real Dhangadhi businesses.

What You Will Learn (Week-by-Week Syllabus)

Week 1: Data Entry & Formatting (Speed Mastery)

• Keyboard Shortcuts: Stop using the mouse! Learn the “Ninja Shortcuts” to navigate data 5x faster.

• Smart Data Entry: Using Flash Fill and Auto-Fill to clean messy data instantly.

• Professional Formatting: Designing bills and reports that look like they came from expensive software.

• Data Validation: Creating “Drop Down Lists” so others cannot make mistakes while entering data.

Week 2: The Magic of Formulas (The Brain of Excel)

• Logical Functions: Master IF, AND, OR, & IFERROR to make decisions (e.g., “If sales > 50,000, give 5% Bonus”).

• Lookup Wizardry: Stop searching manually. Master VLOOKUP, HLOOKUP, and the modern XLOOKUP to find data across different sheets.

• Math & Stats: SUMIF, COUNTIF, and AVERAGEIF to generate instant reports (e.g., “Total Sales of Dhangadhi Branch only”).

Week 3: Data Analysis & Reporting (Boss Level)

• Pivot Tables: The most important skill for Banks. Summarize 10,000 rows of data into a 1-page report in 3 clicks.

• Charts & Dashboards: Turning boring numbers into beautiful Pie Charts and Trend Lines for presentations.

• Filtering & Sorting: Advanced filtering to find specific customer data instantly.

Week 4: Real-World Projects (Nepal Context)

• Salary Sheet Automation: Creating a payroll system that automatically calculates Tax, Provident Fund (PF), and Net Salary.

• Inventory Management: Tracking Stock In / Stock Out for a wholesale shop.

• Interest Calculation: Creating a Loan Repayment Schedule (EMI) used in Cooperatives.

• Printing Masterclass: How to print a large spreadsheet on a single A4 page perfectly.

Career Opportunities

• Assistant Level in Banks: Essential for Teller and Customer Service roles.

• Storekeeper: Manage stock in department stores or hardware shops.

• Data Entry Operator: High demand in NGOs and Project Offices.

• Account Assistant: Help CAs and Accountants with daily entry.

Why Choose Easy Computer Education?

• Real Business Data: We don’t use “Apple/Orange” examples. We use raw data from real sales and banking scenarios.

• Formula Cheat Sheet: Every student gets a printed guide of the Top 50 Formulas to keep on their desk.

• Interview Prep: We conduct a “Mock Test” similar to the Banking Assistant exams to test your speed.