
Completed
Posted
Paid on delivery
Create a one-page dashboard summarizing deal activity and fees for three categories: 1. LATAM (Latin America) 2. US (United States) 3. FIG (Financial Institutions Group) ⸻ Data Inputs: • Number of Deals for each category over a given time period (monthly, quarterly, or YTD — specify which). • Total Fees Generated for each category in the same time period. • Data will come from [source name: e.g., internal deal database, Refinitiv, Bloomberg, Excel exports]. ⸻ Charts & Visuals Required: 1. Bar Charts or Column Charts – one for each region/category showing Number of Deals over time. 2. Bar Charts or Column Charts – one for each region/category showing Fees over time (in USD millions). 3. Summary Table – a table at the top or bottom with: • Category (LATAM / US / FIG) • Total Deals • Total Fees (USD m) • Average Fee per Deal (optional) ⸻ Layout: • Header – syndicate metrics with tables for deals this week - with one table for us it, one for LATAM and one for FIG -then syndicate productivity - it has to have the number of revenues us, latam vs FIG. The p&L of all categories • Three sections – one per category (LATAM / US / FIG). Each section should have: • A table for papeline • A table for reverses Table for most frequent issuers and names to be paying attention to - a table with last pricing too if any space Then if space Administration tasks • Color coding – consistent but distinct colors for each category (e.g., LATAM = blue, US = green, FIG = orange). • Compact design – everything should fit neatly onto one page without scrolling. ⸻ Tools: • Recommended: Excel or PowerPoint with embedded Excel charts. • Use pivot tables if working with raw deal data to quickly summarize counts and sums. ⸻ Final Deliverable: • One PDF or PPT slide containing the dashboard. • Editable source file (Excel / PPT) for future updates.
Project ID: 39685263
17 proposals
Remote project
Active 11 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

"""""""""""""""""""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 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 USD in 1 day
7.7
7.7
17 freelancers are bidding on average $129 USD for this job

Please share the detail data for PPT and Excel file. I can do this comfortably with good quality and with in dead line Thanks
$140 USD in 2 days
7.2
7.2

Hello, I’ve reviewed your requirements and understand that you need a compact, one-page dashboard summarizing deal activity and fees for LATAM, US, and FIG, with visualizations, summary tables, and categorized sections for different performance metrics. With advanced Excel dashboard design skills, data visualization expertise, and experience in financial reporting, I can deliver a clean, data-driven layout that is both informative and visually engaging. My approach will begin by importing and structuring your raw deal data from the specified source into Excel. I will use pivot tables to summarize the number of deals and total fees for each category over the selected time period, calculating averages where relevant. Then, I will create distinct, color-coded bar/column charts for each category, along with summary tables showing total deals, total fees, and other key metrics. The layout will be optimized for one-page clarity, including pipeline, reverses, frequent issuers, last pricing, and admin tasks, all formatted for quick reference. The final dashboard will be delivered as both an editable Excel/PPT file and a polished PDF for distribution. Would you like me to design the dashboard so that the time period (monthly, quarterly, YTD) can be switched dynamically using a dropdown filter? Best Regards, Aneesa.
$100 USD in 1 day
6.7
6.7

"""""""""""""""""""""EXCEL EXPERT | AUTOMATION | DASHBOARDS"""""""""""""""""""" Sir/Madam, ''FINANCIAL DASHBOARD,'' get it within 6 hours. Excel is my expertise, and I take pride in solving complex tasks efficiently and accurately. There is no challenge in Excel that I cannot handle, from simple formulas to advanced conditional logic and complete automation through VBA and Macros. I have extensive experience in leveraging Excel's full potential to deliver 100% precise results. My skills include but are not limited to: 1. Advanced formulas for automation and data processing 2. VBA and Macro automation for efficiency 3. Pivot tables for data analysis and reporting 4. Interactive dashboards for visual insights 5. Automated invoice and quotation systems 6. Custom Excel templates for various business needs About me I am a Chartered Accountant with extensive experience from Ernst & Young Ford Rhodes Global and PwC. I am an expert in Microsoft Excel, accounting, auditing, financial statements, and form creation through VBA in Excel and Google Sheets. I also specialize in QuickBooks and Sage. I ensure error-free solutions and am available 24/7, even after project completion. The price is negotiable, and I am ready to start immediately. Let’s connect! Regards, Spogmai Kakar"
$66 USD in 1 day
5.2
5.2

Hello, I am excited about the opportunity to develop a comprehensive financial dashboard summarizing deal activity and fees for LATAM, US, and FIG categories. With a focus on clarity and data visualization, I will create bar or column charts to effectively represent the number of deals and fees for each region over the specified time period. Utilizing pivot tables to analyze your internal data and ensuring a visually appealing layout with consistent color coding will enhance the dashboard's usability. Additionally, I will incorporate a summary table to present key metrics succinctly, as outlined in your project description. I believe my skills in data visualization, financial analysis, and proficiency with Excel will allow me to deliver a polished, editable source file that meets your specifications by consolidating all required elements onto a single page. Thanks, Monicah
$80 USD in 3 days
5.2
5.2

Hey! I have gone through your description. I have done MPhil in statistics. I have expertise in data analysis and data visualization. I have strong command in Power Bi. I have previous experience on dashboard creation and i can also show you some samples if you message me. I can provide you quality work that meets all of your requirements. I can do this job with full accuracy and on time. Looking forward to see your interest. Thank-you.
$30 USD in 1 day
5.1
5.1

Hello, I can create a clean, one-page dashboard summarizing deal activity and fees for LATAM, US, and FIG using your specified data source (e.g., Excel, Refinitiv). It will include bar/column charts for deal volume and fees over your chosen time frame (monthly, quarterly, or YTD), plus a summary table showing total deals, total fees (USD m), and average fee per deal per category—all presented clearly for quick insights. Contact me for quality work. Thanks
$100 USD in 7 days
4.4
4.4

Hi! I’m excited to help you build a comprehensive, one-page Excel dashboard summarizing deal activity and fees across LATAM, US, and FIG categories. With extensive experience in financial data analysis, pivot tables, and dynamic chart creation, I’ll deliver a compact, visually clear report featuring color-coded sections, multiple tables, and bar charts—all designed for easy updates and export to PDF or PPT. I understand the importance of precision and usability in wealth management workflows and will ensure the dashboard meets your layout and visualization needs perfectly. Looking forward to discussing your data source and timelines!
$50 USD in 2 days
2.5
2.5

Hello, I understand that you need a one-page dashboard summarizing deal activity and fees for the three categories LATAM, US, and FIG. I can create a clean, well-organized dashboard that will show all your required details clearly on a single page. What I will deliver: I gave includes all the points exactly as they were in your job description, with nothing missed and nothing extra added. Tools & Format: • I will use Excel with pivot tables for quick summarization and embedded charts. • I will develop an Excel sheet with a built-in button that, when clicked, will automatically export all visuals from Excel into a well-formatted PowerPoint presentation. I will ensure the design is visually clear, easy to read, and ready for presentation. I’m confident I can deliver exactly what you need quickly and accurately. Looking forward to your confirmation so we can get started. Best regards,
$85 USD in 5 days
2.1
2.1

Hello Noa, I am excited to propose my services for developing the financial dashboard you outlined. With my background in data management and visualization, I can create a comprehensive one-page dashboard that effectively summarizes deal activity and fees for LATAM, the US, and FIG. To start, I'll gather the necessary data inputs as specified and utilize Excel to create visually appealing bar or column charts that provide clear insights into the number of deals and fees over your chosen time period. Each category will be distinctly color-coded, ensuring a clean and compact design while maintaining readability. I will also ensure that the layout includes various tables that capture essential metrics, such as pipeline and reverses, as well as a summary table at the top or bottom for quick reference. After completing the dashboard, you'll receive both the final PDF/PPT and an editable source file for any future updates you might require. Thanks, ALESSIO
$215 USD in 7 days
1.0
1.0

A one-page financial dashboard should give decision-makers a clear picture without having to click or scroll — and still hold all the key deal metrics. I’d structure this in Excel first, using pivot tables to summarize deal counts, total fees, and average fees for LATAM, US, and FIG over the chosen period. From there, I’d design clean, color-coded bar/column charts for both deal volumes and fees. The top section would hold the syndicate metrics tables (weekly deals per region, productivity, P&L summary), followed by the three category sections with pipeline, reverses, most frequent issuers, and last pricing tables. Color coding (e.g., LATAM = blue, US = green, FIG = orange) will be consistent throughout for quick recognition. I can deliver the dashboard as a single PDF or PPT slide with the editable Excel source so you can refresh the data easily in future weeks. Do you want the average fee per deal included by default, or kept optional to avoid clutter?
$250 USD in 7 days
0.0
0.0

New York, United States
Payment method verified
Member since Aug 9, 2025
₹750-1250 INR / hour
$15-25 CAD / hour
€30-250 EUR
₹500000-1000000 INR
₹750-1250 INR / hour
₹1500-12500 INR
$30-250 USD
$250-750 USD
₹1250-2500 INR / hour
₹750-1250 INR / hour
$2-8 USD / hour
₹1500-12500 INR
$30-250 USD
₹1500-12500 INR
₹12500-37500 INR
₹37500-75000 INR
₹12500-37500 INR
$10-50 USD
₹100-400 INR / hour
₹12500-37500 INR