Find Jobs
Hire Freelancers

Need to make an MS excel work.

$10-30 CAD

Terminado
Publicado hace más de 3 años

$10-30 CAD

Pagado a la entrega
Data File needed for this Case Problem: [login to view URL] Cross State Trucking Brian Eagleton is a dispatch manager at Cross State Trucking, a major freight hauler based in Chicago, Illinois. Brian needs to develop a workbook that will summarize the driving log of Cross State drivers. Brian has a month of travel data from one the company’s drivers and wants you to create a workbook that he can use to analyze this data. Complete the following: 1. Open the [login to view URL] workbook located in the Excel1 > Case1 folder included with your data files. Save the workbook as NP_EX_1_Trucking in the location specified by your instructor. 2. Change the name of the Sheet1 worksheet using Travel Log as the name, and then move it to the end of the workbook. Rename the Sheet2 worksheet using Documentation as the name. 3. In the Documentation sheet, enter your name in cell B3 and the current date in cell B4. Move the Documentation sheet to the front of the workbook. 4. Go to the Travel Log worksheet. Resize the columns so that all the data is visible in the cells. 5. Between the Odometer Ending column and the Hours column, insert a new column. Enter Miles as the column label in cell I4. 6. In the Miles column, in the range I5:I25, enter formulas to calculate the number of miles driven each day by subtracting the odometer beginning value from the odometer ending value. 7. Between the Price per Gallon column and the Seller column, insert a new column. Enter Total Fuel Purchase as the label in cell N4. 8. In the Total Fuel Purchase column, in the range N5:N25, enter formulas to calculate the total amount spent on fuel each day by multiplying the gallons value by the price per gallon value. 9. In cell B5, use the COUNT function to calculate the total number of driving days using the values in the Date column in the range D5:D25. 10. In cell B6, use the SUM function to calculate the total number of driving hours using the values in the Hours column in the range J5:J25. 11. In cell B7, enter a formula that divides the hours of driving value (cell B6) by the days of driving value (cell B5) to calculate the average hours of driving per day. 12. In cell B9, use the SUM function to calculate the driver’s total expenses for the month for fuel, tolls, and miscellaneous expenditures using the nonadjacent range N5:N25,P5:Q25. 13. In cell B10, use the SUM function to calculate the total amount the driver spent on fuel using the range N5:N25. In cell B11, use the SUM function to calculate the total amount spent on tolls and miscellaneous expenses using the range P5:Q25. 14. In cell B13, use the SUM function to calculate the total gallons of gas the driver used during the month using the range L5:L25. In cell B14, use the SUM function to calculate the total number of miles driven that month using the range I5:I25. 15. In cell B15, enter a formula that divides the total miles (cell B14) by the total gallons (cell B13) to calculate the miles per gallon. In cell B16, enter a formula that divides the total expenses (cell B9) by the total miles driven (cell B14) to calculate the cost per mile. 16. Cross State Trucking wants to keep the cost of driving and delivering goods to less than 65 cents per mile. If the cost per mile is greater than 65 cents, enter over budget in cell B4, otherwise enter on budget in cell B4. 17. In cell A1, increase the font size of the text to 28 points. In cell D3 and cell L3, increase the font size of the Mileage Table and Expense Table labels to 18 points. 18. Change the worksheet to landscape orientation. Scale the printout so that the worksheet is scaled to 1 page wide by 1 page tall. If you are instructed to print, print the entire workbook. 19. Save the workbook, and then close it. For example you can the work done on different question in the attachments.
ID del proyecto: 27425518

Información sobre el proyecto

