Not Just Numbers
▼
Tuesday, 26 March 2013

Excel Tip: Presenting Pivot Table data in a fixed layout using GETPIVOTDATA

›
It's been a while since I covered GETPIVOTDATA  on the blog, so I thought it was worth a re-visit, but with the specific objective of...
6 comments:
Tuesday, 19 March 2013

Excel Tip: Using Goal Seek

›
Before we get into this week's post, I'd just like to say a big thank you for the magnificent response to my survey last week. I ...
1 comment:
Monday, 11 March 2013

Excel Training - I need a minute of your time

›
Hopefully you are finding my Excel tips useful and they are helping you with your daily work. This week, however, I need a little somethi...
Tuesday, 5 March 2013

Excel Tip: INDEX and MATCH - an alternative to VLOOKUP (and HLOOKUP)

›
In my last post  I described how to use both VLOOKUP and HLOOKUP to lookup and return data from lists or tables. Whenever I mention these...
8 comments:
‹
›
Home
View web version
Powered by Blogger.