Management homework help

Using Microsoft Excel

As you move through your courses, Microsoft Excel will be a tool you will continue to use in and out of the classroom. It can be used for personal budgeting, planning for your financial future, and aiding in important decisions based on data. For this SLP assignment, you will apply basic Excel functions used as a tool (spreadsheet) to store, analyze, and manipulate data. Use the spreadsheet and the linked Excel tutorial videos provided to learn the steps required for each part of the SLP Assignment. Management homework help.

Manipulate the data in this sample order spreadsheet to address the following:

Sort your spreadsheet and then calculate each region’s order totals.

Which region’s order generated the highest dollar amount?
What percent of total sales does this region represent?
Insert a pie chart illustrating the sales by region.
Change the spreadsheet name from SalesOrders to SalesAnalysis

ORDER A PLAGIARISM FREE PAPER NOW

Evaluate each rep’s order total.

Add a new spreadsheet to your workbook.
Name the spreadsheet RepSales and change the color to blue.
Copy the data from the SalesAnalysis spreadsheet to the new RepSales spreadsheet.
Sort the data by rep.
Which rep generated the highest sales?
Insert a Pivot Table.

Save your Excel workbook. Label each worksheet.

EXCEL Tutorials: Applicable to Microsoft Excel 2007, 2013, 2016, 2019

If you are using Microsoft Office 365, there are tutorials located within Excel.

Tutorial video author: Kevin Stratvert, Microsoft Employee

Microsoft Excel Tutorial for Beginners: https://www.youtube.com/watch?v=e7xGuGqgp-Q&feature=emb_rel_pause

Excel Formulas and Functions Tutorial: https://www.youtube.com/watch?v=Jl0Qk63z2ZY

Pivot Tables Excel Tutorial: https://www.youtube.com/watch?v=m0wI61ahfLc&feature=emb_rel_pause

SLP Assignment Expectations

Submit an Excel Workbook with two spreadsheets; one labeled SalesAnalysis and the other labeled RepSales. On the individual spreadsheets, complete the analysis listed above. Utilize the tutorial to complete the assignment. Management homework help

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.