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

Highlights

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

You’re in the eye of the storm amid a swirl of slips, forms and receipts. Chart your way through tax-time turbulence with these updates and resources.