Most people who use Excel daily have never been taught how it works. They type numbers, manually format columns and repeat the same copy-paste every week. This course starts from how spreadsheets actually function and builds from there. You will write formulas that calculate across sheets, create charts that communicate data clearly, build tables that sort and filter automatically, and use VLOOKUP and IF to automate the repetitive parts of your work.
What you will be able to do
Write formulas that calculate, reference and cross-check data
Create charts that make data immediately readable
Build tables that sort and filter without manual work
Use VLOOKUP, IF and nested functions in real files
Format consistently without doing it column by column
Automate weekly or monthly reporting tasks
Course modules
Getting Started
Navigation, cells, basic formatting
Formulas & Functions
SUM, AVERAGE, IF, VLOOKUP
Data Tables
Sorting, filtering, pivot basics
Charts & Visuals
Chart types, formatting, labels
Advanced Functions
Nested IF, IFERROR, COUNTIF
Who this is for
- Office workers who use Excel daily but feel limited
- Administrators who format reports by hand every week
- Anyone entering a data-heavy role
- Freelancers who need to present financial data to clients
Lifetime access
Certificate Included
Practice files included
12h 00min of content
EN + PT language options
Access within 24 hours. 14-day refund available.