98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Microsoft Office articles
Finance Teams Embrace Automation With MS Office
Wed 23rd May 2012
Just to let you know, we regularly run financial management for non finance managers courses!
The quarterly board meeting is often dreaded by today's Finance teams. Three months of data has to be produced in a way that is both clear and makes sense to everyone present within the business, and that means lots of reports and presentations. Even worse: these all have to be produced within a short timescale before the meeting, so there's no time to double check everything. The result? An overstressed and overworked financial team, deadlines missed, reports and presentations that aren't proofed and may contain mistakes, and a board meeting descending into chaos. How can this be avoided?
One of the key functions that can be used to good effect in this scenario is using the powers of automation that MS Office has. As your IT department will tell you, this is down to Visual Basic programming (VBA) that can be used in all Microsoft Office applications to automate the process. A good example is that in the past, the finance team have to produce a new chart within a PowerPoint spreadsheet every time there's a new bit of financial data.
Let's say that a zero was missed off the profit balance (ouch!). If this is spotted and corrected, the finance team still have to re-enter the data, produce a new chart, delete the old one, and copy the new one over to the presentation slide. Time consuming and stressful, all for the sake of one keystroke.
With VBA, your IT department can program Excel to "talk" to PowerPoint, so that the software knows something has changed, and does the corrections itself within the presentation. In other words, completely automating the process. Now doesn't that sound easier?
Another example to show this would be if the PAs within the business were using a mail merge to send invites to the quarterly meeting. Let's say the company "contacts sheet" is in Excel or Outlook, and they copy across the email or postal addresses to Word. If there's a typo or someone's email address has changed, they would have to go through both the spreadsheet or contact card, change it, then go back to Word and correct it. Not so with VBA automation - Word would 'pick up' on the correction and update the invite. Much easier.
The upshot of using the simple power of automation is that there is less stress, less duplication by your financial (and other teams), and best of all, people want to attend that quarterly meeting because they know it's fast, up-to-the-minute data that is mistake free. Result!
Author is a freelance copywriter. For more information on vba courses london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-2075-finance-teams-embrace-automation-with-ms-office.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsCLSH Management
Executive PA Carina Lundin Excel Intermediate All good! Low Carbon Vehicle Partnership
Project Manager Dan Hayes Excel Intermediate Very good overall, higly recommend the course to anyone who uses excel as there is always something you can learn to improve your performance. Suggestion: Create a scenario from start to finish of the day to tell a story of a business e.g. you are all working for a green grocers with a mean boss and he wants all of this information by the 5pm. Use the course material to get all this info to the boss etc etc. May make the each item on the course that little bit more relatable/transferable to delegates work practices. Inspirational Development Group
Financial Controller Jainisha Patel Excel Intermediate Great training course |
PUBLICATION GUIDELINES