Find Jobs
Hire Freelancers

I need an excel expert

$30-250 AUD

完了済み
投稿日: 4年以上前

$30-250 AUD

完了時にお支払い
I have a big excel table from a supplier and I need to seperate all the data in to some sort of Pivot Table I would say, But my only issue is that in a lot of the cells there are majority variations of part numbers that need to be also put onto each line. I have uploaded a short file of what I am talking about. Sheet 1 Will have a small version of the table I have and Sheet2 has an example of how I need it layed out
プロジェクト ID: 22384725

プロジェクトについて

36個の提案
リモートプロジェクト
アクティブ 4年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi There, I can help you to seperate all the data in to some sort of Pivot Table as like you say, i have many experience using excel over 10 years, please kindly chat me,' thanks. Regards.
$50 AUD 2日以内
4.9 (15 レビュー)
4.6
4.6
この仕事に36人のフリーランサーが、平均$124 AUDで入札しています
ユーザーアバター
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 AUD 1日以内
4.9 (338 レビュー)
7.4
7.4
ユーザーアバター
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will transform your data from one format (sheet1) to another (sheet2). I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $100* and can deliver within a couple of days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$100 AUD 2日以内
4.9 (240 レビュー)
7.5
7.5
ユーザーアバター
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$100 AUD 2日以内
4.9 (241 レビュー)
6.9
6.9
ユーザーアバター
Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me. Roy
$100 AUD 1日以内
4.9 (354 レビュー)
6.9
6.9
ユーザーアバター
I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and info. The modules can upload external databases. There is a search engine with high search capability to find a specific record (or group). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password. I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience in implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace.
$250 AUD 7日以内
4.9 (88 レビュー)
7.1
7.1
ユーザーアバター
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Making the SKU column values are tricky it seems, as there are repetitions and they have been sequenced. Just clarify with a concise mini size input vs output. Willing to take up your project. Thank you, Regards.
$140 AUD 3日以内
5.0 (112 レビュー)
6.3
6.3
ユーザーアバター
Hi, I am an expert in Excel, I have checked the attached file and I can complete your project in 1 day using Excel Power Query. I am ready to start your project immediately, please send me a message to discuss further. Thanks
$50 AUD 3日以内
4.8 (81 レビュー)
6.0
6.0
ユーザーアバター
Hi, I have checked the excel sample that you attached to the project post and I can assist you to create the payhs for each part. Best regards, Florin Enache
$100 AUD 1日以内
5.0 (22 レビュー)
5.3
5.3
ユーザーアバター
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully and checked attached file. I can develop a macro to get data from sheet1 and arrange them same as sheet2. I have done many similar projects so can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$45 AUD 1日以内
4.8 (95 レビュー)
5.7
5.7
ユーザーアバター
Hi there, I saw that there are stacked data in your records and needed to be separated, each having a single row. Please tell me more about your data - how many rows of data do you have . we need to determine our best approach to solve the issue. I'll be standing by to help. Reggie
$80 AUD 2日以内
5.0 (9 レビュー)
4.3
4.3
ユーザーアバター
Hi Good Day! A serious freelancer here. I can help you to complete this project. I saw your file but need additional detail from you. Can you message so we can discuss it. I can make it automated using Excel Formulas and VBA Macro. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$100 AUD 2日以内
4.9 (36 レビュー)
4.5
4.5
ユーザーアバター
Hello! I offer you a macro that will create you a pivot table in one click. The macro can be launched using both hot keys and buttons on the ribbon. I will also provide you with any help on its use. If necessary, I will make any minor changes to the macro for free within a week after ordering. If you are interested in my offer, please open a chat for more details.
$50 AUD 2日以内
5.0 (1 レビュー)
2.6
2.6
ユーザーアバター
Hi hope you are doing well. I can make pivot tables as per your need. please explain what is majority options of numbers means? let me hear from you. thanks
$55 AUD 1日以内
5.0 (1 レビュー)
1.1
1.1
ユーザーアバター
I am very good in excel and it’s functionality. I would be able to get it done in 2 days time(max) . Hope that I will be selected for the project. I have 11 years of experience in using MS office products.
$250 AUD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello, Thanks for reviewing my proposal on your project. I am expert in all type of data entry work (Ms Excel, Word, PowerPoint PDF to word excel conversion). I’ve more than 15 years’ of experience in document management. I’ve a passion for accurate data entry. I am looking for a long term relationship. If you award me a project I will prove myself as dedicated resource. I can give you a free sample of my work in a day. Regards
$30 AUD 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, I'm interested in the project, I have extensive knowledge of Excel, I expect contact for more details.
$100 AUD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi, I have few years experience with excel as a business analyst and financial analyst. I can do your job in max 2 days. Cheers,
$150 AUD 2日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello sir, I'm a professional freelancer with 2 years of experience. I can do this job because it is my expertise. Everything will be done within the time frame. Relevant Skills and Experience - data entry - microsoft words - microsoft excel - data processing - pdf I will make sure everything will rum smoothly. Any amendments are up to 2 times only. Feel free to message me.
$222 AUD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi there! I am Baldwin Vargas, and I am a newbie here in the freelancing world. And it would be a real pleasure if you will be my first ever client. So I looked into the sample spreadsheet you attached herewith. And run it through the problem description and specs you indicated. From what I understood, you want to list down all SKU codes coming from the different product columns (those that come after Make, Model Name, Model Year columns). And across the SKU codes are their corresponding Make, Model Name, and Model Year. And what makes this task complicated is that SKU codes could be assigned to different Make, Model Name, and Model Year. And vice versa. Also, as you mentioned, some Make, Model Name, Model Year has no assigned SKU codes for all kinds of products. So I don't think there's any built-in Excel function that could produce your intended output. It is best to write a Macros to produce the output you specified. The basic design of the program is for it to cycle through all the SKU codes, row by row, and just outright print the corresponding Make, Model Name, and Model Year. We could probably extend the functionality into listing as well what kind of product is a particular SKU and sort them accordingly. I have an existing VBA project that does some of the things I mentioned above, and I can definitely reuse some of them. Will you give me the chance of working with you? I think I can finish this project in 5 days for $150.
$150 AUD 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
With a good efficiency, I can complete this task in a needed time. I have some skills required to complete this task and otherwise I'm a hardworking person to complete this project.
$111 AUD 2日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

AUSTRALIAのフラグ
Helensvale, Australia
5.0
1
お支払い方法確認済み
メンバー登録日:11月 18, 2019

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。