Microsoft Excel 2003

Price: $295.00

5 Sessions –
15 Hours of Interactive Training

Nearly every organization today, regardless of size, uses spreadsheets to analyze data and do “what if” projections of future scenarios. Whether you're a spreadsheet novice or have some experience, the Excel 2003 course from LearnKey can help you quickly get up to speed. Expert instructor Erin Olsen uses practical examples to show you Excel fundamentals before moving step-by-step into more advanced topics like graphs, charts, formulas and macros. At the conclusion of this course, you'll feel confident in your ability to use Excel 2003 for powerful business applications.

Benefits

• Gain valuable skills using the professional standard for spreadsheet programs.
• Produce powerful business charts and graphs with advanced Excel capabilities.
• Enhance personal productivity and technical credibility.
  

Session 1

Section A: Introduction
· Exploring Excel
· Data Types
· Navigating
· Selecting Data
· Noncontiguous Selection

Section B: Workbook Basics
· Entering Data
· Dates
· Numbers
· Fill Handles
· Fill Options
· Save

Section C: Editing Worksheets
· Replace/Edit Data
· Cut, Copy & Paste
· Drag & Drop
· Delete Data
· Rows & Columns
· Change Width & Height
· AutoFit
· Data Validation

Section D: Formatting Data
· Format Toolbar
· Font Format
· Merge & Center
· Format Cells
· Indent
· Borders & Shading
· Layout Options
· Add Graphics

Section E: Advanced Formatting
· Number Formats
· Decimals
· Special Features
· Dates
· Custom Formats
· Create Custom Format
· Conditional Format
· AutoFormat

Section F: Reusable Formats
· Using Templates
· Creating Styles
· Modifying Styles
· Creating Template
· Use/Save Worksheet

Session 2

Section A: Basic Formulas
· Formula Syntax
· Create Formula
· Create & Edit Formulas
· Relative Reference
· Absolute Reference
· Complex Formulas
· Formula Rules

Section B: Formula Auditing
· Tracing
· Evaluate Formula
· Circle Invalid Data
· Watch Window

Section C: Basic Functions
· Function Syntax
· Common Functions
· Building Functions
· Paste Function Box
· Paste Function Button
· AutoCalculate
· Date & Time Functions
· Logical Functions

Section D: Working with Names
· Create Names
· Range Names
· 3-D Names
· Use Names
· Range Functions
· Paste References
· Edit Range

Section E: Organization
· Worksheets
· Copy Worksheets
· Consolidate Data
· Tab Naming

Section F: Charts
· Chart Wizard
· Define Data
· Layout Options
· Position Options
· Charting Toolbar
· Format Options
· 3-D Charts
· Modify Data

Section G: Save & Print
· Save Options
· Save As Web Page
· View Saved Files
· Print Setup
· Page Setup Options
· Print Area

Session 3

Section A: Protecting Data
· Worksheet View
· Cell Protection
· Allow Range Editing
· Protect Sheet
· Protect Workbook

Section B: Sharing Workbook
· Set Up for Sharing
· Comments
· Email for Review
· View Changes
· Track Changes
· Compare Side by Side

Section C: Database
· Defining Databases
· Database Components
· Using Forms
· Filtering with Forms

Section D: Sorting Database
· Freeze Panes
· Sort Buttons
· Sort Columns
· Sort Order

Section E: Database Function
· DFunction Syntax
· Modify Function
· And vs. Or
· Record Count
· VLookup

Section F: Filtering
· AutoFilter
· Multiple Filters
· Custom Filters
· Advanced Filters
· Copy to Location

Section G: Subtotals
· Working with Subtotals
· Count Subtotal
· Average Subtotal
· Grouping
· Linking Workbooks

Excel 2003 Advanced

Session 4

Section A: Excel Advanced Features
· Quick Review
· Ways to Manipulate Data
· What-if Analysis Tools
· Goal Seek

Section B: Using Solver
· Setting Solver Parameters
· Modifying Parameters
· Solver Results

Section C: Forecasting with Trendlines
· Terminology
· Trendline Types
· Creating Charts
· Adding Trendlines
· Formatting and Deleting Trendlines

Section D: Working with Scenarios
· Creating Scenarios
· Showing Scenarios
· Modifying Scenarios
· Merging Scenarios
· Scenario Summaries
· Protecting Scenarios

Section E: PivotTables and PivotCharts
· PivotTable Features
· PivotTable Terminology
· PivotTable Fields
· Creating PivotTables
· PivotTable Layout
· Field List and Toolbar
· Modifying PivotTables
· Filtering PivotTables
· PivotCharts
· Grand Totals and Viewing Details

Section F: Capturing Data from the Web
· Basic Options
· Refreshable Web Queries
· External Data Toolbar
· Web Query Options
· Saving Web Queries
· Exporting Web Pages to Excel
· Redirecting Web Queries

Section G: Using XML
· Saving Spreadsheets to XML Format
· Creating XML Maps
· Exporting XML Data Excel 2003 Advanced

Session 5

Section A: Macros
· Macros Defined
· Naming Rules
· Storing Macros
· Recording a Macro
· Running a Macro
· Editing a Macro
· Absolute vs. Relative Cell Referencing
· Assigning Macros to Buttons

Section B: Web Functionality
· Hyperlinks
· E-mail a Hyperlink
· Hyperlinks Within Files
· Hyperlinks to Other Files
· Optimizing for Web Publication
· Publishing to the Web
· Office Web Components
· Viewing in a Browser
· Republishing

Section C: Customizing the Interface
· General and View Options
· Calculation and Edit Options
· Custom Lists and Chart Options
· Save Options
· Spelling Options
· Security Options
· Customizing Toolbars
· Creating New Menus

Section D: Manipulating the Screen Display
· Freezing Panes
· Splitting Screens
· Opening in a New Window
· Comparing Side by Side

Section E: Working with Templates
· Benefits
· Creating Styles
· Copying and Importing Styles
· Saving Templates
· Using Templates

Section F: Excel with Other Applications
· Word Mail Merge
· Importing Contacts to Outlook
· Outlook Journal Options
· Linking to Outlook Contacts
· Linking to PowerPoint Charts