United States Microsoft Excel 2010 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Excel 2010 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Excel 2010 freely available. Click on any of the linked lesson listings below to preview FREE!
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.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Welcome to Excel
|
||
| Introduction | (02:33) | |
| Course Objectives | (03:52) | |
|
Menus / Shortcuts / Commands
|
||
| Touring the Excel Screen | (04:23) | |
| Understanding the Backbone of File Management | (04:10) | |
| Compatibility with Earlier Versions | (03:03) | |
|
Getting Started
|
||
| Starting Excel | (02:42) | |
| Multiple Methods for Tasks | (03:50) | |
| Moving Around | (05:29) | |
|
Customizing Your Screen
|
||
| Customizing the Ribbon | (05:39) | |
| Quick Access Bar | (04:16) | |
| Quick View of Shortcuts | (02:42) | |
|
Building a Framework
|
||
| Creating a New Spreadsheet | (05:03) | |
| Table Features | (04:23) | |
| Saving / Sending / Publishing | (03:33) | |
|
Editing Techniques
|
||
| Home Ribbon pt. 1 | (05:09) | |
| Home Ribbon pt. 2 | (04:08) | |
| Adjusting Columns and Rows | (04:19) | |
| AutoCorrect and Spell Check | (04:07) | |
|
Manipulating Data
|
||
| Finding and Replacing Data | (03:46) | |
| Using AutoFill | (03:29) | |
| Customizing AutoFill | (03:29) | |
|
Adding Special Effects
|
||
| SmartArt pt. 1 | (04:15) | |
| SmartArt pt. 2 | (03:54) | |
| Shapes and Pictures | (04:47) | |
|
Using Different View
|
||
| Using Excel Options | (04:48) | |
| Options Continued | (03:39) | |
| The View Menu | (05:16) | |
| Splitting the Screen | (04:48) | |
| Arranging Multiple Workbooks | (04:07) | |
|
Visualizing Worksheets
|
||
| Conditional Formatting | (03:36) | |
| Setting Rules for Conditions | (02:54) | |
| Rules Continued | (04:14) | |
| Alignment and Text Customization | (03:05) | |
| More Customization | (02:32) | |
|
Protecting Your Work
|
||
| Hiding Cells and Worksheets | (02:40) | |
| Selecting Visible Cells | (02:50) | |
| Protection | (04:33) | |
| Validation | (03:11) | |
| Validation Messages | (02:42) | |
| Validating Dates | (02:38) | |
| The Trust Center | (03:15) | |
|
Linking with Paste Special
|
||
| Using Paste Special | (03:01) | |
| Linking Data between Worksheets | (03:15) | |
| Linking with Multiple Workbooks | (05:04) | |
| Linking to Other Applications | (03:56) | |
| Linking with a Formula | (02:33) | |
|
Printing
|
||
| The Page Layout Menu | (04:39) | |
| Headers and Footer | (04:46) | |
| Print Headings on All Pages | (05:18) | |
| Wrapping Up the Page Layout Menu | (03:00) | |
|
Templates
|
||
| Using Templates | (03:06) | |
| Creating a Custom Template | (04:20) | |
| Working with Comments | (03:44) | |
| Creating Hyperlinks | (02:35) | |
|
Cell References
|
||
| Understanding Addressing | (04:51) | |
| Absolute vs. Relative | (03:48) | |
|
Introducing Formulas
|
||
| The Formula Menu | (03:25) | |
| The Basics: Order of Operations | (03:56) | |
| Calculating Totals with AutoSum | (04:09) | |
| Printing vs. Viewing Calculations | (03:19) | |
| Basic Formula Examples | (04:06) | |
| Insert Function | (04:10) | |
|
Advance Formulas and Functions
|
||
| Functions vs. Formulas | (04:18) | |
| Creating Formulas (Countif) | (03:42) | |
| Names | (04:51) | |
| Creating Formulas with Names (Countif) | (05:24) | |
| The IF Statement | (05:10) | |
| Conditional Statement Examples | (04:34) | |
| Formulas Manipulating Text | (03:42) | |
| Formula and Function Errors | (02:38) | |
|
Working with Tables
|
||
| Working with Excel Tables | (02:35) | |
| Understanding Limitations and Compatibility | (03:03) | |
| Calculating Table Data Totals | (04:07) | |
|
Sorting and Filtering
|
||
| Sorting Data | (03:05) | |
| Using the Filter Tool | (05:19) | |
| Applying Advanced Filters | (03:52) | |
| Working with Subtotals | (03:01) | |
| Subtotals Continued | (02:57) | |
|
Charts and Graphics
|
||
| Creating a Chart | (02:36) | |
| The Design and Format Ribbons | (04:47) | |
| The Layout Ribbon | (03:14) | |
| More Editing Techniques | (04:57) | |
| Moving Charts | (03:56) | |
| Combination Charts | (04:17) | |
|
Creating a Specialty Chart
|
||
| Understanding Dialog Box Terminology | (04:35) | |
| Single Point Chart | (03:41) | |
| Detailing the Chart | (04:21) | |
| Recapping Wizards | (03:35) | |
|
Spicing Up Your Spreadsheets
|
||
| The Insert Menu | (04:19) | |
| Working with Graphics | (04:25) | |
| The Need for Color | (05:17) | |
|
Adding Objects
|
||
| Creating and Formatting AutoShapes | (04:24) | |
| Adding Photos and Shapes | (04:13) | |
| Move / Copy / Resize Graphics | (04:54) | |
|
Excel Integration
|
||
| Working with Word | (05:43) | |
| Excel and Other Office Applications pt. 1 | (04:39) | |
| Excel and Other Office Applications pt. 2 | (03:10) | |
| Creating PDF Files | (04:00) | |
|
Working with Pivot Tables
|
||
| What is a Pivot Table? | (04:31) | |
| Formatting Pivots | (05:05) | |
| More Formatting | (04:36) | |
| Calculations | (04:18) | |
| Pivot Charts | (02:32) | |
|
Working with Databases
|
||
| Flat vs. Relational Database | (05:24) | |
| Working with External Data | (05:20) | |
| What is a Query? | (04:15) | |
|
Automation and Macros
|
||
| Automating Routines | (05:13) | |
| Creating a Macro | (04:33) | |
| More Macros | (05:14) | |
| Macros from Buttons | (03:39) | |
| More Buttons | (04:41) | |
|
New Features for Your Work
|
||
| Using Comments | (04:45) | |
| Graphs in Comments | (03:37) | |
| Sparklines | (04:39) | |
| Slicers in Pivots | (03:05) | |
|
Final Tips
|
||
| Using Help | (03:30) | |
| Help and Formulas | (05:18) | |
| Work Files | (03:42) | |
|
Conclusion
|
||
| Wrap Up | (02:58) | |
|
Credits
|
||
| About the Author | (02:05) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Excel 2010 |
| Author: | Lauri Sowa |
| SKU: | 34181 |
| ISBN: | 1-936334-66-6 |
| Release Date: | 2010-12-10 |
| Price: | |
| Duration: | 8 hrs / 120 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
Mark Bremmer does an impressive job teaching Poser 7. It's been a real pleasure listening and observing as a student! Thanks Mark! Thanks VTC!
James Hight