|
|
Class Outline*
|
|
| Request Info | Contact Us
|
|
Excel Power User
Duration:
1 Day
Overview:
This class is designed for the Excel user who works with large amounts of data and needs to quickly create formulas, spot errors, or work with text.
Prerequisite:
Excel Level 2
|
|
Outline:
|
Text Functions
|
|
We will examine several different functions to search within text, extract data, and combine text with concatenation tools.
|
|
Information Functions
|
|
Reveal the type of data within your cells, and use that information within an IF statement to return the data that you need.
|
|
Array Functions
|
|
Arrays and other CSE (Ctrl-Shift-Enter) formulas can streamline your work by creating one formula in place of dozens.
|
|
Advanced Formulas
|
|
We will review and expand on IF statements and Vlookups and will consider how to use Match and Index formulas with more flexibility.
|
|
|
|
|
*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.
|