Find Jobs
Hire Freelancers

Excel Workbook for Customer Insights

$30-250 CAD

Selesai
Dibuat 25 hari yang lalu

$30-250 CAD

Dibayar ketika dikirim
I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel table that presents the top 10 customers by volume. Ideal Skills: - Proficiency in Excel, especially in pivot tables and data visualization - Experience in creating dynamic and interactive spreadsheets - Understanding of customer variance analytics Please make sure that the workbook is user-friendly, and the layout is intuitive for ease of use.
ID Proyek: 38016939

Tentang proyek

73 proposal
Proyek remot
Aktif 24 hari yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For my past work please visit https://www.freelancer.pk/u/TayyabDastgir?frm=TayyabDastgir&sb=t Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir Excel
$30 CAD dalam 1 hari
5,0 (7 ulasan)
3,2
3,2
73 freelancer menawar dengan rata-rata $113 CAD untuk pekerjaan ini
Avatar Pengguna
What an exciting opportunity! My name is Akriti, a seasoned Excel and data management professional who is well-versed with Visual Basic and Apps. I have a deep understanding of business needs and the ability to translate diverse data into meaningful insights, which I believe makes me the perfect fit for your project. As an expert in pivot tables and data visualization, I'll craft a user-friendly Excel workbook that incorporates all the key features you require. My skills extend beyond Excel alone; I have also mastered Google Sheets. Therefore, if you ever need any additional support in migrating this workbook to G-Sheets or even integrating it with other Google Workspace apps for smooth collaboration, I got you covered! I bring a unique blend of analytical thinking and creative problem-solving to every project. For instance, to address your request for customer variance analytics, I would design formulas that not only show year-over-year percent changes and absolute differences but also allow you to drill down into various dimensions such as branches and years for deeper insights.
$200 CAD dalam 1 hari
4,9 (438 ulasan)
7,6
7,6
Avatar Pengguna
I can do this workbook according your requirements. I'm ready to start right now. If you message me, we can do further discussion. Waiting for your message. Thanks!
$100 CAD dalam 7 hari
5,0 (185 ulasan)
7,5
7,5
Avatar Pengguna
hi there, I have read the specifications and I can build the sheet which will show the analysis on customer data including pivot table for filtering on different columns and top customers table and also variance with charts etc, ready to start now thanks
$100 CAD dalam 1 hari
5,0 (475 ulasan)
6,9
6,9
Avatar Pengguna
Hello Dear Client, As a native englsih speaker and an experienced customer service agent, i am perfect for this job. I have exeperience in using different CRMs including Hubspot, Zoiper, Zendesk, Zoho among others. I have knowledge on how to onboard clients, i can pick up phone calls, follow up , arrange customer visists and if i can help and solve the problem over the phone i will make sure i do it. I am able to document all calls, communicate with the team to do the home visist and any other assignments given. I am available to work on a full time basis, i have a headset, reliable internet, and an excellent working pc. You are guaranteed quality work and smooth running of operations. Kindly send me a message for further discussions. Warm Regards, Tai
$30 CAD dalam 1 hari
5,0 (3 ulasan)
6,7
6,7
Avatar Pengguna
Hi! With my expertise in Excel, data visualization, and analytics, I am confident that I can deliver a high-quality and user-friendly workbook that meets your requirements and exceeds your expectations. I am committed to delivering a comprehensive Excel workbook that not only meets your functional requirements but also provides valuable insights to support your decision-making process. I am confident that my skills and experience make me a suitable candidate for this project. Regards, Zohaab
$250 CAD dalam 5 hari
5,0 (12 ulasan)
4,9
4,9
Avatar Pengguna
Hi there, I am a Data Scientist and a professional responsible for extracting actionable insights and knowledge from large volumes of data for Microsoft applications Development. I can write clean Excel, Word, Access, PowerPoint, Power BI, and Outlook and create VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work; I am willing to fully devote my time and energy to improve the service offered with timely, accurate, and professional results; building trust and a long-term relationship with customers is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project means benefiting from my extensive skills in Excel and data analysis and entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
$100 CAD dalam 2 hari
5,0 (11 ulasan)
4,7
4,7
Avatar Pengguna
Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includesData Entry, Data Processing, Visual Basic, Excel and Visual Basic for Apps, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
$200 CAD dalam 3 hari
5,0 (2 ulasan)
3,9
3,9
Avatar Pengguna
As an Excel expert, I am meticulous and skilled at navigating the intricate world of spreadsheets. My proficiency in pivot tables, data visualization, and understanding of customer variance analytics perfectly aligns with the requirements of your project. I will build a 100% user-friendly and intuitive Excel workbook that brings your customer insights to life. My data prowess extends beyond just organizing information; I ensure it translates into actionable insights that empower your decision-making process. I understand the significance of sales volumes, customer slicing, and year-over-year variances for comprehensive business analysis. Your Excel workbook will not only have a separate sheet for each branch's sales but also allow users to independently filter and slice through the provided pivot tables based on branch or year. The cherry on top is my creative flair that can take your workbook to a whole new level! Alongside delivering exceptional functionality, I'm ready to incorporate aesthetically pleasing designs that are easy on the eyes while highlighting crucial information. Let me handle your data challenges so that you can focus on what truly matters - growing your business. With me as your digital cape-wearer, you won't just overcome data headaches but soar above them!
$160 CAD dalam 2 hari
5,0 (1 ulasan)
3,3
3,3
Avatar Pengguna
Greetings, If your dataset includes all of required data (includin ghistorical data) ; then all of required KPIs are time factor. Could be prepared and ready in 2-3 hours work. I have over 15 years of MS Excel Experience. I am specialized in Excel Reports Automation, and presenting multi source files in consolidated and migrated report as per your requirement However, my commitment does not end when the project is finished. I strongly believe in providing exceptional after-service support to my clients, ensuring their continued support for any data-related queries. Your success is my top priority, and I am committed to being a reliable partner throughout our cooperation. I can Do: - Any required Excel Formulas. - MS Excel Spreadsheets cleaning and Formatting. - MS Excel Spreadsheets Conditional Formatting. - MS Excel Spreadsheets Standardizing . - Excel Reports Automation. - Presenting (Pivot Table, Pivot Charts or spreadsheet Tables) for multi source files in consolidated and migrated report as per your requirement - Power BI charts and reports. Don't hesitate to accept my offer and feel free to visit my Portfolio for some related previous projects samples Regards Emad @EmadOwaida's profile on Freelancer https://www.freelancer.com/u/EmadOwaida?frm=EmadOwaida&sb=t
$120 CAD dalam 2 hari
5,0 (1 ulasan)
3,5
3,5
Avatar Pengguna
Dear Sir/ Madam I am interested in your project and I can deliver you the best service within a minimum time. I am a professional accountant, experienced over 10 years in accounting, auditing, and constructing services. I am an expert of handling, updating, preparing, entering, and organizing data as per the requirements. I am indeed familiar with the Excel basic to advanced analysis including data visualisations and automations. I can assure you that i will be providing you an exceptional service. My reviews in the profile exactly demonstrate my services towards some similar projects. My experience as a Chartered Accountant also includes areas such as governance, risk, compliance, data analytics, forensics, complex accounting models, IFRS consulting. Please look in to my profile for more details. Looking forward to hearing from you. Best regards SwarniD
$140 CAD dalam 3 hari
5,0 (1 ulasan)
3,4
3,4
Avatar Pengguna
Hey, Good morning? I hope this proposal finds you well. As an experienced freelancer, I have honed my skills in Data Processing, Data Entry, Excel, Visual Basic for Apps and Visual Basic and am confident in delivering top-quality work. If you could kindly message me, we can discuss and get started soon. I'm deeply grateful
$160 CAD dalam 1 hari
5,0 (2 ulasan)
2,9
2,9
Avatar Pengguna
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, CHINTAN SHAH
$40 CAD dalam 1 hari
5,0 (5 ulasan)
2,5
2,5
Avatar Pengguna
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
$45 CAD dalam 2 hari
4,5 (7 ulasan)
2,3
2,3
Avatar Pengguna
I'm a skilled Excel expert with extensive experience in creating dynamic workbooks for data analysis. I'll develop a user-friendly Excel workbook tailored to your needs, featuring customer contact info, sales data with pivot tables, year-over-year customer variance analysis, and visualizations like the top 10 customers table. My expertise ensures a high-quality solution that meets your requirements efficiently. Let's collaborate to create a powerful tool for your decision-making process!
$200 CAD dalam 5 hari
5,0 (3 ulasan)
2,0
2,0
Avatar Pengguna
Dear Jason W., I’ve read all of your requirements fully and I'm really interested in Excel Workbook for Customer Insights. I have rich experience in Visual Basic, Data Entry, Visual Basic for Apps, Data Processing and Excel with over 9 years. I am always ready to discuss more detail this project with you and I can start working immediately. Looking forward to working with you soon. For the best result and a long term in the future. Regards, Mikael.
$30 CAD dalam 5 hari
5,0 (1 ulasan)
1,6
1,6
Avatar Pengguna
HI!! I'm an Excel expert ready to build your customer insights workbook. Here's how I'll deliver: Organized Data: Clean customer contact sheets, ready for analysis. Powerful Pivot Tables: I'll set up slicers for filtering by branch and year. Clear Variances: Y/Y customer change calculations, both absolute and percentage-based. Top 10 Visualization: Dynamic Excel table highlighting your most valuable customers. Ease of Use: An intuitive layout guides decision-making. Let's discuss your data format. I'm committed to creating a valuable sales analysis tool! Regards, Muhammad
$50 CAD dalam 2 hari
5,0 (1 ulasan)
1,5
1,5
Avatar Pengguna
Hello prospect Client! My name is Indrawan Bayu and I am an Excel expert, specializing in the use of formulas and data processing. Your project is based on my day-to-day work as an analyst, which gives me a great advantage in understanding your needs thoroughly. Budget-wise, I understand the importance of keeping costs down and always offer efficient solutions at a reasonable price. Throughout my career, I've faced various challenges in complex spreadsheets and have always found innovative and effective ways to solve them. My services do not end with the delivery of the project, I offer full support even after completing the work. My main goal is your absolute satisfaction and I guarantee to review the project until it fully meets your expectations. Trust me to carry out this task. I guarantee quality, skill and complete results. Don't forget to check my profile for examples of previous work and don't hesitate to contact me for more details of the project. I look forward to the opportunity to work with you soon!
$140 CAD dalam 7 hari
5,0 (1 ulasan)
0,9
0,9
Avatar Pengguna
Hi, thanks for opportunity to join this project. My expertise is data processing and data visualization. I'm fluent on Excel and Power BI Please find me on chat and share a detail.
$30 CAD dalam 1 hari
5,0 (1 ulasan)
0,4
0,4
Avatar Pengguna
Hi there, I hope you are doing well! I am Dian from Indonesia but right now I am living in Madrid, once I read your description, I sure can contribute and deal with this job because this is my field. I am a Master student in Banking and Financial Regulation and I have experience becoming a secretary of principal in an International school in Bali for more than 4 years before I moved to Madrid, and several experiences as an assistant online. I had a deal with big Chinese factories to promote and make their website, and I also worked with a professional art artist from Australia to promote her Instagram. I am ready now and can start ASAP. I am also an expert and have great experience in Python, R language, lead generation, web search, web scraping, virtual assistant, product upload on e-commerce sites, Excel, PDF to Word/Excel conversion, data processing, data entry, etc. Please send me a message to discuss more. Thank you. Regards, Dian
$50 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
What is a Bid in Freelancer? Let’s start by looking at what exactly is a bid in Freelancer. The bid meaning in Freelancer is similar to responding to a job posting anywhere else. A potential employer publishes an ad when they want to hire a new employee. They describe the job and the required skills. Potential employees then submit their CVs or resumes to apply for the job. A bid in Freelancer is not much different. Simply put, clients post a description of their jobs on Freelancer.com. This posting creates an “auction” for skilled help to complete those projects. Each project requires specific skills, so freelancers with those skills “bid” on the project. And that’s why it is
$140 CAD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Melfort, Canada
4,9
8
Memverifikasi Metode pembayaran
Anggota sejak Sep 30, 2020

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.