Course Features
Duration
1.46 hour
Delivery Method
Online
Available on
Lifetime Access
Accessibility
Desktop, Laptop
Language
English
Subtitles
English
Level
Beginner
Teaching Type
Self Paced
Video Content
1.46 hour
Course Description
Course Overview
International Faculty
Post Course Interactions
Hands-On Training,Instructor-Moderated Discussions
Skills You Will Gain
Prerequisites/Requirements
There are no pre-course requirements
What You Will Learn
How to create a Pivot table and analyse data with one
How to create a drop-down list
Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE
VLOOKUP and the new XLOOKUP function