Microsoft Excel Capabilities

There were quite a few capabilities of Microsoft Excel that were discussed in this week's readings that I was unaware of before such as creating formulas. I had no idea one could do that. I could use this in a professional capacity to put together a forecast if I worked in a hotel or if I'm working as an accountant and trying to figure out how much money my clients would or have made or just to keep up with their financials. I would have to learn how to create a formula but that is a great capability of Microsoft Excel I was unaware of.

Also there was the Auto Sum I was unaware of that you can use within the formula. I didn't know you could just click an auto sum button and it add up everything for you that you entered. I could use this as an auditor helping clients with inventory in company such as a retail facility. I could use this capability in a career as a tax professional as well to help clients with their taxes such as if I worked at H&R block or something. I could use it if I owned my own business to see keep track of my own financials and inventory.

I can use Formulas and the Auto Sum both in my own professional business for things such as scheduling employees and forecasting how many employees I made need on a particular day or how well I maintained business with a certain amount of staffing on a particular day. I can use it for my basic accounting like doing a checkbook ledger with entering deposits and expenditures. I can track my product sales on a daily, weekly, monthly, or quarter basis and keep up with my inventory from that by attaching the formula to certain spread sheets. I can create a formula with a customer database and tracking what they spend on a daily, weekly monthly and quarterly basis so I can see what I need to change or how to better market for better sales or compare sales for those certain times with the use of formulas.