Microsoft Excel 2003 Complete Courseware Courseware and Training Materials

What's included?
What’s included?
Available for delivery as a download from our web server or provided on CD, this courseware package includes the following resources to make your trainer’s life much, much easier.

This courseware package includes:

	Student Manual. Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs.
	Student workbook. Fully customisable. Additional book includes series of practical tasks and review questions.
	Student workbook exercises. Fully customisable. Sample exercises to accompany the student workbook.
	Trainer manual. Fully customisable with additional information for trainers.
	Timetable and lesson plans. Fully customisable. Detailed timetable and plans ensure you deliver the best possible course.
	PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

To get started, just open this ‘Microsoft Excel 2003′ training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered ‘off-the-peg’ and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

Course outline
Course outline

Course contents: Foundation level

• Introduction What is Excel? — New Features in Excel 2003 — Opening Excel — Exiting Excel
• Help with Excel Finding Help — The Office Assistant — The Help Task Pane
• Beginning Excel The Standard Toolbar — The Formatting Toolbar — Working with Excel Menus — Exploring Task Panes — Excel Shortcut Keys
• The Basics of File Management New Workbooks — How to Open Existing Workbooks — How to Save Workbooks — How to Close Workbooks — Excel File Types
• Explore your Workbook Switching Worksheets — The Active Cell — Selecting Cells — Exploring a Worksheet — The Zoom Feature
• Working with Excel Columns, Rows, Cells, and Ranges — Creating Worksheet Labels — Entering and Deleting Data — Printing your Worksheet
• Basic Excel Features What is AutoFill? — What is AutoSum? — What is AutoComplete? — Working with Basic Formulas
• Editing Tools Using AutoCorrect — Using Spell Check — Using Find and Replace — Documenting a Worksheet with Comments
• Moving your Data Dragging and Dropping Cells — How to Cut, Copy, and Paste Cells — How to Cut, Copy, and Paste Multiple Cells and Items — How to Use Paste Special — How to Insert and Delete Cells, Rows, and Columns — Using Undo, Redo, and Repeat
• Using Smart Tags and Option Buttons What are Smart Tags? — The Error Option Button — The AutoFill Option Button — The Paste Option Button
• Modifying Cells and Data Changing the Size of Rows or Columns — Working with the Formatting Toolbar — Adjusting Cell Alignment — Rotating Text — Creating Custom Number and Date Formats
• Cell Formatting Conditional Formatting — What is the Format Painter? — What is AutoFormat? — Cell Merging and AutoFit — Find and Replace Formatting
• Enhancing a Worksheet’s Appearance Adding Patterns and Colours — Adding Borders — Adding Fill Effects — Working with Styles
• Modifying Excel’s Toolbars Hiding Toolbars — Showing Toolbars — Moving Toolbars — Customizing Toolbars
• Working with Charts Creating a Chart — Formatting a Chart — Manipulating a Chart — Enhancing a Chart with Drawing Tools — Enhancing your Chart with Titles and Tables
• Working with Charts and Data Changing the Type of Chart — Changing the Source Data — Creating 3-D Charts — Working with the Chart Axes and Data Series — Making Custom Charts
• Organizing your Workbook Inserting and Removing Worksheets — Renaming, Moving, and Colour-Coding Worksheets — How to Split and Freeze a Window — Using Multiple Workbooks and Windows — Using a Watch Window — Creating a Custom View
• Formatting your Workbook Using Headers and Footers — Inserting Page Numbers — Changing Margins and Orientation — Hiding Rows, Columns and Worksheets
• Printing a Workbook Choosing a Print Area — Setting up Page Breaks — Choosing Paper Size and Changing Print Scale — Adding Print Titles and Gridlines
• More Workbook Features Linking Workbooks — Consolidating Workbooks — Combining Worksheets — Protecting Worksheets — Using Templates

Course contents: Intermediate level

