Microsoft Excel
Following the Excel for Starters class, the Excel courses may be taken in any order.
Office 2011 is installed on the Macs, however, in looks and functionality, it is significantly different from Office 2010.
Excel for Starters
Upon completion of this course, the student will be able to:
- Use the Interface
- Enter Data into Cells
- Work with Columns and Rows
- Work with Ranges
- Create Formulas
Prerequisite: General knowledge of the Windows or Macintosh operating environment
Excel Formatting & Printing
Upon completion of this course, the student will be able to:
- Format Numbers
- Format Text
- Format Cells
- Format Conditions
- Use Page Setup
Prerequisite: Excel for Starters
Excel Worksheets & 3-D Formulas
Upon completion of this course, the student will be able to:
- Use Large Worksheets
- Manage Worksheets
- Create 3-D Formulas
- Work with Multiple Workbooks
- Paste Special Features
Prerequisite: Excel for Starters
Excel Functions, Scenarios & Solver
Upon completion of this course, the student will be able to:
- Use Functions
- Use Advanced Functions
- Audit Functions
- Manage Function Scenarios
- Function with Goal Seek
- Solve Function Problems
- Function with Data Tables
Prerequisite: Excel for Starters
Excel Charts & Graphics
Upon completion of this course, the student will be able to:
- Describe Chart Types
- Create Charts
- Change Chart Types
- Format Charts
- Draw Objects
- Insert Shapes
- Diagram
Prerequisite: Excel for Starters
Excel Data Management & Importing
Upon completion of this course, the student will be able to:
- Organize Lists
- Sort Lists
- Import Data
- Validate Data
- Filter Data
Prerequisite: Excel for Starters
Excel Macro Magic *Webinar Only
Upon completion of this course, the student will be able to:
- Define a Macro
- Run a Macro
- Record a Macro
- Write a Macro
- Edit a Macro
Excel PivotTables & PivotCharts *Webinar Only
Upon completion of this course, the student will be able to:
- Create PivotTables
- Revise PivotTables
- Create PivotCharts
- Revise PivotCharts