Find Jobs
Hire Freelancers

Voicecall and teach me how to sort my data and create automated dashboard (Excel) in power query/ pivot table/ VBA

€12-18 EUR / hour

Completed
Posted over 3 years ago

€12-18 EUR / hour

I have a pretty messed up data source (data moved to the wrong columns, multiple cell groups need to be moved to the right location) and the data also has to be sorted out by different Thresholds. In the end I need to plot only those cells that meet all 6 Thresholds in a bar diagramm. I want to have a fully automated dashboard where I can change the threshold values and data source for future probes. I need somebody who can teach me how to accomplish this on my zoom call in either english or german language. You need to have expertise in power query, Pivot charts and probably also VBA. Thank you for helping me!
Project ID: 29173223

About the project

10 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
€0 EUR in 2 days
5.0 (43 reviews)
5.3
5.3
10 freelancers are bidding on average €14 EUR/hour for this job
User Avatar
Sehr geehrter Simeon V.,   Wir haben 20 Jahre Erfahrung in PHP, Visual Basic, Data Processing, Data Entry, Excel, daher können wir dieses Projekt erfolgreich abschließen. Bitte überprüfen Sie unser Profil hier: https://www.freelancer.com/u/tangramua Hier finden Sie detaillierte Informationen zu unserem Unternehmen, unserem Portfolio und den jüngsten Bewertungen des Kunden. Außerdem wollten wir persönlich Fragen zu Ihrem Projekt besprechen, um Ihnen die richtige Einschätzung zu geben.   Freundliche Grüße, Verkaufsabteilung Tangram Canada Inc.   P.S. Wie Sie aus den Details Ihres Profils ersehen können, befinden Sie sich in Europa. Seien Sie informiert, dass sich unsere technischen Büros in der Ukraine befinden, d. H. Sie können mit unseren Entwicklern fast in derselben Zeitzone arbeiten.
€15 EUR in 5 days
4.9 (116 reviews)
7.8
7.8
User Avatar
--EXCEL EXPERT I CAN START NOW ---------- Hello Sir I can do this work as you want please ping me 100 % accuracy Thanks Anowar
€12 EUR in 40 days
5.0 (266 reviews)
6.4
6.4
User Avatar
Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in -  Macros  Formulae  VBA  User forms Willing to share a sample of my work done on various excel applications on this platform.
€12 EUR in 40 days
4.9 (55 reviews)
5.3
5.3
User Avatar
I have knowledge of Microsoft office. I have 6 month of experience in data entry and typing. You can expect high accuracy on my work.
€15 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, Greetings! I can help you in your project perfectly from now. I am available for 48 hours in a week. I have left my job to work here and earn more by providing quality work on time. So, I am looking for the opportunity to prove me as a Expert Worker. I have read your project thoroughly. All the requirements matched with my skills exactly what I am looking for. My Educational Background and Experiences are following;  Bca  2 years as Virtual Accountant  Expert in Bookkeeping and Accounting, Financial Statement preparation, Bank Reconciliation, Taxation, A/P and A/R Management, Payroll, Inventory, Data Entry & Typing, Social Media Management  Skilled in Ms Office with Advanced Excel and Formulas, Google Sheets, Customer support, Tally, Quickbooks I can work with your project perfectly as per your requirements and instructions. Please award me the project so that we discuss more in it. Regards,
€15 EUR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a certified data entry operator. My language has a quality to impress anyone else. so I would like to do this job.
€12 EUR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Respected Sir / Madam, I have seen your excel file, read your requirements. But what type (Format ) of multiple cells have grouped. It may paste / retrieve on right location, perhaps one by one, because after the separation / split of columns through command, data type of column may be effected. Second in Excel one work can do with different sketches. Is it necessary to do it with the help of Pivot Chart / table. Pivot chart can do different types sorting of Columns and rows with an auto sum reply in required column. We can do all of this with some specific programming in Excel. Lastly from the shared 3 sheets grouped data columns and pivot table type is not clear. Please tell us, what you want actually? What if these 6 columns would be shown with a different pattern? What if diagram will be shown with stacked bar chart or pie chart?
€15 EUR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Hagen, Germany
5.0
3
Payment method verified
Member since Dec 6, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.