
Welcome! You’re in the right place if Excel feels scary or unfamiliar. We will cover navigation of Excel and introduction to the ribbon functions.
How the course works: short videos, easy templates, hands-on practice.
Download the starter files folder from the resource section.
What’s a workbook vs a worksheet?
What are rows, columns, and cells?
Tour of the whole Ribbon: Home, Insert, Page Layout, View, Data, etc
Zooming, resizing columns, and opening/saving files
Explanation of tabs and functions within the Ribbon, as well as Quick Access Toolbar
Freeze Panes three ways to keep headers in place
Autofill series (days, numbers, months)
Quick-select ranges with Ctrl + Shift + arrows
Useful real life tips and usual practices
How to move around the Excel sheet faster
How to change font formats, fonts, font sizes, and colours
Alignments, how to not overdo it
Merging and wrapping trick, and when not to do it
Rationale behind utilising certain shortcuts
How to change font formats, number types (currency, %, dates) etc
Indentation and when to use certain formats
Usual practices in real-life scenarios and corporate usage
Conditional formatting and importance in Accounting / Finance jobs
Creating a Budget table from scratch (including income and expenses)
Use SUM formula to calculate totals
Make the table look presentable with formatting and borders
Add a chart (optional bonus)
Utilising learnt shortcuts to navigate the spreadsheet and table
Typing formulas incorrectly
Inconsistent formatting
Forgetting to autosave or label sheets
Quick recap of best practices
Using keyboard without a mouse
Basic to intermediate Excel keyboard shortcuts to increase efficiency, save time, and look proficient
Dos and don’ts, tips & tricks, and pitfalls
Variation/multiple ways to achieve same outcome
Congrats! You’ve completed your first Excel project
Practice a few more times with the template
Ready for Part 2? (Excel for Finance – Intermediate Tools & Formulas — more advanced and useful tools, shortcuts, and functions)
Budget Tool Solution
Feel lost in Excel? You’re not alone.
This beginner-friendly course is your shortcut to finally understanding how Excel works – no jargon, no fluff, and no prior experience required.
Whether you're a student, intern, working professional, or just trying to make sense of your finances, Excel Like a Dummy – Beginner Crash Course gives you the core skills you need to get started, fast.
You’ll learn how to:
Navigate the Excel interface like a pro (even if you've never opened a spreadsheet before)
Format your data cleanly and clearly (numbers, dates, currency, text)
Use time-saving tools like Freeze Panes, Autofill, and basic shortcuts
Build your very first working spreadsheet: a personal budget tracker
Avoid the most common beginner mistakes that slow people down
This course includes:
Step-by-step, bite-sized videos with clear walkthroughs
Downloadable templates (budget tracker, formatting practice sheet, ribbon cheatsheet)
A hands-on project you can actually use in real life
By the end of this crash course, you’ll go from “Excel dummy” to confident user — ready to handle spreadsheets without breaking a sweat.
Perfect as a first step before diving into advanced formulas, dashboards, or Excel for finance.
Let’s make Excel one of your most useful life skills with this introduction course. Ready? Let’s go.