clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif
   Master Microsoft Excel 2007 - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
In this Microsoft Excel 2007 video tutorial, VTC author Cheryl Duncan provides easy to learn training on the new Microsoft version of Excel. Using the VTC method of computer based training using video and audio together, this training course will quickly bring any user up to speed with this most popular spreadsheet program from Microsoft. Starting with basic topics such as accessing the Help system, creating a new workbook, selecting cells and more, this tutorial builds on the basics and moves towards more advanced topics such as writing formula's, linking data, and creating charts and graphs. Complete with work files to help you follow along in the training, this is an invaluable resource for any Excel 2007 user, beginner and advanced alike.
Microsoft Excel 2007 Training
Access the complete Microsoft Excel 2007 Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Excel 2007 plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Excel 2007 from our PC and Mac compatible CDRom. The affordable price of $99.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Excel 2007
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Excel 2007
Description: Click here to open / close full description
In this Microsoft Excel 2007 video tutorial, VTC author Cheryl Duncan provides easy to learn training on the new Microsoft version of Excel. Using the VTC method of computer based training using video and audio together, this training course will quickly bring any user up to speed with this most popular spreadsheet program from Microsoft. Starting with basic topics such as accessing the Help system, creating a new workbook, selecting cells and more, this tutorial builds on the basics and moves towards more advanced topics such as writing formula's, linking data, and creating charts and graphs. Complete with work files to help you follow along in the training, this is an invaluable resource for any Excel 2007 user, beginner and advanced alike.

-Close-
Instructor: Cheryl Brumbaugh Duncan (more by this author)
Instruction: 104 Tutorials - Duration: 8 hrs
First Release: 2007-11-12
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $99.95
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Excel 2007
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Excel 2007
 
Below is content list for all of the lessons included with the Microsoft Excel 2007 Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction to Excel 2007
movie image Welcome to Excel 2007
movie image Overview of Spreadsheets and Excel 2007
movie image Overview of Course
movie image New in Excel 2007 pt. 1
movie image New in Excel 2007 pt. 2
movie image Understanding the Excel 2007 Workspace
movie image Introducing the New Excel 2007 Ribbon
movie image Using the Quick Access Toolbar
movie image Compatibility with Earlier Versions

Installing Excel 2007
movie image Considerations Before You Install
movie image Installing Excel

Microsoft Excel 2007 He|p
movie image Accessing Microsoft Excel 2007 He|p
movie image Using Excel 2007 He|p
movie image Using Microsoft Office On-line
movie image Accessing the Support Knowledge Base


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

Global Sales
1623 Military Road #703
Niagara Falls, NY, USA
14304-1745
1-877-882-2262 or sales@vtcGlobalSales.com
VTC Canada
200 N. Service Rd W., Suite 1-377
Oakville, ON, Canada
L6M 2Y1
905-465-1263 or sales@vtcCanada.com


©2008 VTC Global Sales / VTC Canada All Rights Reserved.