Excel and Power Query

MS Excel: beginner level

2 days · 16 hours6–12 people

Strong spreadsheet foundations for clear data, accurate calculations and sharing.

Excel is part of everyday work, but weak foundations turn sheets into manual fixes. Participants learn to enter data cleanly, build simple formulas and prepare readable summaries.

Ask about training View the program

Outcomes

What you will learn

Enter, edit and format data confidently

Use formulas and core functions

Understand relative, absolute and mixed references

Sort, filter and work with tables

Build clear charts and print-ready sheets

Audience

Who this workshop is for

People new to Excel
Employees using spreadsheets occasionally
Administration and office teams
People preparing for the next level

Course agenda

From knowledge to hands-on work

Day 1 · Sheets and formulas

Interface, ribbon, sheets and workbooks
Data entry, editing, autofill and Flash Fill
Number, date, currency, percentage and style formats
Rows, columns and sheets
First formulas and calculation order
Relative, absolute and mixed references
SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF and IF

Day 2 · Data and presentation

Sorting and filtering
Excel tables, total row and slicers
Conditional formatting rules, bars and color scales
Choosing and formatting charts, including combo charts
Print area, repeated headers and page fit
Sheet and workbook protection
OneDrive, sharing and useful keyboard shortcuts

Final exercise

Turn a raw list into a structured table with formulas, a chart and a version ready to share.

What you take away

Named completion certificate, practice files and a function and shortcut guide.

FAQ

Questions about this course

Do I need to know any formulas?

No. We start from the basics and practice every topic.

Can I move to the intermediate course afterwards?

Yes. This course prepares you for more complex functions and PivotTables.