Intermediate & Advanced Excel & Powerpoint 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/2013 - 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

Microsoft Excel 2010/2013 - Pivot Tables

PivotTables is one of the most powerful reporting features that Excel has to offer, and yet is also one of the least understood and most underutilised functions available. In this 3.5 hour crash course on PivotTables you will learn not only how to create pivot tables, but how to manipulate the data, summarise the data, and present the data in the exact format that works best for your reporting needs.

Once you’ve finished this course you will be the office Guru on PivotTables.

Topics Covered - 3.5 Hours

  • 1. Introduction to PivotTables
  • 2. Creating & Pivoting PivotTables
  • 3. Summarising PivotTable Data
  • 4. Sorting & Filtering PivotTable Data
  • 5. Formatting PivotTables
  • 6. Applying Conditional Formatting to PivotTables
  • 7. Creating & Manipulating PivotCharts

8 Participant Maximum - $1097 + GST

($137 per person for a group of 8)

Book In!
back to top

Microsoft Excel 2010/2013 - Graphs & Presentations

Excel has a truly staggering number of options when it comes to how you want to manipulate and present your data. Whether it be conditional formatting or advanced graphs and charts you’ll learn it all in this jam packed Advanced Graphs & Presentations course.

Topics Covered - 3.5 Hours

  • 1. Adjusting Numerical Formats Quickly
  • 2. Controlling Fonts, Borders & Cell Colours
  • 3. Alignment Tools
  • 4. Other Awesome Formatting Tools
  • 5. Row, Column, and Sheet Adjustments
  • 6. Displaying Data as an Outline
  • 7. Tables, Themes, Styles, and Other Data Visualization Tools
  • 8. Understanding Excel Chart Concepts
  • 9. Creating Basic Charts Quickly
  • 10. Fine Tuning Charts with Design Tab Choices
  • 11. Inserting Pictures, Shapes & Text Boxes
  • 12. Adding Titles, Labels & Legends
  • 13. Layout Tab: Using Axes & Gridlines
  • 14. Layout Tab: Using the Analysis Tool
  • 15. Adding WordArt Styles
  • 16. Other Formatting Tools
  • 17. Adjusting Specific Chart Types
  • 18. Changing a Chart’s Data Source

8 Participant Maximum - $1097 + GST

($137 per person for a group of 8)

Book In!
back to top

Microsoft Excel 2010/2013 - Advanced Formulas

Harnessing the power of formulas is key to truly utilising all that Microsoft Excel 2010 has to offer. From basic SUM formulas, we’ll move through to conditional formulas, 3D formulas, Lookup and reference functions and many more! Prepare to manipulate and collate your data like never before!

Topics Covered - 3.5 Hours

  • 1. Formula and Function Tips & Shortcuts
  • 2. Formula & Function Tools
  • 3. IF & Related Functions
  • 4. Lookup & Reference Functions
  • 5. Power Functions
  • 6. Statistical Functions (Optional)
  • 7. Date Functions
  • 8. Text Functions
  • 9. Information Functions
  • 10. Math Functions (Optional)
  • 11. Array Formulas & Functions

8 Participant Maximum - $1097 + GST

($137 per person for a group of 8)

Book In!
back to top

Microsoft Excel 2010/2013 - Keyboard Shortcut Mastery

Just about anything that you can do with a mouse in Excel can be done more easily and quickly by keyboard shortcut. In this course you’ll enter the nerdy world of substituting keyboard shortcuts for dragging the mouse around. Not only will you look like a serious Excel guru after completing this course, you’ll also get your work done a lot faster!

Topics Covered - 1.5 Hours

  • 1. Top 10 Awesome Shortcuts
  • 2. Ribbon & Quick Access Toolbar Tips
  • 3. Display Shortcuts
  • 4. Selection Shortcuts
  • 5. Data Entry & Editing Shortcuts
  • 6. Drag & Drop Techniques
  • 7. Formula Shortcuts
  • 8. Operational Shortcuts
  • 9. Formatting Shortcuts

15 Participant Maximum - $597 + GST

($39 per person for a group of 15)

Book In!
back to top
 

Microsoft Powerpoint 2010 - Intermediate Training

Just about anything that you can do with a mouse in Excel can be done more easily and quickly by keyboard shortcut. In this course you’ll enter the nerdy world of substituting keyboard shortcuts for dragging the mouse around. Not only will you look like a serious Excel guru after completing this course, you’ll also get your work done a lot faster!

Topics Covered - 3.5 Hours

  • 1. Understanding The PowerPoint Interface
  • 2. Getting Set Up
  • 3. Formatting A Presentation
  • 4. Adding Tables & Charts
  • 5. Working With Shapes
  • 6. Getting Into Audio & Video
  • 7. Adding Diagrams & SmartArt

8 Participant Maximum - $1097 + GST

($137 per person for a group of 8)

Book In!
back to top

Microsoft Powerpoint 2010 - Power Shortcuts

Just about anything that you can do with a mouse in Excel can be done more easily and quickly by keyboard shortcut. In this course you’ll enter the nerdy world of substituting keyboard shortcuts for dragging the mouse around. Not only will you look like a serious Excel guru after completing this course, you’ll also get your work done a lot faster!

Topics Covered - 1.5 Hours

  • 1. Top 10 Awesome PowerPoint Shortcuts
  • 2. File Management Techniques
  • 3. Arranging An Efficient Interface
  • 4. Knockout Keyboard Shortcuts
  • 5. Creating Content
  • 6. Working Efficiently With Text
  • 7. Working Efficiently With Images
  • 8. Working With Shapes & Objects
  • 9. Animation Shortcuts
  • 10. Integrating With Other Office Applications
  • 11. Printing & Publishing Your Presentation

15 Participant Maximum - $597 + GST

($39 per person for a group of 15)

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!

arrow

privacy We value your privacy and would never spam you