Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Dr lark dentist adrian mi

06/12/2021 Client: muhammad11 Deadline: 2 Day

Excel-Hw/Excel - Exercise 5 Pivot Tables.doc
INFS 3250

Exercise 5 - Pivot Tables, Reports & Charts

Name: ____________________________ Points: ______ / 25
Due: See Blackboard Due Date! (2.5 pts deduction for each class period late)

This assignment requires for you to do some readings and research on the use and mechanics of Microsoft’s Pivot Table capabilities. Pivot tables replace the need to create summary tables as you have for the previous exercises. I think you will enjoy seeing a different way (and potentially easier way once you get the hang of it) of summarizing data into classifications.

Go to the following link: http://office.microsoft.com/en-us/support/results.aspx?qu=pivot+tables+Excel+2013&ex=1

There are 15 different help topics there – I suggest you follow each link and read through the information to gain a good understanding of Pivot Tables.

Once you have read through the material – download the assignment file: Excel Exercise 5.xlsx and complete the following operations (create each Pivot Table Report on its own worksheet):

Points

Description / Instructions

Each of the following Pivot Table operation is worth 2 points for a total of 20. Create the pivot table and/or chart. Pay attention to formatting. Save each table to its own worksheet with a descriptive tab name (for example: pivot-1, pivot-2, etc). Print each report and chart – clearly labeled and attach the prints to this grading sheet for submission.

1. Create a Pivot Table Report that summarizes the Payroll Data. Provide Totals for Gross Pay, Total Deductions and Total Net Pay by Department.

2. Create a Pivot Table Report that summarizes the Payroll Data by Hourly and Salary. Display counts, Total Gross Pay, Minimum Gross Pay, Average Gross Pay and Maximum Gross Pay.

3. Create a Pivot Table Report that summarizes the Payroll Data by Health Insurance Enrollment. Display by Department, the counts and total HI deduction for each enrollment (family, individual).

4. Create a Pivot Table Chart that summarizes the Payroll Data. Create a Pie chart that displays the % of Gross pay by department.

5. Create a Pivot Table Chart that summarizes the Payroll Data. Create a Bar chart that displays the Total Gross Pay and Total Deductions by Department.

6. Create a Pivot Table report that summarizes the Shipping Report. Provide totals of Qty, Product Cost, Shipping Costs, Cost perOrder and Projected Revenue by Vendor.

7. Create a Pivot Table report that summarizes the Shipping Report. Provide totals of Qty, Product Cost, Shipping Costs, Cost perOrder and Projected Revenue by Item#.

8. Create a Pivot Table report and chart from the Shipping Report that presents the total projected revenue by Vendor in a pie chart.

9. Create a Pivot Table report and chart from the Shipping Report that presents the total projected revenue by Item in a Bar Chart.

10. Create a Pivot Table report from the Shipping Report that presents the counts, totals, minimum, maximum and average of the Projected Revenue by Item#.

Organization of Workbook – WORTH 5 points

