Excel & Spreadsheet Mastery
Organise, analyse, validate and present information with spreadsheets — formulas, lookups, pivot tables, charts, data cleaning, models and dashboards.
- Planned 30 days
- About 2 h per day
- 6 planned modules
This course is in development and not yet available for purchase. The planned curriculum below is a draft and may change before launch.
Overview
A hands-on spreadsheet program. You learn spreadsheet structure, data types and formatting, formulas, relative and absolute references, conditional logic, lookup functions, text and date functions, sorting and filtering, data validation, tables and structured references, pivot tables, charts, conditional formatting, cleaning imported data, modelling, error checking, collaboration and versioning, automation fundamentals and reporting dashboards. Lessons state which features need a particular application or paid subscription. The capstone is a documented, validated spreadsheet solution.
What you will be able to do
- Structure workbooks and format data correctly
- Write formulas with correct references, logic and lookups
- Clean, validate and summarise data with tables and pivot tables
- Build clear charts and dashboards
- Model scenarios and check for errors
- Collaborate and automate repetitive steps safely
Before you start
- Basic computer skills
Planned curriculum
A draft outline of the modules being written. Lessons are not available yet, and the outline may change after expert review.
Availability
This course is not on sale yet. It becomes available only after its lessons, assessments and resources pass Yumeora's review. When published, it is planned to be included in Yumeora All-Access.