Text & Date Functions
What you will be able to do
- Clean and split text from other systems
- Join text and numbers into labels
- Calculate with dates, month-ends and working days
- Build fiscal year and quarter labels
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Text
- Joining text: & and CONCAT
- TEXTJOIN
- LEFT, RIGHT and MID
- LEN, FIND and SEARCH
- TRIM and CLEAN
- UPPER, LOWER and PROPER
- SUBSTITUTE and REPLACE
- TEXT
- TEXTSPLIT, TEXTBEFORE and TEXTAFTER
- VALUE: text to numbers
Module 2: Dates
- How Excel stores dates; TODAY and NOW
- DATE, YEAR, MONTH and DAY
- EOMONTH and EDATE
- DAYS and YEARFRAC
- WORKDAY and NETWORKDAYS
- Fiscal year, quarter and period formulas
Project: clean a bank export and build an invoice ageing list
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free