Microsoft Excel 2010
by Lauri Sowa
Start the free chapterVTC'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.
Course content
Welcome to Excel2 lessons
Menus / Shortcuts / Commands3 lessons
Getting Started3 lessons
Customizing Your Screen3 lessons
Building a Framework3 lessons
Editing Techniques4 lessons
Manipulating Data3 lessons
Adding Special Effects3 lessons
Using Different View5 lessons
Visualizing Worksheets5 lessons
Protecting Your Work7 lessons
Linking with Paste Special5 lessons
Printing4 lessons
Templates4 lessons
Cell References2 lessons
Introducing Formulas6 lessons
Advance Formulas and Functions8 lessons
- Functions vs. Formulas4:181 credit or ad
- Creating Formulas (Countif)3:421 credit or ad
- Names4:511 credit or ad
- Creating Formulas with Names (Countif)5:241 credit or ad
- The IF Statement5:101 credit or ad
- Conditional Statement Examples4:341 credit or ad
- Formulas Manipulating Text3:421 credit or ad
- Formula and Function Errors2:381 credit or ad