This course brought to you by Wolters Kluwer
1 Lesson / $55 / 2 CPE hours
Topics Covered
- 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.
- Identifying other cells a formula relies on by way of the Trace Precedents 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.