Covers Excel 2016 and previous versions. Demoed in Excel 2016
Have you ever wished there was a way to compute everything you need with the push of a single button? Or create your own custom function? This Microsoft Excel macros for finance class help make that possible. Using macros and custom functions allows you to quickly work through the tedious setup of your spreadsheets and gets you to what matters faster — the data analysis that drives the bottom line.
Many Excel users don't realize the power of macros or feel they are too complicated to use. In this workshop, we will show all levels of Excel users how to increase their efficiency, cut costs, reduce errors in data analysis, and automate mundane and repetitive tasks.
Don't waste any more time computing formulas and taking time away from analyzing and decision making. Discover the ease of macros and watch as they simplify and make your work life more productive!
What You'll Learn
- What macros are and how you can benefit by using them
- How to create your own custom function
- How to plan your macro before creating it
- Five easy steps to create a macro
- How to edit a macro
- Options for storing the macro
- The Visual Basic Editor — what it is and how it works
- Practical guidelines for writing a macro
- And much more!
Who Will Benefit
Managers, supervisors, financial professionals, financial analysts, accountants, administrative assistants and anyone who uses large amounts of data in their job will benefit from learning how to simplify their processes.