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 Excel articles
Excel: The Key To Cutting Waste From Your Company
Tue 14th February 2012
Yet you might be surprised at just how common it is for companies to do just that. Not deliberately, mind you, but it happens nonetheless, it happens in the depths of an organisation's essential data - those key numbers - where it's all too easy to overlook or to not understand. There'll often be a cost increase here, an income drop there, perhaps so small that it seems a drop in the ocean if it's noticed at all; however, just as the smallest snowball slipping from the top of the mountain can easily become an avalanche if its left unchecked, so the tiny, unnoticed or ignored problem amongst the mass of figures can lead on to serious financial trouble if not addressed from the beginning.
But there are nonetheless two sides to every story. It's not always easy to find one number that causes concern in a mass of figures that are going perfectly well, not always easy to diagnose a minor complaint when so much seems to be working fine. And if someone is going to be taking time from their work schedule to monitor such matters, would that not mean that there's something else they're not doing instead? After all, time is a valuable and finite resource, just like money; the balance between the two needs is often a difficult one to find.
Unless, that is, the wonders of modern technology could offer an automatic solution. And voila! Here's conditional formatting in Excel, the answer to that question. How it answers is by monitoring every bit of information that's put into it, and highlighting changes; the user's role is simply to tell Excel what will need to be identified.
Let's say that an organisation has sales figures from many different departments to consider: with conditional formatting, Excel can flag up any number which drops by a certain percentage (perhaps with a spectrum of colours signifying the size of the decrease), so a quick glance through the data will be all that's needed to pick up on a problem. Alternatively, you could insert Sparklines into the data - these are small, simple line charts that fit into individual cells on the spreadsheet, showing you at a glance how an aspect of your data is progressing (or not).
Having critical trends immediately visible on your spreadsheet can transform your business's results, by giving you the power to act upon developments as soon as they happen, killing problems at the root or encouraging positive movement to flourish.
It's certainly worth ensuring that all relevant sections of your staff can make use of conditional formatting - to this end, conducting a training needs analysis will help identify who needs assistance, and what kind of assistance, to get the most of the software - because it's only when everyone is able to see these key developments that you can be truly confident of always having that power to act. No-one likes wasting money; with Excel, there's no reason for it to slip through your grasp in future.
Author is a freelance copywriter. For more information on microsoft excel course, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-2044-excel-key-cutting-waste-from-your-company.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsGovia Thameslink Railway
Production Leader Mark Almeida Introduction to Management Neve's delivery of the course was very accurate and conscientious. She made an effort to involve everyone in the group practically and it was a pleasure to be part of her course. Recruitment Consort Limited
Delivery Consultant Effective Communication Skills I feel everything was spot on. The course was exciting and I really enjoyed all the activities. I have learnt a lot from today which I will take to my work setting and work on in the future. Our trainer was very good, she had a natural warm manner and went the extra mile to listen and engage in conversation with everyone which is very refreshing! Focusrite
ECommerce Trading Manager, Americas Richard Bloomer Power BI Reporting None - great course and very interactive. Learnt more than I was expecting! |
PUBLICATION GUIDELINES