 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2003 Professional
Course Aims
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. |
Assumed Knowledge
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 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. |
|
Table of Contents
|
Excel 2003 - Templates and Add-Ins
|
Create a template file for frequently used worksheet layouts
|
|
Edit and apply a template file
|
|
|
|
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
|
|
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
|
Track changes and resolve conflicting changes
|
|
Route a workbook to several reviewers
|
|
|
Excel 2003 - Querying a Database
|
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
|
|
Assign keyboard shortcuts to actions
|
|
|
|
Excel 2003 - Using Views and Workspaces
|
Save different views of a workbook
|
|
|
|
Excel 2003 - Recording 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
|
|
|
|
|
|
