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 File Tasks  Using My Computer within Excel   Using the My Places Toolbar    Navigating with My Computer  Performing Basic Tasks with My Computer       Changing Views            Step-By-Step   Skill Sharpener Saving your Files   File Formats     File Properties  AutoRecover    Upgrading a Workbook            Step-By-Step  Skill Sharpener Using Templates     Opening a Template      Downloading a Template          Using a Template         Creating a Template      Step-By-Step   Skill Sharpener Case Study   Review Questions       Working with Functions and Formulas           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           Step-By-Step   Skill Sharpener Exploring Excel Functions   What are Functions?     Finding the Right Function         Some Useful and Simple Functions        Step-By-Step   Skill Sharpener Using Functions in Excel     Inserting Functions       Using Functions and AutoFill to Perform Difficult Calculations    Using the IF Function    Working with Nested Functions           Step-By-Step   Skill Sharpener Working with Names and Ranges   What Are Range Names?         Defining and Using Range Names          Selecting Nonadjacent Ranges  Using AutoCalculate     Step-By-Step   Skill Sharpener Working with Array Formulas        What are Array Formulas?        Using Basic Array Formulas      Using Functions with Array Formulas    Using the IF function in Array Formulas Step-By-Step   Skill Sharpener Case Study   Review Questions       Managing Tables        Working with Tables          What is a Table?           Creating Tables            Modifying Tables          What is the Total Row?            Step-By-Step   Skill Sharpener 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        Step-By-Step   Skill Sharpener Working with Tables and Filters     Sorting Data in a Table What is an AutoFilter?  Custom AutoFilters       Using an Advanced Filter          Copying Filtered Records         Step-By-Step   Skill Sharpener Using Excel as a Database  Filtering with Wildcard Characters        Validating Your Data    What are Database Functions?  Step-By-Step   Skill Sharpener Case Study   Review Questions      Enhancing your Workbook     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            Step-By-Step   Skill Sharpener Working with Text Boxes   Adding a Text Box       Selecting a Text Box     Manipulating a Text Box           Formatting a Text Box  Step-By-Step  Skill Sharpener WordArt    Adding WordArt to your Spreadsheet   Changing the Font Color           Changing the Outline Color       Adding Effects  Step-By-Step   Skill Sharpener ClipArt      Finding ClipArt Inserting ClipArt           Manipulating ClipArt     Inserting a Photographic Image Step-By-Step   Skill Sharpener Using Objects        Creating New Embedded Objects        Embedding Existing Files           Editing Embedded Objects     Embedding Parts of Files         Step-By-Step   Skill Sharpener Case Study   Review Questions       Finalizing Your Workbook      Protecting your Workbook Protecting your Workbook       Protecting your Worksheets      Unlocking Cells           Protecting your Excel Files        Step-By-Step   Skill Sharpener Finishing Your Workbook  Using the Document Inspector  Using the Compatibility Checker           Marking a Workbook as Final  Step-By-Step   Skill Sharpener 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     Step-By-Step   Skill Sharpener 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      Step-By-Step   Skill Sharpener 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     Step-By-Step   Skill Sharpener Case Study   Review Questions     Index