Find Hard coded values in Excel Formulas

Find Hard-coded values in Excel Formulas

Finding hard-coded values within Excel Formulas is something Excel users have struggled with for a long time. While I was researching this article, I am surprised that the solution I am about to offer you has not been widely covered so far. What exactly is a hard-coded value? It would be common to see a […]

Document Entire Excel Workbook with the Click of a Button

Document Entire Excel Workbook with the Click of a Button

Why Document an Entire Excel Workbook You already know the story…. or do you…..? So the internal accountant produces a monthly pack for management, which contains financial information. These reports are fantastic.  Detailed Sales reports show sales against budget, against the prior year, as a 12 month rolling total. They are also further sliced against […]