spreadsheets – FiscalShare

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

May 17, 2014 Short URLadvanced Excel, Excel mastery, spreadsheet design, spreadsheetsAccounting, Analysis, Data, Excel, Finance, Procedures and Practices

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

December 31, 2013 Short URLaccounting, Accounts Payable, analysis, best practice, data, Excel, Excel solver, Excel spreadsheet, Expense, funding sources, Funds, General Journal, government spending, governmental accounting, information technology, Invoice, Microsoft, Microsoft Excel, nonprofit accounting, problem solving, public school finance, school district business, school districts, school finance, solver, solver function in Excel, spreadsheetsAccounting, Finance, Government, Public Schools, School Construction

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

December 5, 2013 Short URLcalculation, conflict of interest, disaster recovery plan, dismissals, employment, Excel, fired, government, hiring, IT mistakes, jobs, Management, revenue calculations, school bonds, school district, school district business, spreadsheets, tax rate, unemploymentCareer Development, Excel, Finance, Management, School District Jobs