Excel - Direct Dates & Tangle with Text
A one-hour live class on dates and text in Excel: date formulas and functions such as TODAY, NOW, NETWORKDAYS, DAYS, YEARFRAC and DATEVALUE, plus Flash Fill to complete text patterns automatically.
About this course
A one-hour live class on dates and text in Excel: date formulas and functions such as TODAY, NOW, NETWORKDAYS, DAYS, YEARFRAC and DATEVALUE, plus Flash Fill to complete text patterns automatically.
Curriculum
- Know how to handle dates and date formulas.
- Use Dates in Functions - TODAY and NOW, NETWORKDAYS, DAYS, YEARFRAC, and DATEVALUE
- Have Excel recognize patterns to automatically fill in data with Flash Fill.
- Work with the Change Case - UPPER, LOWER, and PROPER, and Replace function results with values.
- Use the CONCAT, TEXTJOIN, Text to Columns Wizard, RIGHT, LEFT, MID, LEN, FIND, and TRIM functions Combine functions for more functionality
- Work with Columns and Split text
Who it's for
Excel users handling dates and text.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.