Microsoft Excel 2007 Tutorial - Training Videos

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 2007

Affordable Training you can depend on
This Microsoft Excel 2007 video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 8 hours long these Microsoft Excel 2007 tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft Excel 2007 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Microsoft Excel tutorial serves as both a definitive guide and learning aid for newcomers to Excel and a guide to discovering the new features / tools that have been included in this release. Offer comprehensive visual insights this training CD skips boring and complex explanations and presents the training in an easy to follow step-by-step format which is both easy to follow and simple to use, learn at your own pace right from your own desktop.

Topics covered on this Microsoft Excel tutorial include:
Installing Excel, Importing Data, Selecting Cells, Formatting, Copy and Paste, Printing, Adding Styles, Borders, Fills and Colours, Functions, Formulas, Errors, Filtering, Validating, Exporting Data, Creating Charts, Importing Graphics, Creating XML Files.

Microsoft Excel 2007 Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Introduction to Excel 2007

Installing Excel 2007

Microsoft Excel 2007 He|p

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

Microsoft Excel 2007 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Excel 2007
Instructor	:	Cheryl Brumbaugh Duncan
Price	:	US$ 99.95
Duration	:	8 hours - 104 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33810

BENEFITS OF THIS TRAINING COURSE

Master Microsoft Excel 2007 in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.