Excel Data Manipulation &
Reporting with Pivot Tables
- 30th June 2022
- 14th July 2022
- 27th July 2022
- 2nd August 2022
- 16th September 2022
- 24th October 2022
- 16th November 2022
- 8th December 2022
Register for Microsoft Excel
Wizard Corporate Training is one of the leading training providers in Australia. Having launched in the ACT in 1992, we now have a national presence across the country and offer a range of Microsoft Excel courses.
With over 22 years experience in the Australian IT end user, Project Management and Professional Self Development training industry, Wizard’s experience in the training field is second to none. We provide comprehensive Excel Courses Melbourne for professionals, small business, corporate and government employees.
Microsoft Excel Courses Melbourne
Wizard Corporate Training was founded on, and continues to build on, a basis of using experienced educators to develop, deliver and support our training programs. Our Excel courses Melbourne cover all skill levels, with Essential, Intermediate and Advanced courses available, for all current versions of Excel.
These courses range from half day, full day to two-day courses.
Microsoft Excel Essentials
This course aims to provide you with the skills and knowledge necessary to build, edit and chart worksheet data in the Microsoft Excel environment.
Excel Intermediate Formulas and Functions
This course aims to provide you with the skills and knowledge necessary to manage data and solve problems using functions and formulas.
Intermediate Data Manipulation and Pivot Reporting
The aim of this course is to provide you with the skills and knowledge necessary to use the majority of Excel’s analysis tools for modelling and manipulating data.
Excel Advanced Formulas and Functions
The aim of this course is to start with a blank spreadsheet and quickly dive into using combinations of functions and formulas to perform dynamic analysis.
Advanced Complex Data Analysis
Excel courses Melbourne aims to provide you with the skills and knowledge necessary to, create comprehensive and flexible reports, import and analyse data stored externally to Excel and extract information from Excel databases.
Excel VBA Programming
This course aims to provide you with the skills and knowledge necessary to use Visual Basic for Applications in Excel.
Microsoft Excel PowerUsers
This two-day Excel course is designed to teach the participant how to combine the functionality of Power View, PowerPivot, Power Query, and PowerMap into graphs, charts, KPIs, reports, and other visualisations for use in their business.
It enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, and create calculated columns and measures using formulas, build PivotTables and PivotCharts.
Excel Data Analysis using Power BI
This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will gain an understanding of how Power BI can provide data analysis solutions for report creators and consumers. They will discover how to prepare data and gain practical experience in connecting a variety of data sources.
This two-day course will take students from a beginner level to moderately advanced concepts such as DAX.
Excel Advanced Pivot Tables Analysis
This half day course aims to provide you with the skills and knowledge necessary to, create comprehensive and flexible reports from Excel databases
Excel Advanced Macro Overview
This half day course introduces users to the Macro recorder in Excel and gives you the skills to record edit and run simple macros.
learnt new things
Thank you for your session today it was great. learnt many new things i can put into my daily work day. one thing is that the trainer was great but spoke a little fast and ran through things we did miss and had to ask him to show us again. but other than that was well worth the day training.
Word intermediate - Improving Efficiency
Great course and great trainer. Everything was very clear and well understood.
Very knowledgeable and informative of illustrator, Thanks Eric
Data manipulation and Reporting with Pivot Tables
Great refresher course Chris made learning so relaxed and enjoyable
Right amount of details and examples. The flow was easy to understand
Intermediate Excel training
Chris Rai from Wizard Training is extremely knowledgeable and informative regarding Excel. As a relatively new user to excel, Chris broke it down into pieces and practice session templates. Thanks again Chris for sharing your experience 🙂
Eric was totally great!
Eric was totally great! He took the time to lay a foundation of basic knowledge, but was then very happy to tailor the course content to our needs. He is a generous teacher, and communicates with humour and enthusiasm.
What We Do?
Consultancy & Customisation
Our facilities also include a large break out area, and are close to public transport. Wizard staff will be on hand to assist you and your clients during your time with us.
Wizards relationship with training facility providers in other states means that we are able to assist in, and if required, project manage national facility hire requirements. Let Wizard help arrange your next room hire!
- Data Projectors
- Whiteboard & Markers
- Up to 16 PC’s (ask us for our latest specs)
- Trainer PC
- The rooms can easily be configured to a layout of your choice
- Data Projectors
- Whiteboard & Markers
- Instructor PC
- Room setup, with choice of layout, u-shape, pod
- Refreshments available all day
- Morning & afternoon tea
- Restaurant lunch (optional)
- Close to city parking and public transport routes
- Friendly staff to greet your attendees