Monthly budget
A budget sheet with categories, totals and a chart of where the money goes.
From tidy spreadsheets to formulas, PivotTables and dashboards: the office skill almost every employer asks for.
You have reached the end of the beginner stages. Prove what you learned with a project.
You have reached the end of the intermediate stages. Prove what you learned with a project.
You have reached the end of the advanced stages. Prove what you learned with a project.
A budget sheet with categories, totals and a chart of where the money goes.
Calculate averages and grades with IF and highlight anyone at risk.
Summarise a sample sales file by region, product and month with PivotTables and charts.
Combine twelve monthly files into one clean table that refreshes with one click.
Build a dashboard with key numbers, trends and slicers for a sample business.
Model a loan or savings plan with scenarios and Goal Seek.
The same roadmap as a reading list: every stage, what each topic covers, and which ones are optional.
Enter data, move around quickly and format it so it is easy to read.
Calculate with formulas and understand relative and absolute references.
Find what you need in a long list in seconds.
A free, browser-based alternative that works much the same way.
Make a formula choose between results based on a condition.
SUMIFS, COUNTIFS and AVERAGEIFS for totals by category.
Pull matching values from another table.
Clean names, split text and calculate with dates.
Summarise thousands of rows by any category in a few clicks.
Pick the right chart and keep it simple and honest.
Highlight what matters automatically.
Turn ranges into tables that grow and keep formulas consistent.
Import, clean and combine data with steps that repeat on new files.
Stop wrong entries with drop-down lists and rules.
Find and remove repeated rows safely.
FILTER, SORT and UNIQUE return whole lists that update by themselves.
Scenarios, Goal Seek and data tables for planning and forecasting.
One page of charts and key numbers that updates when the data does.
Name parts of long formulas and build your own reusable functions.
Automate repeated tasks with recorded macros and simple code.
Work on the same file at the same time without overwriting each other.
Lock formulas and layout so others can only edit the right cells.
Separate inputs, calculations and outputs, and label everything.
When data outgrows Excel, the same skills carry over to Power BI.
Spreadsheets are used for budgets, reports, lists and analysis in almost every office job, from HR and sales to finance and operations.
Usually XLOOKUP or VLOOKUP, SUMIFS, PivotTables, charts, data cleaning and sometimes Power Query or macros.
Both are useful and very similar. Excel is more common in large organisations; Google Sheets is free and easy to share.
© 2026 KamerLink. All rights reserved.