whopkins@accessanalytic.com.au

Home/Wyn Hopkins

About Wyn Hopkins

This author has not yet filled in any details.
So far Wyn Hopkins has created 15 blog entries.

Combine multiple tables with Excel Power Query

How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]

Stop merging cells!

Stop merging cells! One Microsoft Excel Insider has been quoted as saying that 53% of Excel Users merge cells. There is a standard tool on the toolbar called “Merge and Center”, it “merges” two or more cells into one and then centers the text horizontally within the merged cell. This can cause a number of [...]

The Great 48 Excel Toolbar

The Great 48 Excel Toolbar We love Excel and it can do some pretty amazing stuff. But sometimes there are a lot of unnecessary steps and clicks which are quite annoying, especially when you’re using Excel all day long! So we developed this Excel toolbar for ourselves and now we're sharing it with [...]