
In Progress
Posted
Paid on delivery
Excel File: Using the data files assigned to you, find the interesting “story” that is contained in the data and build a dashboard to visually illustrate “your story” to a user who is unfamiliar with the data file. Include these ten elements plus any other Excel skills that help tell “your story.” 1. Data combined from more than one file by Power Query (Get Data/From Folder) 2. Data sorted (largest to smallest or alphabetically, etc.) 3. Pivot table(s) 4. Slicer(s) 5. Time-line slicer(s) (see video on how to convert your years to a date format) 6. Pivot chart(s) 7. Conditional formatting 8. “Filtered” data 9. A “Top-5” and/or “Bottom-5” list Optional skills, including: 10. Data resulting from a LOOKUP type, OFFSET or INDEX formula 11. Data that results from a SUMIF, COUNTIF or AVERAGEIF formula 12. Two-dimensional or three-dimensional map 13. Adding entry validation on interactive cells (a drop-down list) 14. Macro(s) with button(s) You can include other elements and repeat elements, but make sure your file includes the basics. Label and organize your backup sheets (where you did your data work and analysis) so they are easy to follow. You MUST include information from at least two different source files in your dashboard.
Project ID: 38842904
56 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi, My extensive skill set in Excel and PDF means that I have the necessary expertise to bring your dashboard project to life. I'm well-versed in all the elements required for this task including Power Query, Pivot tables, Pivot charts, and Conditional formatting to name just a few. My ability to merge data from multiple sources using Power Query will elevate your dashboard to new heights - ensuring your story is accurately told. In addition to the basic requirements, I can also provide added-value skills such as LOOKUP-type formulas and INDEX formulas which aid in presenting complex data meaningfully. My proficiency in Excel macros will be an asset in creating a user interface that enhances interaction with your dashboard. One thing that sets me apart is my proven ability to deliver real results. In everything I do, whether it's working with big brands or small businesses, my end goal is always the same - increasing revenue and driving growth. I've achieved remarkable milestones across various industries, including a 40% increase in revenue in one year for an e-commerce company. Let's combine my data-driven approach with your challenging project requirements to create a meaningful narrative from raw information - transforming it into an invaluable tool for impact decision-making. Thanks.
$200 USD in 3 days
3.7
3.7
56 freelancers are bidding on average $366 USD for this job

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$220 USD in 4 days
8.6
8.6

"""""""""""""""""""ADVANCE EXCEL DASHBOARD EXPERT"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$99 USD in 1 day
7.5
7.5

With extensive experience in finance and data analytics, I am confident in my ability to thoroughly analyze your data and create a compelling story. My proficient skills in Excel and programming language like Visual Basic allow me to leverage features such as Power Query to efficiently combine the data from multiple files, sort it according to your preferred criteria, and effectively use Pivot tables and slicers to provide valuable insights. In addition, I can create Pivot charts that bring clarity to complex information and apply conditional formatting to highlight crucial aspects of the dataset. I particularly enjoy solving complex problems using advanced formulas like LOOKUP, SUMIF, COUNTIF or OFFSET, which can add depth to your story. Furthermore, my proficiency extends to map generation, entry validation, and even macro implementation for a seamless user experience. Throughout the project, I promise to maintain clear and organized backup sheets that you can easily follow. Moreover, by including information from at least two different source files in the dashboard as required, I aim to provide a comprehensive and enriched understanding of your data set. Open to feedback and aiming for client satisfaction through exceeding expectations, I offer continued support even after the project completion. Let's discuss your project further.
$40 USD in 1 day
7.4
7.4

Hi, Are you looking for professional dashboards and reports in Power BI that represent your brand's value, you've come to the right place. With my expertise in interactive design and solving complex calculations, I can create a dashboard that meets your needs. Things I would love to do for you I can load your data in Power BI Desktop, do proper data modeling, and then Create Professional Power bi Dashboards and power bi reports with great Data visualization in power bi including Filters Cards to make it Attractive so you can share power bi visualization with your colleagues/clients. I can use DAX Functions in power bi to create new columns, measures I can troubleshoot and fix any issue you are facing related to Power bi DAX Measures, power query, and M language in Power bi I can publish the report to your Power Bi service account and prepare the Dashboard as per requirement. I can Refresh the Power Bi report in Power-bi per the user-specified timetable. And Lot More
$220 USD in 7 days
6.4
6.4

Hi there! I Understand the value of accurate and efficient data entry. My expertise in Data Processing, ⛔Data-Entry⛔Excel⛔VBA-Macro⛔Power-BI & Accountant⛔PDF⛔ MS⛔Visual Basic⛔Data Processing⛔Excel⛔Excel VBA⛔Excel Macros will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Choose me for this project and let's achieve your goal together! Cheers!
$30 USD in 1 day
4.5
4.5

