Written by Jay Killeen
Published on September 18, 2018 at 04:48AM
You have conditional formatting rules in Excel 2016 and all of a sudden they are duplicated all over the place and super messy. This fixes it.
Published on June 07, 2018 at 11:13PM
Because the current Excel Autosave is just so bad XD
Published on March 22, 2018 at 06:37AM
Turn on Agent Forwarding for SSH when deploying by Capistrano to Digital Ocean servers
Published on March 21, 2018 at 02:09AM
Take the currently logged in user in PowerBI and filter data based on an attribute of the User table
Published on March 08, 2018 at 11:07PM
Users logged into PowerBI can have their email address exposed. This allows us to create dynamic row level security using inner joins on a user table.
Published on February 07, 2018 at 06:07AM
Now you can click a metric in one of your Worksheet reports and be taken straight to the underlying data in a way that is easy to see.
Published on February 07, 2018 at 12:21AM
This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query
Published on February 07, 2018 at 12:01AM
Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.
Published on February 05, 2018 at 04:50AM
Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query
Published on January 23, 2018 at 01:42AM
Convert a date to the Financial Year (Fiscal Year) like '01/01/2017' = '2018'. Australian example used. Pure VBA without Excel formulas. Just the solution.