Excel

The past week I’ve been reviewing a revamped budget file. The budget file is totally revamped which means extensive testing is required. I was able to design an automated checking of whether cells are appropriately locked (or unlocked) using the CELL(“protect”, ref) function. I also have a user defined function CellFormula (a macro) that shows…

I keep learning new things.Lately, my boss wanted an easy way of “printing” her budget file as an Excel file but without formulas to send to our customers. Previously, she sent the budget file as a PDF but you know you can’t use the information in Excel unless you have the professional version of Acrobat to convert…

This is going to be a quick post but I have to note something.Today, I read an email where the reports done on Monday will now be due by 10:30 am.  This is very aggressive deadline considering that the summary report for the executives would be sent out between 3 and 6 pm, as a…

It’s budget season again and we’re back to trying to make the budget file better. Because of the nature of our business, we have sites that use different sets of GL account codes which makes creating a single budget file problematic. But my boss is a master of Excel. Most people would create three separate files but…

Last week my boss and I did some collaboration which we haven’t done in a while. It’s always nice to work with somebody, so I can hear how they think or approach problems. She’s working on revamping her budget model and I’m doing some research on some of her questions. I’m also working on some…

I’m working on some interesting problems posed by my boss. She wanted something done that would entail more automation so I’m working on helping her.One thing she is doing is completely redoing her budget file and one of the problem she is encountering is the exploding size of the file. Last year’s budget file was…