Advanced Excel Sheet Development
$10-30 USD
货到付款
We need an Excel expert to create a comprehensive and automated Excel workbook to track jobs, calculate payouts, and manage financials for two different companies: "CRST Solutions" and "LL Flooring". The workbook should include dropdown lists for easy data entry and formulas to automate calculations
we want to be able to add customers name account number date job was done. and calculate the number of jobs each installer did and how much they made including the company.
then what ever the company makes "gary calderon llc" should be didvided on excel to both partners who are
Argeliz pepin and Gary calderon
The chosen candidate should understand the intricacies of Excel 2019, as version 2404 Build 16.0.17531.20152 64-bit will be utilized. Excel skills such as Macros, Pivot Tables, VLOOKUP and complex formulas are necessary to accomplish the tasks.
The functionalities essential for this project are:
- Data Entry and Calculation: Accurate entries must be ensured and mathematical computations executed smoothly.
- Data Analysis and Visualization: Understand trends, patterns, and interpret the data graphically.
- Automated Reporting: Create reports updated in real-time using raw data.
The sheet will house in excess of three worksheets, hence requiring skillful management of complex workbook navigation and references.
Ideal applicants possess strong attention to detail and excellent problem-solving abilities. Familiarity with dynamic, interactive spreadsheets is also preferred. If you can visualize data in clear, creative, and insightful ways while establishing an easy-to-use data entry and reporting system, this project is for you.
项目ID: #38172179
关于项目
授予:
Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
有26名威客正在参与此工作的竞标,均价$26/小时
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how 更多
Sir, am an EXCEL Formula, VBA & MACRO , AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD and DATA ANAYSIS expert with advanced skills. About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA 更多
Hello, I have over 14 years of experience in reporting and data analysis. I have designed multiple dashboards and implemented VBA automation to reduce human intervention and enhance data accuracy. These dashboards and 更多
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver h 更多
As a seasoned Data Scientist and Programmer, proficient in cutting-edge tools such as SPSS, Tableau, Excel, VBA, and Python, I strongly believe I can deliver the advanced Excel sheet you require to streamline your oper 更多
Hi I am having 9+ years of experience in software programming and have experience in AWS C#, C, C++ Angular Python SQL Excel all types of DB operations Power BI dashboard development i can complete you work with good 更多
Hello, I'm excited about the opportunity to create a comprehensive and automated Excel workbook for "CRST Solutions" and "LL Flooring". I'll develop dropdown lists for easy data entry and implement formulas to automat 更多
As a BBA student I have lots of knowledge regarding this field. I also gain some experience throughout the internship. I am a fresher here but I am sure that you will love it at the end.
My greatest strength is the attention to detail, My ability to work in a fast-paced environment while maintaining accuracy of my work. My dedication towards task makes me a perfect candidate for this work and I am very 更多
I am very interested in the jobs posted here, I am skilled with Excel formulas for the program you want to create like Macros, Pivot Tables, VLOOKUP
I bring to the table a unique combination of data management, reporting, and automation skills that make me primed for this Excel project. With years of experience in using Excel as a powerful reporting tool, I have cr 更多
Hi, Brief background I am a Chartered Accountant (CA) based in Nepal with 3 years of experience in Audit Associates post qualification and 3 years of internship experience. CA is the highest professional degree in 更多
Hey, Expert in Excel formulas. I want to understand more on your requirements and can discuss further about the timeline and budget.