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

NDA Tasmania Logo

MS Excel (Advance)

Upon completion of this course, attendees will have the knowledge and skills to design effective spreadsheets and work with financial or other business applications in an efficient manner.

by NDA Tasmania [Claim Listing ]
IFA Australia - Institute for Financial Analysts Australia Logo

Excel VBA

Excel VBA 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 ]
  • Price
  • Start Date
  • Duration
Crimson Innovations Logo

Microsoft Excel

We can offer assistance with all aspects of any skills development project, including analysing skill requirements, assessing existing skills, course planning and preparation and scheduling.

by Crimson Innovations [Claim Listing ]
StressLess Learning Logo

Microsoft Access Introduction training

This course is designed for those who need to create a new database, design data tables, design forms and reports and create simple queries

by StressLess Learning [Claim Listing ]
  • Price
  • Start Date
  • Duration
Centre for Continuing Education Logo

Microsoft Excel

This one-day introductory course assumes no prior programming knowledge, and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should ha...

by Centre for Continuing Education [Claim Listing ]

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