Kessler Associates Kessler Associates Kessler Associates for Word and PowerPoint document templates, Excel spreadsheets, website creation, and graphic design

Digital design services

Kessler Associates blog: Excel takes the strain

Most businesses use Excel for creating their spreadsheets. It's a highly useful tool for calculating long trains of figures and providing you with detailed totals at the end.

However, there's a lot more to it than that. Given a properly laid-out workbook, small businesses and sole traders can run their entire accounts in Excel, construction firms can run highly detailed project fabric projections, and a vast array of facts and figures can be stored in such a way that makes the data easy to read and ready to be output to a printer.

Add to that some intelligent styling and layout direction, and you'll have an Excel workbook that can really do the job it's supposed to do, instead of losing your figures in something that's been hastily set-up and poorly planned.

Kessler Associates Excel image

Complex formulae can handle figures based on their condition so that, for instance, if Circumstances A are met (a cost raised on a Tuesday), a figure is added to Total X, whereas if Circumstances B are met (a cost raised on a Thursday), a figure is added to Total Y.

VAT figures can be deducted from totals, or added to them, and the VAT rate can easily be amended from one location. Programming functions can be added to your workbook to automate complex functions, insert new rows in a table, sort data, print it, and produce a series of reports based on it.

You could have a dialogue box that allows you to hide selected worksheets in your Excel workbook so that outside contractors only see what you want them to see - and what's more, they can only edit figures that you want them to edit.

Summary sheets can handle your data entries in various ways, giving you a multilayered set of figures to work with for your projections or project calculations. The possibilities are endless, so let us know what you need and we can show you how to do it.

More detailed information is available via PDFs from the Excel spreadsheets page on the web site.

Whatever you need, we have the solution.

Return to the blog index here.

Contact us

Tel: +44 (0) 845 838 5524

Full contact details here.

Follow us

Visit the Kessler Associates Facebook page
Visit the Kessler Associates Google+ page
Follow Kessler Associates on Twitter

Like / Tweet

Contact us now to find out more about our services.
Copyright © 1999-2019 Kessler Associates. All rights reserved. Site map. Blog.