Excel: Macros for Budgeting and Corporate Accounting
Date: Fri, Jul 26, 2013
Time: 02:00 P.M. ET
Duration: 1 hour 10 minutes
Function: CFO, Controller, Financial analyst, Business owner, Business unit manager, Other finance professionals using Excel on a regular basis
If you think creating and using those "time-saving" Excel macros actually eat up more time than they're worth, give us a chance to change your mind. Take the pain out of creating and using macros so you can get back to preparing and analyzing budgets and statements of accounts.
Macros, those tiny programs that store repetitive keystrokes, only live up to their promise of shaving hours off of budget and account preparation work if they are created and recorded effectively.
Join Bill "MrExcel" Jelen as he guides intermediate and advanced Excel users through the steps to create and build simple, yet valuable, macros you'll use every day.
From this Webcast, you will learn:
- Two settings to allow the macro recorder to work;
- How to deal with data sets that each contain a different number of records each month;
- How to incorporate repetition, such as repeating a report for every cost center or account;
- How to move your IF functions to a macro; and
- How to create secret macros that run in response to any event, such as entering data in cell A2.
We will also present examples of real-world scenarios where you would use macros, such as the following: On a daily basis, you track accounts receivables by vendor, as well as totals, so you can update your company's working capital metrics. To help the team get a quick handle on the age of receivables, you color code totals that exceed certain thresholds. Using a macro to capture the daily and weekly Excel calculations and formatting will cut down on repetitive keystrokes and mouse clicks to help you breeze through the process.
This Webcast does not currently offer the opportunity to earn continuing professional education (CPE) credit. We invite you to stay tuned to CFO.com for future Webcasts that will offer attendees opportunities to earn CPE credit.
For inquiries or complaints concerning this Webcast, please call (888) 250-5719.
About the Presenter
Bill Jelen, MrExcelBill Jelen, the world's foremost spreadsheet wizard, is known internationally as "MrExcel." His Web site, MrExcel.com, is the premier source for Excel tips and solutions.
About CFO Learning
- CFO Learning provides targeted training and education for corporate finance
executives and their teams to help these professionals stay ahead of today's evolving business
environment. Our training is delivered online, in-person, and in self-study formats and our presenters
are leading experts experienced in providing efficient instruction to professionals.