Microsoft Office XP - Excel 2002 - CEXB

Description With the Excel 2002 training course from ATS, you can learn both spreadsheet basics and advanced features of this latest version of Excel. ATS 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 course you'll feel confident using Excel 2002 and understand how to use it to maximize productivity

Course Outline

Module 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 and 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

Module 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

Module 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

Price £ 358 (Bundle of 3)

Complementary Courses
Word 2002
Access 2002
Outlook 2002
Powerpoint 2002
XP Intergration
XP Professional Bundle

<<Back <<Contact Us