
Excel
Excel is the most widely used tool for working with numbers. Learn to organise data, use formulas and build reports you can rely on.
Excel is the most widely used tool for working with numbers. Learn to organise data, use formulas and build reports you can rely on.
What You Will Learn
- Cells, ranges, formatting and tables
- Core formulas such as SUM, IF, COUNTIF and lookup functions
- Sorting, filtering and cleaning data
- Charts and conditional formatting
- PivotTables and summarising data
- Shortcuts and good spreadsheet habits
What You Will Build
- A monthly budget tracker
- A sales summary with a PivotTable
- A dashboard-style report
Who This Course Is For
Students, office workers, small business owners and analysts.
What You Need
Excel or a compatible spreadsheet app. No experience is needed.
How The Course Works
Every course on Skills in Minutes is free and follows the same five sections: Beginner, Intermediate, Advanced, Projects and Go pro. Each lesson is short, ends with a quick quiz and a summary, and builds on the one before. You can stop and return at any time.
Where It Can Lead
- Administrative and finance roles
- Data and business analyst
- Small business owner who manages their own numbers
Results depend on your practice, your goals and your market. This course gives you the skills and a portfolio of practical work to show for it.
Course Outline
Beginner10 lessons
1What Excel is and finding your way around2Entering and editing data the right way3Your first formulas4Functions: SUM, AVERAGE, MIN, MAX and COUNT5Formatting numbers and making sheets readable6Copying formulas and cell references7Sorting, filtering and Excel Tables8Turning numbers into charts9Common mistakes, error messages and good habits10Beginner project: a monthly budget trackerIntermediate10 lessons
11Decision formulas: IF, AND, OR and IFS12Counting and adding with conditions: COUNTIF, SUMIF and friends13Lookups: VLOOKUP, INDEX and MATCH, and XLOOKUP14Text functions: cleaning and combining words15Working with dates and times16Data validation and drop-down lists17Conditional formatting18PivotTables: summarising data in seconds19Several sheets, named ranges and cleaning messy data20Intermediate project: a monthly sales reportAdvanced10 lessons
21Dynamic arrays: FILTER, SORT, UNIQUE, SEQUENCE and LET22Advanced lookups and array logic: INDEX, SUMPRODUCT and LARGE23What-if analysis and financial functions24Statistics and forecasting: median, spread, correlation and trends25Power Query: import and clean data without formulas26Building dashboards27Automating Excel: macros, scripts and safe habits28Using Excel in professional life29Handling Excel projects: requirements, testing and handover30Capstone: build and document a workbook systemQuestions
Does this work in Google Sheets?
Most formulas and ideas work in both. The course points out the differences.
Which Excel version do I need?
Any recent version works. Newer functions are marked.
Is Excel still worth learning?
Yes. It remains one of the most requested skills in office roles.
