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.