Non-accredited short course
Microsoft Excel 365 Intermediate
Excel users comfortable with data entry, formatting and basic formulas.
Programme information
Microsoft Excel 365 Intermediate
Short course · Digital skills and AI
Entry Requirements
Recommended: Excel 365 Basic or equivalent skills in data entry, formatting and simple formulas. Use Microsoft Excel 365 for practice.
Course Outline and Delivery
Practical outcome. Build a monthly sales report with formulas, a PivotTable and a chart.
On-site, live online or blended · 2 training days Self-paced online · 16 study hoursWhat you’ll learn
- Relative and absolute references
- Conditional formulas and lookups
- Tables, sorting and filtering
- Data validation and conditional formatting
- PivotTables and charts
Assessment and Completion
Practise relative and absolute references, conditional formulas, lookups and PivotTables. Check the accuracy of your calculations and summaries before sharing your workbook.
Practical task. Analyse monthly sales in an editable workbook and create a PivotTable and chart to explain the results.
Completion and recognition
Submit the monthly sales workbook with working formulas, a PivotTable and chart, and explain two findings. Finweb issues a Certificate of Attendance to learners who meet the attendance requirements.
Dates and Fees
Ask Finweb about dates, fees, delivery options and what is included.
