Home › Free courses › Data Analysis for Work: Excel, Google Sheets and Power BI

Free course · Certificate

Data Analysis for Work: Excel, Google Sheets and Power BI

Learn data analysis for work in Excel, Google Sheets, WPS Office or LibreOffice, then build a report in Power BI and a shared dashboard in Looker Studio. Start from the question, tidy the data, use the median when the average lies, take pivot tables further, compare rates instead of totals, read trends, and catch the extra zero or copied row before anyone else does. Then pick the right chart, spot misleading ones, write titles that say the finding, build a dashboard that works on a phone, and write your finding in three lines. You practise on a real sales file from start to finish.

Covers
Start this course free →Free account · no card needed

What you will learn

Foundations

  1. Start With the Question"Can you look at the sales data?" is not a question yet. Turn it into one you can answer.
  2. What One Row MeansBefore any formula, find out what a single row stands for. It decides what you can add up.
  3. Tidy Data Before You AnalysePivot tables, charts and Power BI only work on a plain list. Fix the layout first.
  4. Averages That LieOne very large number can drag an average a long way. The median tells you what is typical.

Getting comfortable

  1. Pivot Tables, the Second StepYou can already sum by branch. Now show shares, months and two things at once.
  2. Compare Rates, Not TotalsThe biggest branch has the most of everything, complaints included. Divide before you compare.
  3. Trends Over TimeMonth on month, the same month last year, and the one-off spike that is not a trend.
  4. Numbers That Look WrongBefore you trust a total, look for the extra zero, the copied row and the impossible value.

In practice

  1. Pick the Right ChartThe question picks the chart. Bars to compare, a line for time, a table for exact numbers.
  2. Charts That MisleadA cut-off axis or a title that claims too much changes what people see. Spot it, and never do it.
  3. A Title That Says the FindingMost chart titles name the data. A good one tells the reader what to see.
  4. A Dashboard on One ScreenThree numbers at the top, two or three charts below, one filter. Built to read on a phone.

Advanced

  1. Power BI: Your First ReportPower BI Desktop is free on Windows, and many analyst job ads ask for it. Build a report from the practice file.
  2. Looker Studio: A Dashboard You Can ShareFree with a Google account, runs in a browser, and shares like a Google Doc.
  3. Write the Finding in Three LinesWhat happened, why it matters, what to do. A manager should be able to act without opening the file.
  4. The Branch Review, Start to FinishUse the whole course on the practice file, and write the three lines your area manager will read.

Your certificate

Pass the lesson checks and Loazi issues a certificate in your name. It carries its own ID, so an employer can type it into loazi.org/verify and see straight away that it is genuine.

More free courses

16 lessons · Free

Spreadsheets for Work: Excel & Google Sheets

Excel and Google Sheets the way offices use them.

Covers
See the course →
16 lessons · Free

Get Shortlisted: CV, LinkedIn and Job Search

Write a CV that gets shortlisted, and find real jobs.

Covers
See the course →
16 lessons · Free

Job Interview Skills: From Invite to Offer

Prepare, answer well, and practise a full mock interview.

Covers
See the course →
16 lessons · Free

Your First 90 Days at Work

Pass probation and start your first job well.

Covers
See the course →
16 lessons · Free

AI Tools for the Workplace

Use AI chat tools well at work.

Covers
See the course →
16 lessons · Free

Workplace Writing in English

Emails and messages a busy manager reads and acts on.

Covers
See the course →
16 lessons · Free

Cyber Safety and Data Protection at Work

Spot scams and protect your accounts and data.

Covers
See the course →

Questions

Are the courses really free?

Yes. Every course on Loazi is free for students and graduates. You need a free Loazi account to take them.

What do I get at the end?

Pass the lesson checks and Loazi issues a certificate in your name with its own ID. Any employer can type that ID into loazi.org/verify and see straight away that it is genuine.

Do I need any experience?

No. Each course starts from the basics and builds up through four levels, so you can begin wherever you are.

Start Data Analysis for Work: Excel, Google Sheets and Power BI

Free. Short lessons. A certificate you can show.

Join Loazi free →