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!
Pivot
Tables
Creating
Updating
Adding Fields
Field Options
Manipulating
Consolidation
Charts
New 2010 Pivot Charts
Slices
Outlining
Creating an Outline
Group/Ungroup
Manipulating
Removing
Scenario
Manager
Adding
Updating
Merge
Summary
Printing
Customising
Ribbon
Add/Remove Button
Create New Ribbon Tab
Book Now or Enquire
|
Functions
Nested IFs
VLOOKUP / HLOOKUP
Mathematical
Date/Time
Text
Information
Statistical
Database Functions
Financial
Nesting
New 2010 Functions
General
Formatting Numbers
New Conditional Formatting Rules
Goal Seek
Text Joining
Array
Styles
Options
Custom Lists
Auditing
Mixed References
New 2010 Smart Art & Drawing Features
Advanced Charts
Adding 2nd Y Axis
Custom Charts
Trend Lines
Introduction
to Macros
Recording Macros
Assign to Keyboard
Assign to Ribbon
Save in Personal
Save in Workbook
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
Name Manager
New Analysis Features
Excel Tables
Filtering and Sorting
PivotTable Enhancements
New Proofing Features
Page Layout View
SparkLines
Slicers
Book Now or Enquire
|
