Working with Text in Excel 2016

Overall Aim:

To teach you techniques and functions for transforming, splitting, combining, summarizing, visualizing, and organizing text.

Session Length: 60-90 minutes

Intended Audience: Staff or Faculty

Prerequisite: Familiarity with Excel 2016

Format: Direct Instruction, Guided Practice, and Independent Practice

Session Objectives

At the end of the session, the participants will be able to:

• Articulate the function and purpose of Excel 2016

• Transform your text using text wrap, text direction, merge cell, alignment, indent, outdent, lower, upper, and proper functions

• Split and combine text using text to columns, concatenation, and left

• Summarize text using CountA, Countifs, and Sumifs functions

• Visualize text using fonts, cell styles, and conditional formatting

• Organize text using filters, text filters, sorting, custom sorts, and sort by color

  ---

Session Documents

• Handout - 11x17 (pdf)
• Handout - 8.5x11  (pdf)

Session Practice Files

• Excel Text Data (xlsx)
• Fun with Fonts (pdf)
• Independent Practice (pdf)

Printer Friendly Version