Excel 101: Introduction to Spreadsheets Part 2

Authored by David Ringstrom
About this Course
Topics covered include: Adding fields to a blank pivot table to create instant reports; Spell-checking spreadsheets by way of a keyboard shortcut or menu command; Adding fields to a blank pivot table to create instant reports; Limiting access to sensitive workbooks by way of password protection; Removing the Table feature from Excel spreadsheets once it's no longer needed or simply erasing the alternate row shading; Swapping out data within worksheet cells by way of the Replace feature;Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns; Separating first/last names into two columns without using formulas or retyping; Identifying duplicates in a list using Conditional Formatting; Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns; Building a basic chart within an Excel worksheet. Upon completing this course, you should be able to: Identify the location of the Field List command within Excel's ribbon menu interface; Identify the feature that allows you to separate data into multiple columns; Identify the ribbon tab that contains the Total Row command.
$ 56.97
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Basic
CPE Credits
2.0
Prerequisites
None
Last Updated
08/03/2018
14119