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 Training Courses

Why Choose Access Analytic?

At Access Analytic, we don’t just provide training and consulting—we lead the industry. With a 25-year track record of excellence, we are the trusted choice of top global companies for training and consulting in Power BI, advanced financial modelling, data analytics, and AI-driven business solutions.

Industry-Leading Expertise

Our Course Facilitators are internationally recognised thought leaders, speaking at major conferences around the world. One of our directors has been a Microsoft MVP for over seven years—and is the only combined Excel and Data Platform MVP in Australia—highlighting our elite-level expertise.

Global Reach, Local Presence

We deliver world-class training across Australia, Oceania, the South Pacific, the Middle East, Africa, and Asia, helping professionals and organisations harness the power of Power BI, Excel, and AI. Our expertise extends beyond consultancy—we train and educate thousands of professionals worldwide.

Top-Ranked YouTube Channel

We run one of the world’s top YouTube channels for Power BI and Excel, where thousands of professionals look to us for cutting-edge insights and practical expertise.

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.

Elite Team,
No Juniors

We only give you highly experienced facilitators. Every Facilitator assigned to your training course will have the right mix of expertise in areas such as Power BI, finance, AI, best-practice financial modelling, and data analytics. Our team’s depth of real-world knowledge ensures your business benefits from proven insights that streamline processes, enhance decision-making, and deliver measurable results.

Perth-Based, but Borderless Support

Our team is locally based in Perth, but we run courses all around the world.

Setting the
Standard

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.

Meet Our Speakers

Jeff Robson

Founder & CEO | Data and Financial Modelling Specialist

Read More

Wyn Hopkins

Director | Microsoft MVP | Reporting and Automation Expert

Read More

Yury Tokarev

Director | Financial Modelling and Analytics Expert

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

(We no longer run public courses for individuals)
Consent