Maximising your Excel Productivity (1 day)

Hidden shortcuts and techniques that save time and improve productivity.

Unlock Time-Saving Excel Techniques for Optimised Productivity

Maximise your efficiency with this comprehensive course designed to reveal hidden shortcuts and advanced techniques that can transform your workflow. Discover the latest Excel features and learn more about Dynamic Array Excel, Power Query and Pivot Tables. Equip yourself with essential Excel tools and techniques to work smarter, not harder.

What you get from this course

Learn the latest Excel features that are used by Excel Experts to get more done in less time.
Discover how Dynamic Array Excel has REVOLUTIONISED how you can write formulas
XLOOKUP has killed off VLOOKUP – learn why
Power Query is the greatest improvement to Excel productivity ever… if you’re not using it you’re probably wasting hours.
Revisit and/or learn about Pivot Tables and discover what the more advanced Power Pivot is all about.

Pre-requisites

This is one step above a basic user course. Users should already be comfortable with day-to-day Excel use.

Full course outline

Tips and Tricks a recent new formula

Data Types
Tables
Traffic Lights
SWITCH & TEXTJOIN
Best practices and shortcut techniques
Using Autocorrect to generate formula

Power Query

Automated data import and clean up with the world’s greatest data washing machine
Introduction to Power Query’s capability, that will save hours of manual effort
Replaces a lot of functionality previously only solvable with Macros

Dynamic Array Excel and the Amazing new Functions

“A complete Game Changer” – Writing formulas that now SPILL
FILTER, UNIQUE, SORT, SEQUENCE
TEXTSPLIT, TEXTAFTER, TEXTBEFORE
VSTACK, DROP, CHOOSECOLS
XLOOKUP the VLOOKUP killer

Tables and Databases

Sorting techniques
Using Autofilter to show top 10 or custom views of the database
Flagging and removing duplicate entries

Pivot Tables & Refreshable Dashboards

Create your own dashboard using pivot tables and pivot charts
Value and Date grouping functionality
Top 10 filters
Traps to avoid
Present your summarised data with interactive connected Slicers
A first look at Power Pivot and the Excel Data Model (note we have an entire 2 day course dedicated to Power Query and Power Pivot)

Who Should Attend

All Excel users. Anyone interested in saving huge amounts of time in their daily use of Excel.

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.

Learn More

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.

Learn More

Public Courses

Our public courses are located primarily in Perth (with options for interstate and international participants), providing individuals or smaller teams with the opportunity to join our comprehensive training sessions alongside other industry professionals.

Learn More

Upcoming Course Dates

Power BI Essentials (2 days) Face-to-Face Training

February 11, 2025 @ 8:30 am - February 12, 2025 @ 4:30 pm

A$1,499.00 – A$1,699.00

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 3^rd 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)

Client testimonials

We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.

I can see a massive difference in the skills and confidence of our analysts before they attended your course vs after they finish. It’s really lifted the quality of the models I’m seeing.This course forces participants to think. They have to work hard to apply the concepts (i.e. they can’t sit back and just listen).

There’s also a big component of learning by doing which in my opinion is invaluable.

Jeff has an unassuming nature and a great coaching style. That’s what makes the course work so much better than if I were trying to run it!

Head of Analysis large multinational client

Thank you so much for the training – I found it incredibly valuable! Already over the last 2 days I have used a number of your tips and tricks and have also done some ‘IF’ and ‘INDEX MATCH’ formulas which is a great confidence boost and is so much faster than the old school VLOOKUP that was my trusty go to – not anymore!

I’m still blown away by the Power Query so will spend some time working through how I can better utilise it in the coming weeks and will be sure to watch your video. Thank you again for the training – I know others that attended are more excited about excel and what it can do too!

Chevron Employee

Other courses you might be interested in

Maximising your excel productivity

Power Query Booster

DAX Booster for Power BI

Power BI Essentials

Power Query in a Day

Power Query & Power Pivot for Excel

Advanced Budgeting & Forecasting

Financial Modelling in Excel Training Course

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!