Layout Table~~~~3865~3865~~

Excel 3 Sessions - 9 Hours of Interactive Training~
With the Excel 2002 training course from LearnKey, you can learn both spreadsheet basics and advanced features of Excel. LearnKey expert Reed Jacobson’s energetic instruction begins with fundamentals like charts and graphs, moves step-by-step through intermediate topics such as building formulas, and concludes with expert level features including database links and macros. At the conclusion of this training course, you’ll feel confident using Excel 2002 and understand how to use it to maximize productivity. This course covers all the objectives for the Microsoft Office Specialist exams..

Benefits
• Gain valuable skills and improve personal productivity..
• Acquire knowledge that will add credibility for future career prospects.
• Increase marketability by using the latest information technology. .~~~3865~3866~~

Course Outline Table~~~~3865~3867~~

Session 1~Section A: Introduction & Simple Lists
· Introduction
· Cell Reference
· Creating Lists
· Simple Formatting
· AutoFill Values
· Format Painter

Section B: Workbooks & Worksheets
· Save a Workbook
· File Properties
· Rename & Delete Worksheets
· Move & Copy Worksheet
· Printing a Workbook

Section C: Manipulating Values
· Editing Values
· Insert, Delete & Move Cells
· Copy Cells
· Comments
· AutoFilter
· Find & Replace

Section D: Charts
· Create a Chart
· Chart Options
· Manipulate Values
· Chart Type
· Secondary Axis
· Add Values

Section E: Summarizing Values
· New Worksheet
· Add Values
· AutoSum
· AutoFormat
· Modifying Format Styles

Section F: Formatting & Graphics
· Create a Grid
· Create a Border
· WordArt
· Add Text
· Merge & Center
· Insert Clip Art
· Drawing Object
· Rotated Text
· Print Preview

Section G: Using Help
· Tool Tips
· Office Assistant
· Ask a Question Box
· Context Sensitive Help
· Comprehensive Help~~~3865~3868~~

Session 2~Section A: Financial Functions
· Loan Calculation
· Insert Function
· Name Ranges
· Amortization Table
· Future Value
· Date Functions
· Dynamic Dates

Section B: What-If Analysis
· Goal Seek Command
· Create Scenarios
· View Scenarios
· Single-input Data Table
· Two-input Data Table

Section C: Relative & Absolute References
· Expense Allocation
· Formula Auditing
· Trace Precedents
· Finding Errors
· References
· Evaluate Formulas

Section D: Protection
· Protect Worksheet
· Unlock Cells
· Protection Options
· Protect Workbook
· Control Input

Section E: Lookups
· Named Range
· Exact Lookup
· Bonus Amount
· Range Lookup
· Moving Ranges
· External References
· Update & Repair Links
· Hyperlinks

Section F: Advanced Formatting
· Custom Number Formats
· Conditional Formatting

Section G: Consolidating Values
· Budget Template
· Save As Template
· Enter Values
· Consolidate: Sum
· Consolidate: Link
· Create Workspace
· 3D Formulas

Section H: Sharing Workbooks
· Share a Workbook
· Track Changes
· Merge Workbooks~~~3865~3869~~

Session 3~Section A: Creating Sample Data
· Sample Database
· Replicate Ranges
· Sort Command
· Random Numbers

Section B: Exporting & Importing Data
· Export to Text
· Export to Database
· Import from Database
· Import from Text
· Import Text Wizard

Section C: Advanced Filters
· Custom AutoFilter
· Advanced Filter
· Extract a List

Section D: Subtotals & Outlines
· Subtotal
· Outline
· Nesting Subtotals
· Manual Grouping

Section E: Summarizing with a PivotTable
· Create a PivotTable
· PivotTable Field List
· Manipulate a PivotTable
· Format
· Group Data
· Create a PivotChart
· Manipulate a PivotChart
· AutoFormat

Section F: Publishing Workbooks
· Preview Large Document
· Freeze Headings
· Header
· Footer
· Preview a Chart
· Print a Chart
· Static HTML Page
· PivotTable Interactivity
· Spreadsheet Interactivity
· Web Queries

Section G: Creating Macros
· Record Macros
· Play Macros
· Visual Basic
· Edit a Macro
· Toggle Macro

Section H: Adding User Interface
· Custom Toolbar
· Menu Command
· Security Level
· Workbook Button
~~~3865~3870~~

Ordering~~~~3865~3871~~

Excel 2002/XP Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|670408|PER USER%3A ONLINE Course|!78962|LIBRARY LICENCE%3A CD Course|670405|~3865~3872~excel microsoft end user 2002 xp~