Any proficient Microsoft Excel user will agree that Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use every Excel tool at your disposal? In this course, you'll learn how to maximize Excel's analytical and functional 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 of a value to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead to better decision-making.
In this practical and information-packed course, you'll learn 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. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced pivot table techniques, like creating calculated fields and calculated items. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. And you'll become proficient at nesting functions within other functions to accomplish just about anything Microsoft Excel has to offer.
This course includes a knowledgeable and caring instructor who will guide you through
your lessons, facilitate discussions, and answer your questions. The instructor
for this course will be
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.