Analysis Tips

Finance and Data

Short post today – it’s running late now. I read earlier today about CFOs and big data: namely that CFOs oversee a lot of data and are in the prime spot to take advantage of this new buzzy business method. The article also said that just data alone is useless – one needs to add…

Abstract: Analysis
|

Doing Analysis

Everybody talks about big data and analytics, (my understanding is that they are related but not the same thing) but we have probably been doing some form of analytics all along. Analytics is just a snazzy term for analysis which has always been around since man has a brain. Big data is a term that…

Testing Excel Files

Testing Excel Files

This week I’m testing the budgeting file since we made some changes to it. There is definitely some level of discipline and method to it. At SAIC, the type of files I created were rather simple and did not require multiple entry points, so testing the files were easier to crosscheck. You basically tested the…

Macros

Macros

This past week I’ve been working on macros to create a flat file since formulas create such a large file and slow it down. Last week I showed in 2 posts the formulas to create a flat file. Today, in a very short post, I will lay out some of the macro functions that I…