98.7% 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:
TestimonialsCABINET OFFICE
PA Helen Smyth Excel Intermediate Thank you, very good course. The Shipowners' Protection Ltd
Finance Assistant Marta Ornacka Growth Hacks for Introverted Professionals I was honestly not expecting this course to be so good and useful. It made me think differently and actually realise that there is nothing wrong with being an introvert, and absolutely nothing wrong with communicating my needs in terms of how I work most efficiently. It has made me realise my next steps in terms of work and career development, and I will be sure to complete them. JourneyHR
Media Operations Daniel Thomas PowerPoint Intermediate Advanced Amazing instructor, Very Knowledgeable. Fingers crossed I can make use of the many features that were taught. Thanks Again. |
PUBLICATION GUIDELINES