Logic, text and dates
Decisions with IF, AND, OR and IFS, handling errors, cleaning and splitting text, and calculating with dates and times.
About 3 hours of study
Learning objectives
- Write conditional formulas
- Clean and split text
- Calculate with dates and times
Lessons
- 1
IF, AND, OR, IFS and handling errors Intermediate
Making decisions in formulas: IF with one or more conditions, AND, OR and NOT, nested IFs versus IFS, and catching errors with IFERROR and IFNA.
- 2
Text functions Intermediate
Cleaning and reshaping text: LEFT, RIGHT and MID, LEN, FIND and SEARCH, TRIM and CLEAN, changing case, joining with & , CONCAT and TEXTJOIN, SUBSTITUTE, TEXT and VALUE.
- 3
Dates and times Intermediate
How Excel stores dates as serial numbers and times as fractions of a day, and the functions that build, split and calculate with them: TODAY, DATE, EOMONTH, EDATE, WEEKDAY, NETWORKDAYS and more.