Loading
Home › General Help › I have an excel project that needs to be complete. You wi...
Status: Completed

I have an excel project that needs to be complete. You will use Microsoft Excel 2010 to create a new workbook. This will be a fairly simple assignment for someone who is familiar with excel.

Date Posted: 19/03/2013
Category: General
Due Date: 20/03/2013
Instruction
I have an excel project that needs to be complete. You will use Microsoft Excel 2010 to create a new workbook. This will be a fairly simple assignment for someone who is familiar with excel.
Tutor Uploads
No File uploaded yet.
Bidders
tutor4U_d_971 13 years, 6 months ago
Rated 9.33 earned 53632.21 around 1383 assignments.
Hi. I`m familiar with excel.
$15.00
  • This is the assignment. Please let me know if you are still interested. Using Microsoft Excel 2010, create a new workbook that will be used to record the jobs performed and charges generated by a landscaping company. In the first worksheet, create columns for the employees of your landscaping business. Required fields for this worksheet include the following and you may add other fields if you wish: Employee_ID, First_Name, Last_Name, and Hourly_Wage You will add at least 10 records of your creation to populate this data. Sort in ascending order on Last_Name. Create a second worksheet that will hold the fields to maintain a client list. Required fields for this table include the following and you may add other fields if you wish: Client_ID, Client_Name, Client_ZipCode, HourlyBilling_rate (format currency with 2 decimal places) You will add at least 10 records of your creation to populate this data. All values are fictional. Sort in ascending order by Client_ID. Create a third worksheet to record jobs performed. Required fields for this table include the following and you may add other fields if you wish: Job_ID, Date, Client_ID, Hours_Worked, Employee_ID, Cost, Bill_Amount, Discount (format Cost, Bill_Amount, and Discount as Currency, 2 decimal places) You will add at least 20 records of your creation to populate this data. All values are fictional. The Employee_ID and Client_ID of each record in the Jobs worksheet must match a record in the respective Employees and Clients worksheets. Cost is a calculated field that must include a VLOOKUP function linked to the Employee worksheet Hourly_Wage field and multiplied by the Hours_Worked field. Bill_Amount is a calculated field that must include a VLOOKUP function linked to the Client worksheet and also multiplied by the Hours_Worked field. Discount is a calculated field with an IF statement that will show if the Bill_Amount minus Cost is greater than $100, then the discount is 10% of the Bill_Amount.
    User_624 | Mar 19, 2013, 02:54 AM
  • I get it am using Microsoft Excel 2007 will it be compatible?
    tutor4U_d_971 | Mar 19, 2013, 03:00 AM
  • I do not know.
    User_624 | Mar 19, 2013, 03:02 AM
  • I think they have the same features. assign it.
    tutor4U_d_971 | Mar 19, 2013, 03:03 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
ScholarPro 13 years, 6 months ago
Rated 9.98 earned 5625.81 around 69 assignments.
Hello kselli, I may help you again with this, if you want. Regards
$15.00
  • That would be great. You did wonderful last time. This is the assignment. Please let me know if you are still interested. Using Microsoft Excel 2010, create a new workbook that will be used to record the jobs performed and charges generated by a landscaping company. In the first worksheet, create columns for the employees of your landscaping business. Required fields for this worksheet include the following and you may add other fields if you wish: Employee_ID, First_Name, Last_Name, and Hourly_Wage You will add at least 10 records of your creation to populate this data. Sort in ascending order on Last_Name. Create a second worksheet that will hold the fields to maintain a client list. Required fields for this table include the following and you may add other fields if you wish: Client_ID, Client_Name, Client_ZipCode, HourlyBilling_rate (format currency with 2 decimal places) You will add at least 10 records of your creation to populate this data. All values are fictional. Sort in ascending order by Client_ID. Create a third worksheet to record jobs performed. Required fields for this table include the following and you may add other fields if you wish: Job_ID, Date, Client_ID, Hours_Worked, Employee_ID, Cost, Bill_Amount, Discount (format Cost, Bill_Amount, and Discount as Currency, 2 decimal places) You will add at least 20 records of your creation to populate this data. All values are fictional. The Employee_ID and Client_ID of each record in the Jobs worksheet must match a record in the respective Employees and Clients worksheets. Cost is a calculated field that must include a VLOOKUP function linked to the Employee worksheet Hourly_Wage field and multiplied by the Hours_Worked field. Bill_Amount is a calculated field that must include a VLOOKUP function linked to the Client worksheet and also multiplied by the Hours_Worked field. Discount is a calculated field with an IF statement that will show if the Bill_Amount minus Cost is greater than $100, then the discount is 10% of the Bill_Amount.
    User_624 | Mar 19, 2013, 03:35 AM
  • Tell me my deadline again, i'll start working immediately. Thanks
    ScholarPro | Mar 19, 2013, 03:47 AM
  • Wonderful. I will go ahead and assign it to you. I am loading the rubric as well. I have to have it by the 20th at the latest (tomorrow) although sooner is better. Thank you so much.
    User_624 | Mar 19, 2013, 03:53 AM
  • I uploaded the rubric. Please let me know if you have an issue with opening it.
    User_624 | Mar 19, 2013, 03:53 AM
  • Ok, Send me also the rubric. I will provide you within 6 hours today. I thank you.
    ScholarPro | Mar 19, 2013, 03:54 AM
  • Got it. You may assign it to me. Thanks a lot
    ScholarPro | Mar 19, 2013, 03:55 AM
  • Here is the file ready Regards https://dl.dropbox.com/u/78538175/Excel_Kselli_19032013.xlsx
    ScholarPro | Mar 19, 2013, 04:39 AM
  • Hello, hope you're doing fine. Please let me know whether you got the file and everything's all good. Take care.
    ScholarPro | Mar 20, 2013, 15:50 PM
  • I got it and it is perfect. Thank you! I have released the funds and left feedback.
    User_624 | Mar 21, 2013, 00:05 AM
  • Thank you very much once again.
    ScholarPro | Mar 21, 2013, 00:24 AM
  • Just one thing, it seems that feedback has not been received. Really appreciate if you can provide once again, if it allows. Sorry for bothering. Thanks
    ScholarPro | Mar 21, 2013, 00:41 AM
  • Not a bother at all. I will do it again. I had a hard time getting the payment to go through to so I am not sure what is going on. Let me know if it does not work please.
    User_624 | Mar 21, 2013, 01:51 AM
  • Just good it, thanks a lot..
    ScholarPro | Mar 21, 2013, 02:34 AM
  • I have one more assignment I am going to be posting for microsoft if you are interested. I am posting it in a minute. It is a small assignment.
    User_624 | Mar 21, 2013, 02:51 AM
  • Alright, let's post it, and see whether I can help with it.. Thanks for letting me know..
    ScholarPro | Mar 21, 2013, 02:53 AM
  • It is posted. Let me know if you would like more specifics about it. I do not like posting the instructions or links for everyone to see.
    User_624 | Mar 21, 2013, 03:04 AM
  • Ok, I replied to the post.. so ready to go.. Thanks
    ScholarPro | Mar 21, 2013, 03:08 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}