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

 

Advanced Topics         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         Step-By-Step   Skill Sharpener Excel and Windows           Searching for Documents          Using Office Diagnostics           Checking for Updates   Starting Excel Automatically when Windows Boots       Step-By-Step   Skill Sharpener Using the Excel Viewer      What is the Excel Viewer?        Downloading the Excel Viewer Using Excel Viewer     Step-By-Step   Skill Sharpener Review Questions       Getting the Most From Your Data     Getting The Most From Your Data Using Automatic Outlining         Displaying and Collapsing Levels    Grouping Data Manually           Creating Subtotals        Step-By-Step   Skill Sharpener PivotTables        What is a PivotTable?   Creating a PivotTable   Creating a PivotTable Frame     Specifying PivotTable Data       Rearranging PivotTable Data     Step-By-Step   Skill Sharpener More About PivotTables    Modifying PivotTable Calculations        Formatting a PivotTable            Refreshing a PivotTable            Charting a PivotTable   Creating a PivotTable Based on External Data   Step-By-Step   Skill Sharpener Exploring Scenarios            What is a Scenario?      Creating a Scenario      Creating a Scenario Summary Report  Saving Multiple Scenarios         Step-By-Step   Skill Sharpener What If Analysis     Using a One and Two Input Data Table          Using Goal Seek           Using Solver    Step-By-Step   Skill Sharpener Case Study   Review Questions      Excel and the Internet            Excel and Hyperlinks          What is a Hyperlink?    Inserting Hyperlinks      Modifying Hyperlinks    Using Hyperlinks in Excel          Step-By-Step  Skill Sharpener 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 Step-By-Step   Skill Sharpener Getting Data from the Internet         Importing from an External Data Source            Creating a Web Query  Saving a Web Query    Refreshing a Web Query           Step-By-Step   Skill Sharpener Excel and Office Servers    Publishing to a Document Server          Saving to a Document Management Server       Using Excel with Excel Services            Step-By-Step   Skill Sharpener Case Study    Review Questions      Advanced Excel Tasks         Creating and Using Shared Workbooks      Sharing a Workbook    Opening and Editing a Shared Workbook         Tracking Changes         Resolving Conflicts in a Shared Workbook      Step-By-Step   Skill Sharpener Using Custom AutoFill Lists         What is an AutoFill List?           Creating a Custom AutoFill List            Modifying a Custom AutoFill List          Using a Custom AutoFill List     Step-By-Step   Skill Sharpener Using the VLOOKUP Function      Using VLOOKUP to Find Data            How to Find an Exact Match with VLOOKUP Finding the Closest Match with VLOOKUP     Step-By-Step   Skill Sharpener Linking, Consolidating, and Combining Workbooks           Linking Workbooks  Consolidating Workbooks     Combining Worksheets Step-By-Step   Skill Sharpener Case Study   Review Questions     Index