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

Check out more MS Excel courses in Australia

Mobile Mouse Logo

Basic Word Course

This course will introduce the basics of Microsoft Word and as a result, students will therefore learn to build and manage simple documents, while improving their fundamental Word skills

by Mobile Mouse [Claim Listing ]
IFA Australia - Institute for Financial Analysts Australia Logo

MS PowerPoint

MS PowerPoint course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.

by IFA Australia - Institute for Financial Analysts Australia [Claim Listing ]
University of The Third Age Logo

MS PowerPoint - Presentation- Photos

If you have very little knowledge/usage of computers, you may feel better to attend some Basics of Computers classes first. These are offered at libraries and community halls etc.

by University of The Third Age [Claim Listing ]
  • Price
  • Start Date
  • Duration
TAFE SA Logo

Microsoft PowerPoint (PowerPoint and PowerPoint 2019)

Microsoft PowerPoint (PowerPoint and PowerPoint 2019) training is offered by TAFE SA.

by TAFE SA [Claim Listing ]
Corporate Training Solutions Australia Logo

MS Excel

Corporate Training Solutions Australia  is an independent, Australian owned training provider, highly respected for the delivery of corporate training in desktop software and soft skills development.

by Corporate Training Solutions Australia [Claim Listing ]

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