wolters kluwer

Excel 101: Introduction to Spreadsheets Part 2

This course brought to you by Wolters Kluwer

1 Lesson / $55 / 2 CPE hours

See Excel 101: Introduction to Spreadsheets Part 2 

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.