Hello, I am writing to show my interest in your posted project. With extensive experience in using Microsoft Excel for financial analysis, financial management, interactive dashboards, data analysis, reporting, templates, and management, I am excited about the opportunity to contribute to your team. In my previous role as a freelancer on various sites, I utilized Excel to streamline data entry, dashboards, KPI Dashboards, Financial analysis, and reporting processes, allowing the team to make more informed decisions. Key highlights of my experience include advanced Excel skills, data analysis, visualization through charts, graphs, and dashboards, and providing insightful reports for senior management, automation, macros, error reduction, and data management. Please drop me a message for further discussion. Regards Farah Khan
$250 USD in 7 days
4.4
4.4

Hello, I have prior experience in excel dashboard creation and based on the requirement mentioned I can work for it.I have 7 years of experience in software engineering. Let's connect
$140 USD in 2 days
4.4
4.4

Hello ! I am confident in delivering accurate and comprehensive results for this project. My experience with Data Entry, Visual Basic, Data Processing, Excel and PDF makes me the ideal candidate for this job. My knowledge and passion for this field will ensure the project is completed quickly and efficiently. I am available to start immediately upon your approval. Please message me. Sincerely Bredah
$140 USD in 2 days
3.9
3.9

Hi, I can create an interactive Excel dashboard to uncover and visually present your data's story. With 15+ years of experience, I’ll combine data from multiple files using Power Query, include pivot tables, slicers, and conditional formatting, and ensure it features Top-5/Bottom-5 lists, advanced formulas, and dynamic filtering. The dashboard will be clear, user-friendly, and include organized backup sheets for easy updates. Let’s collaborate to turn your data into actionable insights. Thank you, Ayaz Akhtar
$70 USD in 1 day
4.1
4.1

With 7+ years of professional experience under my belt, I'm equipped with a plethora of skills in cleaning and analyzing data, developing impactful dashboards for both calculations and communication. Proficient in Excel, I have complete immersion in leveraging the Microsoft Power BI platform which is just what you need for this project. I've got proven expertise in building Power BI reports by extracting data from different dynamic sources (a skill you outlined) and using them to develop visually appealing dashboards. My main goal is not only churning out metrics but providing a meaningful story as your project demands. For instance, with the power of Advanced Power BI Reporting, I can sort and filter data, make use of time-line slicers while incorporating conditional formatting techniques to make your message more compelling. I completely understand the need for a clean, easily decipherable approach in presenting complex data and ensuring backup sheets are organized to maintain traceability. To further add value to this project, I am well-versed in using LOOKUP, SUMIF COUNTIF, OFFSET, INDEX formulas and creating macro(s) with button(s) which enable interactivity between cells. My work has always been backed up meticulously with a strong focus on labeling and organizing worksheets to keep things clear. In conclusion, allow me to transform your data into an aesthetically pleasing and easily understandable Excel Dashboard that vividly tells “your story”.
$220 USD in 2 days
4.0
4.0

Hi, I am excited to apply for the your posted project Purchase Order Invoice Review & Spreadsheet. With a strong proficiency in Microsoft Excel, Outlook, MS Office and a proven ability to handle complex data analysis, reporting, and spreadsheet management, I am confident in my ability to contribute effectively to your team. My skills include Data Analysis and Visualization, advanced Excel functions, pivot tables, and charts to analyze data, Automation with Macros and VBA, Data Management, Financial Modeling and Forecasting, document templates, reports and many other tasks. I am eager to bring my attention to detail and commitment to delivering high-quality work to your organization. Thank you for considering my application. Best regards, @CodingHelpLine
$225 USD in 7 days
4.0
4.0

Hi, I am a certified and experienced Excel expert. Your Excel dashboard creating request is perfectly matching with the specialize service offering in my profile. Please feel free to ask any questions if you have. Thanks!
$140 USD in 7 days
3.9
3.9

I am excited to apply for the Excel dashboard project. With a strong background in data analysis, visualization, and Excel expertise, I can create a dynamic, insightful dashboard that fulfills all the requirements outlined in the job description. Here’s how I plan to approach the project: Combine data from multiple files using Power Query and organize it for seamless analysis. Create pivot tables, charts, and slicers (including timeline slicers) to offer an interactive user experience. Use advanced Excel functions like LOOKUP, SUMIF, and INDEX to highlight key insights. Incorporate visual storytelling with "Top-5" and "Bottom-5" lists, conditional formatting, and 2D/3D maps where applicable. My focus will be on crafting a user-friendly, visually appealing dashboard while ensuring that all analysis is traceable via well-organized backup sheets. I’ll also document each step for clarity. I am confident that my skills align perfectly with your needs, and I look forward to helping bring your data story to life. Let me know how I can contribute to your project.
$140 USD in 7 days
3.7
3.7

