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
Course is unavailable for purchase.
NASBA Field of Study
Computer Software & Applications
Level
Basic
CPE Credits
2.0
Prerequisites
None
Last Updated
08/03/2018
14119
This Site uses cookies to store information on your device. Some are essential to make our Site work properly; others help us improve the visitor and user experience. By using the Site, you consent to the placement of these cookies. Read our privacy policy to learn more.