Archive for the ‘Excel Hints’ Category

Playing with VBA in Excel, Without Knowing VBA!

Posted on October 27th, 2008 by Joseph Harris

Introduction to user defined functions and VBA in Excel.

Excel Version Differences

Posted on October 26th, 2008 by Joseph Harris

I try to make all of the advice I offer on this blog generic to all Excel versions. Sometimes it is useful to know some of the more important (or useful) differences. Below are some of the differences that I try to keep a mental note of: 2000 Digitally signed macros Pivot Charts User forms [...]

Paste Special – Transpose

Posted on October 23rd, 2008 by Joseph Harris

Excel Transpose