Microsoft Excel 2007 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 2007′ 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: Fundamentals level

• Starting Out What is Microsoft Excel 2007? — Opening Microsoft Excel — Interacting with Excel — Closing Excel
• About Workbooks Creating a New Workbook — Opening a Workbook — Saving a Workbook — About Excel File Types — Closing a Workbook
• Exploring your Workbook Using Worksheets — The Active Cell — Selecting Cells — Exploring a Worksheet — The Zoom Feature
• Getting Help in Excel 2007 Using the Help Screen — About Online Help — About Offline Help
• The Quick Access Toolbar The Default Buttons — Adding Buttons — Removing Buttons — Customizing the Toolbar
• The Home Tab Clipboard — Font — Alignment — Number — Style — Cells — Editing
• The Insert Tab Tables — Charts — Illustrations — Shapes — Links — Text
• The Page Layout Tab Themes — Page Setup — Scale to Fit — Sheet Options — Arrange
• The Formulas Tab The Function Library — Defined Names — Formula Auditing — Calculation
• The Data Tab Get External Data — Connections — Sort and Filter — Data Tools — Outline
• The Review Tab Proofing — Comments — Changes
• Working With Excel 2007 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
• 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
• Smart Tags and Options Buttons What Are Smart Tags? — The Error Option Button — The AutoFill Option Button — The Paste Option Button — Setting Smart Tag Options
• Editing Tools Using AutoCorrect — Using Spell Check — Using Find and Replace — Adding Comments
• Modifying Cells and Data Changing the Size of Rows or Columns — Adjusting Cell Alignment — Rotating Text — Creating Custom Number and Date Formats
• Cell Formatting Conditional Formatting — The Format Painter — Cell Merging and AutoFit — Find and Replace Formatting
• Enhancing a Worksheet’s Appearance Adding Patterns and Colors — Adding Borders — Working with Styles
• Working With Charts, Part 1 Creating a Chart — Formatting a Chart — Modifying Charts with the Layout Tab — Manipulating a Chart — Enhancing a Chart with Shapes and Graphics
• Working with Charts, Part 2 Changing the Type of Chart — Changing the Source Data — Working with the Chart Axis and Data Series — Saving a Chart as a Template
• Using the View Tab Using Normal View — Using Full Screen View — Using Page Layout View — Page Break Preview
• Managing a Single Window Creating a New Window — Hiding a Window — Unhiding a Window — Freezing a Pane
• Managing Multiple Windows Switching Between Open Workbooks — Arranging Workbooks — Comparing Workbooks Side by Side — Synchronous Scrolling, Resetting a Window, and Saving a Workspace
• Printing your Workbook Opening Print Preview — Using the Print Preview Tab — Quick Printing — The Print Dialog — Using Page

Course contents: Intermediate level

• Using My Computer within Excel Using the My Places Toolbar — Navigating with My Computer — Performing Basic Tasks with My Computer — Changing Views
• Saving your Files File Formats — File Properties — AutoRecover — Upgrading a Workbook
• Using Templates Opening a Template — Downloading a Template — Using a Template — Creating a Template
• Using Formulas in Excel Understanding Relative and Absolute Cell References — Basic Mathematical Operators — Using Formulas with Multiple Cell References — The Formula Auditing Buttons — 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 — Using AutoCalculate
• 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 Tables What is a Table? — Creating Tables — Modifying Tables — 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 — Quickly Adding Records to a Data table — Deleting Records or Fields
• Working with Tables and Filters Sorting Data in a Table — What is an AutoFilter? — Custom AutoFilters — Using an Advanced Filter — Copying Filtered Records
• Using Excel as a Database Filtering with Wildcard Characters — Validating Your Data — What are Database Functions?
• Customizing your Workbook Inserting a Symbol or Special Character — Adding and Editing Shapes — Creating and Altering Diagrams — Changing the Diagram Type — Incorporating Text — Adding a Signature Line
• Working with Text Boxes Adding a Text Box — Selecting a Text Box — Manipulating a Text Box — Formatting a Text Box
• WordArt Adding WordArt to your Spreadsheet — Changing the Font Color — Changing the Outline Color — Adding Effects
• ClipArt Finding ClipArt — Inserting ClipArt — Manipulating ClipArt — Inserting a Photographic Image
• Using Objects Creating New Embedded Objects — Embedding Existing Files — Editing Embedded Objects — Embedding Parts of Files
• Protecting your Workbook Protecting your Workbook — Protecting your Worksheets — Unlocking Cells — Protecting your Excel Files
• Finishing Your Workbook Using the Document Inspector — Using the Compatibility Checker — Marking a Workbook as Final
• Using Excel in Word Inserting Excel Data in Word — Linking Excel Data in a Word Document — Modifying Excel Data after Insertion — Insert an Excel Chart into a Word Document
• Using Excel and Access Linking an Excel Workbook to an Access Database — Importing Table, PivotTable, and PivotChart Data from Access — Transforming an Excel Workbook into an Access Database
• Using Excel With 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 External Data Sources — Publishing a Workbook as a PDF File — Faxing a Workbook

