Maximize your investment in Microsoft Excel 2010 by mastering advanced 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 data 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 less experienced users. Become adept at consolidating and importing external data, and 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 custom controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything Excel has to offer!
Microsoft Office Excel 2010, Microsoft Office Home and Student 2010, Microsoft Office Home and Business 2010, Microsoft Office Professional 2010 are all acceptable (software must be installed and fully operational before the course begins); Microsoft Windows 8, Microsoft Windows 7, Vista, or XP. Note: This course is not suitable for Macintosh users. Completion of the online Intermediate Microsoft Excel 2010 course or a similar course is recommended.
Note: "Starter Version" and "Web App" versions of Microsoft Excel 2010 will not work with the full version of Excel taught in this course.
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.