Tag: spreadsheets

Excel Mastery is What Exactly?

I used to think that the more Excel formulas you knew and the more adept you were at macros, the more you could claim Excel mastery. I have changed my mind.  Those who create complex spreadsheets that are beyond the skill and understanding of their users are pushing the program beyond it’s useful limits. Spreadsheets

Read More

Excel Solver for Expense Transfers

Thank you Pronger for your post about the Excel solver function.  Follow this link to view his explanation and instructions. The solver function is especially useful if you deal with a multitude of funding sources such as state and local grants, federal awards and bond funds.  Each restricted funding source has very particular spending rules and most have

Read More

What Does it Take to Get Fired?

Sometimes, Not Much The article Fatal IT Distractions lists mistakes that will lead to immediate dismissal in the IT world: things like forgetting to back up data nightly or not testing your disaster recovery plan prior to a disaster. This made me ponder.  What will get you fired in the world of school finance? I am not talking about obvious offenses

Read More