Maximising your Excel Productivity (1 day)

Hidden shortcuts and techniques that save time and improve productivity.

Contact Us Today

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

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

  • 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

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

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

  • 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

Previous Conference Events

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

Read More

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.

Read More

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)

Read More

Our Clients

Client testimonials

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

Other courses you might be interested in

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

Trusted by the Biggest Names

Many of the world’s most trusted and respected companies rely on Access Analytic for innovative, data-driven solutions. Our vast experience across industries means we bring the best global ideas and strategies directly to your business. At Access Analytic, we don’t just keep up with the industry—we set the standard. Partner with us for world-class expertise, cutting-edge solutions, and long-term success. 

Contact us today to learn more about our Power BI training options

Consent