Maximising Your Excel Productivity

by Access Analytic Claim Listing

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

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Access Analytic Logo

img Duration

1 Day

Course Details

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.

 

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.

 

Pre-Requisites

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

  • Perth Branch

    Suite 143, Level 1, 580 Hay Street, Perth

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy