Easy to follow Microsoft Excel 2007 Tutorials and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft Excel 2007 tutorials we also list over 400 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft Excel 2007 Tutorial Try for FREE

Select a tutorial category

Discounted Training Courses

Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!

Benefits

01. Unlimited viewing.
02. Downloadable working files.
03. Expert instructors.
04. Use at home / work or both.
05. Works on PC or Mac.
06. Telephone Tech support.
07. Cancel at any time.
08. 300+ courses for 1 low fee.
09. New titles added regularly.
10. 100% Guaranteed

Should you need any help, just call - contact details at the bottom of the page.

Click here to Join

Unlimited Professional Training on over 400+ applications and programming languages for only $30.

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2007 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Can also be Viewed using Flash

Topics covered on this course include:

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 pt. 1
Printing a Worksheet pt. 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
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

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

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
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

Microsoft Excel 2007 Course Details

Microsoft Excel 2007 Training Course
Author:	Cheryl Duncan Other Training by author
Duration:	8 Hours
No. of movies	104

Benefits:
Join the VTC Online University and you will have UNLIMITED access to this tutorial and all the others in the entire library for just US $30 a month. That's over 4000 hours worth of high quality training for one low price of less than $1 a day. Click here to Join

Free Certification - Prove your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Own this Training Course on CD

If you would like to own this Excel 2007 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Excel 2007 tutorial on CD.

Customers Comments

'... This CD is the best investments I've ever made. I attended a computer school to get started with the Mac, and after paying $1,100 for hands-on training, I found it impossible to remember everything we'd covered. Your CD included more information, in an easier-to-understand presentation, than the many weeks of school I attended. It also gives me an instant reference for all the things I am trying to learn ... It's like having a private tutor built right into my computer.'
James T. Axworthy
Woodridge Press Inc., Anaheim, CA ;

Easy to Use QuickTime Format

QuickTime 395 In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.