Text, Time, and Dates
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
How Excel Deals with Text, Dates, and Times
How Excel Deals with Text, Dates, and Times
It is vital that users understand how Excel displays and stores text, date and time values. Find out all you need to know in this lesson.
Change the Letter Case of Words
Change the Letter Case of Words
Using functions to change the letter case can be a big time-saver when cleaning text. In this lesson, we'll fix the formatting of our first name and last name text columns with this technique.
Combine Strings of Text
Combine Strings of Text
We often need to combine multiple cells of text into one cell and to do this we use '&'. Find out how to use this very useful command correctly in this lesson
Chop Lines of Text Part 1
Chop Lines of Text Part 1
LEFT, RIGHT and MID are functions that allow us to chop a cell of text into smaller parts. They are used regularly for cleaning text in datasets.
Chop Lines of Text Part 2
Chop Lines of Text Part 2
Combining MID with a new function, FIND, allows to extract words from the middle of a text string much more effectively. Here how I show you how to extract the email provider (e.g. gmail) from an email address.
Search for Text in a Dataset
Search for Text in a Dataset
To search for text in our dataset, we can use the Find and Replace dialog box or alternatively, we can use the FIND function in our formulas. I'll compare both options in this lesson.
Split Address Field into Multiple Columns
Split Address Field into Multiple Columns
The address field often contains some useful geographic data such as state and postcode. As a result, it always makes sense to separate this data into individual columns for sorting and filtering purposes.
Convert Dates from Text into Values
Convert Dates from Text into Values
Dates and times will often be stored as text in a dataset. So that we can use these data in formulas, we'll need to convert into a date value or a time value using some Excel functions.
Add and Subtract Dates
Add and Subtract Dates
To analyse to time-series data effectively, you need to know how to add and subtract date values. Here I show you how this can be used to find # sign ups in the last 7 days for our startup.
Compile Weekly Totals
Compile Weekly Totals
Weekly data can be difficult to compile, particularly over multiple months. Using the WEEKNUM function, we'll count the number of sign ups for each week in January.
Analyze Data by Day of the Week
Analyze Data by Day of the Week
A clever way to understand user behaviour is to monitor their activity by day of the week. In Excel, the best way to do this is with the TEXT function
Combine Dates and Times
Combine Dates and Times
Dates and times should ideally be handled stored as one value. Here I show you how to do this for all the entries in our dataset.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
