Onsite Microsoft Excel Intermediate Training

Pick and choose the modules that you want your staff to learn, and we'll do the training in-house! (Sydney Metro only)

Excel 2010
Powerpoint 2010

Microsoft Excel 2010 → Office 365 - Intermediate Excel

Intermediate Excel is where you expand on the basic skills that you've previously learned. In this 7 hour course you will start to get into more advanced function creation, TEXT commands, Ranges & Tables, the all conquering VLOOKUP. In the 2nd half of the session you will be given comprehensive training in creating all of the available charts and graph functionality available in Excel.

This course gives you a comprehensive grounding in most use cases for Excel.

Topics Covered - 7 Hours

  • 1. AutoSum Tips & Tricks
  • 2. Number Formatting
  • 3. Special Number Formatting
  • 4. Custom Number Formatting
  • 5. Conditional Formatting
  • 6. Working Multiple Worksheets
  • 7. Playing With Ranges & Range Names
  • 8. Using Data From Multiple Sources
  • 9. Working With Tables
  • 10. Text Functions
  • 11. Lookup & Reference Functions
  • 12. Charts Orientation
  • 13. Sparklines in Charts
  • 14. Fine Tuning Charts
  • 15. Inserting Pictures, Shapes & Text Boxes Into Charts
  • 16. Adding Titles, Labels & Legends
  • 17. Layout Tab Options
  • 18. Format Tab Options
  • 19. Other Formatting Tools
  • 20. Column & Bar Charts
  • 21. Line Charts
  • 22. Pie Charts
  • 23. Adding & Deleting Data To A Chart
  • 24. Printing Charts

8 Participant Maximum - $2097 + GST

($263 per person for a group of 8)

Book In!
back to top

It’s great… one of our staff members came out and said that it was the best training that they’d ever done! That’s exactly what we want to hear!

Paul Johnson - Workforce Planning Manager, Covermore Travel Insurance

John is definitely one of the most remarkable trainers I have met during my 22 years of studies. He is a very knowledgeable, inspiring, motivating and creative hands-on teacher which makes it a great experience to attend his classes.

Diana Bakos, Kaplan International

Learn The 10 Excel Shortcuts That Helped Me Keep My Job!


privacy We value your privacy and would never spam you