Create Automated dashboard from Excel file [For Executive Presentation]

$40-50 USD

Selesai

Disiarkan

lebih dari 1 tahun yang lalu

$40-50 USD

Dibayar semasa penghantaran

Due date: within 12 hours. I need help creating a colorful/visual dashboard from Excel. Goal: 1. The goal is for the dashboard to show progress of ticket status (in progress, planned or complete) per owner. Example - if John has 12 tickets with 2 complete and 10 in progress, I want to be able to filter the pie chart or histogram to show that information per owner. 2. Macros: I want a separate datasheet where I can update daily data that will reflect in the dashboard. 3. This data will be updated daily to show reduction in open tickets so I want to be able to upload a new data file to refresh the dashboard. Create a 'click here' macro that I can click to enable data refresh breaking down the data by task number, customer name, ID, etc. For rows without customer name, 0 will populate in those tabs. 4. I need something colorful and executive level quality that's compatible with google sheets. I attached a simple file that shows the customer's name and ID, the task number and the status of the ticket (open or closed). Please share a sample of colorful dashboards that you've created.

ID Projek: 34267266

Tentang projek

34 cadangan

Projek jarak jauh

Aktif 2 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@finecodervw

$0 USD dalam 1 hari

4.9

(123 ulasan)

6.5

34 pekerja bebas membida secara purata $57 USD untuk pekerjaan ini

@daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.

$40 USD dalam 1 hari

4.8

(186 ulasan)

7.1

@onlinejob247

Hi, I am ready to start right now ! Ok understood, Honestly, since I don't have a job at the moment, this would mean a lot to me, and I have free time.. * I assure you of smooth communication and high-quality work. * I am online 24/7 and will work whenever you contact me. * You will definitely be 101% satisfied with the end result. If you are available for a chat please leave a message on my chat box. If you want to know about my work experience you can check out my portfolio. https://www.freelancer.com/u/onlinejob247 Best regards Mohiuddin

$50 USD dalam 1 hari

4.9

(136 ulasan)

6.7

@Muhammad6979

Dear Sir/Madam, I am excel expert and create a colorful and dynamic dashboard. I am expert Accountant, writer, researcher, and bookkeeper. I am ACCA (Chartered Accountant). I am expert in EXCEL, QB, XERO and WAVE. You can see my profile. I do have the ability to complete the assigned task within an agreed period of time. Thanks and Regards Muhammad Ilyas Saeed

$50 USD dalam 3 hari

5.0

(104 ulasan)

6.2

@merinsinha

In 12 hours. Beautifull Automated Dashboard. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.

$80 USD dalam 1 hari

4.8

(142 ulasan)

5.6

@raoarslan56

Here sir, I am expert in excel I will create you interactive colourfull dynamic dashboard within 12 hours... I can start rightnow... Teext me to discuss more about the project please...

$45 USD dalam 1 hari

5.0

(33 ulasan)

5.3

@Barroga17

MICROSOFT EXCEL EXPERT Hi I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me to discuss. Regards!

$40 USD dalam 1 hari

5.0

(35 ulasan)

4.9

@hayteekeys

Hi, I'm a great professional virtual assistant and expert in Data works or projects..i am well versed in these areas: - Data mining - Data entry - Excel - Data processing -Automation tools -VBA - Web scraping -Financial Analysis - MySQL -Advanced Excel -Automatioin -MS Office -Python - Oracle -PowerPointMacros -Excel and VBA automation and so on I have about 8 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am an expert in my field, who knows the value of time, very hard working and always delivers the work on time. I make sure i deliver the work well in advance with continuous communication & timely response until satisfactory completion of the project. I always deliver 100% Satisfaction to the client. I hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D

$45 USD dalam 1 hari

4.9

(18 ulasan)

4.6

@rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

$40 USD dalam 1 hari

5.0

(20 ulasan)

4.0

@Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, tables, absolutely any request will be satisfied. If necessary, I will write accompanying documentation or video. Ready to solve a problem of any level of complexity. Services Offered: ✅Automating Tasks. ✅Data Validation. ✅Data Analysis. ✅Custom Formulas. ✅Creating User Forms. ✅Charts. ✅Pivot Tables. ✅Formatting, Fixing, Forms, Formulas, Functions. ✅VBA Macros Automation. ✅Web Scraping/Data Mining from any website and any amount of data. ✅Data collection, Images Downloadable / Images URL. At any time ready to provide support on emerging issues. I am happy to provide after-sales support, you can always count on me. ""✌️People like surprises and here I come into play, to present your ideas to the world in the best manner✌️"". Please don't waste your time looking around. Please feel free to contact me. I'm ready to start your project. Thanks in advance!"

$80 USD dalam 2 hari

4.7

(15 ulasan)

3.8

@wilfrednjorog

Hey! I have vast experience in Excel, Excel Macros, Data Processing and Excel VBA, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to work on a freelance basis if that is what you prefer. I look forward to hearing from you soon! Thank you for your time. Thanks & regards - Wilfred

$100 USD dalam 3 hari

0.0

(0 ulasan)

0.0

@satindersaini07

Hi Dear! We have read your requirement. We can do it. I can complete your project on time and within your budget. Skills: C#, ASP.NET, VB.NET, SQL, EXCEL, PHP/MySQL, CodeIgniter, Angular, Html5/css3, JavaScript, jQuery, Ajax, NodeJS, PHP

$50 USD dalam 7 hari

5.0

(1 ulasan)

0.0

@azeemyounas1997

Hey There! I am Certified MS-Office Suite professional. I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform; Data Analysis Data Visualization Automation Complex calculations. Hoping to hear from you. Feel free to provide further info via chat. Thanks and regards, Azeem Younas

$40 USD dalam 1 hari

4.0

(1 ulasan)

0.0

@Ronakpatel23

I am Good And Unique in Data entry. If you got a good work than i recommend To me. And i give my best in this work. Your project is completely my responsibilities. My good experience in this work. My typing speed is Very fast and i complete your project in short time because i Love this work and You don't Worry about your project it's completely my responsibilities

$42 USD dalam 5 hari

0.0

(0 ulasan)

0.0

@munirkasuri11

Hello! I am expert and professional in this work, I have read all your details and I will work on your project with low price and unlimited revisions. Give me this project and get extraordinary and 100% work. Thanks ? Regards UMAIR

$40 USD dalam 1 hari

0.0

(0 ulasan)

0.0

@imd001418

Hey! My name is Imran Ahmad. I have a great Mis executive experience in data processing, data enty and excel. So i make your work like a masterpiece. I am a dedicated freelancer.

$45 USD dalam 7 hari

0.0

(0 ulasan)

0.0

@jeevarajagopal

Dear Concerned, Having around 20 Years of experience in Excel, I will be able to complete your project on time and deliver it you. Looking forward to hearing from you on the project. Thanks & Regards Jeeva Rajagopal + 91 7305827113

$45 USD dalam 1 hari

0.0

(0 ulasan)

0.0

@rathodvenky59

I can do your work as soon as possible and i will do my work in my responsibility......, I will do my work at

$45 USD dalam 7 hari

0.0

(0 ulasan)

0.0

@dikshantpatil200

i think i will do your work properly because i recently done same project of my another client, if yo give me this project then i will do great work..

$40 USD dalam 1 hari

0.0

(0 ulasan)

0.0

@shreyasgowda12

As a Data Analyst, reliable, and highly experienced Freelancer with expertise in Data Analytics, Google Analytics, Google Data Studio, Process Automation, SQL, BIG Data, Tableau, Power Bi, Data Visualisation.

$40 USD dalam 1 hari

0.0

(0 ulasan)

0.0

@harsh8in2000

I have worked such kind of Excel VBA Applications. Created more than 60 such applications in the One of the Big Investment Bank. I have created some sample on your sample data. Lets discuss and I can show you. Let me know.

$50 USD dalam 15 hari