Maximising Your Excel Productivity

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.