Category: <span>Financial Models</span>

Visually Express Data with Excel in USA State Map

Written by Gregory on August 7, 2014. Posted in Business & Markets, Excel Skills, Financial Models.

The world is visual and there are times that financial data needs to be presented in a visual form. Excel is capable of keeping up and making your life easier to display your data for management.

Forcing Excel to Recalculate

Written by Gregory on December 2, 2012. Posted in Binary, Excel Skills.

Occasionally your computer might run out of RAM, or Excel could just get bogged down because you have too much open and things just start to not calculate properly. Sometimes everything is working...

ModelOff 2012

Written by Gregory on October 27, 2012. Posted in Excel Skills, Financial Models.

I cracked under pressure on the 15th green and it cost me the green jacket. Round 2 of ModelOff 2012 didn’t go well for me. I did exceptionally well in Round One. I found out confidentially...

SQL Previous Business Day Function

Written by Gregory on October 18, 2012. Posted in Binary, Financial Models.

This is a simple function for MS SQL that can make reporting so much easier by finding the previous business day. Setup the function: CREATE FUNCTION [dbo].[fn_prevbusday](@date DATETIME) RETURNSDATETIMEAS BEGIN DECLARE...

Tell Excel To Leave My HSA Alone!

Written by Gregory on December 19, 2010. Posted in Excel Skills. 1 Comment on Tell Excel To Leave My HSA Alone!

With Excel trying to think for me, it would like to help me out and turn my HSA abbreviation into "has". This is quite annoying when you really do not want to put H.S.A. on your spreadsheet.

SQL Linked Server Syntax

Written by Gregory on August 26, 2009. Posted in Binary, Financial Models.

Select, Insert, Update and Delete T-SQL for Linked Server in MS SQL