Advanced Excel Sheet Development

已完成 已发布的 7 个月前 货到付款
已完成 货到付款

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.

Excel Visual Basic 数据输入 数据处理 Visual Basic的应用程式

项目ID: #38172179

关于项目

26个方案 远程项目 活跃的7 个月前

授予:

axiomswb

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..

$40 USD 在1天内
(57条评论)
7.0

有26名威客正在参与此工作的竞标,均价$26/小时

amokhtar70

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 更多

$30 USD 在3天内
(44条评论)
5.5
sareheshak

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 更多

$20USD 在1天里
(35条评论)
5.2
Jatin77777

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 更多

$30 USD 在2天内
(28条评论)
4.8
syedalihassansh4

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 更多

$20USD 在1天里
(13条评论)
2.6
malaikamb2001

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 更多

$10USD 在1天里
(3条评论)
1.8
esratechnologies

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 更多

$20 USD 在7天内
(1条评论)
0.7
imandaneshi1

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 更多

$30USD 在1天里
(0条评论)
0.0
gloria033

I can generally compile up to 10 pages of lecture notes per day. I’m interested to hear more about the project and the subject matter of the lectures. If you award me the project, I’d be pleased to discuss this further 更多

$30USD 在1天里
(0条评论)
0.0
manishniroula8

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.

$20 USD 在2天内
(0条评论)
0.0
yoursathished7

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 更多

$20 USD 在7天内
(0条评论)
0.0
DetriKartika

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

$40.35 USD 在7天内
(0条评论)
0.0
elsevarsultanov

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 更多

$20 USD 在7天内
(0条评论)
0.0
CaAvinashsingh

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 更多

$20 USD 在7天内
(0条评论)
0.0
gauravsngarg

Hey, Expert in Excel formulas. I want to understand more on your requirements and can discuss further about the timeline and budget.

$75 USD 在3天内
(0条评论)
0.0
akmal3008

Hello! My name is Muhammad Akmal bin Zainuddin from Malaysia. I have an experienced in data entry and a broad knowledge on data entry almost 1 years now. I understand that you are looking for a skilled Advanced Excel S 更多

$20 USD 在7天内
(0条评论)
0.0