CIS210 Computerized Spreadsheet
Module 5 Discussion
DQ1 By now, you are finding that Excel has a lot to offer in terms of applications to help boost a business. From general accounting to inventory to the overall tracking of balances, Excel can be fully integrated into what a business needs.
Taking what you learned so far, what and how do you see Excel working in the business environment you currently work in (or want to work in)?
DQ2 Spreadsheet programs are used in most businesses today. Microsoft Excel, Google Sheets, or Apple Numbers have a lot of similarities. Using any of the spreadsheet software, you can enter data, link workbooks, apply mathematical formulas, functions, and charts. Spreadsheets have a range of tools and features to save, manage, and analyze data.
What is Excel’s what-if analysis tools:
Goal Seek
Scenario Manager
Data Table
PMT function
What are Pivot Tables?
Pivot Tables and What-if analysis have endless possibilities, list 3 of the most important uses of Pivot Tables and what-if analysis for business owners.
