|
Working with Lists
|
· Creating a List
· Using a Data Form
· Adding Records Using a Data Form
· Finding Records Using a Data Form
|
· Deleting Records Using a Data Form
· Sorting Records in a List
· Using Autofilter in a List
|
|
Working with Charts
|
· Creating a Chart with the Chart Wizard
· Moving a Chart
· Resizing a Chart
· Changing a Chart Type
· Editing Chart Text
|
· Modifying Chart Options
· Formatting Category and Value Axis Data
· Formatting a Data Series
· Changing a Chart’s Source Data
|
|
Working with Graphics
|
· Using the Drawing Toolbar
· Formatting Drawing Objects
· Inserting WordArt
|
· Inserting an Organizational Chart
· Modifying an Organizational Chart
|
|
Workgroup Collaboration
|
· Web Page Preview
· Converting Worksheets to Web Pages
|
· Inserting Hyperlinks
· Viewing and Editing Comments
|
|
Financial and Logical Functions
|
· Using the IF Function
· Using Nested Functions
· Using the PMT Function
|
· Using the FV Function
· Using Autocalculate
|
|
Date and Time Functions
|
· Understanding Date/Time Functions
· Adding a Date and a Date Interval
|
· Subtracting Dates
· Calculating Time Intervals
|
|
Managing Workbooks
|
· Creating a Workbook Using a Template
· Creating a New Template
· Editing a Template
· Showing or Hiding Workbook Elements
· Creating a Workspace
|
· Comparing Workbooks Side-by-Side
· Saving a Workbook in a Different
File Format
· Using Data Consolidation
|