Skip to main content

Excel Short Topics: Text Functions

ID : 3632   
« back to classes page
Do you ever work with data sets imported from somewhere or prepared by somebody else that are messy, disorganized, full of clutter or inconsistently formatted? Do you ever want to display numbers in a more readable format, or at least in a format that makes more sense? If you’ve ever experienced those situations, this class will be extremely useful to you as it focuses on the use of Excel’s text functions.   
This class begins by exploring which functions join together and split text (CONCATENATE and Text to Columns). Then you will unlock the power of pulling pieces of a text string (LEFT, RIGHT, MID, LEN and FIND) out and how to then embed that piece into an IF function or string items together for use in a LOOKUP. Appropriate use of formatting functions (UPPER, LOWER, and PROPER) will also be explained. Named ranges for use within these functions will also be covered. Finally, you will learn about using the Paste Special features of Pasting Values and Transpose.

Class Details

1 Sessions
Weekly - Thu

CCC Technology Center

Nancy Dugan 



Schedule Information

Date(s) Class Days Times Location Instructor(s) Instructional Method
4/11/2019 - 4/11/2019 Weekly - Thu 1:00 PM - 4:00 PM Clinton, CCC Technology Center  Map, Room: Classroom 17, Computer Lab Nancy Dugan  ClassRoom

Other Class Offerings

Excel Short Topics: Text Functions
ID: 2784

04/06/19 - 04/06/19
Weekly - Sat
1 session

SCC Urban Campus

Nancy Dugan

Call 563-441-4100 to register
Send to Friend »