Excel 2010: Intermediate

This intermediate-level training course builds on your knowledge of the basic functionality of Excel 2010 by teaching you how to customize your spreadsheets and perform complex analyses. To begin, you’ll practice activating and moving between worksheets, and you’ll review the different viewing options available in Excel. You’ll create range names and learn how to use those in formulas. In working with charts, you’ll learn how to change the layout and make practical modifications. You’ll also learn how to create, edit, and modify Sparklines to visually represent your data on a smaller scale. The course also shows you how to work with graphics, apply conditional formatting to save you time, and utilize many of the most commonly-used and helpful functions available in Excel 2010.
This course is 2 hours and 31 minutes in length and is part of our series on Microsoft Excel 2010. It includes engaging and accessible narration along with step-by-step visual instruction to improve your efficiency in Excel.