Question: This portfolio project I don't know how to do. I need a complete one or a step by step directions for me. Scenario You are

This portfolio project I don't know how to do. I need a complete one or a step by step directions for me.

This portfolio project I don't know how to do. I need a

Scenario You are a Human Resources (HR) Representative working for XYZ Imports, a small business that has recently experienced a great deal of growth and expansion. XYZ Imports is a small company and has been managing its own payroll system. Now that the company is experiencing significant growth in business, with the signing of contracts with several more firms, there is a need to increase the company's workforce. The number of workers on the payroll is expected to double within the next four months, with more projected growth in the future. While this is certainly a good problem to have, it has also revealed that there is a need to improve how data is stored and managed to handle the increased volume of data. This has resulted in an immediate need to outsource the payroll to a third-party organization. The CEO has selected ADP, one of the largest payroll organizations in the United States. To set up the payroll with ADP, you must provide information related to each employee as mandated under the Fair Labor Standards Act (FLSA). ADP requested that this information is provided in an Excel Spreadsheet along with tables. Your job is to help prepare for this transition by creating the necessary items in Microsoft Excel Directions This project will help you demonstrate proficiency in Microsoft Excel. You will begin by completing data entry. Then, you will create a chart from the data to demonstrate Excel's capabilities for visualizing data. Next, you will transform the original data using the Power Query Editor to extract data from the original table into two new tables with related information. Finally, you will create of a fourth and final table using the time-and effort-saving VOIM112 - Portfolio Project Directions and Rubric 2 features, forms and macros. Throughout this project, you will utilize several features that will be useful to you as you progress through your academic and professional careers. Requirements and Formatting Your Portfolio Project must include the following: Data entered faithfully from source material 1 table created from original data entered Use of formula to generate Wages Paid by Pay Period column 1 clustered bar chart . 2 tables created using Power Query Editor . 1 table created using forms and macros Deadline Deliverable items for the Portfolio Project will be required at different points during the course. Details for each submission are included below in the Deliverable Descriptions, Deliverable Descriptions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!