Excel 2010: Advanced

This course teaches you to utilize the advanced-level tools and functions of Excel 2010, allowing you to customize your worksheets, create sophisticated charts, and perform complex analyses. To begin, you’ll learn how to use templates, as well as create and modify custom template files. You’ll see how to format date and time entries, and you’ll learn how to format numbers automatically. The course also shows you how to create and modify a variety of charts, and it demonstrates how to sort and filter your data effectively. You’ll learn how to analyze data using scenarios and how to automate repetitive tasks by using macros. You’ll also gain tips on how to collaborate with others while protecting your data.
This 2-hour, 13-minute course is part of our Microsoft Excel 2010 series. It includes clear and helpful narration and step-by-step visual instruction to help you master many of the advanced features of Excel 2010.