23 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
$0 CAD en 1 día
4,9 (169 comentarios)
6,5
6,5
23 freelancers están ofertando un promedio de $21 CAD por este trabajo
Avatar del usuario
HI There, I read your full instruction and check screenshoots. I can complete the assignment accourding to the instruction with 100% accuracy. I have already done as like as some assignment before for a student. to check my previous assignment experience send me a massage. Please, send me the files to start the assignment. Lets discuss in chat. Thanks Rubel Ahmed
$15 CAD en 1 día
5,0 (87 comentarios)
4,8
4,8
Avatar del usuario
__________________I am available right now______________________ Hi there, Quality and time is my commitment. I read the description and I am sure I can do this task perfectly. I want to say that, I will start right now and funds will be after your satisfaction. Consider!
$50 CAD en 1 día
4,9 (42 comentarios)
4,7
4,7
Avatar del usuario
Dear Employer, You have specified that you need an MS excel work.. I'm a professional Data Entry Expert with 7+ years of experience. I've read your project description carefully. I have worked on several similar projects and can deliver quality projects to tight deadlines. Here is a sampling of the data entry projects I’ve completed: https://www.freelancer.com/projects/data-entry/Project-for-Abdul-26795214 https://www.freelancer.com/projects/data-entry/Build-list-blogs-26649667 https://www.freelancer.com/projects/web-scraping/need-professional-web-scraper-27100683 I can do this project very carefully within the provided time. Best regards @Servicehour24
$30 CAD en 1 día
5,0 (6 comentarios)
4,6
4,6
Avatar del usuario
Hi, I have read the job description carefully and I would love to work on these project. I am available to start the work now if required. Looking forward to hear from you.
$15 CAD en 7 días
5,0 (13 comentarios)
4,1
4,1
Avatar del usuario
HI, I have checked the project : Need to make an MS excel work I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visualization Dashboards and i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks
$30 CAD en 1 día
4,4 (11 comentarios)
3,3
3,3
Avatar del usuario
Hi there, I can do this project right now with 100% accuracy. If you need any sample please let me know. I am an Expert in make an MS excel work.. I have no project in my hand so that I can start your project right now. I work efficiently and will finish in a timely manner and will provide high quality work. I am waiting to your quick positive reply and if you have any questions, feel free to ask me. Thanks! K P Janaka
$20 CAD en 1 día
5,0 (6 comentarios)
2,4
2,4
Avatar del usuario
Good Day! Hello I'm Rolyn Rose Sanoy. I have work with excel for almost 5 years. I can managed to work with your service needed and submit it on time. I offer excellent service in the following software and tools: * Microsoft Office, Word, Excel, Powerpoint If you need my assistance/service just chat or email me . It's my pleasure to give you my service . Thank you and more power!
$20 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello I read your work description so I can do it with full satisfaction and within minimum budget. I have experience in the same work and I can do it according to your requirements. thanks
$20 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am a professional expert in excel I can take care of all the things according to the description I promise to deliver 100% error free work, lets discuss on chat.
$10 CAD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have seen the task along with the attachments you have posted. I am a data entry professional and have good knowledge and experience with working in excel. I will complete the task accurately within the deadline and I am sure you will be content with my work. Looking forward to hearing from you. Thank you.
$15 CAD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
HI, I am interested in this project. I am having experience of working with excel file format about 25 years in Multinational company. Please chat with me. Regards Ramesh
$20 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a professional in Database management. Already working as a Team Manager MIS for past 12 Years. Having more than 12 years experience in Data Base Management. expert in Excel ,Word, data entry and Proofreading.
$19 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Not hardworker but smart worker only can do best for this project while being punctual on the given time by the clients or company
$20 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am ready to do this sir . I have understand all what I have to do I will do this work . very fast in 2 days . I hope you will give me this work..
$30 CAD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hi i am fenil , I would like to complete your task within your days requirements with honestly . Also i will provides my best for this task. I hope i will get positive responds from your side .Thank you.
$16 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi! I have more than 5 years experience in data entry and database management. I have read the step-by-step guide that you wanted to be incorporated in the worksheet. I can do a simple worksheet based on your needs or I can use Excel VBA to make a cleaner user interface. The formula will be incorporated in the VBA and will be protected from unwanted or accidental changes if there are many users that will use the file. Using Excel VBA, formatting and printing (to pdf if you prefer) of the needed sheet can also be done by clicking a button that will be created in the sheet. Kindly message me if you want my assistance. Thank you.
$25 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Iam love these type of data entry works. And iam doing these works for my satisfaction and my pocket money
$10 CAD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I m a professional data entry specialist.i can make project fastly and I have many experience for it.
$20 CAD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hii sir I am interested to do this assignment I am new in freelancer but I have 3 year of experience. so please give me a chance and I will do my best. thank you , (satyam)
$20 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hey there, I am very interested your projects. I have free time these days. So, i can deliver the work on time. Kindly, be sure that your work will we delivered with 100 % high quality. My name is shubham kumar. I am a data entry specialist. And i went to get your work done as quickly as possible. Thank you.
$15 CAD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Vancouver, Canada
5,0
4
Forma de pago verificada
Miembro desde jun 23, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.