Find Jobs
Hire Freelancers

URGENT: Teach me extreme Excel formulas, VBA! (You need to be extremely skilled in Excel!!!) via skype/teamviewer

£2-5 GBP / hour

Closed
Posted over 10 years ago

£2-5 GBP / hour

Can you write stuff like this without a problem? example: =SUMPRODUCT(($A$1:$A$33=$F2)*($B$1:$B$33=$G2)*(ROW($A$1:$A$33)-(ROW($A$1)-1))) or =IFERROR(INDEX($U$5:$AC$9,MATCH($A7,$T$5:$T$9,0),MATCH(B$5,INDEX($U$5:$U$9,MATCH($A7,$T$5:$T$9,0)):INDEX($AC$5:$AC$9,MATCH($A7,$T$5:$T$9,0)),0)+2),"") and using ADDRESS/INDEX, INDIRECT? If you are a extremely competent with excel formulas not just VBA, I need you! Job Description - my budget is about £4/h = $6.5 - You need to be able from about 3pm-10pm as that's usually when im free around. (UK, GMT TIME!!!) - I need to quickly learn advanced Excel formulas and VBA to develop my Data Analyst skills. If you everything in VBA - sorry not for me. - Need to learn very advanced formulas and functions, complex IF formulae along with MATCH/INDEX, COUNTIFs, SUMPRODUCT, macro development for quick data cleansing. - NESTED FORMULAS - You need to have a decent understanding/speaking of English. - Have an idea of how you will teach, I prefer learning by actually doing things - dummy exercise. Mention jigsaw in your reply so I know you read this. - You need to have a decent and reliable internet connection to be able to skype and use a remote assistance program. - Looking to pay a student price per hour; will have too ignore too high bids. - About 3-4 weeks; and about 8-10 hours/week. Skills Required - Advanced Excel (I mean really, an Excel expert - ill test) you. - VBA programmer too. - Advantageous if you have experience of stats, business/financial models and SSRS experience Skills Required
Project ID: 5336775

About the project

16 proposals
Remote project
Active 10 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
16 freelancers are bidding on average £5 GBP/hour for this job
User Avatar
A proposal has not yet been provided
£5 GBP in 10 days
4.9 (19 reviews)
5.7
5.7
User Avatar
I am ready to do the job for you and hopefully I can do it nicely with very good quality of output in time.
£22 GBP in 10 days
5.0 (33 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
£4 GBP in 10 days
4.9 (39 reviews)
4.4
4.4
User Avatar
Hi, I have proven skills related with your project (by exams and previous work). Please consider my offer. Best Regards
£4 GBP in 8 days
4.6 (3 reviews)
3.4
3.4
User Avatar
Hi, I have over 8 years of experience working with Excel VBA and formulas My skills include: 1. Reading/writing data from/to excel and other files (text, word, access)-using VBA 2. Adding complicated nested formulas to worksheets (vlookup, hlookup, match, index, indirect, array formulas).Directly as well as, using Macros based on conditions entered by user 3. Formatting data (rearranging, splitting, combining, sorting) using macros 4. Making macros that react to user actions 5. Combining different charts (Line, column, candlestick etc) on a single chart 6. Connecting to databases using ADO/ODBC and executing SQL queries. Databases worked on: MySQL, Access, Oracle, Other Excel files 7. Creating rich user interfaces in Excel using various controls (buttons, list/combo boxes, radio buttons etc..) Both, directly on excel worksheets as well as on individual forms. 8. Scraping websites from within Excel VBA 9. Automatically generating charts and pivot tables from VBA 10. Optimization using Excel Solver 11. Creating Macros that interact between different Office applications (Word, Powerpoint, Excel, Outlook) Please send me some sample of the input data for testing so I can demonstrate my knowledge then you can decide on hiring me. thanks & regards
£3 GBP in 10 days
4.8 (8 reviews)
2.9
2.9
User Avatar
Hi I specialize in Excel and VBA programming and have completed many projects using MACRO. Have also worked for a fortune 500 compnay - Emerson. Here at freelancer.com I have successfully completed two projects. Looking forward to hear from you. Thanks.
£2 GBP in 10 days
5.0 (3 reviews)
2.2
2.2
User Avatar
Hello, I am interested to work on your project. I have skills on DataEntry work, MS Word, Outlook, Access, Excel Macros and Photoshop. I have trained nearly 200 head counts on Excel in private sector. And i am ready to do the job at your cost. Please let me know if i am eligible for this job. Thank you, With Regards, V. Sivanath
£3 GBP in 10 days
5.0 (1 review)
1.3
1.3
User Avatar
A proposal has not yet been provided
£3 GBP in 10 days
4.7 (2 reviews)
1.0
1.0
User Avatar
Hello. I could help you learn excel. I am an economic student from one of the best colleges from Brazil and I work as intern for one of the biggest brazilian banks, developing macroeconomics models. I could teach you the most important formulas that I use in my work, and if you bring me some problems that you are facing we could solve together. And I know VBA to, so I can teach you when I use VBA to solve my tasks when I use normal Excel formulas. Check my profile, we could do a test class if you want. Thank you.
£4 GBP in 3 days
4.9 (2 reviews)
0.4
0.4
User Avatar
jigsaw First of all, you need to send me an excel file to show you my capability and including everything you need to know, and if you are satisfied with it, we need to find a way to teach you together before everything. Thanks "Don't award me before we have a discussion"
£4 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I understand your project. My skill Advanced Excel . I do not expert VBA programmer too. Best Regards Md. Jalal Uddin
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will try my best.. I am experienced person. I will teach you each formula with eample.............................................................................................
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I am an expert in excel and able to provide you any help on the excel and work on excel. Regards
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am skilled Excel Formula and VBA professional. I have 8+ years experience of MS Excel Dashboard and tracking tools development. I use formulas at least 70%-80% when I automate the any requirements provided to me. Looking forward to hear from you. Thanks and regards. Santosh Venkatesh Yadav
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am Expert VBA Excell, Access Developer,more ever i have sql, desktop developement skill I Believe My ability would perfect for you,because I have completed a more than 15 projects that are relevant to the skills required in this job posting. They include secure payment gateways for the financial sector and a secure informational portal. i can complete your geekato windows8 work, add me on your skype-omdevgohil if you interested in my work Thanks,
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A strategic and logical thinker with excellent knowledge in identifying and defining marketing opportunities and problem having rich experience of 11 years in Market Research Analysis & Project Management • Experience in analysis principles and tactical evaluation of the market environment. • Skilled in generating, refining, and evaluating marketing actions. • Proficient in designing the method for collecting information, managing and implementing the data collection process. • Expertise to set strategic priorities on all aspects of market. • Proficient analyzing the results and communicating the findings and their implications Please give me a chance to serve you. you won't regret it.
£3 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
BLACKBURN, United Kingdom
0.0
0
Payment method verified
Member since Apr 8, 2011

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.