by admin | Jan 11, 2017 | Excel Path - Step by Step
This is my first blog post of 2017. I have to say I do love the energy of a new year. My favourite time of the year are those days between the “two Christmases” i.e. 25th December and 6th January. There is no pressure. Just movies to be watched, sweets to...
by admin | Nov 4, 2016 | Excel Path - Step by Step
Debra Dalgleish (http://www.contextures.com) is one of my Excel heroines and the pivot table guru. She is someone whose work I regularly reference in class. I recently asked her to help me answer a question that regularly comes up in class when people ask about pivot...
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 30, 2016 | Random
The Facebook of Business: Why Excel Isn’t Going Away Anytime Soon. George J. Mount blogs about Microsoft Excel, business analytics, and other tips for analysts at georgejmount.com. He is the author of the new course, “Hired with Excel: What Every Analyst Needs to...
