In this hands-on course we will explore how Excel handles data and introduce a variety of techniques to make your life easier when setting up Excel reports or preparing your data for analysis. We will cover efficient ways of handling dates in data exports, combining or splitting columns (like first and last name), reporting on data that is stored across multiple workbooks, grouping and filtering data (even when the information that we want to group by is a column in another table) and using ‘What If’ analysis for forecasting. Best of all, we will show you how to set up links and connections to the data source so that you can set and forget and build a robust Excel report that refreshes as your new data is added or updated.
You'll gain a solid understanding of how Excel ‘thinks’ and learn handy tricks to work more efficiently with large datasets. You'll get an introduction to the concepts of Excel databases and take away techniques to create efficient reports, freeing you up to focus on the data insights rather than the data cleansing.
This was one of the most productive training sessions that I have done in the last 5 years
Good content, delivered very well.
Sun Engineering Ltd
I felt the trainer as very informative and knowledgeable and delivered the session well, I enjoyed the session and gained some well needed knowledge.
Sun Engineering Ltd
Appreciated Robbie's ability to involve all participants thru program whilst playing catch-up with those that did not immediately relate to issue.
Liquor Legends
FANTASTIC! I have already recommended you guys to 3 friends who are looking at doing some courses soon!!
Presence of IT
Robby was Brilliant! I learnt heaps of new tricks and will definitely be back for another advanced excel course. Thanks again Robby for all your hard work yesterday. I found Pete an excellent trainer with plenty of patience and willingness to share his knowledge. Thank you Pete!
Mater
I enjoyed the course and found my attendance to be beneficial.
ERM Power
Murray was very helpful and was able to work with our specific requirements which made the course even more beneficial. I have already recommended PD Training to CASA for future training.
Civil Aviation Safety Authority
I had a chat to two of the participants from yesterday's Excel training. We didn't discuss the specific questions listed in your survey, but they both said the training was excellent and they definitely gained valuable knowledge from it. They said their trainer (Peter) was an excellent trainer.
Mater
Denise was a fantastic trainer and I thoroughly enjoyed my training
Westfield Ltd
Thanks for making the organising so easy. You have all been very helpful.
Mater
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
You'll gain a solid understanding of how Excel ‘thinks’ and learn handy tricks to work more efficiently with large datasets. You'll get an introduction to the concepts of Excel databases and take away techniques to create efficient reports, freeing you up to focus on the data insights rather than the data cleansing.
After completing this course, participants will have learned to:
Topic 1
Group and Outline Data
Make large datasets easier to read by grouping them by region, month or topic. Quickly hide and unhide the columns that you need to see.
Topic 2
Consolidating Workbooks
Do you need to report across an entire department or company by have been collecting the data in individual workbooks? See how Excel can combine information from multiple workbooks and even maintain links to the original data source.
Topic 3
Splitting and Combining Data in Columns
Last name, First name or T-shirt, S (Blue) can appear in our data source, but make it challenging to do proper analysis. Learn a few techniques and formulas that split, combine and prepare your data for reporting.
Topic 4
Transforming Data with Power Query Editor
Introduction to Excel Power Query, the tool that automates data cleansing, splitting and combining columns, calculating new columns and working with data from multiple sources.
Topic 5
Introduction to the Excel Data Model
Did you know that Excel can be a relational database? Using the Excel Data Model you can connect to multiple sources of data and transform the data to make analysing and reporting more comprehensive.
Topic 6
Flash Fill
Add an email address column to a table of Last Name, First Name with just one click. Understand how Excel uses pattern recognition to make copying, combining, and cleaning data more efficient.
Topic 7
Looking Up and Retrieving Data (VLOOKUP, INDEX, MATCH)
Expand your database knowledge to work with multiple tables of data.
Topic 8
Summarising Data with Pivot Tables and Pivot Charts
Pull together your newly cleansed data into a beautiful Excel Dashboard or report in no time using Pivot Charts.
Topic 9
Advanced Filters
Start using Excel databases to find the best candidate for the job in a list of applicants or filter data based on advanced criteria.
Topic 10
Database Functions
Use database functions to create custom reports and tables to meet exact business requirements.
If you’re not happy with the outcomes from
the course we offer a money back guarantee
For every participant
valued at $199 each
No one left behind
with our 1/2 price re-run promise
12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.
We take care of all of the details, so you don’t have to:
At the completion of training participants are encouraged to create an action plan, and invite an accountability buddy via their Orgmenta App.
In your Training Management Centre you have transparency to the action plans so you can see what people are going to do differently.
Our systems and people make it easy to identify how you’ll be able to measure impacts and then report on the success in the weeks or months after training.
It’s surprisingly easy to make it so that your system can automatically be up to date with all the training record details you need.
After completing this course, participants will have learned to:
Topic 1
Group and Outline Data
Make large datasets easier to read by grouping them by region, month or topic. Quickly hide and unhide the columns that you need to see.
Topic 2
Consolidating Workbooks
Do you need to report across an entire department or company by have been collecting the data in individual workbooks? See how Excel can combine information from multiple workbooks and even maintain links to the original data source.
Topic 3
Splitting and Combining Data in Columns
Last name, First name or T-shirt, S (Blue) can appear in our data source, but make it challenging to do proper analysis. Learn a few techniques and formulas that split, combine and prepare your data for reporting.
Topic 4
Transforming Data with Power Query Editor
Introduction to Excel Power Query, the tool that automates data cleansing, splitting and combining columns, calculating new columns and working with data from multiple sources.
Topic 5
Introduction to the Excel Data Model
Did you know that Excel can be a relational database? Using the Excel Data Model you can connect to multiple sources of data and transform the data to make analysing and reporting more comprehensive.
Topic 6
Flash Fill
Add an email address column to a table of Last Name, First Name with just one click. Understand how Excel uses pattern recognition to make copying, combining, and cleaning data more efficient.
Topic 7
Looking Up and Retrieving Data (VLOOKUP, INDEX, MATCH)
Expand your database knowledge to work with multiple tables of data.
Topic 8
Summarising Data with Pivot Tables and Pivot Charts
Pull together your newly cleansed data into a beautiful Excel Dashboard or report in no time using Pivot Charts.
Topic 9
Advanced Filters
Start using Excel databases to find the best candidate for the job in a list of applicants or filter data based on advanced criteria.
Topic 10
Database Functions
Use database functions to create custom reports and tables to meet exact business requirements.
Activities and discussion for engaged learning all day.
On average PDT trainers have 15 years industry experience and 7 years training experience.
We always tailor activities and scenarios to be relevant to you.
In-House and Public Class participants are welcome to join a public class in the same topic for 12 months.
The confidence of booking with an acclaimed multi-national training company.
Support, reinforcement & extension eLearning and videos in the App.
The most important foundation for communication and building meaningful relationships is listening, develop your skills with this micro eLearning course.
Not exactly what you needed? Try other courses in the MS Office Apps Courses Category
Supporting leaders and teams around the globe, we're proud to mark 15 years of growth, innovation, and success. Thank you for being part of the PD Training journey. The future is looking bright!