← All certifications
Fundamentals8 lessons · 10-question assessment · 2 attempts

Data Analytics with Excel

Turn raw spreadsheets into decisions, the skill employers ask for in every interview.

WHAT THIS LESSON COVERS

Data analytics is answering a real question with evidence instead of opinion. Excel remains where most business data lives and where most business analysis happens, because every report, payroll file, sales register and ledger you will ever receive arrives as a spreadsheet. This lesson frames what analysis actually is, and where Excel fits in the workflow from raw file to decision.

THE FOUR QUESTIONS EVERY ANALYSIS ANSWERS

1. What happened? (Descriptive: the sales report, the attrition count.)

2. Why did it happen? (Diagnostic: which region, which month, which team.)

3. What will happen? (Predictive: run-rate projections, trend lines.)

4. What should we do? (Prescriptive: the recommendation.)

Most office work lives in the first two, and doing them well is already valuable. The habit that separates analysts from spreadsheet operators is always starting from a question, never from the file. "What is in this sheet?" produces dumps; "which three products drove last quarter's growth?" produces analysis.

THE WORKFLOW, END TO END

1. Get the data: export, download, copy.

2. Clean it: fix headers, types, duplicates and blanks (lesson 1; typically half the work).

3. Explore: sort, filter, pivot, aggregate until the shape of the data is visible.

4. Analyse: formulas, lookups, pivots and charts answering the question.

5. Communicate: one page, one chart, one recommendation.

Beginners spend their effort on step 4 and their hours on steps 1 and 2. The professionals' secret is the reverse allocation: a clean, well-shaped dataset makes every later step easy.

WHY EXCEL AND NOT SOMETHING FANCIER

Because the ecosystem is already there. Your company's data, your colleagues' skills and your clients' expectations are all Excel-shaped. Excel handles comfortably into the hundreds of thousands of rows, its formula language is a shared workplace dialect, and the concepts you learn here (filtering, joining, aggregating, visualising) transfer directly to SQL, Power BI or Python when scale demands them. Learn the thinking here; upgrade the tool later if the data outgrows it.

WORKED EXAMPLE

An HR executive receives an attendance export for 120 employees across three months and is asked "are we paying for people who are not showing up?" Question defined. Clean: fix the date column that imported as text, remove 14 duplicate rows, drop two ex-employees. Explore: pivot attendance by employee and month. Analyse: flag anyone with more than 8 LOP days while still drawing full salary, cross-check against payroll with a lookup. Communicate: one page, three names, the rupee value of the discrepancy, one recommendation. That whole investigation is this course in miniature, and it took under two hours because the data was cleaned first.

WHAT GOOD OUTPUT LOOKS LIKE

A decision-maker should read your output in 30 seconds: the answer in one sentence, the evidence in one chart or table, the assumption and caveat in one line. If your analysis needs a walkthrough to be understood, it is not finished. This is a communication discipline as much as a technical one, and it is what turns spreadsheet work into influence.

THE VOCABULARY YOU WILL REUSE EVERYWHERE

Row, column, cell, range. Filter and sort. Aggregate (sum, count, average). Join or lookup (matching records across tables). Pivot (rearranging long data into summary). Chart (visual encoding). These six ideas are the whole of analytics in any tool; Excel is simply where you will practice them first, on data your office actually cares about.

FOUR MISTAKES OF BEGINNERS

1. Starting from the file instead of the question.

2. Editing the raw data in place, so the original is lost and the analysis cannot be rechecked.

3. Manual fixes (typing corrected values by hand) that break silently next month when new data arrives.

4. Presenting 40 rows when one sentence and one chart would have decided the meeting.

PRACTICE

Take any spreadsheet you can find (attendance, sales, expenses) and write the one question you would answer with it, in one sentence. Then list the columns you would need and the one chart that would show the answer.

Loading…

The assessment

10 multiple-choice questions · 50% pass mark · two attempts.