Hey ! I have gone through your instructions carefully, and I am fully capable of handling this project. With my in-depth knowledge of PDF, Visual Basic, Data Entry, Data Processing and Excel, I’m eager to bring my skills to help meet your objectives. Don’t hesitate to reach out if you’d like further clarification on my approach to this task. Warm regards, Wilfred
$195 USD in 2 days
3.3
3.3

Hello, I am interested, I can help you with the project, I have strong expertise in Excel, Dashboards, Power BI, Data Analysis and more, I am looking forward for your additional comments.
$250 USD in 7 days
2.4
2.4

Hi, I am a senior developer with more than 7 years of experience in Excel, ExcelVBA, Macro, Formulas, Data Processing. So I am confident to complete your project. I can work full time for your project and try to meet your requirements. I design and structure the project from scratch. "Client's idea + programmer's robot coding is the perfect result" This is my idea. If you want the perfect result, please contact me. Thank you.
$40 USD in 1 day
3.2
3.2

Hi there, I am excited to help you uncover the story within your data and build a visually engaging and interactive Excel dashboard to effectively communicate it to users. I will combine data from multiple source files using Power Query and incorporate key elements such as sorted data, pivot tables and charts, slicers, and a timeline slicer. The dashboard will feature dynamic components like conditional formatting, filtered data, and "Top-5/Bottom-5" lists to highlight critical insights. Additionally, I will apply advanced Excel functions such as LOOKUP or SUMIF and include optional elements like dropdown lists for interactivity or macros with buttons to enhance user experience. The data work and analysis will be clearly labeled and organized in backup sheets for transparency and ease of understanding. With my expertise in Excel and data visualization, I am confident in delivering a compelling dashboard that meets your requirements and exceeds expectations. Let’s bring your data story to life! Regards, Muzafar
$30 USD in 7 days
2.7
2.7

⚛️ Excel, ExcelVBA, Macro, Formulas, Data Processing Expert Available to work right now ⚛️ Hello Customer! I am an experienced software developer from Vietnam. I found that I am suitable for this project. As an experienced software developer, I have rich experience in Excel, ExcelVBA, Macro, Formulas, Chart and have built many projects like this. I promise to complete this project on time and with high quality. Please contact me to discuss your project fully. Thank you.
$45 USD in 1 day
2.1
2.1

As an experienced Data Specialist with a deep understanding of the power of data analysis in decision-making, I believe I possess the unique skills needed to curate an insightful Excel Dashboard from your assigned datasets. My expertise lies in using advanced functions like Power Query, Pivot Table, Slicers - including time-line ones, to bring disintegrated data sets into a coherent format. I am fully conversant with conditional formatting, data filtration, generating "Top-5" or "Bottom-5" lists, and also using complex functions like LOOKUP and SUMIF. Moreover, my proficiency extends to creating interactive visualizations that can provide a comprehensive glance at complex information. By using techniques such as two-dimensional or three-dimensional mapping and drop-down lists, I ensure an efficient and enjoyable user experience for anyone interacting with your Excel. Additionally, I am well-skilled in creating Macros which would further enhance the interactivity of your final dashboard. To recapitulate, my technical prowess combined with my passion for storytelling through data would make me the ideal candidate for your project. As my expert use of Excel can transform raw data into a compelling narrative, let me turn your scattered dataset into an informative masterpiece that will leave even the most unfamiliar users feeling enlightened by "Your Story".
$60 USD in 2 days
1.8
1.8

Hi Sir, I have worked as a finance manager in local NGOs, Schools, Chartered Accountant Company & Super Markets, and I have over 15 years of experience. My qualification is an MBA (Master of Business Administration) & I am proficient in Excel Dashboard tasks. I have gone through your requirements and am highly interested. I will deliver the project with 100% satisfaction and under a deadline. I will do this job as per your expectations. Please come over and chat, let's discuss more on the project. I will start work immediately and provide you with daily updates. My Skills; ✅ Proficient in Excel Dashboard tasks. ✅ Advanced knowledge of Power BI & Ms. Excel. ✅ Attention to detail and accuracy. ✅ Familiarities with Excel Formulas. ✅ Experience with creating and polishing Power BI visuals. ✅ Proficient in data transformation techniques. After the competition & delivery of the project, any modification and alteration will be provided free of cost. I am looking forward to working with you! Best Regards, Naseem
$83 USD in 2 days
0.8
0.8

Toronto, Canada
Payment method verified
Member since Nov 29, 2024
€30-250 EUR
₹100-400 INR / hour
$15-25 USD / hour
$10-30 USD
₹1500-12500 INR
₹400-750 INR / hour
₹750-1250 INR / hour
$10-30 USD
$15-25 USD / hour
$1500-3000 USD
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$10-30 USD
₹1500-12500 INR
₹600-1500 INR
min £36 GBP / hour
₹750-1250 INR / hour
₹600-1500 INR
$2-8 AUD / hour