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.