Excel 2007: Intermediate

This training course will build upon your knowledge of the basic functionality of Excel 2007 and show you how to improve your efficiency and productivity using intermediate-level skills and tools. To begin, you’ll gain tips on how to activate and move between worksheets, and you’ll learn how to create range names and use those in formulas. You’ll review how to use cell comments effectively, how to create and modify charts to present your data visually, and how to insert and modify images and graphics. By the end of the course, you’ll also develop a strong understanding of how to use conditional formatting to save you time and how to utilize a range of important and useful functions, such as the COUNT, IF, and VLOOKUP functions.
This 2-hour, 18-minute course is part of the Microsoft Excel 2007 training series. It includes engaging narration and step-by-step visual instruction to help you develop essential Excel skills.