Microsoft Excel Exercise Essay

Submitted By zoner2015
Words: 569
Pages: 3
Open Document
Microsoft Excel Exercise

James Duckett

IT/206

Joseph Navara

June 7, 2015

Situation 1 : A business professional wants to use Microsfot Excel for the use of organizing data for his monthly expense report. He has never used Excel and is wondering about the functions that would help support him. The approach that should be used to inform this customer is to explain the functions that would help the to emphasize his spreadsheets for his monthly expense report. I would also explain to the customer that the spreadsheets will add up the tables for him to help him get done quicker. I would tell the customer that he could set it up to give him the total expense by the day , week, and also the month. I would also thell the customer that he could also set it up to calculate the total 's spent on transportation, food, and motel expenses. Additionally, he could also calculate the fuel, entertainment, phone, and misc expensenses. I would then inform the customer that he can add graphs, and charts to know what was spent in each category whether it was spent 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 functions over the phone is that the customer can get easliy confused. If I was able to show the customer I feel they would be able to understand and use the functions better if I was there in person. If the customer still didnt understand I would then proceed to give them some website to research more about the functions.

Situation 2 : An indivdual needs help calculating the .monthly average of his grocery spending. On the days in which no grocerys are spent he enters zero. The approach that should be used is to help the customer put in his cost in the correct days. He could then highlight all of his costs and it would show him the total amount that was spent. If he enters the information and he wants it to show in currency he could highlight the information, right click and hit the format cells option in which he could change the cells
Show More

Related Documents: Microsoft Excel Exercise Essay

Essay on Tutorial: Microsoft Excel and Sample Excel Spreadsheets

comments about the directions appear in blue. Then there are “Try it!” exercises in green. These “Try it!” exercises are a key feature of this tutorial. I have embedded numerous sample Excel spreadsheets so that you can try out the directions right away—without switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet “comes alive.” The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, you’re back in Word…

Words 1377 - Pages 6

Personal Budget Essay

Personal Budget Exercise – Excel Creating a spreadsheet track personal business expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2,500. Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories: Housing (mortgage or rent) Utilities…

Words 1048 - Pages 5

Essay about Case Brief

Wide Web. 3. Review basic features of the Windows 7 interface including file management 4. Develop basic computer software skills by creating documents and presentations in the popular Microsoft Office Professional suite. Software packages to be used include Word 2010 for word processing, Excel 2010 for spreadsheet development, Access 2010 for database management, and PowerPoint 2010 for graphic presentations 5. Experience integration features of the Office Professional software suite…

Words 1445 - Pages 6

Requirement Of Computer With Computer Application

GENERAL INFORMATION UGBA 104 last updated: 11 August 2014 Requirements • • • Excel Knowledge / Willingness to learn Excel Computer with Internet Connection Professional Attitude Registration Q: I am currently waitlisted in your class. Can you get me in? A: Faculty and GSIs cannot enroll students. Please contact the…

Words 2754 - Pages 12

Agatha Crissty Essay

applications and other related documents in accordance with specific guidelines established by the State Board of Equalization and /or Board of Supervisors. • Extensive work in a database system, processing and tracking appeal applications; uses Microsoft Office products and other various programs as needed in the daily operations of the Assessment Appeals Board. • Respond to a wide variety of in-person and phone inquiries from department staff and members of the public in connection with assessment…

Words 621 - Pages 3

Essay on Educational Psychology and Learners

Principles of Learning Introduction The following assignment discusses motivation, learning activities, organisation of information, communication and feedback. The theories of psychologists will be referenced to the examples given for motivation and the organisation of information. Theories include those of Abraham Maslow, Jerome Bruner and David Kolb. Motivation Students attend Learning Resources IT training on a voluntary basis, and are therefore highly motivated. These students…

Words 3215 - Pages 13

Analyse Fundamental Concepts To Extrapolate The Nature Of Information Systems And Their Role In Business

systems through written and oral business presentations. UNIT CONTENT 1. Foundations of Information Systems Technology 2. Business Organisation and Structure 3. Strategic Use of Information Systems 4. Introduction to Networks and Data Communication 5. Microsoft Office Skills 6. Writing Resource Proposals 7. Information Systems for E-Commerce 8. Managing the Information System – Ethics 9. Developing Information Systems, Processes and Implementation LEARNING IN THE WORK PLACE 40% of the assessment in this…

Words 2393 - Pages 10

Essay about 4201 AU Session 2 2014 Syllabus

dominant vehicle for finance professionals in the business world to practice their trade. This course will utilize Excel, a spreadsheet program offered by Microsoft, and challenge the student to improve their finance and modeling skills by personally constructing 25+ spreadsheet models. Students will further improve their familiarity with financial data analysis through various exercises that incorporate their completed models. The student who puts in the effort to not only complete the models, but…

Words 1964 - Pages 8

Following and Sub Procedure Essay

Lecture 20 _ Exercise Manual 1. Please go download a driver (mySQL) from the BB (file named mysql-connector-odbc-5.1.9-win32.msi), and install 2. If you are using other OS, go to http://dev.mysql.com/downloads/connector/odbc/5.1.html and download the correct driver and install NOTE you need to make sure the appropriate driver is installed. My computer (64bits) though uses 32 bit driver. 3. In Excel VBE, tools->reference->Microsoft ActiveX Data Objects 2.8 Library 4. Now, let's work on the…

Words 577 - Pages 3

Essay on UNIT 2

Program of Study: Date/ Week Topic Objective/Learning Outcome (SMART) Method Resources Assessment Links to Week 1 ICT suit H& S procedures. Complete ILP and registration paperwork. Portfolio building. To know how to work safe in the ICT suit Group discussion Q&A remind prompt and check understanding during each session. Handout. Refer to each week. Week 2 Identify ICT components. Turn on the computer Create a password and set up a new folder to store files Exit…

Words 1997 - Pages 8