Rename worksheet tabs to reflect the Pivot table operation (you may simply use the corresponding step# from the above instructions). Properly label each required Pivot Table report and Chart (again, identifying the assignment step# would be very helpful) and print each report. Be sure to add report titles, chart titles, legends and anything else that would help the user read the reports.

Pay attention to aesthetic details. Be sure the user of the reports can immediately identify what is being reported. How you package this assignment together and identify your worksheets and will count as 5 points toward the total grade.

________

Total Points Awarded out of 25

Save your finalized document and post it to the Blackboard web site. Attach your printed reports to this document. Write your name on the top of this form and turn it in as a vehicle to communicate your graded project.

Excel-Hw/Excel - Exercise 6.doc
INFS 3250

In Class Project – Exercise 6

Text Functions

Name: ____________________________ Points: ______ / 20
Due: See Blackboard Date! (2 pts deduction for each class period late)

Download the Excel Exercise 6.xlsx spreadsheet and complete the following operations:

Text Manipulation Section

Import the external data file: Exercise6.txt into the worksheet titled TextFunctions. The file is a TAB Delimited file with headings. Manipulate the data using Excel’s Text functions to convert it in more meaningful and useful forms.

Rebuild the data – using the appropriate text functions on the original data. In most cases you will need to create one (or more) work-in-process columns to perform the text manipulations. Copy the manipulated data (properly converted) – and PASTE the VALUES onto the NewTextWorksheet. Leave the original TextFunctions spreadsheet intact so that I can see the formulas used in your solution.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Engineering Mentor
Top Essay Tutor
Accounting & Finance Master
Professional Coursework Help
Quality Homework Helper
Coursework Helper
Writer Writer Name Offer Chat
Engineering Mentor

ONLINE

Engineering Mentor

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$32 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$18 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$41 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$38 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$47 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$46 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Washing machine depreciation rate - Glen williams public school - Healthcare- Associated Infections - Blank periodic table word document - Balancing chemical equations made easy - The higher the correlation between the stocks in a portfolio - Discussion - 4x 8y 40 when y 0.8 - Tim steinert alibaba net worth - Now, summarize that point as accurately as you can (about 50-75 words). Then, write a refutation or rebuttal to their point (about 100 words). - Cuddly dudley theme song - Willow used in basketry - 8 point dif fft example - Fombrun tichy and devanna 1984 - The following transactions pertain to smith training company for 2016 - Kelvin giormani sofa for sale - International finance - Theory and practice of counseling and psychotherapy student manual pdf - Food a fact of life explore food - Shadow health tina jones comprehensive assessment - 3.1&3.2 Discussion: Devotional Reflection-Children of Light-Transparency & Borland Case Final Response - Bundaberg dump opening times - Bill penney toyota university drive northwest huntsville al - Discussion Board initial response x 5 - Access control discussion 7 - NEED IN 15 HOURS or LESS - Marketing communications role play - Fmagx quote - Discussion - Are machine learning based intrusion detection system always secure? An insight into tampered learning. - ?? same-day +27833173182 HLOTSE - LERIBE ABORTION CLINIC // PILLS,,,, - The baldrige award criteria emphasize all of the following except - Serial episode 3 leakin park answers - What four elements make up the human body - Air fuel ratio chart - Knowledge matters promotion with traditional media sim answers - Spiral chart tableau - American Literature - Week 1; Assignment: Defining Homeland Security - Exercise on Biological and Contextual Theories - Substitution table for tenses - Acm code of ethics - An internet company located in southern california - Unit III Discussion Board - Case 9 the data cleansing task - 1 -2 paper discussion in APA standard on Key Considerations in Data Visualization - 5 finger rule for choosing a book - Rutgers class registration schedule - Community mental health team dumfries - Wgu c229 time log obesity - Me talk pretty one day style - Way cool produces two different models of air conditioners - What is an episodic soap note - Lag length selection eviews - N491 Discussion Mod 6: - Macbeth act 5 scene 5 - Unit 5 Power Point Presentation - How would epictetus analyze the value of bodily pain? - Www chemical ecology net java lat long htm - Gorongosa wild cam - The norton introduction to literature 11th edition pdf - Business law chapter 18 test answers - First article inspection procedure - Master of physiotherapy griffith - Bigger than enron worksheet answers - Sample grounded theory research questions - Research Project 1 - You would use spatial order to - 8035 1 mark scheme - Tuff wheels was getting ready to start - The general's favorite fishing hole answers - Acca sbr past papers - Concur expense administrator manual - Thinking through the past volume 2 - Hush puppies creative brief - Multidimensional scaling in marketing research ppt - C program for playing cards - Computer science distilled pdf drive - INtEr cAst lOvE mArRiAgE +91-9799046502 lOvE bAcK sPeCiAlisT mOlVi jI - How i met my husband alice munro character analysis - Can someone do my Week 5 work for me Discussion 1 & 2 and Assignment in Organizational Behavior? - Earth science - Burning off cardinia shire - French rococo painter of gilles - Accounting essay help - Spanish american war crossword answers - Wedding cake model of justice - I need 6 pages double space on SUPPLY CHAIN MANAGEMENT SYSTEM - The legacy chronicles out of the ashes epub download - Moment of inertia of right triangular plate - Reflection - Two classes 2 - Cultural relativism and universal human rights by carolyn fluehr lobban - World elder abuse awareness day mn - Colligative properties of solutions experiment - Art research paper outline - Rebecca is a calendar year taxpayer - Dyson distribution and supply chain strategy - Art history analysis paper - E-oz energy skills australia - Cjt assignment