Microsoft Excel Intermediate
1 day course
What you will learn:
- Understand and use a range of common worksheet functions
- Understand and utilise Absolute Referencing
- Organise a database list by advanced filtering and subtotalling
- Utilise Conditional Formatting to change cell appearance
- Create and modify charts to create static dashboards
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Post Course Support
What you will learn:
- Understand and use a range of common worksheet functions
- Understand and utilise Absolute Referencing
- Organise a database list by advanced filtering and subtotalling
- Utilise Conditional Formatting to change cell appearance
- Create and modify charts to create static dashboards
What you'll get:
Courseware and Handouts
Capped Class Sizes
e-Certificate
Post Course Support
Course prerequisites
Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.
In-Person Training
Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.
Online Training
Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.
It is also recommended that you have a second screen attached to your computer. This will allow you to watch the online training session and complete the course activities at the same time.
Topics covered in this training course:
- Absolute cell referencing
- COUNTA COUNTBLANK COUNTIF functions
- The IF function
- SUMIF Function
- TODAY and NOW functions
- Calculations with dates
- EDATE and NETWORKDAYS functions
- Working with time values
- AutoFill date sequences
- Flash fill
- Conditional formatting
- Data bars, icon sets, highlight cells
- Managing and editing rules
- Finding duplicates
- Adding sparklines
- Advanced sorting
- Complex filter criteria
- Searching for criteria
- Multiple subtotals
- Create a basic PivotTable
- Working with outlines
- Switching rows / columns
- Reorder series
- Adding data to an existing chart
- Create chart from non-adjacent data
- 3-D chart rotation
- Creating a dual axis combo chart
- Creating a dashboard
- Sizing charts on dashboard
- Aligning charts on dashboard
- Formatting a dashboard
You might be interested in:
