
Completed
Posted
Paid on delivery
Title: Excel Expert for Portfolio Resource Management (Dashboards + Pivot Power) Scope: Build a portfolio resource management workbook where: • Resources can be assigned to multiple projects across months. • Capacity per resource is entered. • Dashboards show utilisation over time with slicers/filters (by person, role, project, month). • Analytics identify under/over-allocation. Must-have skills: Advanced Excel (pivot tables, Power Query, formulas incl. SUMIFS/XLOOKUP/INDEX-MATCH, dynamic arrays), slicers/timelines, charts What I provide: A detailed workflow(attached to this post) + a 30-min walkthrough of required tables, charts, and slicers. Deliverables & timing: • First cut within 18 hours of kickoff. • Feedback applied to a final version within 2–3 days. • Clean, documented formulas, no VBA required (unless agreed). • Works on modern Excel (O365). How to apply (fast): Have a quick look at the design attached to the post, Share 1–2 similar dashboards you built, and confirm availability for a 30-min call today (AEST/Sydney).
Project ID: 39716551
50 proposals
Remote project
Active 8 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
50 freelancers are bidding on average $152 AUD for this job

As a Full stack developer specialized in Data Processing and Visualization, I understand the value of an efficient and comprehensive resource management system. My mastery of Advanced Excel with high-level skill in pivot tables, Power Query, formulas(SUMIFS/XLOOKUP/INDEX-MATCH), and dynamic arrays, along with my expertise in slicers/timelines and charts, aligns perfectly with the task at hand. Throughout my 7-year career, I've collaborated with top companies like Metlife GOSC and DXC Technologies on projects requiring sophisticated data management solutions; a testament to my proficiency in Excel. In addition to this, my knowledge of Python further extends my capabilities to tackle complex data analysis tasks. Most notably, my approach to client service is fundamentally rooted in your satisfaction. My bid reflects the fair value of my work while ensuring expedient delivery. I believe that fostering long-term relationships through quality results is essential because it provides you with reliability as well as consistency in product output. I am available from EST TIME 8 AM - 12 PM for any discussions or further clarifications. Choosing me for this project guarantees not just a finished product but also an enjoyable partnership.
$180 AUD in 3 days
8.6
8.6

"""""""""""""""""""ADVANCE EXCEL 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 Certified business Accountant with more than 10 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 4 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, Power BI, 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 400+ 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 AUD in 1 day
7.6
7.6

As a data enthusiast, I'm excited by the challenge your portfolio resource management project presents. I have over 5 years of experience in data analysis and I am an Advanced Excel user, well-versed in Power Query, Pivot Tables, and formulas including SUMIFS, XLOOKUP, INDEX-MATCH. Building dynamic arrays and utilizing slicers/timelines is second nature to me. Having already reviewed your detailed workflow and design, I am confident in providing a first cut of your dashboard within the tight 18-hour timeline you specified.
$250 AUD in 1 day
7.5
7.5

Hi There, Glad to know your requirement. I have delivered more than two hundred excel based projects. Could work on this one too. You seem like having planned everything as to how things have to be done. Will listen to you, understand and take it forward. Looking forward to your message. Thank you
$350 AUD in 7 days
7.1
7.1

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..
$140 AUD in 7 days
7.1
7.1

Hi, I create reliable and efficient Excel automation using VBA macros and advanced formulas customized to fit your exact needs and workflow. What I Can Help You With: Excel Automation & VBA Development VBA Development Excel Macros Automation Complex Formulas Custom Functions Dynamic dashboards, charts, and visual reports Pivot tables & data summaries Automating Repetitive Excel Processes with VBA Macros Custom Excel spreadsheets tailored to your needs Generating PDF Reports from Excel Data Converting PDFs to Excel Worksheet
$165 AUD in 3 days
6.7
6.7

Hi pooyas4, I have over 8 years of real-world experience and freelance expertise in Excel. I have carefully reviewed your project requirements for building a Portfolio Resource Dashboard. I am confident in my ability to create the necessary dashboards, pivot tables, and analytics to meet your needs. I would like to connect with you in chat to discuss your project further and share insights on how I can assist you in achieving your goals. Regards
$30 AUD in 1 day
5.7
5.7

Hey! I have gone through your description. I have strong expertise in Excel, Power Query, Pivot Tables, and dashboard development. I have built similar resource management and capacity planning dashboards with slicers, timelines, and advanced formulas (SUMIFS, XLOOKUP, INDEX-MATCH). I have strong command on Excel. I can provide you with quality, error-free work that meets all your requirements and deliver on time. Looking forward to your response. Thank you.
$30 AUD in 1 day
5.2
5.2

Hello, I am excited about the opportunity to help you create an advanced portfolio resource management workbook! With strong expertise in Excel, including pivot tables, Power Query, and dynamic arrays, I can ensure your dashboards will provide effective utilization insights while meeting all your requirements. Given the detailed workflow and the attached design, I will swiftly build out the initial version within 18 hours of kickoff. I’ll utilize advanced Excel functionalities like slicers and charts to highlight under/over-allocation clearly, ensuring you have a robust analytics tool at your fingertips. I am available for a quick 30-minute call today (AEST/Sydney) to discuss further and finalize the details. Your project is a fantastic opportunity for collaboration, and I look forward to sharing similar dashboards I have created in the past. Thanks, Monicah
$135 AUD in 3 days
5.0
5.0

Hello I can create a professional portfolio resource management workbook with dynamic dashboards, pivot-based analytics, and clean, documented formulas to track utilisation and allocation across projects and resources. My expertise with Power Query, advanced formulas (SUMIFS, XLOOKUP, INDEX-MATCH, dynamic arrays), slicers, and interactive charts ensures a precise and user-friendly solution. I can share similar dashboards I’ve built and am available for a 30-minute call today to walk through your workflow and requirements. Regards Muhammad
$100 AUD in 1 day
4.6
4.6

Hi sir, I have a lot experience I can be the best for your project. I will do this project without any mistake. You can trust me. Please give me a chance so that I can show you my skill and tell you about my hard work.
$30 AUD in 1 day
4.5
4.5

Hello there, With extensive experience in statistical and predictive analytics, My proficiency in SPSS combined with my programming skills in Python will not only ensure an effective data analysis but also allow for flexibility and automation, optimizing efficiency throughout the process. Throughout my career, I have consistently proven my problem-solving mindset transforming complex datasets into clear and actionable insights that clients can use to drive their business forward. Data cleaning and transformation is an often-overlooked area of importance; however, it's where precise analysis begins. My vast experience in this area ensures thorough sorting of your data for accurate analysis - leaving no stone unturned. Lastly, I recognize that clear communication is vital to successful project completion. I assure you of my commitment in communicating regularly and effectively throughout this project, leaving no room for ambiguities. Trusting me with this project will not just avail you of a qualified individual but also someone who is dedicated in leveraging their knowledge and experience for unparalleled client satisfaction.
$30 AUD in 1 day
3.5
3.5

Hi there, Greetings! I checked your project details of Excel Guru for Portfolio Resource Dashboard, I have worked on 1000+ Projects. I have 5+ years of the experience in same kind of projects. I am expert into data entry in excel, VBA, VLOOKUP, HLOOKUP, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office or Google sheets at large since that is my area of expertise within your minimal budget and provide quality work within the time required. My proficiency in Excel, attention to detail, and efficient work ethic make me well-suited for this task Looking forward for your Positive response. Regards
$100 AUD in 2 days
3.9
3.9

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categorical data project effectively and efficiently. I have extensive experience in collecting, cleaning, analyzing, and visualizing data using Python programming, an invaluable asset for a project of this nature. Additionally, I am well-versed with CRISP-DM framework and adept at identifying patterns within datasets Choosing me means benefitting from not only my expertise but also my personal approach to projects. I understand that each task is unique, requiring tailored skills, and so I'm willing to go the extra mile to provide you with results that meet and exceed your expectations. Let's join forces in this project as our combined strengths will surely produce a result that's efficient, elegant and insightful! Let's not waste any more time! Together, we can mine this data efficiently and answer the questions to achieve your goals. Best Regards, Thanks
$30 AUD in 1 day
3.1
3.1

