📊 EXCEL BUSINESS ESSENTIALS

Excel foundation for data & business work

You use Excel every day but still spend a lot of time to clean data, write formulas, calculate KPI, or verify figures? 🤯

You want Excel to be not just a place to enter data, but truly become a tool that supports work and decision-making?

🚀 Excel Business Essentials is designed to help you build an Excel foundation following real-world work thinking: DATA → CLEAN → FORMULA → KPI

Instead of learning Excel by memorizing a bunch of functions and disconnected operations, you will learn through workflows and real business problems, from raw data to a complete KPI table.

---

🎯 WHO IS THIS COURSE FOR?

This course is suitable for:

👩‍💼 Office staff who want to use Excel more effectively in daily work.

📈 Business staff / Sales who need to track revenue, orders, KPI, bonuses, and performance.

💰 Accountants who need to aggregate, verify, and calculate figures accurately.

👥 Human Resources / HCNS who regularly work with employee data, departments, and reports.

⚙️ Operations staff who need to process and verify data before creating reports.

🎓 Students and Excel beginners who want to build a practical Excel foundation for work.

No advanced Excel knowledge required. You only need to know basic operations such as opening/saving files, entering data, and simple cell formatting.

---

🔥 WHAT WILL YOU LEARN AFTER THE COURSE?

After about 5 hours of learning and practice, you can:

✅ Understand how a business data table should be organized.

✅ Identify common data errors before starting calculations.

✅ Convert data into an Excel Table for easier management, filtering, and expansion.

✅ Use core Excel formulas to solve business problems.

✅ Calculate Revenue, Orders, Average Order Value (AOV), KPI and Bonus.

✅ Use SUMIFS, COUNTIFS, AVERAGEIFS, IF, AND, OR, IFERROR, ROUND in real-world situations.

✅ Check formula logic and reconcile results instead of relying only on whether Excel reports an error.

✅ Complete a workbook following the process:

RAW DATA → CLEAN DATA → KPI TABLE 📊

---

🧩 COURSE CONTENT

1️⃣ MODULE 1 — BUSINESS DATA FOUNDATION

Understand data before writing formulas

⏱️ 60 minutes

You will learn how to read and organize a standard business dataset:

🔹 Row, Column, Record, Field, Header 🔹 Distinguish Text / Number / Date data 🔹 Get familiar with Excel Table 🔹 Sort, Filter, Freeze Panes 🔹 Important rule: 1 row = 1 transaction, 1 column = 1 attribute 🔹 Identify layout errors such as Merge Cell, blank rows, or placing total rows in the middle of the data range.

💡 Practice: Work directly with a sample sales file of about 500–1.000 rows, convert data into an Excel Table, and filter data by region, product, and status.

📁 Output deliverable: 01_DATA_STANDARDIZED

---

2️⃣ MODULE 2 — BASIC DATA CLEANING

Clean data before analysis

⏱️ 45 minutes

Real-world data is rarely perfect. Therefore, before calculating KPI, you need to know how to detect and handle common errors such as:

🧹 Blank / Null 🧹 Duplicate 🧹 Extra spaces 🧹 Inconsistent text 🧹 Inconsistent dates 🧹 Number stored as Text 🧹 Inconsistent region, department, or status names.

💡 Practice: Detect 8–10 intentionally planted errors in the dataset, then clean them and note cases that require manual checking.

📁 Output deliverable: 02_CLEAN_DATA

---

3️⃣ MODULE 3 — BUSINESS FORMULAS

Turn data into meaningful numbers

⏱️ 120 minutes

This is the core module of the course 🔥

You will learn how to use groups of Excel functions that are frequently used in business problems:

📌 SUM — aggregate data 📌 SUMIFS — sum by condition 📌 COUNTIFS — count transactions by condition 📌 AVERAGEIFS — average by condition 📌 IF — classify results 📌 AND / OR — combine multiple business conditions 📌 IFERROR — handle display errors 📌 ROUND — round numbers 📌 Some Text / Date functions needed for each problem.

💼 You will apply formulas to:

💰 Calculate Total Revenue 🧾 Calculate Total Orders 📊 Calculate Average Order Value (AOV) 👤 Analyze revenue by employee 🌍 Analyze revenue by region 🎯 Determine Met / Not Met KPI status 🎁 Calculate bonuses based on revenue and KPI conditions.

In particular, the course does not only focus on “writing correct syntax”, but also guides you on how to check formula logic and reconcile results.

