Text, Time & Dates
Each piece of data you use is categorized by type. Excel uses these types to analyze your data and return impactful insights. In this course, you’ll learn how to manipulate text, time and date types, allowing you mine the most important valuable information from your dataset.
Intermediate 15 Lessons 150 Minutes CPD Credits
About This Course
To make the most out of the data you have, you’ll need to understand how Excel interprets and stores data.
In this course, you’ll explore how Excel deals with text, time and date data types, and how to manipulate each to fit your analysis needs.
By the time you’ve completed these 15 lessons, you’ll be able to clean, chop, combine, split and convert data, expanding your interpretation capabilities significantly.
Explain how Excel interprets text, dates, and times
Adjust the letter case of text
Combine and split strings of text
Search for specific strings of text
Convert dates between text and Date values
Add and subtract combine dates and times
Compile totals by day or by week
Analyze data within specified time intervals
Organize a spreadsheet and its data
1. How Excel Deals with Text, Dates, and Times
2. Change the Letter Case of Words
4. Chop Lines of Text Part 1
5. Chop Lines of Text Part 2
6. Search for Text in a Dataset
7. Split Address Field into Multiple Columns
8. Convert Dates from Text into Values
9. Add and Subtract Dates
10. Compile Weekly Totals
11. Analyze Data by Day of the Week
12. Combine Dates and Times
13. Add and Subtract Times Part 1
14. Add and Subtract Times Part 2
15. Analyze Data Within Time Intervals
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.