|
Working with Tables
|
· Creating a Table
· Enter Data into a Table
· Deleting Rows and Columns
· Formatting a Table
· Totaling Data in a Table
|
· Sorting Data in a Table
· Sorting Multiple Columns
· Filtering Data Using Autofilter
· Creating Custom Filters
|
|
Working with Charts
|
· Creating a Chart
· Moving a Chart
· Resizing a Chart
· Changing the Layout and Style
· Labeling Chart Elements
· Formatting Chart Text
· Formatting Chart Elements
|
· Changing the Chart Type
· Showing or Hiding Gridlines
· Customizing Axes
· Creating a Pie Chart
· Changing a Chart’s Source Data
· Moving a Chart to a Different Worksheet
· Saving a Chart Template
|
|
Working with Graphics
|
· Adding Clip Art
· Adding Pictures
· Adding Shapes
· Formatting Drawing Objects
|
· Inserting WordArt
· Inserting SmartArt
· Inserting an Organizational Chart
· Modifying an Organizational Chart
|
|
Workgroup Collaboration
|
· E-mailing a Workbook
· 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
|