• Using Formulas in Excel Understanding Relative And Absolute Cell References — The Basic Mathematical Operators — Using Formulas With Multiple Cell References — The Formula Auditing Bar — Fixing Formula Errors — Displaying And Printing Formulas
• Exploring Excel Functions What Are Functions? — Finding The Right Function — Some Useful And Simple Functions
• Using Functions in Excel Inserting Functions — Using Functions And AutoFill To Perform Difficult Calculations — Using the IF Function — Working With Nested Functions
• Working with Names and Ranges What Are Range Names? — Defining And Using Range Names — Selecting Nonadjacent Ranges — What Is Auto Calculate?
• Working with Array Formulas What Are Array Formulas? — Using Basic Array Formulas — Using Functions With Array Formulas — Using The IF Function In Array Formulas
• Working with Lists What Is A List? — Creating Lists — Modifying Lists — What Is The Total Row?
• Working with Records and Fields What Are Records And Fields? — Adding Fields By Inserting Columns — Adding Records By Inserting Rows — Adding Records With A Data Form — Finding And Deleting Records
• Working with Lists and Filters Sorting A List — What Is An AutoFilter? — Custom AutoFilters — Using An Advanced Filter — Copying Filtered Records
• Using Excel as a Database Filtering With Wild Card Characters — Validating Your Data — What Are Database Functions? — What Are Lookup Functions?
• Creating Macros in Excel What Is A Macro? — Creating A Macro — Playing A Macro — Assigning A Shortcut Key To Macro — Macros, Buttons, And Toolbars
• Excel Form Controls What Is A Form Control? — The Form Toolbar — Adding A Control To A Worksheet — Assigning A Macro To A Control — Using Form Controls
• Using Excel in Word Inserting Excel Data In Word — Modifying Excel Data After Insertion — Linking Excel Data In Word — Linking An Excel Chart In Word
• Using Excel w/Other Programs and Files Using Outlook To Send Excel Data — Opening An Excel File In A Different Format — Importing Data From A Text File — Importing Data From A Database

Course contents: Advanced level

• Outlining and Grouping your Data Using Automatic Outlining — Displaying And Collapsing Levels — Grouping Data Manually — Creating Subtotals
• PivotTables What Is A PivotTable? — Creating A PivotTable Frame — Specifying Data in a PivotTable — Rearranging PivotTable Data
• More on PivotTables Modifying PivotTable Calculations — Formatting A PivotTable — Refreshing A PivotTable — Charting A PivotTable — Creating A PivotTable Based On Data From An External Database
• Exploring Scenarios What Is A Scenario? — Creating A Scenario — Creating A Scenario Summary Report — Saving Multiple Scenarios
• What if Analysis Using A One And Two Input Data Table — Using Goal Seek — Using Solver
• Excel and Hyperlinks Hyperlinks and the Internet — Inserting Hyperlinks — Modifying Hyperlinks — Using the Web Toolbar — Browsing Hyperlinks In Excel
• Excel Workbooks as Web Pages Interactive and Non-Interactive Web Pages — Saving A Workbook As A Web Page — Saving A Worksheet As A Web Page — Saving A Chart As A Web Page — Saving A Range As A Web Page
• Getting Data from the Internet Importing From An External Data Source — Creating A Web Query — Saving A Web Query — Refreshing A Web Query
• Creating and Using Shared Workbooks Sharing A Workbook — Requesting Reviews — Reviewing A Workbook — Tracking Changes — Merging And Revising A Shared Workbook
• Visual Basic and Macros Adding Code To Your Macro — Adding Comments To VBA Code — Declaring Variables — Prompting For User Input — Iteration Over A Range — Using If Then Else Statements
• Advanced File Management Identifying File Properties — Searching For Files — Protecting Personal Information — Creating Back Up Files — Changing Auto-Recovery Settings
• Excel Security Digital Signatures — Macro Security — Protecting Your Workbook With A Password
• Custom and Advanced Features in Excel Customizing Excel By Changing Options — Using Custom AutoFill Lists — What Is Text To Speech? — Using Detect And Repair