About this course
Excel essentials gives your team a solid, practical grounding in the spreadsheet skills used every day. Participants learn to structure data properly, write formulas that stay correct as data changes, format sheets so they are easy to read and share, and turn numbers into clear charts. The course is hands-on throughout, with exercises based on typical business tasks.
Who it's for
- New or occasional Excel users
- Staff who work with lists, reports or simple financial data
- Anyone who wants to stop relying on colleagues for spreadsheet tasks
What participants will learn
- Navigate Excel efficiently and use shortcuts that save time
- Structure data in tables that are easy to sort, filter and maintain
- Write formulas with relative and absolute references
- Use core functions such as SUM, AVERAGE, IF and COUNTIF
- Format sheets and numbers clearly and consistently
- Create and format charts that communicate results
- Prepare workbooks for printing and sharing
Course outline
1.Getting around Excel
- Workbooks, sheets, cells and ranges
- Entering and editing data efficiently
- Useful keyboard shortcuts
2.Organising data
- Excel tables
- Sorting and filtering
- Freezing panes and managing large sheets
3.Formulas and functions
- Building formulas
- Relative and absolute references
- SUM, AVERAGE, MIN, MAX, IF and COUNTIF
4.Presenting your data
- Number and cell formatting
- Conditional formatting
- Creating and formatting charts
- Printing and sharing workbooks
Before you start
Basic computer skills. No previous Excel experience is needed.