Find Jobs
Hire Freelancers

Complete my report with best excel lookup formulas

$30-250 AUD

Terminado
Publicado hace más de 4 años

$30-250 AUD

Pagado a la entrega
There are 3 sheets of Report Data that I need the formulas created. Sheet DETAIL DATA is the source data. Each month, I insert a row in front of the previous month to add new months data For example, in October, I will insert a new Row I, and September will become Row J. The new months Data (October) will become Row I There are a variety of formulas that I have tried in all the sheets and columns, but I need an expert to populate the best formula in each column and sheet. In the SALES BY CUSTOMER tab, Row D has the formulat that seems to be working best at the moment. I have tried a variety of SUMIF, SUMPRODUCT etc, but this longer formula seems to be the only one I can make work, in regards to: 1-getting the totals correct, 2-Being able to handle the fact that I add in a new months column of data in front of the prior month in the DETAIL DATA tab. I need the Sheets SALES BY CUSTOMER, ALL DETAIL, and REVENUE and GROWTH, to pull data according to the row heading, from the DETAIL DATA sheet. I also need all the heading rows to automatically populate the correct relevant dates based on the report month (contained in the REPORT INFO sheet). I believe the column references are self explanatory in terms of what data is required, but happy to answer any clarification questions.
ID del proyecto: 21824917

Información sobre el proyecto

40 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
$100 AUD en 2 días
4,8 (150 comentarios)
6,2
6,2
40 freelancers están ofertando un promedio de $118 AUD por este trabajo
Avatar del usuario
Hi, I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, and Visual Basic Application including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting databases to and vice versa (+ automation with VBA). My modules allow filling information on forms (with drop-down list ), manipulating and merging the info in structured tables and populating results in build-in reports and forms. There is a search engine with high search capability to find specific records. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. There is a report generator which enables you to develop templates independently, and the files secured by username login and password. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$250 AUD en 7 días
4,9 (90 comentarios)
7,1
7,1
Avatar del usuario
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
$140 AUD en 7 días
4,7 (100 comentarios)
6,4
6,4
Avatar del usuario
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$200 AUD en 3 días
4,7 (70 comentarios)
5,7
5,7
Avatar del usuario
I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automation and create highly dynamic and automated dashboards for Budgeting and Financial Modeling. I will be happy to discuss in detail how I am highly suitable for this project.
$50 AUD en 1 día
4,7 (65 comentarios)
5,6
5,6
Avatar del usuario
Hi there! I read your description. I can make this done in very short time! I am ready to start work right now. i can do this work easily. IF you are interested to work with me message me.
$140 AUD en 1 día
4,9 (60 comentarios)
5,0
5,0
Avatar del usuario
Greetings! Happy to see your Job post! I am Sajid, having Academic Qualification of Charted Accountant. I have read your project details and I am confident I am the suitable and experienced candidate for the task. Look forward to hear from you. I have the following skills: • Preparation of Financial Statements • Financial Model • Business Plan • Business Analysis/Valuations • Bank Reconciliations • Budgeting and Forecasting • Book Keeping in all online software • Data entry • Web Scraping and Research • Data Conversion (PDF to Excel, JPEG, XML etc) I have relevant experience in using MS Excel, MS Project, ERP, SAP, QuickBooks, Peachtree, Xero, Tally and Others Accounting software’s. If you have any query related to my proposal please message me. I will provide you work sample before accepting the project. THANK YOU!!! Regards
$140 AUD en 7 días
5,0 (5 comentarios)
4,1
4,1
Avatar del usuario
Hi, I have worked with data analysis and visualization in excel and google sheet. I would like to work on your project. Let me know if you want to discuss further. Regards, Monir
$250 AUD en 10 días
5,0 (3 comentarios)
3,2
3,2
Avatar del usuario
Hello Sir/Madam I am an expert user of MS Excel. I can help you in completing your report. I can start working right now if you accept my bid. Looking forward to hear a positive response from you. Regards, Ali F.
$60 AUD en 1 día
4,7 (3 comentarios)
1,9
1,9
Avatar del usuario
I am a multi-skilled person with sound proficiency in English language for being a native writer and proofreader while I am also well-versed in French and Portuguese languages. Furthermore, I am a PR professional with expertise on crafting engaging and interesting web content, articles, press release, blog posts, report writing, research paper, thesis writing, technical writing, ppt and all sorts of written materials. Attention to detail is my forte while excellent grammar and use of rich and extensive vocabulary is my priority. You can expect truly impeccable and original write up. Jobs that require higher level of accuracy and focus are my priority. I particularly enjoy tasks where I am required to make use of my writing prowess to the fullest. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service.
$100 AUD en 2 días
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
Note: I will do your project in 25 AUD. I have worked for my various clients across the globe and they are really satisfied with my work. Hi Hope you are doing great :) I have gone through your project details. I am PhD qualified writer currently work Gallup Pakistan. I will help you with report with best excel lookup formulas. I have done various Data extracting, data Processing, and Excel related projects for my clients globally. I am familiar very with Mail chimp, Email Scraping, Excel work, and various Data scraping & Data mining related work and etc. I am 100% sure that I will meet your expectations and deliver within stipulated deadlines. If you have any query feel free to message me for discussions /details and to check my samples. Thank you in advance.
$30 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am highly motivated to assist you. Look forward to discussing this opportunity with you. I have been successful in solving my past client's Projects in a way that saves their time, efforts and money. I strive to minimize our clients’ financial pressure by solving their problems with certain proven techniques and advanced solutions. Given an opportunity, I assure you the best of my services and quality work to your complete satisfaction. Kind Regards Raman Kumar Please tweak this as per the requirement.
$150 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My working hours will be 10am - 6pm (8hr) in the weekend (Saturday - Sunday) Negotiable as your request (based on availability)
$138 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I want to do this project I have Completed knowledge about MS Excel Advanced I have completed many formulas using this project I deliver this project with in 2 or 3 days I have completed this project on time.
$32 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello Friend I am interest in your project you posted. I have good experience in spreadsheet, data typing and data entry and work for eight years in the relevant field.
$200 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm good in excel for formulating the numbers.
$155 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I understand the job I can do your job I am having very good typing speed and knows about formulas used in excel.
$35 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am good work .
$155 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hi i can help your job. you can review my profile page. let me know if you are interested to working with me. thanks milah
$222 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Sir! This is Haslinda. I'm very confident to take your project and will do it with perfection. I have Diploma and Degree in Office System. I have excellent typing skills and huge experience in using Microsoft Office including Excel. I hope you can give me this valuable opportunity to work with you. Please don't hesitate to contact me. Thank you.
$30 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am new to freelancer.com but I have 10 years hands-on in Excel. I am good I excel shortcuts, formulas, macros, pivots charts, etc. I can provide quality deliverable on time.
$30 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Kelvin Grove, Australia
5,0
6
Forma de pago verificada
Miembro desde abr 1, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.