Excel 365 Major Updates – Discover What’s New (1 day)

In-Person and Virtual Classroom options for in-house training (live, instructor-led, interactive training)

All of our courses are available for In-house Training. We can also run training virtually. We provide live, instructor-led, interactive courses and our world-class instructors guide you through every step. Our Course Facilitators have over 20 years' experience in delivering training for clients all over the world. A number of Public Courses are scheduled for Perth. Face-to-Face interstate and international training is also back in full swing but can still be delivered using online platforms.

No Events

 

In July 2020 a range of massive updates hit all users of Excel that use a Microsoft 365 licence.

Excel formulas are able to work in a different way in the new world of “Dynamic Array” Excel

A series of new functions released.

XLOOKUP replaces the need for VLOOKUP and INDEX MATCH

Coming soon…

The LET function will improve performance and improve the readability of longer formulae

Data Types will grow in functionality

Connectors for Power BI will become available to E5 license holders

Old but under-utilized…

Power Query is still an unknown for many users

The Power Pivot Data Model can replicate many of the powerful features of Power BI but is largely left untouched.

What is Excel 365?

Microsoft 365 (previously known and packaged as Office 365) is the way most organisations now subscribe to continuous updates of versions of Excel, Word, and the other “Office” products.

In July 2020 Excel will receive dramatic new capabilities as the Dynamic Array version of Excel rolls out to everyone.

Powerful new functions will then become available including:

  • XLOOKUP
  • FILTER
  • UNIQUE
  • SORT
  • SORTBY
  • RANDARRAY

Old formulas may appear with @ symbol. New functionality will be introduced using the # symbol. This is a major update to Excel

Discover existing functionality

  • Power Query can save every Excel User time and effort. This session will introduce what it can do, why and when to use it and run through some basic examples.
  • Power Pivot (“the data model”) was the mother of Power BI. Create relationships between different data sources with no formulas required
  • Pivot Tables tips, advice, best practice

Course Outline

The new Excel Engine (Dynamic Array Excel)

    • How you write formula will change forever
    • XLOOKUP, why it will kill off VLOOKUP and INDEX MATCH
    • Understanding impacts of using the new functions
      • FILTER
      • UNIQUE
      • SORT
      • SORTBY
      • SEQUENCE
      • RANDARRY
      • #
  • How to handle #SPILL errors

Other Recent Features Plus Tips & Tricks

  • Stock and Geography Data Types
  • TEXTJOIN, AGGREGATE, SWITCH
  • Stacked Chart Totals
  • How to add Traffic Light Icons
  • Why to use Tables whenever you can
  • Much more…

Power Query and Power Pivot

  • Introduction to the basic concepts and best practices
  • How to do “Power BI” inside Excel

Pivot Tables and Other Useful Tips

  • How to use Pivot Tables
  • Best Practice tips
  • Clever hacks
  • Time saving advice

| Top | Back

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 the basic user course. Users should already be comfortable with day to day Excel use.

 

Top | Back

Facilitator: Wyn Hopkins

Excel MVP, B.Sc. (Hons) Accounting & Financial Management | LinkedIn | Wyn qualified as a Chartered Accountant with PricewaterhouseCoopers in the UK in 2000, before working as an analyst for the FTSE 100 companies HBOS and Barclays. Microsoft awarded him the status of  Most Valuable Professional for the 7th year running in 2023. This recognises his expertise and willingness to share his knowledge via blogs, articles, community events and YouTube videos. The Access Analytic YouTube channel now has over 85, 000 subscribers. Wyn is an experienced Trainer and Excel / Power BI Developer. Since joining Access Analytic in 2007, he has delivered hundreds of amazing solutions for clients including many for Chevron and other leading organisations in Perth.

 

Facilitator: Yury Tokarev

PhD, Chartered Accountant, Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE) | LinkedIn | Yury is a Director and an International Training Specialist at Access Analytic Solutions. He has over 25 years of experience in corporate finance, chartered accounting, and consulting. Prior to his current role he worked in Business Services and Advisory at WHK Chartered Accountants and Corporate Finance at one of the top European Investment Banks. Yury has wealth of experience having delivered hundreds of Financial Modelling, Power BI and Excel solutions to clients ranging from start-ups to multi-billion corporations, including Chevron, Woodside, Northern Star Resources, Quadrant Energy, TransAlta and many more. Yury is also an international trainer on these subjects, and provides training for companies throughout Australia, Asia, the Middle East, South Pacific and South America.

 

Top | Back

Benefits & Inclusions

Practical: Highly experienced facilitators who actively and regularly consult to clients also.
Applicable: apply what you learn to your job to further your career.
Hands-on: the course is designed to provide maximum hands-on experience.
Passionate: Our facilitators love this subject!
Clear: we specialise in translating complex subjects into concepts that are easy to understand.
On-going help: you can always e-mail the facilitator.
Comprehensive course notes.
Networking: meet industry peers and hear how they approach this subject.
Certificate of completion.
… and much more!

Top | Back

 

Clients who have 4 or more people interested in this course normally prefer to run this course on an in-house basis in their offices.

We can bring all the equipment for up to 8-10 people so all you need is a room!

Benefits of In-house Courses

  • Flexibility: we can combine content from multiple courses to create a custom course just for you, add-on a workshop or some mentoring sessions then run everything at the times that suit you.
  • Timing options: if you’re in Perth, we can split courses into half or single days and schedule these at times to suit you
  • No hidden extras: our fixed fee includes all materials and equipment costs for all participants
  • Cost effective: usually 50%+ less than sending the same number of people to a public course

In-House Details & Pricing

  • Structure: half-day or full-day sessions
  • Location: all courses are available in-house, many are also available in open sessions
  • Class size: minimum of 4, maximum of 30
  • Provided: projector, laptops, manual
  • In-house Fees: contact us today to discuss your requirements

In-house Course Fees

Call us on +61 8 6210 8500 to discuss your requirements.

Notes:
– We are happy to customise our courses to suit your requirements
– A 10% discount applies when booking 10+ full days of training in any 30 day period
– Many courses can also be split into half-days (please enquire)
– Fees for locations outside of Perth do not include equipment