VTC Legacy
Home / Business Applications

Microsoft Excel 2013

by Helen Bradley
116 lessons19 chapters7.1 hReleased 20136 free
Start the free chapter

This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp. To begin learning today, simply click on the movie links.

Course content

Excel Basics6 lessons
Getting Started6 lessons
Entering Data8 lessons
Rearranging a Worksheet5 lessons
Basic Formulas & Functions12 lessons
Formatting a Worksheet10 lessons
Creating Charts8 lessons
Adding Art4 lessons
More Complex Functions6 lessons
Working with Tables6 lessons
Working with PivotTables5 lessons
Working with Large Worksheets6 lessons
Advanced Tools & Techniques12 lessons
Printing a Worksheet6 lessons
Spreadsheet Design6 lessons
Automating with Macros4 lessons
Working with Skydrive4 lessons
Conclusion1 lessons
Credits1 lessons