Excel Exercise

Topics: Microsoft Excel, Spreadsheet, Pivot table Pages: 3 (833 words) Published: October 6, 2011
Microsoft Excel Exercise

September 19, 2011
Patrica Byerly

Microsoft Excel Exercise

Situation 1: A business professional wants to use Microsoft Excel to organize data for the monthly expense report. He has never used Microsoft Excel and is inquiring about the functions that would support him with this task. The approach that should be used to for this customer is to explain the functions that would help the customer to organize his spreadsheets for his monthly expense report. I would also explain to the customer that he may add formulas to the spreadsheet that will add up the totals for him, to help him get it done quicker. I would tell the customer that he could set it up to give him the total expenses by the day, week and also the month. I would also tell the customer that he could also set it up to calculate the totals spent on transportation, food, and motel expenses. Additionally, he could also calculate the fuel, entertainment, phone, and misc. expenses. I would also alert the customer that using filters will help narrow down data for an easy view without having to look all over the data to find what he is looking for, such as how much was spent on the motel stay. I would then tell the customer that he can add graphs and charts to show what was spent in each category, whether it was by the day, week, or month. I would let him know that if he decides to use graphs and charts it would be an easy and quick way to analyze the information. Some challenges with explaining all the function over the phone is that with so many functions, the customer can still get confused. If I was able to show the customer I feel they would be able to understand how to operate the functions better if I was there to show them in person. If the person still didn’t understand I would give him some web sites to look at tutorials.

Situation 2: A husband is having difficulties with is Microsoft Excel spreadsheet. He has been trying to track his monthly grocery...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Excel Scenario Week 3 CIS 211
  • Week 4 Ms Excel Exercise Essay
  • Week 6 Excel Essay
  • Essay about Matlab vs Excel
  • Excel Evaluation Essay
  • excel worksheet Essay
  • Excel: Spreadsheet and Instructor Explanation Essay
  • Excel Wth Vba Essay

Become a StudyMode Member

Sign Up - It's Free