|
|
Navigation
& Data input
- Quick Navigation
of spreadsheets
- Accurate
selection of large amounts of data
- Shortcut
Keys
- Named Ranges,
modifying & deleting
- Custom Lists,
creation & deleting
- Using AutoFill
to create numbered sequences
Functions:
IF & VLookups
- Absolute
Addressing
- Using the
IF Function – Using the Paste Function
- Using the
Vlookup
- Shortcut
to view all formulaes
- Auditing
Toolbar
Data
& Form
- Data &
Form
- Using the
Form to search for records
- Adding records
using the Form
Advanced Filter
- Using the
AutoFilter
- Using the
Advanced Filter
- Filtering
Results to another area of spreadsheet
Auditing
Toolbar
- Using
the Auditing Toolbar
- Tracing
Precedents
- Tracing
Errors in Formulaes
Protection
- Protecting
Worksheets
- Protecting
Workbooks
- Protecting
parts of a spreadsheet
- Placing
a password on the file
|
Goal
Seek & Consolidation
- Using
the Goal Seek in Excel
- Consolidating
Data in a spreadsheet
Pivot
Tables
- Creating
Pivot Tables
- Modifying
Pivot Tables
- Formatting
data within Pivot Tables
- Refreshing
data in a Pivot Table
- Creating
a Pivot Chart
- Modifying
a Pivot Chart
Scenarios
- Creating
Scenarios
- Shortcuts
to viewing scenarios
Views
- Hiding Rows
- Create Views
- Shortcut
to view “Different Views”
Toolbars
- Creating
Personal Toolbar
- Deleting
Toolbar
Macros
- Recording
a Macro
- Running
a Macro
- Assigning
a Macro to a button in Toolbar
- Assigning
a Macro to a push button on spreadsheet
- Editing &
Deleting a Macro
|
|
