Find Jobs
Hire Freelancers

Excel expert require to automate a spreadsheet with internal mapping

$30-60 AUD

Closed
Posted about 6 years ago

$30-60 AUD

Paid on delivery
I need an excel guru to do the following in a spreadsheet 1) Automatically fix dates of the current spreadsheet when a daily report inserted into a tab. 2) Updates to be performed by using Index and match function and not using VB or Macro. 3) Automatically index and match to another tab in the same spreadsheet. 4) Create charts in summary tab. Note need to use formula instead of macro function.
Project ID: 16189131

About the project

32 proposals
Remote project
Active 6 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
32 freelancers are bidding on average $53 AUD for this job
User Avatar
An expert in excel formulations. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Thanks.
$100 AUD in 3 days
4.9 (327 reviews)
7.6
7.6
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
$60 AUD in 1 day
4.9 (317 reviews)
7.3
7.3
User Avatar
Dear Sir/Madam, I'm happy to help you on this task. Please send me the data sheet to confirm. I'm an expert in advanced excel skills and have already done lots of such dynamic excel models without macros/vba for clients, and you can visit my profile to see my reliability Best regards Priyal
$60 AUD in 1 day
5.0 (195 reviews)
6.8
6.8
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. Best regards
$61 AUD in 3 days
4.9 (238 reviews)
6.9
6.9
User Avatar
Dear client I have previously carried out a number of projects in excel using formulas. Kindly contact me for further details Roy
$60 AUD in 3 days
4.9 (338 reviews)
6.9
6.9
User Avatar
Hi there, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
$66 AUD in 1 day
4.9 (178 reviews)
6.6
6.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered seven excel vba projects in the past one month. Willing to take up your project. Let us discuss further. Looking forward to working with you. Thank you, Regards.
$60 AUD in 1 day
5.0 (109 reviews)
6.3
6.3
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$50 AUD in 1 day
5.0 (34 reviews)
5.7
5.7
User Avatar
I have excellent command on MS Excel. I am well-versed with the index and match functions and achieve the requirements using formulas only Few of my past projects - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$80 AUD in 2 days
4.8 (93 reviews)
6.0
6.0
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$61 AUD in 4 days
4.9 (66 reviews)
5.6
5.6
User Avatar
Hello Sir, I’ve more than 5 years of experience of Ms Excel with advanced level formulas understanding. Kindly text me over chat for further details. You can also review my profile to know more about my skills and experience required for this work. Thanks
$50 AUD in 2 days
4.6 (37 reviews)
5.3
5.3
User Avatar
Hi there, I read through the job details and I am absolutely sure that I can do the project very well. I'v good command on Office tools like (Excel, Word, Formulas, Function, Spreadsheet). I will create clean & formals and function to perform all tasks as per your requirement. Let's chat for short discussion. Thank You
$50 AUD in 5 days
4.9 (33 reviews)
4.6
4.6
User Avatar
Hello, Based on the details we will agree I will created the functionality you need only with formulas without vba macros. I'm also available on Skype for a more efficient communication. FYI, my last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that sends emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius
$60 AUD in 6 days
5.0 (28 reviews)
4.4
4.4
User Avatar
Available Immediately | MS Excel Expert | Assured quality of the work | Check the jobs history for the same
$50 AUD in 1 day
5.0 (8 reviews)
3.4
3.4
User Avatar
Hi This is entirely doable in excel without having to use macros, however, you need to realise that the file size will be larger than if you were using macros. Mainly because all the formulas needed will be duplicated and waiting dormantly in the spreadsheet, even when there is no data to populate the cells with. I would like to work with you on this project, it's always good for an excel macro developer to exercise not using macros. Makes one appreciate just how robust and versatile excel can be. Kind Regards John
$40 AUD in 3 days
5.0 (14 reviews)
3.2
3.2
User Avatar
Hi, I am professional software developer with more than 4 years of experience. I have worked on 100+ excel related projects including formulating numerous formulas. I see you have requirements which doesn't use macro and would like to take up the task. Looking forward to hear from you. Thank you.
$35 AUD in 1 day
5.0 (8 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
$45 AUD in 5 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hi. I worked in valuation module of commodity trading company for 5 years. And thus I am comfortable in devloping complex formule in excel. Please contact me if you would like to share more details of the project. Thanks.
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Data can do wonders if you have MS-Excel. Such an extraordinary software. All the to do(s) listed here are simple but challenging. Provide the details and you will get the job done. I have 5 years of hands on experience on MS-Excel with huge data, professional as well as personal.
$50 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a hardworking person and work and pass on time, no delay, no hassle for your project. Hire me with no regrets! Ready to get more done, let me shave hours off of your workweek. Whether it is business or personal, I am here to help you. I can start now pm me.
$50 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jan 30, 2018

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.