08 6210 8500
Pay my invoice
This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query.
Power Query is Excel’s best feature and it’s also key to the popularity of Power BI. It gives Excel and Power BI analysts the power to draw information out of multiple sources, link it together and perform calculations on it that can then be sliced & diced any way you want.
The course covers the core elements needed to get an understanding of what Power Query can do and how to apply multiple techniques to convert messy data into clean tables for analysis.
What you get from this course
- Be able to import data from a variety of disorganised layouts to quickly deliver key information in minutes not weeks
- Utilise best practice techniques
- Provides a solid framework and rules to allow you to automate your reporting and analysis immediately on returning to work.
Agenda Highlights
Pre-requisites
This is a beginner’s course and assumes attendees have no prior knowledge of Power Query.
Previous use of Excel, VLOOKUP / XLOOKUP / Pivot Tables or Power BI would be considered a sensible base level of experience to get the most from this course.
The exercises will be conducted using the desktop version of Excel 365 or Power BI desktop. The techniques are the same in both with minor User Interface differences.
Software Required
Excel 365 or Power BI Desktop
Download and install the free Microsoft Power BI Desktop
For Excel 365 ensure you have a build version greater than 2203 (you can check via File > Account > the About Excel section contains the Version (2203 means March of 2022)
Windows only (No Mac)
Who Should Attend
- Excel users & analysts that focus on extracting, re-organizing and analysing data
- Power BI users connecting to data sources that are poorly organised
- Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards
Delivery Options
In-house
All courses are available for in-house training, providing flexible options to meet your needs wherever you are – Perth, interstate, or internationally. Our in-house courses are designed to maximise value with flexibility, tailored content, and cost savings for your team.
Virtual Training
Our virtual training options (in-house training only) bring the same high-quality, live, instructor-led courses directly to your team, no matter where they are located. Our virtual training features the same level of interaction as our in-person sessions, while providing the convenience of learning from any location. This option is ideal for interstate and international clients.
Upcoming Course Dates
Our Public courses are aimed at smaller groups of 3 – 8 people so that there is more opportunity for the instructor to assist on a 1-1 basis and discuss the attendee’s specific real-world scenarios.
NOTE: For Public Courses a minimum of 3 attendees must have signed up 4 weeks in advance of the course otherwise the course will be postponed, and full refunds offered. The 3rd day option also requires a minimum of 3 attendees to proceed
Why Learn From Access Analytic
Practical
Highly experienced facilitators who actively and regularly consult with clients.
Applicable
Apply what you learn to your job to further your career.
Hands-on
The course is designed to provide maximum hands-on experience.
Passionate
Our facilitators love this subject!
Clear
We specialise in translating complex subjects into concepts that are easy to understand.
On-going help
You can always email the facilitator with any questions.
Comprehensive course notes
Useful working document to support your learning.
Networking
Meet industry peers and hear how they approach this subject.
Our Course Facilitators
Jeff Robson
Masters (Applied Finance), Bachelor of Commerce (Accounting & Information Systems), Certified Information Systems Auditor (CISA), Fellow of the Australian Institute of Management (FAIM), Fellow of the Financial Services Institute of Australasia (F Fin), Member of the Australian Institute of Company Directors (MAICD), Microsoft Excel Expert, International Presenter
Wyn Hopkins
Microsoft MVP, Published Author of “Power BI for the Excel Analyst”, B.Sc. (Hons) Accounting & Financial Management
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”.
YouTube content creator: over 5.5 million views and 95,000+ subscribers.
Yury Tokarev
PhD (Finance and Economics), Chartered Accountant with the Australian Institute of Chartered Accounting (CA), Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE)
Our Clients
Client testimonials
We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.
Head of Analysis large multinational client
Chevron Employee
Other courses you might be interested in
Learn from highly qualified finance professionals with international experience
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
