Text and information functions in Excel

This is the agenda for Table of Contents
Table of Contents
 
Introduction

Welcome

 
Information functions

• What We Will Cover
• Information Functions
• The INFO() Function
• What Have We Done

 
Text functions

• 5 Very Useful Text Functions - Part 1
• 5 Very Useful Text Functions - Part 2
• What Have We Done

 
Finding specific characters

• Finding Specific Characters
• Creating Mail Merge Data
• Extracting Name and Address
• Extracting Mid-Field Text - Part 1
• Extracting Mid-Field Text - Part 2
• What Have We Done

 
Manipulating text with functions

• Manipulating Text With Functions
• Using the SUBSTITUTE() Function
• Using the REPLACE() Function
• What Have We Done

 
Conversions

• Creating Customer Upload Fields
• Creating Customer Numbers Using Functions
• Using the CODE() and CHAR() Functions
• Sneaky Use of the CHAR() Function

 
Creating hyperlinks

• Creating Hyperlinks
• Creating a Navigation Bar - Part 1
• Creating a Navigation Bar - Part 2
• What Have We Done

 
Cleaning data

• Cleaning Data
• Looking Up Customer Balances
• Using the TRIM() Function
• Using the CLEAN() Function
• What Have We Done

 
Guarding against errors

• Guarding Against Errors
• Error Types
• #DIV/0! Errors
• Dealing With Errors
• What Have We Done

 
Conclusion

• In Review
• Conclusion
• Final Quiz