Getting
Started with 2010
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
Microsoft Back Office replaces the File menu
Customise the Ribbon!
Editing
Spreadsheet
Enter/Edit
Selection Techniques
Cut/Copy/Paste
Undo/Redo
Fill by Example
Basic
Formulae
Enter/Edit Formulae
Arithmetic Operators
Autosum
Presentation
Number Display
Font Type/Size
Align Data
Patterns/Colours
Adjust Col/Row
Borders
File
Procedures
Save/Save As
Open/Close
Printing
Print Preview
Define Print Area
Printing Worksheet
Page
Setup
Orientation/Scaling
Centring Horiz/Vert
Headers/Footers
Sheet Options
Book Now or Enquire
|
Managing
Formulae
Order of Precedence
Relative v. Absolute
Formula to Valve
Functions
Min/Max
Average/Count
Sum
IF
Comparison Operators
2010 Conditional Formatting
Spark Lines
Range
Names
Create & Define
Going to a Range
Printing a Range
Use in Basic Formula
Spreadsheet
Efficiency
Cell Notes
Sorting
Page Breaks
Freeze Titles
Control Large Sheets
Charts
2010 Chart Designs
Chart Types
Autoformat
Re-size/Move
Legends & Titles
Basic
Filtering
Autofilter
Select Filter
Sort
Remove Filter
New Features of Excel 2010
New General Features
Increased Capacity
Office Backstage View
More Templates
File Types
New Formatting Features
Galleries
Conditional Formatting
New Formula Features
Resizable Formula Bar
AutoComplete
New Analysis Features
Excel Tables
Filtering and Sorting
New Proofing Features
Page Layout View
SparkLines
Book Now or Enquire
|
