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
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at
(+353) 01 523 3930
LOADING...