CAREER PLANNING, USING POWERPOINT AND EXCEL, AND DIVERSITY
Module 4 – SLP
CAREER PLANNING, USING POWERPOINT AND EXCEL, AND DIVERSITY
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.
Manipulate the data in this sample order spreadsheet to address the following:
Sort your spreadsheet and then calculate each region’s order totals.
1. Which region’s order generated the highest dollar amount?
2. What percent of total sales does this region represent?
3. Insert a pie chart illustrating the sales by region.
4. Change the spreadsheet name from SalesOrders to SalesAnalysis
Evaluate each rep’s order total.
1. Add a new spreadsheet to your workbook.
2. Name the spreadsheet RepSales and change the color to blue.
3. Copy the data from the SalesAnalysis spreadsheet to the new RepSales spreadsheet.
4. Sort the data by rep.
5. Which rep generated the highest sales?
6. 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.