Posts

[SOLVED] Fix Duplicate Conditional Formatting Rules in Excel 2016

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.

Building Your Own (And Better) Autosave Feature for Excel

Published on June 07, 2018 at 11:13PM

Because the current Excel Autosave is just so bad XD

Again With The Permission Denied Could Not Read From Remote Repository

Published on March 22, 2018 at 06:37AM

Turn on Agent Forwarding for SSH when deploying by Capistrano to Digital Ocean servers

Add Dynamic Role Level Security to PowerBI Using an Attribute of the Current User

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

Add Dynamic Role Level Security to PowerBI using current users email

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.

Automate Excel Table Filters Using VBA and Activate them Using Hyperlinks

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.

[SOLVED] SQL Get Financial Year from Date

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

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

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.

Add Hyperlinks to an Entire Column using VBA in Excel

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

[SOLVED] Excel VBA Get Financial Year from Date - No Formula

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.