Who Should Attend
This course is intended for users who have some experience using Excel Functions. It assumes the user is already comfortable with navigating and selecting data in Excel. Anyone who works with dates, text, or data entry in Excel will benefit from this course.
Course Objectives
This course aims to help students become more comfortable working with dates and text. Students will learn about a many useful Excel functions and when to use them as well as how to combine different text functions with each other for maximum effect. By the end of this course, you will be experienced in both date and text functions.
Agenda
1 - Lessons
- Work with Dates - Learn how to use the TODAY and NOW functions, the NETWORKDAYS function, the DAYS function, the YEARFRAC Function, and the DATEVALUE function.
- Flash Fill Feature - Learn how have Excel recognize patterns to automatically fill in data with Flash Fill.
- Working with Text - Learn how to use the CONCAT function, the TEXTJOIN function, the Text to Columns Wizard, the RIGHT function, the LEFT function, the MID function, the LEN function, and the TRIM function.
- Working with the Change Case Functions - Learn how to use the UPPER, LOWER, and PROPER functions, as well as combine text functions.