Excel 2007 Training Materials

Part of the Office 2007 Computer Training Materials Library featuring high quality, fully customizable, print-on-demand training courseware titles for Microsoft Office 2007.

This course provides everything you need to professionally deliver Microsoft Office Excel 2007 training including editable training manual, hands-on exercises, exercise files,  detailed instructor guide,  unlimited online learning licensing and classroom-ready PowerPoint slides.

This course comes with:   Training Manual Exercise Workbook Exercise Files Instructor Guide PowerPoint Slides Lesson Plans

You also receive:   Unlimited reprinting rights Unlimited number of users Unlimited rights to customize all course contents to suit your needs Questions? Would you like more information on this or any of our training courses? Call us toll free 1-800-730-7115.

All Velsoft computer training courseware titles are completely customizable so you can easily edit each course to better suit your needs or the needs of your clients. Likewise, courses can be personalized to any organization in seconds giving you the ability to brand the material as your own. All courses come in Microsoft Word and PowerPoint formats for quick and easy editing. Print the materials as you need them, as many times as you like.

 

Excel 2007 Training Course    order now $ 995 course outline  •  download sample

Office 2007 Training Library    order now $ 2495 complete bundle   •  best value     The complete Office 2007 Computer Training Materials Library includes:   Access 2007   Excel 2007   InfoPath 2007   OneNote 2007   Outlook 2007   PowerPoint 2007   Project 2007   Publisher 2007   SharePoint Designer 2007 (formerly FrontPage 2007)   SharePoint Server 2007   Visio 2007   Word 2007   Business Contact Manager 3

Using our computer training materials is easy and cost effective.
It works like this... each course (whether you purchase the course individually or as part of a library of related titles) comes with printable training manuals, stand alone exercise workbook, exercise files, instructor guide, classroom-ready PowerPoint slides and convenient lesson plans. Each of the components can be opened into Microsoft Word (or Corel WordPerfect) for editing and you are allowed to make any changes you want to the content to better suit your needs.

Why write Excel 2007 training materials when we've done it for you? We've saved you thousands of hours.  We do the prep work... you do the training.

By offering such flexible training solution, you will enjoy how easy it is to customize the training materials to meet your needs. You are allowed to make any changes to the content - including replacing our name with yours. Want to replace our examples and references to those of your own in order to enhance the training and your students' experience? No problem. Prewritten courseware saves you time any money and helps you better prepare for classroom training with well-researched and proven course materials.

Excel 2007 Course Outline

 

Getting Started         Starting Out         What is Microsoft Excel 2007? Opening Microsoft Excel          Interacting with Excel    Closing Excel   Step-By-Step   About Workbooks Creating a New Workbook    Opening a Workbook   Saving a Workbook     About Excel File Types Closing a Workbook    Step-By-Step   Skill Sharpener Exploring your Workbook  Using Worksheets        The Active Cell Selecting Cells  Exploring a Worksheet The Zoom Feature        Step-By-Step   Skill Sharpener Getting Help in Excel 2007 Using the Help Screen  About Online Help       About Offline Help       Step-By-Step   Skill Sharpener Case Study   Review Questions     The New Interface      The Quick Access Toolbar The Default Buttons      Adding Buttons Removing Buttons         Customizing the Toolbar          Step-By-Step  Skill Sharpener The Home Ribbon  Clipboard         Font     Alignment         Number            Style     Cells     Editing  Step-By-Step   Skill Sharpener The Insert Ribbon  Tables  Charts  Illustrations       Shapes Links    Text    Step-By-Step   Skill Sharpener The Page Layout Ribbon    Themes           Page Setup      Scale to Fit       Sheet Options   Arrange            Step-By-Step   Skill Sharpener The Formulas Ribbon         The Function Library    Defined Names Formula Auditing          Calculation       Step-By-Step   Skill Sharpener The Data Ribbon    Get External Data         Connections     Sort and Filter  Data Tools       Outline Step-By-Step   Skill Sharpener The Review Ribbon          Proofing           Comments        Changes           Step-By-Step   Skill Sharpener Case Study   Review Questions       Excel Basics    Working With Excel 2007  Columns, Rows, Cells, and Ranges       Creating Worksheet Labels       Entering and Deleting Data        Printing Your Worksheet          Step-By-Step   Skill Sharpener Basic Excel Features          What is AutoFill?         What is AutoSum?        What is AutoComplete?            Working with Basic Formulas   Step-By-Step   Skill Sharpener 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 Step-By-Step   Skill Sharpener 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        Step-By-Step   Skill Sharpener Editing Tools          Using AutoCorrect       Using Spell Check        Using Find and Replace            Adding Comments        Step-By-Step   Skill Sharpener Case Study   Review Questions       Editing Your Workbook          Modifying Cells and Data   Changing the Size of Rows or Columns Adjusting Cell Alignment           Rotating Text    Creating Custom Number and Date Formats     Step-By-Step   Skill Sharpener Cell Formatting      Conditional Formatting  The Format Painter       Cell Merging and AutoFit          Find and Replace Formatting    Step-By-Step   Skill Sharpener Enhancing a Worksheet’s Appearance        Adding Patterns and Colors      Adding Borders            Working with Styles      Step-By-Step   Skill Sharpener Working With Charts         Creating a Chart           Formatting a Chart        Modifying Charts with the Layout Ribbon          Manipulating a Chart    Enhancing a Chart with Shapes and Graphics    Step-By-Step   Skill Sharpener 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    Step-By-Step   Skill Sharpener Case Study   Review Questions       Printing and Viewing your Workbook            Using the View Ribbon       Using Normal View      Using Full Screen View Using Page Layout View           Page Break Preview     Step-By-Step   Skill Sharpener Managing a Single Window            Creating a New Window          Hiding a Window          Unhiding a Window      Freezing a Pane            Step-By-Step   Skill Sharpener Managing Multiple Windows         Switching Between Open Workbooks  Arranging Workbooks  Comparing Workbooks Side by Side   Synchronous Scrolling, Resetting a Window, and Saving a Workspace  Step-By-Step   Skill Sharpener Printing your Workbook     Opening Print Preview  Using the Print Preview Ribbon Quick Printing   The Print Dialogue        Using Page Setup         Step-By-Step   Skill Sharpener Case Study   Review Questions     Index