Ability Software Consultants +44 (0)1531 828366
info@officecourseware.com
Instructor with Microsoft Office, OpenOffice and StarOffice training coursewareOfficecourseware.com

Home Titles Costs Contact Us Links

Table of contents from instructor-led training courseware notes. Page numbers are for guidance only and may vary. Courseware notes are formatted for double-sided printing.

Microsoft Excel 2003 Advanced

  Page

Worksheets

 1
Introduction 1
Working with Sheets 1
Sheet Groups 3
3-D Printing 5

Linking Files

 7
Introduction 7
Why Link Workbooks? 7
Managing File Links 8
Workspaces 11

Functions

 13
Introduction 13
String Manipulation with Text Functions 14
Date and Time Functions 15
Lookup and Reference Functions 18
Maths Functions 21
Conditional Sum Wizard 21
Analysis ToolPak 24

Advanced Formatting

 25
Number formats 25
Conditional Formatting 27
Styles 28

Templates

 31
Introduction 31
Standard Templates 31
Custom Templates 32
Template Properties 33
AutoTemplates 33
Storing Templates 34

Scenarios

 35
What is the Scenario Manager? 35
Using the Scenario Manager 35

Views and Reports

 39
Custom Views 39
Report Manager 40

Auditing

 43
Auditing Features 43
Precedents and Dependants 43
Formula Auditing Toolbar 44
Formula Error Checker 45
Evaluate Nested Formula 46
Watch Window 47

Data Commands

 49
Lists 49
Filtering Lists 52
Grouping and Outlining 56
Subtotals 57
Consolidation 58
Template Wizard 60

Pivot Tables

 63
Introduction 63
PivotTable Reports 63
Managing Pivot Tables 65
PivotChart Reports 70

External data

 71
Microsoft Query 71
Pivot Tables Using External Data 72

Charting

 75
Chart Types 75
Adding Data to a Chart 76
Removing Data from a Chart 77
Trend Lines 77
Picture Charts 78
Changing Values 79

Goal Seek

 81

Add-Ins

 83
About Add-In Programs 83
Add-In Programs Included with Excel 84
Installing an Add-In 84

Introduction to Macros

 87
What is a Macro? 87
Recording a Macro 87
Running a Macro 88
Relative References 88
Assigning Macros to Buttons and Objects 89
 
  Word 2003 Intro
Word 2003 Adv
Word 2003 Dev
Excel 2003 Intro
Excel 2003 Adv
Excel 2003 Dev
PowerPoint 2003
Outlook 2003
Visio 2003
Access 2003 Intro
Access 2003 Adv
FrontPage 2003		  


All trademarks and product names used on this web page are for identification purposes only and are acknowledged as the registered trademarks of their respective owners. Officecourseware.com and Ability Software Consultants do not claim the endorsement of, or to represent, any of the companies whose names or products are presented on this page.