My only experience using spreadsheet software was creating a budget to track my income and expenses. It was a good way to visualize where my salary mysteriously disappeared to every month.

By doing this, I was able to automate fixed bills like rent, car payments, phone, etc. to see how much I had left over. I was also able to start automating how much money I could put into my savings/investing and how much money I had left to spend for the month. I no longer use my spreadsheet as religiously as I used to when I first started, but I am planning on updating it soon in reflection of my current lifestyle.

A feature that helped with this budget was the AutoSum. It saves time from manually doing the calculations and updates when there are changes in the flexible portion of expenses like grocery, gas, and dinners out. I like to do this part first, and then calculate the total expense =(total fixed expense)+(total flexible expense). Then I calculate the total money left over =(monthly budget)-(total expenses fixed and flexible).

I have never needed to use this software in work as it is not my department, but I do get a printed sheet that was made with this software as a list of things to do for the day as an inspector. Moving forward I definitely feel more confident in using this type of software if ever a job will require it out of me, but for now I am perfectly happy keeping my spreadsheet knowledge for personal use.