Excel 2003 Advanced

Computer Training Solutions
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Templates and Add-Ins

Create a template file for frequently used worksheet layouts �Edit and apply a template file �Use workgroup templates �Load an Add-in program

Using Analysis Tools

Use one- and two-input data tables to resolve What-If? calculations �Solve a problem using Goal Seek �Use Solver to calculate complex problems �Create What-If analyses using the Scenario Manager

Scatter and Combination Charts

Create an XY (Scatter) or Bubble chart �Add a trendline to a chart �Create a combination chart �Add a second value axis to a chart

Protecting Data

Apply and remove worksheet protection �Lock and unlock cell ranges �Apply and remove file passwords to open or change a workbook

Excel Validating Data Entry

Apply data validation rules and display user prompts �Validate data on a worksheet

Auditing a Worksheet

Display formulas in worksheet cells �Trace precedents and dependents �Trace and fix errors �Use the Formula Error Checker �Use the Formula Evaluator to obtain results in part of a formula �Use the Watch Window to view results in cells

Sharing a Workbook

Create a shared workbook �Track changes and resolve conflicting changes �Merge workbooks �Route a workbook to several reviewers

Querying a Database

Set up a data source �Create a query to import data as an external range �Format and refresh an external data range �Import a table from an HTML web page �Round trip HTML data in Excel

Using XML

Understand the use and capabilities of XML �Use Access to generate a schema �Apply a schema to a Word document �Import and export XML lists in Excel

Customising Command Bars

Add and remove a command from a toolbar �Customise button images and groups �Create a new command bar �Assign keyboard shortcuts to actions

Using Views and Workspaces

Save different views of a workbook �Use a workspace file

Recording a Macro

Record a macro �Run a macro �Edit a macro �Delete a macro �Assign macros to menus, shortcut keys, and toolbars �Set up macro virus protection

Digitally Signing a File

Create, view, and remove a digital signature
...''

Elements of this syllabus are subject to change.

Phone:08456 44 1234

School Address:

Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP UK

Jobs & Resumes: London
Houses & Roommates: London
Travel Agencies: London

Search other schools for Excel 2003 Advanced training resources.

Visual Basic
CSS with XML
XLST & XPATH
XML
Acrobat
ASP Intermediate/Advanced
ASP
CorelDraw 12 Advanced
CorelDraw 12
DHTML/DOM
Excel 2003 Intermediate
Flash
FrontPage 2003 Intermediate/Advanced
FrontPage 2003
Illustrator Advanced
Illustrator Intermediate
Illustrator
InDesign CS Intermediate/Advanced
InDesign CS

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.