Program Topics

• Excel fundamentals and worksheet navigation
• Managing worksheets, columns and ranges
• Data entry, editing and Auto Fill tools
• Formatting cells and worksheets
• Sorting and filtering data
• Basic formulas and calculations
• Essential Excel functions (SUM, AVERAGE, COUNT etc.)
• Absolute cell referencing
• Conditional formatting basics
• Flash Fill and custom lists
• Introduction to charts and graph creation
• Working across multiple sheets and files
• Page setup and print settings
• Printing worksheets, ranges and charts
• Viewing and managing multiple worksheets concurrently.

Delivery Options

• 1x day
• The program can be condensed and customised as needed for any audience. While designed to be delivered on-site at your premises to individuals or groups, this course is also
available through live facilitator-led virtual learning for small groups.

Audience

• Designed for beginners or anyone wanting to build confidence using Microsoft Excel in the workplace.

Key Outcomes

• Learn the tips and tricks necessary to navigate your spreadsheet with lightning speed, and to perform repetitive formatting tasks instantly
• Understand how to build a range of formulas correctly and learn the concepts that will allow you to move to the next level of Excel quickly
• You’ll build on cutting time spent on basic formulas even more by learning how to link formulas with other spreadsheets and files
• You’ll learn to use Auto Fill tools that will slash the time you’ll need to spend on repetitive data entry, whether it’s text or numeric values
• Learn to reduce the time you’ll need to spend manipulating Excel databases not just through using filtering and sorting tools, but also with the power of wildcard searches.