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 Excel articles
How Excel Can Boost Even The Smallest Business
Thu 18th November 2010
Brian is an amateur inventor, in the classic Sunday-afternoon-in-the-shed sense. Having created many interesting but fundamentally useless devices, he's struck upholstery-maintaining gold with a new solution to the problems of pet hairs and soft furnishings. Production levels of his invention are modest, but sales have been quite impressive and Brian has able to turn a profit. Despite having no prior knowledge of accounts, he's been able to keep a tight grip on the money coming in and going out, and he's been able to identify where changes need to be made to optimise profits. However, he hasn't stumbled upon a long-buried talent for managing his figures - he's been using Microsoft Excel 2010.
Of course, Brian starts with entering all the necessary numbers, from which any sums that need to be done are calculated automatically. Beyond merely collating and calculating, however, Excel can help Brian to expand his business with a wide range of tools for analysing his data, to better understand where his company is heading, what aspects are succeeding and which are impeding progress.
A number of different stores are stocking Brian's product, and it's important that he can see which are proving to be more or less successful. Conditional formatting in Excel gives him this information at a glance. Individual entries can be highlighted or marked with symbols (such as stars or traffic lights) in order to show immediately where all is well and where there is a concern, such as falling sales or increasing costs. Similarly, Excel 2010's Sparklines technology can automatically create miniature graphs within the spreadsheet data, allowing Brian to see how sales of his product from any one store have changed over a period of time, without needing to create separate charts.
However, this at-a-glance assessment has inevitable limitations. Sometimes, Brian will need a deeper level and thoroughness of analysis, and Excel certainly won't let him down in this department. An enormous range of charts, graphs and diagrams can be created from whichever aspect of his data Brian chooses, ensuring that he fully understands the nature and progress of the key figures - and he can easily combine charts and data on a dashboard, bringing all the most important details together in a single location. And should he wish to illustrate his creation's potential for a store that's considering carrying the product, he can share (electronically or in print) the dashboard and charts, making sure they include all the information that he could need to convince the potential seller.
Of course, meeting with the managers of these stores means that Brian spends ever more of his time away from his office (which, aptly enough, is also his shed). Fortunately, he can access his Excel spreadsheets from anywhere. The Excel Web App allows him to log on to his data from an ordinary web browser, and view it from any computer, wherever he may be - and with that, he can be confident of always being aware of how his nascent company is doing.
Brian may be an amateur inventor, but with Excel, he can be sure of managing his business as a professional. To this end, it would certainly be worthwhile for him to consider a short training course, to ensure that he can get the most benefit from the program's range of powerful and versatile tools. After all, he's finally come up with something that works - and Excel can help ensure that both he and his invention can fulfil their potential.
Author is a freelance copywriter. For more information on excel training courses, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1258-how-excel-can-boost-even-smallest-business.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsPension Protection Fund
Investment Accountant Trevor Francis Excel PowerPivot Good course and nice size class. Catalyst Housing
Capital Accountant Habib Hanif Excel Dashboards for Business Intelligence The course topics were very good and well structured. I can honestly say I learned so much on this course and am extremely satisfied with Jen's training. The course has given us the knowledge to put in practice in our reports. Fantastic value for money. Environment Agency
Senior Specialist Jemma Hey OneNote Introduction I was really impressed with her knowledge on all things Microsoft and willingness to help our group with wider understanding! |
PUBLICATION GUIDELINES