by admin | Nov 24, 2014 | Random
Well, have to say I’ve been off the grid (at least for this blog post) for the past while but my intention is certainly to begin blogging again – bringing you lots of tutorials and interesting tricks and tips from the world of Excel. Recently I have been...
by admin | Sep 10, 2014 | Random
So if you have read my first post in this series on Powerpivot, and you are thinking about exploring it a bit more here are some resources to check out. Installing Powerpivot There are two versions one for 32 bit machines and the other for 64 bit machines. You can...
by admin | Sep 3, 2014 | Excel Path - Step by Step
Powerpivot is a new free add-in that first appeared in Excel 2010. As a trainer I’m incredibly excited about the possibilities this offers Excel users to streamline their work and to do a lot more with their data. Imagine just updating your data connection and...
by admin | Jul 1, 2014 | Random
Well, as you know,I’m a fan of pivot tables. And now I’ve come across the most comprehensive, thorough pivot table package I have seen in a long time. It’s developed by a guy called John Michaloudis from a website called MyExcelOnline.com. I...
by admin | Nov 18, 2013 | Case Studies - How To
In the first of these blog posts I showed you how to set up your data entry sheet to make it pivot table friendly. Now in this blog post we are going to use pivot tables to show the following… Analysis of each property’s performance (using total income)...