The great end of life is not knowledge but action.
T H Huxley (1825-1895)
Monthly Archives: June 2016
The man that views the world at fifty the same as he did at twenty has wasted thirty years of his life.
Muhammad Ali (1942 to 2016)
Useful Excel VBA Range Technique
Titles made simple in VBA
It is common to create headings for data sheets in Excel VBA. There is an array technique that can make this a simple process.
What is now proved was once only imagin’d.
William Blake (1757 to 1827)
Why Does My Pivot Table Default to COUNT?
And how to fix it
When you drag a value column to the value section of a pivot table, sometimes the default calculation is COUNT, not SUM. This is frustrating, but easily fixed.
Print Titles
Print Titles is the term Excel uses to describe the rows and columns you want repeated when you print a sheet over multiple pages.
You typically want to repeat the labels in the top row(s) and those in the left column(s) of the sheet.
There is a dedicated button to define Print Titles on the Page Layout ribbon tab.
You can display multiple rows and columns.
Of course I don’t look busy, I did it right the first time.
The Dilbert Principle
Scott Adams
Excel VBA BeforePrint Issue
Not all Print Previews are Equal
Excel has a BeforePrint event which enables you run VBA code before a document is printed. This event can also be triggered by Print Preview. But not all Print Previews are the same.
What you’re thinking is what you’re becoming.
Muhammad Ali (1942 to 2016)
This is a great video on data visualisation in general.
It includes two great tips, with examples, to improve your visualisations.
Cole has a great website as well.
The years teach much which the days never know.
Ralph Waldo Emerson (1803 to 1882)
A wonderful site with suggestions and examples for data improved visualisations, and how you tell a story with data.
Cole has a book out as well.