2020-21 Update: Excel

Summary

This course provides a one-stop update on the latest productivity enhancement tools such as Notes and Ideas, the incorporation of rich data types, new ways to model data and carry out calculations using dynamic arrays, and a host of other new functions.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT.   

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
AccountingCPD.net, Practice and business improvement

Booking with a Training Ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course overview 

Recent improvements

  • Excel versions
  • How to check your version of Excel
  • Improvements to comments
  • Improvements to Ideas
  • Ideas in action
  • Workbook Statistics and Sheet View
  • Using free images and icons
  • Using images and icons

Working with data

  • Rich data types
  • Configuring rich data types
  • Using rich data types
  • Tips for rich data types
  • Pivot table improvements
  • Retrieving data from a PDF
  • Data profiling

Dynamic arrays

  • The basics
  • Changing how Excel works
  • Creating a unique list
  • Working with dynamic arrays
  • Dynamic data validation and SORT
  • Backward compatibility
  • Pivot table alternatives
  • Using SORT, SORTBY, and UNIQUE
  • Using dynamic arrays
  • Wrapping up UNIQUE, SORT, and SORTBY
  • Using the FILTER function

More new functions

  • Using XLOOKUP
  • Searching in XLOOKUP
  • XMATCH
  • Using XMATCH
  • Using the functions
  • STOCKHISTORY