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

Session Practice Files

Printer Friendly Version

Artboard 1

Transforming your Text