Home › Free courses › Spreadsheets for Work: Excel & Google Sheets

Free course · Certificate

Spreadsheets for Work: Excel & Google Sheets

Excel and Google Sheets the way offices actually use them: formulas, the five functions you will use every week, IF and lookups, cleaning messy data, charts and pivot tables, ending with a real monthly report.

Start this course free →Free account · no card needed

What you will learn

Foundations

  1. What a Spreadsheet Is Actually ForNot a table you type lists into. A calculator that remembers.
  2. Finding Your Way Around a SheetFive parts of the screen that sit in the same place in every spreadsheet app.
  3. Entering Data So It Stays UsefulFour habits that decide whether a sheet works for you later or fights you.
  4. Your First FormulaAn equals sign, a few cell addresses, and a result that keeps itself up to date.

Getting comfortable

  1. The Five Functions You'll Use Every WeekSUM gets you started. These five answer most of what an office actually asks.
  2. Sorting and Filtering Without Breaking AnythingThe fastest way to answer "which ones?" — and the one mistake that scrambles a whole sheet.
  3. Copying Formulas: The Dollar SignWhy a formula that worked in one cell gives nonsense in the next — and the one-key fix.
  4. Formatting That Helps People Read ItA sheet is for someone else too. Three kinds of formatting that make it readable in seconds.

In practice

  1. Making Decisions: IF, SUMIF and COUNTIFFormulas that check something first, then answer. This is where spreadsheets start saving real hours.
  2. Looking Things Up: XLOOKUP and VLOOKUPPull a price, a name or a phone number from another list — the skill most Excel interview tests are built around.
  3. Cleaning Messy DataReal data arrives with extra spaces, duplicates and five spellings of Colombo. Here is the fix for each.
  4. Charts That Make a PointA chart should answer one question at a glance. Picking the right type does most of the work.

Advanced

  1. Pivot Tables: 500 Rows in 30 SecondsThe feature that turns a long list into a summary a manager can read — without writing a single formula.
  2. Checking Your Work Before Anyone Else DoesEvery error code tells you what went wrong. The dangerous mistakes are the ones with no error at all.
  3. A Real Task, Start to FinishThe monthly branch report — every skill in this course, in the order you would actually use them.
  4. Sharing, Versions and Working With OthersA sheet nobody else can use safely is not finished. The habits that make you the person trusted with the numbers.

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

AI Tools for the Workplace

Use AI chat tools well at work.

See the course →
16 lessons · Free

Workplace Writing in English

Emails and messages a busy manager reads and acts on.

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 Spreadsheets for Work: Excel & Google Sheets

Free. Short lessons. A certificate you can show.

Join Loazi free →