Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft Excel 2007 tutorials offer a straightforward uncomplicated insight to using Excel 2007. Created for beginners and experienced users alike this training CD is a comprehensive reference on using Excel in a commercial environment, and making a seamless transition from earlier versions. Using high quality narrated QuickTime videos that cover every aspect in great detail this training CD is a ideal reference and learning aid that will move you towards total proficiency with Microsoft Excel 2007. The tutorial comes complete with working files. Click here for all versions of Microsoft Excel Tutorials

Associated Tutorials: Crystal Reports | Microsoft Project Tutorial | Excel 2003 | QuickBooks 2008 | Microsoft Word 2010 | Microsoft Outlook 2010 Tutorial | MS Powerpoint 2010 | Microsoft Word 2007 Tutorial | Microsoft Access 2010 | Microsoft Project 2010 | Microsoft Office for Mac 2011

Microsoft Excel 2007 Tutorial CD / DVD

When you order this Microsoft Excel 2007 Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft Excel 2007 from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" ...now I watch the training at home and on my laptop on the train going to work. It couldn't be more convenient. Thanks. "Christopher Brazell, Virginia

Microsoft Excel 2007 Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8 Hours in Duration and Covers 104 Lessons.
Introduction to Excel 2007 Installing Excel 2007 Microsoft Excel 2007 He|p
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Working with Worksheets and Workbooks
  • Launching Excel
  • Planning a Project
  • Creating a New Workbook
  • Adding and Deleting Data
  • Importing Data into Excel
  • Naming and Saving a Workbook
  • Managing Multiple Worksheets
  • Printing a Worksheet Tutorials 1
  • Printing a Worksheet Lesson 2
  • Opening and Closing a Workbook
  • Renaming and Deleting a Workbook
Editing Techniques
  • Selecting Cells / Rows / Columns
  • Cut / Copy / Paste
  • Copy and Paste Special
  • Editing or Replacing Content in a Cell
  • Undo / Redo / Repeat Edits
  • Adjusting Row Height
  • Adjusting Column Width
  • Inserting and Deleting Rows / Columns / Cells
  • Merging and Splitting Cells
  • Clearing a Cell
  • Finding and Replacing Data
  • Using AutoFill
Customizing Excel 2007
  • Customizing the Excel Workspace
  • Splitting the Screen
  • Freezing and Locking Cells
  • Hiding and Showing Rows / Columns / Sheets
  • Using Different Views
  • Arranging Multiple Workbooks
  • Displaying Gridlines and Headings
  • Setting a Trusted Location
  • Using Excel Options
Changing the Appearance of a Worksheet
  • Formatting Options in the Ribbon
  • Formatting Text
  • Formatting Numbers
  • Adding Borders
  • Adding Fill Colors and Patterns
  • Using the Format Painter
  • Using Cell Styles
  • Using Document Themes
  • Using Wrap Text
  • AutoCorrect
  • Setting Page Layout Options
  • Adding Headers and Footers
  • Setting Page Breaks
  • Using Templates
  • Using Conditional Formatting
Working with Formulas
  • Using Formulas
  • Formula Writing Made Easy
  • Creating Simple Formulas
  • Order of Operations
  • Creating Formulas with Operators and Cell References
  • Understanding Cell References
  • Calculating Totals with AutoSum
  • Common Functions in Excel
  • Creating Formulas with Functions
  • Creating Formulas with Nested Functions
  • Creating and Managing Names
  • Creating Formulas with Names
  • Displaying and Printing Formulas
  • Error Checking
  • Common Errors When Creating Formulas
Managing Data in Excel
  • Overview of Excel Data Handling Tools
  • Creating an Excel Table
  • Sorting an Excel Table
  • Filtering an Excel Table
  • Formatting Excel Table Data
  • Working with Excel Table Rows and Columns
  • Displaying and Calculating Table Data Totals
  • Using Structured References
  • Validating Data
  • Linking Data Between Worksheets
  • Linking Data Between Multiple Workbooks
  • Exporting Data Tutorials
Charts and Graphics
  • Overview of Charts and Excel
  • Understanding Chart Types
  • Creating a Chart
  • Changing the Chart Type of an Existing Chart
  • Moving and Deleting a Chart
  • Changing the Charted Data
  • Editing Charts Tutorials
  • Formatting a Chart - Design Tab
  • Formatting a Chart - Layout Tab
  • Formatting a Chart - Format Tab
  • Creating a Chart Template
  • Applying a Chart Template
  • Importing Graphics into Excel
  • Modifying Imported Images
Excel 2007 Plays Well with Others
  • Overview of Sharing and Collaborating
  • Excel and Other Office Applications
  • Using the Office Clipboard
  • Creating PDF Files
  • Opening and Saving Files in Other Formats
  • Excel and Databases
  • Using Queries
  • Using with a Document Management Server
  • Publishing an Excel Worksheet
  • Excel XML Files
  • Wrap Up
Credits
  • About This Author and these Tutorials

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Microsoft Excel 2007 Training CD

Title Microsoft Excel 2007
Tutor Cheryl Duncan
Other tutorials by Cheryl Duncan
Videos 104 Lessons- Video run time: 8 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2007
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available to Online Users only
30 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft Excel 2007 from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos | Online Microsoft Excel 2007 Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.