📁 Output deliverable: 03_KPI_CALCULATION

---

4️⃣ MODULE 4 — MINI BUSINESS CASE

After learning, you must be able to do the job! 💪

⏱️ 45 minutes

In the final part, you will connect all the knowledge you have learned into a complete business scenario.

📌 Context:

You are a Business Department support staff. A manager sends you a sales file with data errors and asks you to quickly create a KPI table to evaluate employee performance.

You will:

➡️ Read the business requirements ➡️ Identify the metrics to calculate ➡️ Identify the data source ➡️ Complete the KPI table ➡️ Check sample results ➡️ Detect and handle errors in the workbook.

📈 Sales Performance Problem

You will practice calculating:

💰 Revenue 🧾 Orders 📊 AOV ↩️ Return Rate 🎯 KPI Status 🎁 Bonus

📁 Output deliverable: A complete workbook including:

RAW DATA → CLEAN DATA → KPI TABLE

---

🚀 MINI CAPSTONE — COMPREHENSIVE PRACTICE EXERCISE

This is the part that helps you verify whether you can actually do it or not.

You will start with a sales file containing data errors and complete the entire process yourself:

Step 1️⃣

Standardize the data structure and convert it into an Excel Table.

Step 2️⃣

Handle basic errors:

🧹 Blank 🔄 Duplicate 🔢 Number / Text 📅 Dates

Step 3️⃣

Calculate the metrics:

💰 Total Revenue 🧾 Total Orders 📊 Average Order Value ↩️ Return Rate

Step 4️⃣

Determine employees who Met / Not Met KPI according to the provided conditions.

Step 5️⃣

Calculate Bonus using IF combined with AND/OR and manually check at least 3 cases.

📦 After the practice exercise, you will have:

📄 01_RAW_DATA — original data kept unchanged 📄 02_CLEAN_DATA — cleaned data 📄 03_KPI_TABLE — complete KPI table 📝 Short notes on the data errors detected.

More importantly, the workbook must ensure formulas are logically correct, do not change the original data, include a method for reconciling results, and have a readable layout.

---

🎓 LEARNING METHOD

This is not about learning Excel by “memorizing functions” ❌

Instead, the course follows this method:

30% Explanation → 70% Hands-on Practice 💻

Each concept is implemented in a cycle:

Problem → Formula/Operation → Check → Fix Errors 🔄

The instructor focuses on the thinking behind choosing formulas and how to check results, helping you understand the essence instead of just memorizing syntax.

---

✅ AFTER THE COURSE, YOU CAN CONFIDENTLY CHECK-LIST

☑️ Understand standard tabular data ☑️ Clean basic data errors ☑️ Use SUMIFS / COUNTIFS / AVERAGEIFS ☑️ Use IF / AND / OR ☑️ Calculate basic KPI ☑️ Know how to Verify and reconcile results ☑️ Complete an Excel workbook following a real-world workflow.

---

🌟 WHAT MAKES EXCEL BUSINESS ESSENTIALS DIFFERENT

💡 No unfocused learning — focus on Excel skills that are highly applicable at work.

💡 Not just learning formulas — you also learn how to read data, clean data, and check results.

💡 Learn with real-world data — the course is filled with datasets and problems set in a business context.

💡 Clear output deliverables — at the end of the course, you complete a workbook from raw data to a KPI table.

💡 Build a foundation for advanced learning — the course 1 workbook can continue to be used as input for Excel Business Analytics, where learners continue with Lookup, advanced Data Cleaning, and PivotTable.

---

📌 COURSE INFORMATION

⏱️ Duration: About 5 hours / 300 minutes 🎯 Approach: Concise – Easy to apply – With output deliverables 💼 Method: Learn through workflows and real-world problems 📊 Focus: Data – Formula – KPI 👨‍💻 Learning format: Learn and practice directly on the dataset throughout the course.

---

🚀 FROM “KNOWING HOW TO USE EXCEL” TO “USING EXCEL TO GET WORK DONE”

Excel is not just cells and formulas.

The important thing is that you know:

📥 Receive data → 🧹 Clean → 🧮 Calculate → 🎯 Measure KPI → ✅ Check → 📊 Create reports

And that is the foundational capability that Excel Business Essentials aims for.

👉 Start with the Excel problems you encounter every day and turn them into a clear, accurate workflow that can be applied immediately at work.