We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it’s all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included. To begin learning today, simply click on the movie links.
Understanding the Backbone of File Management
Compatibility with Earlier Versions
Linking Data between Worksheets
Linking with Multiple Workbooks
Wrapping Up the Page Layout Menu
The Basics: Order of Operations
Calculating Totals with AutoSum
Printing vs. Viewing Calculations
Creating Formulas with Names (Countif)
Conditional Statement Examples
Understanding Limitations and Compatibility
Understanding Dialog Box Terminology
Creating and Formatting AutoShapes
Excel and Other Office Applications pt. 1
Excel and Other Office Applications pt. 2
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.