Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for beginner learners who are already familiar with Excel but not proficient analyzing these 3 different types of data. It is best suited to accountants, management consultants, analysts and other business professionals.
Course Overview
This Kubicle course contains 15 lessons, 4 exercises and 1 Exam. It covers the following topics:
- Understanding text, time and dates
- Combining, chopping and splitting strings of text
- Searching and modifying text in a dataset
- Converting dates from text into values
- Adding / subtracting times and dates
- Compiling weekly totals
- Analysing data within time intervals
Key Outcomes
Once you have completed this course you will have a greater understanding of how text can be cleaned, manipulated and analysed in Excel. This will dramatically improve your ability to analyse text-based data.
Separately, you’ll learn how dates and times are stored in Excel, and how to include these data types in a variety of different formulas to perform time-based analysis.