Find Jobs
Hire Freelancers

Custom Excel Spreadsheet with Data Analysis including If/Then Formulas

$30-250 USD

Completed
Posted about 8 years ago

$30-250 USD

Paid on delivery
I need someone to create a spreadsheet that has a lot of If, Then statements on it. A person with knowledge and skill on Excel formulas will do very well with this piece. It is taking 4 months of daily data for 5 locations and placing it into a grid that contains averages and a lot of If, Then statements.
Project ID: 10024276

About the project

27 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi there, Your project sounds fun and interesting - I have over 13 years of corporate experience working in Excel creating advanced automated dashboards and reports which utilized many IF / THEN statements. I also used nested IF statements (IF's within IF's) as well as the ELSE function. Do you have an existing sheet or grid? I am happy to create the grid/data table - I have created more of them than I can remember and can use any color scheme you'd like. I would love to hear more about the specifics of your data and also all of the IF THEN scenarios that you might require and then I could start building out the sheet. We could add a graph or two as well if you'd like to graphically represent some data. Hopefully we can work together! Thanks either way and best of luck, Shaun
$88 USD in 3 days
5.0 (75 reviews)
6.4
6.4
27 freelancers are bidding on average $126 USD for this job
User Avatar
Hi, I am na Excel automation expert and would be happy to assist you. Let me know and we can discuss. Cheers, Arul
$250 USD in 3 days
5.0 (177 reviews)
7.3
7.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$50 USD in 1 day
4.9 (280 reviews)
7.2
7.2
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$200 USD in 3 days
5.0 (210 reviews)
6.8
6.8
User Avatar
I can do it for you quickly and exactly
$100 USD in 3 days
4.9 (103 reviews)
6.5
6.5
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$100 USD in 7 days
4.9 (155 reviews)
6.8
6.8
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$44 USD in 3 days
4.8 (72 reviews)
5.8
5.8
User Avatar
Hello, I am Excel and VBA expert. Can I see a sample file? Please note that I have 100% completion rate and 5-star feedback on projects.
$155 USD in 7 days
5.0 (62 reviews)
5.6
5.6
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$120 USD in 3 days
4.9 (69 reviews)
5.6
5.6
User Avatar
I have the expertise in Excel & Advanced formulas and can do this task , quickly and accurately, as per specification. Ready to start work immediately.
$100 USD in 2 days
4.6 (67 reviews)
5.4
5.4
User Avatar
Analytical and performance driven financial professional with diversified experience in financial analysis, projection and investment. Expertise in investment strategies, asset valuation and portfolio management combined with business development. Tapped into market and business trend as well as market analysis. CFA level I candidate with an MBA and MS in Financial Engineering degree Have experience with following work Business Plans Accounting statements Financial Statement Analysis Superannuition and mortgages Derivatives Risk analysis Academic assignments Case Studies Marketing assignments
$111 USD in 3 days
5.0 (9 reviews)
4.3
4.3
User Avatar
Hello, sir. I am very interested from your project. I'm TOP 6TH freelancer as you can see my profile (https://www.freelancer.com/u/kchg.html). I have enough skills for your project. Kind Regards
$257 USD in 3 days
4.9 (4 reviews)
4.4
4.4
User Avatar
Hello. May I see what exactly has to be done? I'm quite familiar with Excel and if the task may be automated I can do it quickly. Best regards, Alexander.
$49 USD in 2 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi, I am an experienced Accounting and Excel development professional with over a decade of history delivering projects that meet or exceed my client's expectations. I would like the opportunity to do the same for you. I focus on functionality, ease of use and design. Many of my projects included working with and cleaning large datasets from multiple sources. In addition, I have developed formula based logic structures which add value by improving the underlying process flow. My focus is on continuing to provide tools that are easy to use to answer important questions. I have extensive experience in conditional (IF/THEN) statements. I will provide clear instructions, including follow-up to your team to ensure the reporting is easy to use and effective. Many of my clients have been satisfied large corporate customers. Please let me know if you have any questions. Thanks. -Kevin
$155 USD in 3 days
5.0 (6 reviews)
3.9
3.9
User Avatar
Hi, I build smart pricing tool for enterprises. Please contact me for your project. Thanks!...........................................................................
$111 USD in 2 days
4.6 (12 reviews)
3.8
3.8
User Avatar
Greetings! To mention about the task/job/Project, I assure you that I am an Expert and can do these kind of job VERY EASILY. I may be new to this Site, but I assure you I am very experienced and skilled with these kind of jobs "I request you to start the chat as I cannot start a chat with an Employer" Send the file in the chat & explain your exact requirement, give me 30 minutes and I’ll show you the work done in 30 minutes. If you like the work, then ONLY HIRE me I take this opportunity to introduce myself as a highly talented Accountant and Analyst with strong technical knowledge and with an experience in the areas of Accounting, Algorithm, Audit and Business Analysis. With the Degrees in Engineering and MBA, I am specialized in Logical approaches and simplifying day to day business processes. With specialization in Excel and other Microsoft Office tools, I can provide the best reports merging different data from different reports exported from the software. If you need Customer/Vendor/Stock Analysis incorporating all data from different reports, then just hire me Sending customized mails or printing customized letters using Mail merge, or Business Reporting and Analysis or Presentations or Documentation or preparing some daily used templates like Invoice , I am one of the finest choices you can have. If your software cannot give you the right FIFO / LIFO adjustments for stocks / bills adjustment / ageing reports, then I'm the best choice Give me an opportunity.
$100 USD in 2 days
5.0 (1 review)
3.2
3.2
User Avatar
I am proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$155 USD in 3 days
3.9 (9 reviews)
3.5
3.5
User Avatar
Hi, I am Manimaran from India. I have experience in Microsoft Excel for more than 4 years. I can create formulas using excel functions and can create VBA macros. This experience will help me to complete your project with the highest quality and within the committed timeline. Looking forward to hear from you. Best Regards, Manimaran
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir/Madam, I am an experienced professional but I am willing to work for less since I am new to Freelancer.com!! My name is Peter and I'm a Management Consultant at Extrive Consulting, a Toronto-based consulting firm that specializes in Business Process Re-Engineering, Business Systems Analysis, Financial Modeling and Analysis, and Web Application Design/Development. I am an Excel/VBA expert with extensive finance/accounting knowledge. I am the complete toolbox best suited for this project. I can build a macro to automate the task for you! You will be able to re-use this macro for future tasks. I look forward to hearing back from you. Thank you!
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, My name is Anna. I am finance professional with Ms excel expertise.. In response to your requirement, I would like to mention that I have rich experience at reporting and i can create user friendly excel file, with all appropriate formulas. Looking forward to discuss your project details. Regards Anna
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Saskatoon, Canada
5.0
1
Member since Mar 22, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.