WHAT'S NEW------------------------------------------------------------------
A general overview of what's new in Excel 2007
Watch a Demo of new features in Excel
Training Courses on-line
Where your favorite Office 2003 commands are now located
Quick Reference Card - Get up to speed
New Templates
HELP and HOW-TO
GENERAL---------------------------------------------------------------(back)---
Change the appearance of office programs
Preview formats, fonts, and styles before you apply them
Office 2007 FAQ
Auto-correct options
Worksheet and Excel Table Basics
RIBBON---------------------------------------------------------------(back)----
Seeing the commands on the ribbon
Keyboard commands for the ribbon
Customize the quickaccess toolbar
COMPATIBILITY ISSUES ---------------------------------------------(back)----
Open an Office Excel 2007 workbook in an earlier version of Excel
Copy Excel data or charts to PowerPoint
Prompt to open a file as read-only
Microsoft compatibility pack needed to open an Excel 07 worksheet in older version of Excel
How to convert an older document to Word 2007 format.XPS and .PDF file formats explained
DATA ENTRY----------------------------------------------------------(back)----
Create a drop-down list from a range of cells
Consolidate data in multiple worksheets
Change the date system format
Overview of connecting importing data
Clear a data table
Prevent invalid data entry in a worksheet
Create Macros
FILTERING DATA------------------------------------------------------(back)----
Filter by using advanced criteria
Filter for unique values, remove duplicate values
Sort data in a range or table
Filter data in a range or table
Reapply or clear a filter and sort
FORMULAS---------------------------------------------------------------(back)--
Working with formulas
Add and count excel data
Project values in a series
Insert subtotals
Remove subtotals
Complete list of worksheet functions by category
Calculate multiple results with a data table
FORMATTING----------------------------------------------------------(back)----
Apply and customize a theme
Creating and formatting charts
Outline a list of data in a worksheet
Add, change, or clear conditional formatting
Manage conditional formatting rule preference
Find cells that have conditional formats
COOL EXTRAS-----------------------------------------------------------(back)--
Perform statistical and engineering analysis with the analysis toolpak
Overview of PivotTables and PivotReports
Change or delete PivotTable or PivotReport
Change the layout or style of a chart
Create a macro
Create scenarios for what-if analyses
Get the result you want by adjusting a value using goalseek
Define and solve a problem using solver
|
