Author

John

Started out in media/graphic design then moved to Financial Services / MI data / Business intelligence. ~15 years experience of Excel / VBA , and more recently Qliksense , SQL

London, UK 25 posts
Text to Clipboard with Office 365 / 64-bit

Text to Clipboard with Office 365 / 64-bit

Depending on which version of Excel you're using, you may find you're no long able to dump out text into the clipboard in VBA like you used to. I found an interesting bit of Win 10 /64-bit safe code on Stack Overflow -Original Stack Overflow Post. I'm presenting here in...
Read more
Get fast in Excel! Shortcuts to speed up your workflow.

Get fast in Excel! Shortcuts to speed up your workflow.

Have you ever been frustrated scrolling through a huge spreadsheet, or filling out blocks of data a cell at a time?   Read on, as below are a number of shortcuts that'll save you time and energy in your daily chores!   CTRL + Spacebar   / SHIFT + Spacebar   Tired of clicking...
Read more
SQL connections and data import into Excel

SQL connections and data import into Excel

You might have some sophisticated BI tools like OBIEE  / QlikSense /  Power BI etc. , however sometimes it's useful to be able to prototype, or access tables / stored procedures etc directly through Excel. This can be slow and cumbersome working through Excel's query editor, especially if you're already...
Read more
Cleaner Code Part 1

Cleaner Code Part 1

When revisiting old functions, you'll often find some truly brute force methods used, usually due to time restrictions and trying to push together a solution as quick as you can. Something I recently came across was a quick UDF ( User defined function )  to return an integer month from...
Read more