Master Excel’s suite of business intelligence tools (Power Query, Power Pivot, Power Maps etc) on this 2-day Excel training course.
This is a hands-on course that includes lots of time to experiment with what you are being taught and ask questions.
By the time you finish, you’ll be a confident Excel Power Query and Power Pivot user.
✔ A complete Excel Power Tools course that covers all of Excel’s BI functions.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ Ongoing support and help with issues you have after the course.
By the end of this course you will be confidently using Excel’s business intelligence Power Tools to analyse data.
You’ll be very comfortable using Microsoft Excel to:
Oakley is our usual trainer for this course. He has been a Microsoft certified trainer for 8 years.
He has been training Microsoft applications for 19 years and focuses on Excel BI, Power BI and Project.
You don’t need any prior experience with Excel’s Power Tools to attend this course.
It is recommended that you have completed our Excel Advanced level workshop, or have equivalent experience.
It is expected that you have a good understanding of Excel functions such as IF and VLookup functions, as well as Defined Names, Importing Data and a basic understanding of Pivot Tables.
You will need the following installed and fully working to be able to participate in the training:
You don’t need to bring anything with you. We include everything that you’ll need for a really fun, productive day of training.
Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take your course exercises home with you.
✔ A Certificate of Attendance.
Download full course details
This session introduces the course looking at why you might be using Power Query or other Excel Power Tools.
During this section we look at importing data for data analysis from a number of data sources.
We now move to refining our data for use in our data analysis. This section focuses on rows, while the next section focuses on columns.
We now look at how to use power query.
This section looks at using Microsoft Excel Power Pivot and how to analyse new data using it.
To attend this Excel course online, you will need:
✔ MS Excel on your Windows PC/laptop with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom to attend the course
If you have access to a second screen, we would encourage you to use it as it improves the experience.
Office 365
Access
Excel
Outlook
Power Automate
Power BI
PowerPoint
Project
SharePoint
Visio
Word
After Effects
Captivate
Creative Cloud
Illustrator
InDesign
Photoshop
Premiere Pro
AutoCAD
Revit
SketchUp
SolidWorks
Crystal Reports
HTML & CSS
MapInfo
R
SPSS
SQL
WordPress
Finance Courses
Xero
Resilience
Assertiveness
Chairing Meetings
Minute Taking
Team Leader
Time Management