|
Course Outline - Excel 2007 Training: Approx. 6 hrs. of training on 3 CDs or DVDs
Excel 2007 Basic
Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Customize the Quick Access Toolbar
- Navigate and Select in Excel
- Enter Data and Save a Workbook
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
Modifying a Worksheet
- Manipulate Data
- Working with Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Using Styles
Printing Workbook Contents
- Print Workbook Contents Using Default Print Options
- Setting Page Breaks
Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets
Excel 2007 Intermediate
Calculating Data with Advanced Formulas
- Manage Cell and Range Names
- Calculating Data Across Worksheets
- Analyzing Data with Logical and Lookup Functions
Organizing Worksheet and Table Data
- Creating and Modifying Tables
- Formatting Tables
- Sorting or Filtering Worksheet or Table Data
- Calculating Data in a Table or Worksheet
Presenting Data Using Charts
- How to Create a Chart
- Modifying Charts
- Formatting Charts
Analyzing Data Using PivotTables and PivotCharts
- Creating a PivotTable Report
- Analyzing and Modifying a PivotTable
Inserting Graphic Objects
- Inserting and Modifying Pictures and ClipArt
- Drawing and Modifying Shapes
Customizing and Enhancing Workbooks and the Excel Environment
- How to Customize the Excel Environment
- Customizing Workbooks
- Managing Themes
- How to Create and Use Templates
Excel 2007 Advanced
Streamlining Workflow
- Creating Macros
- Adding Macros to the Quick Access Toolbar
- Editing a Macro
- Using Conditional Formatting
- Applying Data Validation to a Worksheet
- Updating Workbook Properties
- Modifying Excel Options
Collaborating with Others
- Protecting Files and Sharing Workbooks
- Merging Multiple Workbooks
- Adjusting Macro Settings
- Restricting Document Access
Auditing Worksheets
- Tracing Cell Precedents and Dependents
- Troubleshooting Errors in Formulas
- Watching and Evaluating Formulas
- Creating a Data List Outline
Analyzing Data
- Adding a Trend Line to Charts
- Create Scenarios and Performing What-If Analysis
Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Managing Linked Cells in Different Workbooks
Importing and Exporting Data
- Exporting Excel Data
- Importing a Table from Word
- Importing a Delimited Text File
|