ADVANCED MICROSOFT EXCEL 2007
Short Description:
Maximize your investment in Microsoft Excel 2007 by mastering advanced Excel features that most users don't even know exist. In this practical, hands-on course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced techniques for PivotTables, like creating calculated fields and calculated items, as well as how to restore the "Classic PivotTable Style" drag-and-drop functionality. You'll see how to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything MS Excel has to offer!
Long Description:
Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you'll see how to maximize Excel's functions and capabilities.
Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making.
Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
REQUIREMENTS:
Requirements:
Microsoft Office Excel 2007 (B000HCVR1M), Microsoft Office Excel Home and Student 2007(B000HCVR26), Microsoft Office Home and Student 2007 (B000HCZ8EO), Microsoft Office Standard 2007 (B000HCVR3A), Microsoft Office Professional 2007 (B000HCVR30), Microsoft Office Ultimate 2007 (B000HCTY26) are all acceptable (software must be installed and fully operational before the course begins); Microsoft Windows XP or Windows Vista; Internet access, e-mail, the Microsoft Internet Explorer or Mozilla Firefox Web browser, and the Adobe Flash and PDF plug-ins (two free and simple downloads you obtain at http://www.adobe.com/downloads by clicking Get Adobe Flash Player and Get Adobe Reader). Note: This course is not suitable for Macintosh users. Completion of the online Intermediate Microsoft Excel 2007 course or a similar course is recommended.
INSTRUCTOR: Chad Wambolt
|
