Microsoft Excel 2003 Advanced Online

Course Overview

This course aims to develop skills using Microsoft Excel to produce and spreadsheets to an Advanced level.

Prerequisites

Basic Mathematic concepts, Excel Intermediate

Objectives

Section A: Creating Sample Data

• Sample Database
• Replicate Ranges
• Sort Command
• Random Numbers

Section B: Exporting & Importing

• Data
• Export tText
• Export tDatabase
• 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: Summarising with a Pivot-Table

• 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