Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.
Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.
Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.
LU Microsoft 365 Apps Project
User Generated
funqlzvxunvy98
Business Finance
Liberty University
Description
Unformatted Attachment Preview
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions. Total annual sales for Ambulatory Care of TX, Inc.: SW2 SW1 NE2 SE1 NW2 NE1 SE2 NW1 176208 Sales by Region Annual Sales 1,125,667 851,283 1,102,101 1,272,386 1,256,707 875,800 1,025,987 634,728 Sales by Sales Associate First Name Last Name Grand Total Region Client Annual Sales Commission Rate Commission Earned 229,846.22 National Pharmaceutical Sales First Name Last Name Grand Total Ahjab Total Quarles Total Ahjab Total Quarles Total Lopez Total Schmidt Total Brown Total Zhu Total Anderson Total Johansen Total Region Client al Sales Annual Sales Commission Rate Commission Earned 261,614.40 8,813.70 15,338.58 4,443.32 45,883.74 12,694.56 51,755.60 41,129.56 29,906.82 19,880.34 31,768.18 National Pharmaceutical Sales First Name George Mia Last Name Anderson Zhu Region Client First Name Last Name Region SE2 SE2 SE2 Client NC Medical Associates Palmetto Physicans NC Medical Associates Mia Mia Mia Zhu Zhu Zhu al Sales Commission Rate Commission Earned Commission Annual Sales Rate 151,827 4% 165,700 4% 151,827 4% Commission Earned 6,073.08 6,628.00 6,073.08 Annual Sales >120000 >120000 National Pharmaceutical Sales First Name Marques Marques...
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science !
Similar Content
Related tags.
Cost of Capital personal budget excel assignment albany technical Summary accountant "J.D Salinger" "J.D Salinger" excel for time sheets at animal service excel CPMGT/303 Version 10 Project Estimating and Control Techniques Income Statement excel
The Restless Wave
by John McCain
Animal Farm
by George Orwell
The Book Thief
by Markus Zusak
The Color Purple
by Alice Walker
by Johann Wolfgang von Goethe
Fear - Trump in the White House
by Bob Woodward
The Curious Case of the Dog in the Night Time
by Mark Haddon
Cat on a Hot Tin Roof
by Tennessee Williams
The Joy Luck Club
working on a homework question?
Studypool is powered by Microtutoring TM
Copyright © 2024. Studypool Inc.
Studypool is not sponsored or endorsed by any college or university.
Ongoing Conversations
Access over 20 million homework documents through the notebank
Get on-demand Q&A homework help from verified tutors
Read 1000s of rich book guides covering popular titles
Sign up with Google
Sign up with Facebook
Already have an account? Login
Login with Google
Login with Facebook
Don't have an account? Sign Up
Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
1.4 Key Skills of the Project Manager
Learning objectives.
- Identify necessary operational leadership skills.
- Identify additional leadership skills required of a project manager.
Every project is unique, and most projects will encounter unexpected technical challenges. Each project management team is a group of individuals who need motivation and coordination. Planning is vital, but the ability to adapt to changes and work with people to overcome challenges is just as necessary. A project manager must master the skills that are necessary to be successful in this environment.
Operational Management Skills
Often the difference between the project that succeeds and the project that fails is the leadership of the project manager. The leadership skills needed by the successful project manager include all the skills needed by operations managers of organizations. These skills include:
- Good communication
- Team building
- Political sensitivity
Project Management Skills
Because project managers generally operate in a project environment that is more time sensitive and goal driven, the successful project manager requires additional knowledge, skills, and abilities.
Albert Einsiedel (Einsiedel, 1987) discussed leader-sensitive projects and defined five characteristics of an effective project leader. These characteristics were chosen based on some assumptions about projects. These characteristics include the project environment, which is often a matrix organization that results in role ambiguity, role conflict, and role erosion. The project environment is often a fluid environment where decisions are made with little information. In this environment, the five characteristics of an effective project leader include the following:
- Credibility
- Creativity as a problem solver
- Tolerance for ambiguity
- Flexibility in management style
- Effectiveness in communicating
Hans Thamhain (Thamhain, 1991) researched the training of project managers and, based on the finding, categorized project management into interpersonal, technical, and administrative skills:
- Interpersonal skills . These skills include providing direction, communicating, assisting with problem solving, and dealing effectively with people without having authority.
- Technical expertise . Technical knowledge gives the project manager the creditability to provide leadership on a technically based project, the ability to understand important aspects of the project, and the ability to communicate in the language of the technicians.
- Administrative skills . These skills include planning, organizing, and controlling the work.
Thamhain’s work provides a taxonomy for better understanding the skills needed by project managers.
Traditionally, the project manager has been trained in skills such as developing and managing the project scope, estimating, scheduling, decision making, and team building. Although the level of skills needed by the project manager depends largely on the project profile, increasingly the people skills of the project manager are becoming more important. The skills to build a high-performing team, manage client expectations, and develop a clear vision of project success are the type of skills needed by project managers on more complex projects. “To say Joe is a good project manager except he lacks good people skills is like saying he’s a good electrical engineer but doesn’t really understand electricity” (Darnall, 1997).
Key Takeaways
- Project managers need the same skills as an operations manager, such as good communications, team building, planning, expediting, motivating, and political sensitivity.
- Project managers need additional skills in establishing credibility, creative problem solving, tolerance for ambiguity, flexible management, and very good people skills.
- Project managers need the same skills as an operations manager, including communications, team building, planning, expediting, and _______ sensitivity.
- In addition to the skills needed by an operations manager, a project manager needs to establish credibility, solve problems creatively, have a tolerance for ____________, be flexible, and have good people skills.
Personal Leadership Inventory
Rate your personal project management skills using the following scale:
- I Improvement needed
Operational management skills:
- Motivating others
- Sensitive to the politics of a situation
Additional project management skills:
- Establish credibility with others
- Find creative solutions to problems
- Tolerate ambiguity
- Use a flexible management style—adapt your management style to changing situations
Darnall, R. W., “The Emerging Role of the Project Manager,” PMI Journal (1997): 64.
Einsiedel, A. A., “Profile of Effective Project Managers,” Project Management Journal 18 (1987): 5.
Thamhain, H. J., “Developing Project Management Skills,” Project Management Journal 22 (1991): 3.
Project Management from Simple to Complex Copyright © 2016 by University of Minnesota is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License , except where otherwise noted.
Share This Book
BUSI 201 Project Skill Review 8.1 Assignment solutions complete answers
BUSI 201 Project Skill Review 8.1 Assignment solutions complete answers In this project, you will analyze sales data using consolidation, subtotals, outlines, conditional formatting, advanced filters, PivotTables, and PivotCharts. Skills needed to complete this project: · Using GETPIVOTDATA (Skill 8.21) · Using Consolidate to Create Subtotals (Skill 8.8) · Sorting Data on Multiple Criteria (Skill 8.4) · Adding Subtotals (Skill 8.7) · Creating an Outline (Skill 8.9) · Creating New Conditional Formatting Rules (Skill 8.1) · Filtering and Sorting Using Cell Attributes (Skill 8.3) · Managing Conditional Formatting Rules (Skill 8.2) · Using Advanced Filter (Skill 8.6) · Refreshing Data in a PivotTable (Skill 8.16) · Adding a Calculated Field to a PivotTable (Skill 8.17) · Applying a Quick Style to a PivotTable (Skill 8.22) · Changing the Layout of a PivotTable (Skill 8.23) · Filtering PivotTable Data (Skill 8.19) · Filtering Data in a PivotChart (Skill 8.24) · Changing the Look of a PivotChart (Skill 8.25) This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead. 1. Open the start file EX2019-SkillReview-8-1. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. Use GETPIVOTDATA to extract data from a PivotTable. In cell D1 on the Analysis worksheet, display the total annual sales for Ambulatory Care of TX, Inc. a. If necessary, go to the Analysis worksheet. b. Select cell D1. c. Type = d. Click the PivotTable worksheet tab. e. Click cell B4. f. Press Enter. 4. Use consolidate to create a summary of the sales data by region. The summary will be located on the Analysis worksheet. a. Remain on the Analysis worksheet and select cell A4. b. On the Data tab, in the Data Tools group, click the Consolidate button. c. Verify that Sum is selected in the Function box. d. If there are any references in the All references box, click each and then click the [Delete] button to remove them. e. Click in the Reference box, and then click the Sales Data worksheet tab. Click and drag to select cells C3:E67. f. Click both the Top row and Left column check boxes. g. Click OK. h. On the Analysis worksheet, delete cells B4:B12, allowing the other cells to shift left. 5. Sort the sales data alphabetically by region and then by last name. a. Go to the Sales Data worksheet, and click any cell in the data set. b. On the Data tab, in the Sort & Filter group, click the Sort button. c. In the Sort dialog, expand the Sort by list, and select Region. d. Click the Add Level button. e. Expand the Then by list, and select Last Name. f. Click OK. 6. Add subtotals to the data to calculate the total commission earned for each sales associate. a. On the Data tab, in the Outline group, click the Subtotal button. b. Expand the At each change in list, and select Last Name. c. Verify that Sum is selected in the Use function box. d. Verify that there is a checkmark next to Commission Earned in the Add subtotal to box. e. Click OK. 7. Copy the subtotal data to the Analysis worksheet. a. On the Sales Data worksheet, click the outline level 2 button to collapse the list so only the total commission earned for each sales associate is visible. This will make it easier to copy the data. b. Select cells A3:G77 and copy them to the Clipboard. Do not include the Grand Total row (row 78). c. Go to the Analysis worksheet and paste the copied data beginning in cell A15. 8. Notice that when you paste the subtotaled data, Excel removes the subtotal grouping, but keeps the subtotal rows and formulas. You can use the Outline command to re-create groups based on the subtotal formulas. a. Click any cell in the data range. b. On the Data tab, in the Outline group, click the Group button arrow, and select Auto Outline. c. Click the outline level 1 button to collapse the list so only the total commission earned for each sales associate is visible. 9. On the Commissions worksheet, create a new conditional formatting rule to apply an icon set to the values in the Rating column. a. Go to the Commissions worksheet and select cells H3:H66. b. On the Home tab, in the Styles group, click the Conditional Formatting button. Click New Rule... c. In the Select a Rule Type box, verify that Format all cells based on their values is selected. d. In the Edit the Rule Description box, expand the Format Style list, and select Icon Sets. e. Expand the Icon Style list, and select 3 Stars. f. Click the Show Icon Only checkbox to hide the values in the selected cells. g. In the Display each icon according to these rules section, expand the first Type list and select Number. h. In the first Value box type 9500 to display a completely filled gold star when the cell value is greater than or equal to 9,500. i. Expand the second Type list and select Number. j. In the second Value box, type 5000 to display a partially filled gold star when the cell value is less than 9,500 and greater than or equal to 5,000. k. Click OK. 10. Sort the sales data so cells with the completely filled gold star icon appear first. a. Scroll down and find a cell with a completely filled gold star. b. Right-click a cell with a completely filled gold star, point to Sort, and select Put Selected Formatting Icon On Top. 11. On the Sales Data Filter worksheet, delete the conditional formatting rule that applies a font format to cells where the value is above average. a. Go to the Sales Data Filter worksheet. b. On the Home tab, in the Styles group, click the Conditional Formatting button. Click Manage Rules... to open the Conditional Formatting Rules Manager. c. If necessary, expand the Show formatting rules for list and select This Worksheet. d. Select the Above Average rule and click the Delete Rule button. e. Click OK. 12. Use the Advanced Filter feature to find sales greater than $120,000 for George Anderson or Mia Zhu. a. Remain on the Sales Data Filter worksheet, and insert four new rows above row 3, so the column label row is now row 7 and there are five blank rows between the title and the column labels. If necessary, clear all formatting from the new rows. b. Copy the range A7:G7 (the column labels) and paste in A3:G3. c. Enter the filter criteria in A4:G5 as follows: i. In A4, type: George ii. In B4, type: Anderson iii. In E4, type: >120000 iv. In A5, type: Mia v. In B5, type: Zhu vi. In E5, type: >120000 d. Click any cell in the data set. e. On the Data tab, in the Sort & Filter group, click the Advanced button. f. Verify that the Filter the list, in place radio button is selected. g. The List range box should display $A$7:$G$71. If it does not, click in the List range box, and then click and drag to select cells A7:G71. h. Click in the Criteria range box. Click and drag to select the range A3:G5 as the criteria range. i. Click OK. 13. The data in the Sales Data worksheet has changed since the PivotTable was created. Refresh the PivotTable to reflect the changes. a. Go to the PivotTable worksheet and click anywhere in the PivotTable. b. On the PivotTable Analyze tab, in the Data group, click the Refresh button. On the PivotTable Tools Analyze tab, in the Data group, click the Refresh button. c. In the PivotTable Fields pane, click Last Name to add the Last Name field to the Rows box. d. In the Rows box, click Last Name and move it above Client. 14. Add a calculated field to determine the average commission rate for each row in the PivotTable. a. On the PivotTable Analyze tab, in the Calculations group, click the Fields, Items, & Sets button. On the PivotTable Tools Analyze tab, in the Calculations group, click the Fields, Items, & Sets button. b. Click Calculated Field... c. In the Name box, type: Average Commission Calculated d. In the Fields box, click Commission Earned, and then click the Insert Field button. e. Type: / f. In the Fields box, double-click Annual Sales. g. The final formula in the Formula box should look like this: ='Commission Earned'/'Annual Sales' h. Click OK to add the calculated field to the PivotTable. i. Click any cell in the new calculated column. j. On the PivotTable Analyze tab, in the Active Field group, click the Field Settings button to open the Value Field Settings dialog. On the PivotTable Tools Analyze tab, in the Active Field group, click the Field Settings button to open the Value Field Settings dialog. k. In the Custom Name box, type: Average Commission l. Click the Number Format button at the bottom left corner of the dialog. In the Category list, click Percentage. If necessary, type 2 in the Decimal places box. m. Click OK. n. Click OK again to close the Value Field Settings dialog. 15. Apply a Quick Style to the PivotTable. a. Click anywhere in the PivotTable. b. On the PivotTable Design tab, in the PivotTable Styles group, click the More button to expand the gallery. On the PivotTable Tools Design tab, in the PivotTable Styles group, click the More button to expand the gallery. c. Click Light Blue, Pivot Style Medium 2. 16. Change the layout of the PivotTable to Tabular and repeat the item labels on every row. a. On the PivotTable Design tab, in the Layout group, click the Report Layout button and select Show in Tabular Form. On the PivotTable Tools Design tab, in the Layout group, click the Report Layout button and select Show in Tabular Form. b. On the PivotTable Design tab, in the Layout group, click the Report Layout button and select Repeat All Item Labels. On the PivotTable Tools Design tab, in the Layout group, click the Report Layout button and select Repeat All Item Labels. 17. Use slicers to filter the PivotTable by region to show only the SW2 region. a. On the PivotTable Analyze tab, in the Filter group, click the Insert Slicer button. On the PivotTable Tools Analyze tab, in the Filter group, click the Insert Slicer button. b. In the Insert Slicers dialog, click the Region check box. Click OK. c. In the Region slicer, click the SW2 button. 18. Filter the PivotChart data to show only the NW1 and NW2 regions. a. Go to the PivotChart worksheet and select the chart. b. On the PivotChart Analyze tab, in the Filter group, click the Insert Slicer button. On the PivotChart Tools Analyze tab, in the Filter group, click the Insert Slicer button. c. In the Insert Slicers dialog, click the Region check box. Click OK. d. In the Region slicer, click the NW1 button. Press the [Ctrl] key and click the NW2 button. 19. Apply a Quick Style to the PivotChart. a. Select the PivotChart. b. On the PivotChart Design tab, in the Chart Styles group, click the More button to expand the gallery. On the PivotChart Design tab, in the Chart Styles group, click the More button to expand the gallery. c. Click Style 8. 20. Save and close the workbook. 21. Submit project for grading.
Starting from: $8.90
More products
Managing Project Resources and Assignments
- First Online: 30 April 2020
Cite this chapter
- Gus Cicala 2
1345 Accesses
At the end of the chapter, the reader should be able to
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
- Available as PDF
- Read on any device
- Instant download
- Own it forever
- Available as EPUB and PDF
- Compact, lightweight edition
- Dispatched in 3 to 5 business days
- Free shipping worldwide - see info
Tax calculation will be finalised at checkout
Purchases are for personal use only
Institutional subscriptions
Author information
Authors and affiliations.
Wilmington, DE, USA
You can also search for this author in PubMed Google Scholar
Rights and permissions
Reprints and permissions
Copyright information
© 2020 Augustus Cicala Jr
About this chapter
Cicala, G. (2020). Managing Project Resources and Assignments. In: The Project Managers Guide to Microsoft Project 2019 . Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5635-0_8
Download citation
DOI : https://doi.org/10.1007/978-1-4842-5635-0_8
Published : 30 April 2020
Publisher Name : Apress, Berkeley, CA
Print ISBN : 978-1-4842-5637-4
Online ISBN : 978-1-4842-5635-0
eBook Packages : Professional and Applied Computing Apress Access Books Professional and Applied Computing (R0)
Share this chapter
Anyone you share the following link with will be able to read this content:
Sorry, a shareable link is not currently available for this article.
Provided by the Springer Nature SharedIt content-sharing initiative
- Publish with us
Policies and ethics
- Find a journal
- Track your research
IMAGES
VIDEO
COMMENTS
BUSI 201 Project Skill Review 8.1 Assignment.pdf - Doc Preview. Pages 6. Total views 8. Liberty University. BUSI. BUSI 201. AmbassadorSummer7314. 5/17/2022. View full document. Students also studied. BUSI 201_Project_Challenge Yourself 2.3 Assignment.pdf. Liberty University. BUSI 201.
Enhanced Document Preview: 11/18/21, 12:08 AM SIMnet - Assignment 14: Excel 2019 Skill Review 8.1 Print Info Student Name: Irvin, Kevion Student ID: [email protected] Username: kevionirvin Assignment 14: Excel 2019 Skill Review 8.1 COURSE NAME BUSI 201 (LUO) | 202140 BUSI 201-D05 In this project, you will analyze sales data using consolidation, subtotals, outlines, conditional formatting ...
Open the start file EX2019-SkillReview-8-1. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
Description. 11/14/22, 11:17 PM SIMnet - Project: Skill Review 7.1 Assignment Inserting a Shape (Skill 7.21) Applying Quick Styles and Other Formatting to Shapes (Skill 7.22) Creating a Chart Template (Skill 7.9) Adding and Removing Trendlines (Skill 7.11) Forecasting Values on a Trendline (Skill 7.13) Changing Trendline Options (Skill 7.12 ...
About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...
Project managers should avoid delegating without controlling (abdication), excessively checking in on team members' progress (micromanagement), and situations in which subordinates ask for help despite being capable of doing the work themselves (reverse delegation).
Click on the View tab. 2. In the Views group, click the Draft option. Change the file type of this document to Rich Text Format and save it with the name Document 1. 1. Click on the File tab and select Export. 2. Click Change File Type, and the double-click on the Rich Text Format. 3.
Written Assignment 2 - The project management team and the project team have a shared objective: to; Discussion Forum 1; Unit 7 - Discussion 7; ... 10 years, I see myself 100% involved in technical project management where I could implement my technical knowledge and project management skills to execute projects effectively and successfully.
Get help with homework questions from verified tutors 24/7 on demand. Access 20 million homework answers, class notes, and study guides in our Notebank.
Expediting. Motivating others. Sensitive to the politics of a situation. Additional project management skills: Establish credibility with others. Find creative solutions to problems. Tolerate ambiguity. Use a flexible management style—adapt your management style to changing situations.
A Skills Approach: Excel 2016 Chapter 8: Exploring Advanced Data Analysis 1 | Page Skill Review 8.1 Last Updated 4/4/18 Skill Review 8.1 In this project, you will analyze sales data using consolidation, subtotals, outlines, conditional formatting, advanced filters, PivotTables, and PivotCharts. Skills needed to complete this project: • Using Consolidate to Create Subtotals • Sorting Data ...
BUSI 201 Project Skill Review 8.1 Assignment solutions complete answers In this project, you will analyze sales data using consolidation, subtotals, outlines, conditional formatting, advanced filters, PivotTables, and PivotCharts. ... Open the start file EX2019-SkillReview-8-1. The file will be renamed automatically to include your name. Change ...
Design and build a network from scratch. Your design must include a minimum of one Cisco 4321 router, two Cisco 2960 switches, and two PCs. Fully configure the network and use IPv4 or IPv6 (subnetting must be included as a part of your addressing scheme). Verify the network using at least five show commands. Secure the network using SSH, secure ...
For this assignment, you will complete Hands-On Project 8-1 Test Subnet Boundaries in Packet Tracer. Follow the instructions for Steps 1-19. Answer the questions in Steps 4, 7, 10, 13, and 14 in a word processing document. Take a screenshot at the end of Step 19 and paste into the word processing document. *Skip Step 20.
Excel 2021 Skills Approach - Ch 2 Skill Review 2.1 - New Project. Excel 2021 Skills Approach - Ch 2 Challenge Yourself 2.4 - New Project. ... Test Bank Exam, or Timed Project assignment. The information on the screen includes the Student Name, Student ID, Assignment End Date, the Length of the Assignment and other assignment details as ...
View BUSI 201_Project_Skill Review 8.4 Assignment.pdf from BUSI 201 at Liberty University.
SIMpath Personal Assignment grades can now be automatically transferred into a student's SIMpath grade in the course gradebook. Previously, Personal Assignment grades had to be manually adjusted by instructors upon completion. ... Ch 8 Skill Review 8.1 - New Project. Excel 2019 Skills Approach - Ch 8 Challenge Yourself 8.4 - New Project ...
Below is the scenario for the course project assignment. You are assuming the role of the project manager for a company (you select the name) to provide a new product (Backpack with built in refrigerated pouch and radio module) to a customer (U.S. Army, Ground Forces and Special Operations). ... Initial Program review (at the customer's site ...
View BUSI 201_Project_Skill Review 7.1 Assignment.pdf from BUSI 201 at Liberty University. AI Homework Help. Expert Help. Study Resources. Log in Join. BUSI 201 Project Skill Review 7.1 Assignment.pdf - Doc Preview. Pages 6. Total views 18. Liberty University. BUSI. BUSI 201. AmbassadorSummer7314.
Assignments • Defining Project Resource Types with Microsoft Project 2019 • Assigning Resources to Tasks • Cost Planning • Task Constraints and Scheduling • Resource Assignment Review Exercise Learning Objectives for This Chapter At the end of the chapter, the reader should be able to: ... Figure 8-1. Resource types Chapter 8 Managing ...
View SIMnet - Assignment 10_ Excel 2019 Skill Review 7.1.pdf from BUSI 201 at Liberty University. 11/11/21, 1:03 AM SIMnet - Assignment 10: Excel 2019 Skill Review 7.1 Print Info Student Name: Irvin, ... Project- Skill Review 7.1 Assignment.pdf. Queens University Of Charlotte. BUSINESS 201. Trending in BUSI 201. Test 3.docx. Liberty University ...