A common business requirement is getting an average of a data set of the past few days to include in a report. Perhaps you want to create a weekly average based on daily data. So how can we get the average from the previous week when the data is shown daily.
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Remove spaces in Excel when trim doesn’t work May 15, 2017
An increasingly regular problem is to remove spaces in Excel when TRIM doesn't work. TRIM is a great function for removing any extra spaces before and after a set of characters and limiting any spaces between words to a single space. But sometimes this still doesn't work.
Where to look for Excel's new data cleaning tool called PowerQuery (or Get and Transform in Excel 2016)
Working in Excel is great because by default it assumes you are working with numbers and as such does its best to display numbers correctly (neatly aligned). However, mostly when moving numbers out of Excel, you may experience that strange occurance of trying to align numbers. You spend hours adding and deleting spaces and yet the numbers never seem to align properly.
Hyperlink Code to create navigation list April 17, 2017
We are big fans of using Hyperlinks when navigating through large spreadsheets. One of the big problems is creating the hyperlinks. It is easy enough to create but very manual. As a result we recommend you look at this link to see some code that creates a reusable macro that you can run on a workbook.
REMOVE current selection from data filter April 13, 2017
When using the Data Filter in the newer versions of Excel, you have the ability to search for items that contain some characters. You can then, in one step choose to add the items to the existing filter using the 'Add Current Selection to filter' tick box. However it is not as obvious how to 'REMOVE current selection from data filter'.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."