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

Lessons

  1. 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. 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. 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.

Module practice

Module quiz

1. What does =IF(5>3,10,20) return?
2. Which function removes extra spaces from text?
3. How does Excel store a date?
4. What does OR(A1>10,B1>10) need to be TRUE?
5. Which function returns the last day of a month?
6. Why does subtracting 22:00 from 06:00 give a negative time?

‹ Formulas and functionsWorking with data ›