RDS Instruction

1. The Excel workspace
2. Getting familiar with the Ribbon
3. Entering data into Excel
4. Formatting your data
5. Importing data
6. Preparing to print your spreadsheet
7. Saving your data

This course will assume students have a working knowledge, and prior experience, with Excel.  This class will show students how to manage data using tables and how to extract additional information using simple Excel formulas.

• Creating a table in Excel
• Table features
• Creating and editing formulas
  • Math Formulas
  • Logical Formulas
  • Reference/Lookup formulas
  • Text Formulas
  • Date/Time Formulas

Pivot Tables

1. What is a Pivot Table - Advantages/Disadvantages
2. Adding New Table / Rows, Columns, Values, Filters
3. Refreshing Table
4. Subtotals, Subgroups,
5. Using Filters for specificity
6. Calculated Fields