Excel Scenario Week 3 CIS 211

Excel Scenario's Scenario 1: A business professional calls the support desk looking to use Excel to organize data for the monthly expense report. He has never used Excel prior to this and has inquired about the functions that would support him with his task.

My general approach for this call would be to start off by explaining what Microsoft Excel is to the business professional. Microsoft Excel is an application used to create spreadsheets. It also provides the user with functions such as calculation, graphing tools, pivot tables, and so on. Following the basic description of the software I would then continue on be providing him with an in depth explanation of the features and functions that would be beneficial for his or her business needs. I would let them know that when they initially open an Excel spreadsheet they will see a rectangular grid of rows and columns. The horizontal rows are already labeled with numbers and the vertical rows are labeled with letters. Spreadsheets are commonly used to store and perform basic analysis of financial information. Excel will be able to assist you by performing basic mathematical operations such as summing columns and analyzing data to show trends on the monthly expense report. These functions will help the business professional find information such as loss or profit. It will also assist in calculating payment plans for loans, payroll expenses, and other costs the business may incur. I would also explain that Microsoft Excel can be used for more than just financial purposes. It will also allow the business to store and analyze other types of data as well. It can be used to graph and chart data to expose trends. It provides tools to aid in sorting and finding specific data, which will save the business a lot of time. The information stored in Excel can be integrated into web pages, electronic presentations, or it can be printed off in a report form. In order to ensure the business professional