Excel Intermediate II
Learn advanced workbook automation and productivity techniques including complex formulas and data analysis, Pivot Tables, Solver, macro creation, and more.
3 Hours | $ 279.00 + GST
Upcoming Course Dates
- Thursday, 13 April | 1pm – 4pm AEST
Course Outline
- Use common worksheet functions
- Use filling techniques
- 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
- Use a variety of financial functions
- Select and change the format of object in a chart
- Use a range of elements and features to enhance charts
- Create more complex formulas and functions
Frequently Asked Questions
Skills Test
Try our skills test and find out which course is right for you. It only takes a minute!
Why Train
with Us?
Our instructor-led courses are interactive and engaging, and will help you develop professional skills in only a few hours.
Expert Trainers
with real-world experience help you build skills and confidence in Microsoft Excel
Hands-on Training Methods
will help you develop practical Microsoft Excel skills in a few hours
Certificate of Completion
to recognise your new software skills
Free Re-Sits within 12 months
to help your practise and reinforce your new skills
Valued by our Clients
More Courses you might be interested in
Microsoft Word
Essentials
Develop your confidence in navigating your way around Microsoft Word.
Microsoft PowerPoint Essentials
Learn how to navigate your way around Microsoft PowerPoint.
Microsoft Outlook Essentials
Learn new skills and gain confidence in using Microsoft Outlook.