Using Excel 365 we are constantly being introduced to new functions and features through Microsoft’s regular updates. In this course we will introduce you to some of the most popular calculation functions now available, as well as some time-saving features to streamline your day-to-day processes.
This course is designed for users who are already proficient in using Excel Functions and are looking to upskill in some of the new functions and features that are now available.
By actively participating in this course, you will learn about the following:
Discover new importing options.
Use the Data Types tool.
Investigate new available functions.
How to use the Analyze Data Feature.
How to use Office Scripts in Excel and Power automate.
You must be a competent user of excel features and understand the basics of functions and formulas.
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses. Delegates may notice differences in their software if using a MAC.
Import a picture and turn into a table
Import an image into a cell
Use Liked Data Types
Stocks, Currency and Geography
New Functions
TEXTSPLIT
TEXTJOIN
TEXTBEFORD
TEXTAFTER
FILTER
UNIQUE
XMATCH
XLOOKUP
DROP
VSTACK / HSTACK
IFS
MINIFS
MAXIFS
LAMBADA
Analyze Data
Look for trends, patterns, rankings and more