Having spikes in your data can sometimes make it difficult to carry out predictive analysis. These spikes can be due to seasonal fluctuations in sales, for example more sales of soft drinks and ice...
Recent Posts
So, I am used to talking about weather temperatures in Celsius, some of my friends would do this as well but depending where they are in the world they would talk about Fahrenheit. I talk about a...
Have you ever needed to type a large number of words into Excel, to facilitate the explanation of a set of values contained within the workbook, or you may just want to have a whole presentation...
Most of my workbooks if they do contain Pivot Tables, will contain more than one. To have to manually refresh all of them would take too long especially if you have a number of them on a...
Hi There 'Excellers'.... I have has real issues with my Blog in the past two weeks and as such have been unable to update it until until I was able to resolve a plugin update...
I want to share with you a tip that I use most days if my rows of data are more than a few hundred lines (which is most days!!). It's the Go To feature where you can specify an exact cell location...