Description
This course is designed as a one-day, hands-on workshop to teach users the intermediate skills of working with Microsoft Excel for Windows. It can be taken as a follow on from our Microsoft Excel Foundation course or taken standalone.
Outcomes
This course better prepares users to utilise Microsoft Excel and to go on to put their knowledge into practice, enabling real business outcomes.
Constitution
- Theoretical: 15% | Practical – Demo: 45% | Practical – Tasks, Activities or Labs: 40%
Percentages are approximate. Whilst we endeavour to include a blend of theory, demo, and activities in our courses we recognise that some delegates prefer a particular style of course (E.g., wholly, or predominantly lab-based workshops or immersion experiences) and kindly ask them to consider their preferred learning style before registration.
Agenda | Learning Paths
- Basics including Navigation and File Operations
- Managing the Worksheet
- Using AutoSum
- Copy Formulas
- The Structure of Formulas
- Formatting The Worksheet
- Using Tables
- Creating Charts
- Creating Pivot Charts
- Editing Charts
- Filtering Charts
- Working with Multiple Workbooks and Worksheets
- PrintingÂ
- Delegates should come to the course with basic computer user skills such as how to open apps, how to use a browser and how to save a file.
- Roles Aimed at: All business roles
- It is not intended for: Advanced users of Microsoft Excel
- Microsoft Teams Installed