Collection: Intermediate Excel
Build on your skills to become an Excel master user!
Course Overview
Become a Microsoft Excel master with our Excel Intermediate Level One program. You'll learn to efficiently organise and manage multiple worksheets, create dynamic worksheets with advanced features, and tailor page layouts and orientations to your specific needs.
You'll also discover how to create visually stunning charts to convey data insights, customise chart elements, and apply various chart styles and formatting options.
Our course will teach you how to apply number formats to display data accurately and consistently, use conditional formatting to highlight trends and patterns, and create dynamic and interactive reports.
This program assumes knowledge of our EXCE101 - Microsoft Excel Beginners program.
What you’ll Receive
- 3 Hour Course
- Handbook
- Participation eCertificate
- Post Course Support
Pricing
-
Online
$199 + GST (Per Person)
Offers
Register to attend both Beginners Excel and Excel Intermediate, or both Intermediate Level 1 & 2, and save $100!
Book 5 or more people to attend this course and save $50 per person!
* Offers automatically applied at checkout, participants can attend different dates of the same course. Offers cannot be combined.
Key Topics Covered
- Use common worksheet functions.
- Apply a variety of page setup techniques.
- Use a range of techniques to work with worksheets.
- Apply borders to cells and ranges in a worksheet.
- Create and use defined names in a workbook.
- Apply conditional formatting in ranges in a worksheet.
- Create and work with tables.
- Select and change the format of object in a chart.
- Use a range of elements and features to enhance charts.
- Apply a range of number formatting techniques to sheet cells.
Who Is This Course Ideal For?
This course is designed for care professionals, administrators, managers, team leaders and supervisors who have a basic understanding of Excel and are looking to enhance their skills with intermediate-level techniques.