More Excel 2007 videos at www.LearnMicrosoftExcel.com. You can also download and print the free Excel 2007 tutorial and sample files from the site. The course can be used for both self instruction for Excel beginners and those moving to Excel from an earlier version. The course is structured into session and lessons make it ideal for teachers who wish to run Excel 2007 courses. This lesson will teach you how to save an Excel 2007 file in Open XML (OpenXML is the new Excel file format), PDF, Excel 97-2003 and other formats. Weve used years of experience from our classroom courses to perfect our teaching method which will enable you to learn Excel 2007 in a fraction of the time needed when learning from conventional text books.

How to create a basic inventory system using Form and Formula

Labels can be created in Microsoft Word using data from Microsoft Excel by saving the data in Excel and doing a data merge. Open a data source and merge the information with help from an employee of an IT company in this free video on creating labels from Excel in Microsoft Word. Expert: Stefanie Northrop Contact: www.cmitsolutions.com/pinellas/ Bio: Stefanie Northrop has over 14 years of knowledge and experience in the telecommunications/IT field. Filmmaker: Christopher Rokosz

In Excel, see how to add a Forms Scroll Bar Linked To a Cell.

See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See many tricks in this video: 1.Data Validation List 2.Hiding Text with formatting 3.Named Ranges 4.Keyboard shortcut for Naming Create Name From Selection 5.Keyboard shortcut for Pasting a Name 6.Insert A Comment 7.Format a Comment (click outer edge) 8.Insert Picture in Comment 9.VLOOKUP 10.VBA to lookup a picture 11.Keyboard shortcut for VBA editor 12.Defined Name Formula 13.INDIRECT function to convert text that represents a reference into a reference 14.Put a formula in a picture 15.Paste Special Linked Picture (Camera Tool) 16.Checking Defined Name accuracy with Collapse Button 17.More How do I Lookup a Picture In Excel VLOOKUP Lookup picture in Database using Excel How do I use VLOOKUP to retrieve a picture

Pivot tables: You’ll learn what a Pivot Table is, and how to use one in Excel 2003. One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

To view all Excel 2007 training videos available, visit www.keystonelearning.com . Follow the link above for a course outline containing all of the Excel 2007 training videos available through KeyStone Learning Systems. KeyStone Learning Systems has Enterprise solutions for Companies, Government, and Education. Visit www.keystonelearning.com/youtube for YouTube viewer specials.

Do you collaborate with other Excel users who use the same workbook? For example, are you responsible for just one part of a budget that must be combined into a Master Budget? If so, you want to watch this short Excel Video Lesson to learn the steps to follow to successfully Share Changes that you and your colleagues make to an Excel 2007 workbook. I invite you to visit my website - www.thecompanyrocks.com - to view all of my video lessons. Danny Rocks

This is the third in a series of tutorials designed to help you get to grips with Excel 2010. Download the tutorial file here: www.classroommultimedia.com

How to create a thermometer chart in Excel 2007 in order to track progress towards a goal. Please note the focus isn’t ideal for the first 15 seconds or so.