Course contents: Advanced level

• Setting Excel Options Changing Your User Name — Changing your Default Font — Changing Your Default File Format — Setting Formula Options — Changing the Appearance of Your Excel Interface
• Excel and Windows Searching for Documents — Using Office Diagnostics — Checking for Updates — Starting Excel Automatically when Windows Boots
• Using the Excel Viewer What is the Excel Viewer? — Downloading the Excel Viewer — Using Excel Viewer
• Getting the Most from Your Data Using Automatic Outlining — Displaying and Collapsing Levels — Grouping Data Manually — Creating Subtotals
• PivotTables What is a PivotTable? — Creating a PivotTable — Creating a PivotTable Frame — Specifying PivotTable Data — Rearranging PivotTable Data
• More About PivotTables Modifying PivotTable Calculations — Formatting a PivotTable — Refreshing a PivotTable — Charting a PivotTable — Creating a PivotTable Based on External Data
• 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 What is a Hyperlink? — Inserting Hyperlinks — Modifying Hyperlinks — Using Hyperlinks in Excel
• Saving Workbooks as Web Pages HTM and MHTML Files — 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
• Excel and Office Servers Publishing to a Document Server — Saving to a Document Management Server — Using Excel with Excel Services
• Creating and Using Shared Workbooks Sharing a Workbook — Opening and Editing a Shared Workbook — Tracking Changes — Resolving Conflicts in a Shared Workbook
• Using Custom AutoFill Lists What is an AutoFill List? — Creating a Custom AutoFill List — Modifying a Custom AutoFill List — Using a Custom AutoFill List
• Using the VLOOKUP Function Using VLOOKUP to Find Data — How to Find an Exact Match with VLOOKUP — Finding the Closest Match with VLOOKUP
• Linking, Consolidating, and Combining Workbooks Linking Workbooks — Consolidating Workbooks — Combining Worksheets

Course contents: Expert level

• Add-ins and the Trust Center What is a COM Add-in? — Add-In Management — Installing Add-ins — Using the Trust Center — Add-Ins
• Information Rights Management What is IRM? — Requirements for IRM — Downloading and Installing the Rights Management Client Software — Using IRM — Opening an IRM Protected Document
• Digital Signatures What is a Digital Signature? — Obtaining a Digital Signature — Attaching your Signature to a Workbook
• Smart Tags and XML What is a Smart Tag? — Inserting Smart Tags into a Worksheet — Setting Smart Tag Options — Creating Custom Smart Tags
• Macros Recording Macros — Playing a Macro — Macro Security
• More Macro Tasks Recording a Relative Reference Macro — Running a Relative Reference Macro — Assigning a Keystroke to a Macro — Copying a Macro from a Workbook or Template
• Visual Basic and Macros Opening the Visual Basic Editor — 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
• Form Controls What is a Form Control? — Adding a Control to a Worksheet — Assigning a Macro to a Control — Using Form Controls
• Advanced Functions Using Financial Functions (PMT and FV) — Understanding Logical Functions — Applying Logical Functions
• Using SharePoint Creating a Document Workspace — Accessing a Workspace — Publishing to a Document Workspace
• User Forms and ActiveX Controls Creating a Blank User Form — Adding Controls to the Form — Adding Buttons and VBA Code — Starting the User Form with a Macro