Course Title: Advanced Microsoft Excel 2007
Hours required: 24
Price: $99
Length course offered: 6 Weeks
Instructor: Chad Wambolt [Bio]
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. Learn how Excel 2007 table tools take the complexity out of table creation and management.
Goals:
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. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Grading System:
Confirmation of Completion awarded with passing score.
School Description:
No matter where you live, you will be able to take any of our comprehensive, convenient online courses offered in connection with a college or university near you. Click "Enroll Now" to find the partner school for the course you want to take.
Instructor Bio: Chad Wambolt
Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.
