Excel 2003 Professional

This course will help you to master the features of Excel required to develop and maintain spreadsheets for use in a workgroup. You will learn to use security, validation, and auditing tools to ensure the integrity of data.

You will also learn to customise the user environment by creating command bars and recording and editing macros. Finally, you will learn to integrate Office applications using XML data and Microsoft Query.

With its companion course, Microsoft Excel Advanced, you can use this course to prepare for Microsoft Office Specialist Excel Expert Objectives.

Target audience

Those wanting to develop their skills in using Excel to design spreadsheets that solve complex problems and can be deployed effectively in a workgroup. You should be competent with the objectives required for Excel at Microsoft Office Specialist Core Level. You should be able to use formulas to link worksheets and workbooks, use list functions, and create and format charts.

Course content

Excel 2003 - 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

Excel 2003 - 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

Office 2003 - 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

Excel 2003 - Protecting Data Apply and remove worksheet protection • Lock and unlock cell ranges • Apply and remove file passwords to open or change a workbook

Excel 2003 - Validating Data Entry Apply data validation rules and display user prompts • Validate data on a worksheet

Excel 2003 - 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

Excel 2003 - Sharing a Workbook Create a shared workbook • Track changes and resolve conflicting changes • Merge workbooks • Route a workbook to several reviewers

Excel 2003 - 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

Office 2003 - 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

Office 2003 - 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

Excel 2003 - Using Views and Workspaces Save different views of a workbook • Use a workspace file

Excel 2003 - 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

Office 2003 - Digitally Signing a File Create, view, and remove a digital signature

Glossary

Index

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today