Hi, I can build your portfolio resource management workbook with advanced Excel features including Power Query, dynamic arrays, slicers, and pivot-powered dashboards. I’ve created similar utilization and capacity dashboards that track multi-project allocations with clear analytics. I can deliver the first cut within 18 hours and finalize it in 2–3 days, ensuring clean, documented formulas without unnecessary VBA. I’m available today for the 30-min call (AEST). Best regards, Maryam
$80 AUD in 1 day
3.3
3.3

As a Power BI and Excel expert, I believe I am the right fit for your portfolio resource management project. I have a profound understanding of the advanced functionalities in Excel, such as pivot tables, Power Query, knockout formulas like SUMIFS/XLOOKUP/INDEX-MATCH, dynamic arrays and more- all of which are essential for building efficient dashboards for resource management. My extensive experience with slicers/timelines and charting will ensure robust analytics that can identify under/over-allocation with ease. Since the project does not require VBA, my proficiency in lean, formula-based solutions would keep things simple and easily maintainable in the long run. Equipped with rich experience working on modern Excel (O365), I understand how vital clean, documented formulas are for a smooth workflow. With that commitment in mind, I promise to deliver your first cut within 18 hours of kickoff and integrate your feedback into a final version within 2-3 days.
$140 AUD in 1 day
2.9
2.9

I thrive on challenges like yours and can deliver a clean, professional, user-friendly solution that scales as you grow. I see you need an Excel expert to build a portfolio resource management workbook with dynamic dashboards. In a similar project, I boosted resource allocation accuracy by 40%. Although new here, I’ve spent 4+ years working with pivot tables, Power Query, and advanced Excel formulas. Could we hop on a 10-minute call to align on your priorities? Regards, Christopher Venter
$150 AUD in 30 days
2.6
2.6

Hi there! I believe I’m a strong match for your project. I have experience creating complex Excel dashboards like the portfolio resource management workbook you require. I am proficient in all the must-have skills mentioned, from pivot tables to dynamic arrays. Let’s connect and see how I can bring value to your project! Regards, Alecia
$150 AUD in 7 days
2.6
2.6

Hello pooyas4, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Data Processing, Excel, Analytics, Visual Basic for Apps, Charts, Data Visualization, Data Analysis Please come over chat and discuss your requirement in a detailed way. Volodymyr
$140 AUD in 7 days
2.4
2.4

Hello there, As an experienced researcher and data scientist, data analyst, my qualitative analysis skills perfectly align with your job requirements. My profound knowledge of Python and R Studio guarantees fast learning and adaptation to new tools. Moreover, my advanced skills in Excel make me highly competent in handling large datasets efficiently—making me proficient in extracting the best insights from your transcripts. I fully comprehend the importance of working papers and meticulously preparing financial statements, especially within strict timelines. my sharp analytical skills and extensive knowledge of excel ensure that I leave no stone unturned in making sure every detail is covered under evaluation. My passion for quality, originality and meeting deadlines makes me an excellent choice for this project. I cannot wait to prove my extensive skills to you through providing actionable insights that will help guide your decision making regarding domestic charter flights. Best Regards
$30 AUD in 1 day
2.5
2.5

South Turramurra, Australia
Payment method verified
Member since Aug 19, 2025
₹600-1500 INR
£20-250 GBP
₹400-750 INR / hour
$10-30 USD
₹400-750 INR / hour
$30-250 USD
₹37500-75000 INR
$8-15 USD / hour
$2-8 CAD / hour
₹12500-37500 INR
$10-30 USD
₹1500-12500 INR
$30-250 CAD
₹750-1250 INR / hour
₹400-750 INR / hour
$10 USD
£20-250 GBP
₹100-400 INR / hour
₹600-1500 INR
₹600-1500 INR