Update a Apple Numbers Spreadsheet with Formulas and Functions
¥1000-3000 JPY
Completed
Posted over 6 years ago
¥1000-3000 JPY
Paid on delivery
Hello,
I am looking who knows Apple Numbers well and could quickly make this spreadsheet work for us.
I need to update a spreadsheet from Google Doc to Apple Numbers because the formulas and functions do not pull through when it was exported.
To do:
1. Tab titled Transactions: Column B, Category. Needs to be connected as a drop-down list to the options on the Tab Categories > Category Name.
2. The Tab titled Profit and Loss needs to be connected to the Transactions tab. So for all columns there needs to be a search function that would find the totals from the Transaction tab for the corresponding items. For example, Revenue> Sales : would need to find a corresponding total amount and the accurate month from the Transactions. (This is a copy of the formula from the google doc : =if(isblank($F7),,SUMIFS(Transactions!$E:$E,Transactions!$B:$B,$F7, ARRAYFORMULA(MONTH(Transactions!$C:$C)),MONTH(G$4))))
If you have any questions, don't hesitate to ask via direct message!
Thank you!
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
Relevant Skills and Experience
I have more then 5 years experience of advance excel such as lookups, pivots, macros, vbscripts etc. I have the relevant skills and experience to complete your work in given time frame.
Proposed Milestones
¥500 JPY - At the start of project
¥2000 JPY - After final submission
Please provide more details about work and also a sample for reference.
¥2,500 JPY in 1 day
4.3 (14 reviews)
3.2
3.2
16 freelancers are bidding on average ¥3,075 JPY for this job
Greeting,
I have understood your Update a Apple Numbers Spreadsheet with Formulas and Functions task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Data Entry, Data Processing, Excel, PHP, Software Architecture
Proposed Milestones
¥3200 JPY - Update a Apple Numbers Spreadsheet with Formulas and Functions
Greetings! My Name Is Murad And I’d like to be considered for your position.
I Would Love To Have The Opportunity To Discuss Your Project Further.
Relevant Skills and Experience
I Provide certain services :
1. MS Office
2. Web Research
3. Data Entry
4. CorelDraw ,Photoshop And Illustrator
5. eCommerce , Amazon , ebay , Shopify
6. WordPress
Proposed Milestones
¥3500 JPY - Milestone
Good knowledge in excel and MS office. Typing speed over 40 and I’ll be able to deliver the project within the deadline.
Relevant Skills and Experience
Good knowledge in excel and MS office. Typing speed over 40 and I’ll be able to deliver the project within the deadline.
Proposed Milestones
¥2500 JPY - Good knowledge in excel and MS office. Typing speed over 40.
Hi i am Raghunandan , Technical guy ,
I know advanced excel and excel , I can take your project and can be completed by two 2 to 3 days depending on the work.
Regards
Raghunandan
Relevant Skills and Experience
Excel , Advanced aExcel Powerpoint , Ms Word
Proposed Milestones
¥2500 JPY - Completed work
Additional Services Offered
¥1 JPY - can contact me if any issues and will work free
i am romel ellivera,i am graduate of information technology, i am performing data entry for 6yrs. and i have an extensive exposure in microsoft excell. i can assure you that i can delivered reports.
Relevant Skills and Experience
updating warehouse stock materials and uploaded to delphi system