Our blog

Business competitiveness is increasingly about versatility, efficiency and innovation. Every business process should be subject to regular review to ensure that operators are being as efficient as they can. How to Get More From Excel Excel spreadsheet users, from administrators to Board members should be able to get more from their data sets in Excel […]

Microsoft Excel is hugely under-utilised by organisations who are unaware of its potential capability. Formulas, macros and pivot tables may seem unfathomable to some, but for others, they speed up labour-intensive data handling tasks. Nevertheless, the above important functions, still only scratch the surface of how you can harness the power of your organisational data […]

There are many basic features of Excel spreadsheets that staff can learn from checking out instructional videos online. However, there are limits to time available for your teams to search online finding how to work smarter and enhance efficiency. No two companies are the same and generic ‘how to’ guides only go so far when […]

There are a number of steps you can take to help ensure accuracy and help prevent errors in a spreadsheet: Design the spreadsheet to allow for growth and with a clear view of the purpose. Always protect cells where possible Turn off auto complete or the automatic conversion of data if relevant. Use drop downs […]

Slicers act as visual filters, allowing you to filter and visualise your data as either in a table or as a chart. You can easily create Slicers in Excel. First enter your data into Excel and put it into a table with headers. 2. Highlight your data in the table, click the design tab and then […]

Round a Number in Excel In the example below there are 7 employees A to G and their monthly sales total. This is how you would round these numbers up to the nearest £1. Using the formula =ROUND(C3/1,0)*1 you can easily round the monthly sales total to the nearest £1. In excel you can use […]