by admin | Oct 17, 2016 | Case Studies - How To
Well, had a bit of a weird experience. I had written a full blog post on how to use Solver to identify what numbers make up a specific number. Let me give you a specific example. Many years ago – when I was working in an office – I’d have a...
by admin | Jul 11, 2016 | Case Studies - How To
In this blog post I’m going to show you how to use one of the new add-ins from Excel (Power Query) to quickly pull in your data from Facebook and then summarize it. Note that if you have found this useful that I cover both pivot tables and Power Query in my book...
by admin | Jun 14, 2016 | Case Studies - How To
A common question in a business is what price do I need to sell something at in order to make a certain margin or if I can only sell something at a certain price – what does my cost price have to be to make a certain margin. As always if you have specific...
by admin | Feb 19, 2016 | Case Studies - How To
Excel Novice 5 min tip – Quickly access frequently used files and folders If you need to quickly access frequently used files and folders, use the File | Recent option to find them. Click on File, click on Recent. You will find a list of recently used files and...
by admin | Nov 27, 2015 | Case Studies - How To
Hope you are well. In this tutorial I want to show you how to clean up a data set with a view to analysing it. During the year I participated in my first 8k race and I found myself curious as to how people did etc. So I asked the organisers for the raw data which...
by admin | Oct 30, 2015 | Case Studies - How To
Well, in this blog post I am going to cover a very common scenario – not having your data the right way around to do something with it i.e. make a pivot table from it. However I am going to show you how to do that with a not (as yet) well known add-in for Excel...
