Layout Table~~~~3905~3905~~

Excel 3 Sessions - 9 Hours of Interactive Training~
In LearnKey’s Excel 2000 training course, expert Reed Jacobson, guides you through spreadsheet fundamentals and provides inside tips for powerful business applications. You’ll learn valuable features such as, formatting, summarizing, and charting methods, along with some little-known techniques that will help you get up to speed and working efficiently. At the conclusion of this training course, you will be confident in your ability to create meaningful spreadsheets.

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. .~~~3905~3906~~

Course Outline Table~~~~3905~3907~~

Session 1~Section A: Introduction
· Uses for a Spreadsheet
· Understanding the Excel Workspace
· Selecting a Range of Cells

Section B: Entering Values
· Entering Text, Numbers & Dates
· Formatting Dates & Editing Values
· Sorting a List

Section C: Managing Workbooks
· Saving a Workbook
· Opening & Closing Workbooks
· Workbook Add, Delete, Rename & Move

Section D: Creating a Form or Document
· Creating a Form or Document
· Changing Fonts, Color & Alignment
· Formatting Dates
· Resizing Columns & Rows
· Creating Backgrounds & Borders
· Inserting Columns
· Merging Cells

Section E: Summarizing Numbers
· Using Auto Fill
· Using Tab to Enter Values
· Creating Totals Automatically
· Understanding the SUM Function
· Creating & Validating Formulas

Section F: Formatting Numbers
· Currency Style
· Auto Formatting Regions & Moving Cells

Section G: Creating Charts
· Adding a Chart
· Adding New Values to a Chart
· Creating a Custom Chart
· Using the Chart Toolbar & Menu
· Chart Location

Section H: Creating Charts
· Print Preview & Page Setup Options
· Preview Color in Black & White
· Selecting Multiple Sheets
· Printing

Section I: Customizing Excel
· Changing Workbook Options
· Using Adaptive Menus & Toolbars
· Context Sensitive Toolbars

Section J: Discovering More
· Screen Tips
· Use Help in Dialogue Boxes
· Using the Office Assistant
· Help Context~~~3905~3908~~

Session 2~Section A: Managing References
· Relative References
· Using Auditing Toolbar
· Mixed & Absolute References
· Saving Workbooks

Section B: Named Ranges
· Naming Cells
· Naming Ranges
· Applying Names

Section C: Manipulating Ranges
· Importing Files
· Special Formatting Features
· Find/Replace

Section D: Basic Functions
· Summarizing Functions
· 3D Formulas
· Logical Functions
· Date Functions

Section E: Look-up Functions
· Types of Look-ups
· Vertical Look-up
· Applying Names to Vertical Look-up

Section F: Financial Functions
· Types of Financial Functions
· Calculating Payments

Section G: Considering Alternatives
· Using Scenarios
· Report Manager
· Using Goal Seek
· Using the Solver

Section H: Enhanced Formatting
· Formatting Numbers
· Formatting Text
· Applying Styles

Section I: Dynamic Formatting
· Applying Conditional Formats
· Using Data Validation

Section J: Graphical Objects
· Using the Drawing Toolbar
· Adding Comments
· Inserting Pictures~~~3905~3909~~

Session 3~Section A: Managing Workbooks
· Introduction
· Adding a File Password
· Protecting a Workbook
· Freezing Row & Column Headers
· Changing Page Breaks
· Printing Portions of a Worksheet
· Setting Workbook Properties
· Creating a Workspace

Section B: Using Templates
· Saving & Editing a Template
· Changing the Default Template
· Changing the Default Worksheet Template

Section C: Sharing a Workbook
· Sharing a Workbook
· Editing a Shared Workbook
· Tracking Changes to a Shared Workbook
· Merging Workbooks

Section D: Query a Database
· Retrieving Data from a Database
· Filtering the Data using Microsoft Query

Section E: Working with Lists
· Sorting Lists
· Using a Form to View/Search a List
· Using AutoFilter
· Using the Advanced Filter
· Adding Subtotals to a List
· Tracing Errors

Section F: Working with PivotTables
· Creating a PivotTable
· Formatting a PivotTable
· Creating a PivotChart

Section G: Excel & the Internet
· Saving a Workbook as HTML
· Saving HTML with Interactivity
· Saving an Interactive PivotTable as HTML
· Importing Values from a Web Site
· Creating Hyperlinks in a Worksheet
· Using the Office Clipboard
· Round Tripping to HTML & Back Again

Section H: Creating Macros
· Creating & Running a Macro
· Looking at a Macro's Code
· Creating Another Macro
· Editing the Macro
· Creating a Button to Run a Macro

Section I: Preparing for Certification
· The Testing Method
· Tips for the Exam~~~3905~3910~~

Ordering~~~~3905~3911~~

Excel 2000 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|180408|PER USER%3A ONLINE Course|!78977|LIBRARY LICENCE%3A CD Course|180405|~3905~3912~excel microsoft end user 2000~