|
MICROSOFT EXCEL XP – Specifics
Course Aims:
Participants will learn advanced workbook features, including range names, working with multiple sheets, linking data, 3D referencing and consolidating data. They will also learn how to use the database features in Excel including AutoFilter, Subtotals, Database Functions and Forms. Finally, participants will learn how to create charts and have an introduction to automating with macros.
Contents:
Documenting Worksheets
Defining Range Names
Using the Range Navigator and F5
Calculating with Range Names
Outlining Worksheets
Working with Task Panes and Smart Tags
Excel Functions
Formulas and Functions
Screen Tips for Functions
Function Reference
Using the Paste Function Wizard
AutoFill Formulas & Functions
Relative and Absolute Addressing
Creating & Using Templates
About Templates and Template techniques
Save File as type
New from Workbook
Using Templates
Cell & Sheet Protection
Multiple Worksheets
Performing Special Pastes
Retaining Formats when Pasting
Name and Colour Sheet Tabs
Moving, Copying and Deleting Sheets
Creating Groups
Linking to other Spreadsheets
Multi-sheet Formulas and Functions
Charting
Elements of a Chart
Editing Chart objects
Overlay Effects
Using Custom Chart types
Adding Trend Lines
Adding Error Bars
Manipulating 3D Charts
Databases
What is a Database List
Using AutoFilter
Insert and Delete Columns while Filtering
Sorting Data
Multilevel Sorting
SubTotal Functions
Extracting Data with Criteria
AND and OR Logic
Managing with Data Forms
Database Functions
Macros
What are Macros
Personal Macro Workbook
Recording a Macro
Running the Macro
Assigning to a Form Button and Toolbar Icon
Target Audience:
Individuals that require greater control of multi-sheet and multi-file workbooks.
Assumed Knowledge:
Proficient users of Excel or prior attendance of an Excel XP Essentials course.
Duration: 1 Day
Suggested follow-up course:
Excel XP Specialists
printer friendly version
|
