Creation of some Excel reports based on multiple Excel sheets -- 2
$30-250 USD
Ukończony
Opublikowano około 3 lata temu
$30-250 USD
Płatne przy odbiorze
I have an Excel workbook that list all my expenses by month (one sheet by month) and by account (one table by account [bank account, credit card, cash]).
I want to summarise and group by Subcategory all the entries from the three accounts (tables [bank account, credit card, cash]) for each month, and also for the whole year. I need four kind of summaries - one for all entries (Bruno, Family, Cassandre), another for Bruno's Group, another for Family's Group, and another for Cassandre Group. I want only the Subcategories that have entries (don't display the Subcategory if there is no entry for this Subcategory)
Plus I want short table with the total for each Subcategory (only the Subcategories that have entries) and the total for all entries (for the concerned Group)
I created something similar using Google Sheets, you can have a look there: [login to view URL] I also attached a screenshot. The only difference in this Google Sheets, it's that all entries come from the same table (there is not a table for each Account [UBS, Mastercard, Cash])
Requirements
1-Summarise and group by Subcategory all the entries (for Group Bruno, Group Family, Group Cassandre)
2-Summarise the total for each subcategory (only the Subcategories that have entries) and the total for all entries (for the concerned Group)
3-Take the three tables for each month in consideration (UBS, Mastercard, Cash)
4-Be careful, in the file "Bruno's Expenses - 2020", there are some rows used only for autocomplete feature (rows > 100). These rows should not be listed here
5-All empty lines from "Bruno's Expenses - 2020" document should not be listed there. Only rows with relevant info filled (date, debits/credits, recipient, subcategory, category, group) should be listed there.
6-Must be compatible with Excel for Mac
7-Must use functions (index(), match(), etc) or Pivot Table (no VBA macros!)
8-Must be dynamic, accept new entries or modification of existing entries and be updated in live
9-Summary tables should be editable, and should retain changes when an entry is added, deleted or modified.
10-The summarise must be refreshed automatically when an entry is added, removed or edited.
Sir,
I can summarize all these sheets in a presentable manner. the data will be arranged with best formatting with 0% error with the help of formulas and pivot tables.
I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your desired time with added Quality. "I have completed similar projects with five stars from client".
About me
I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm "PWC". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I may have less reviews here because this is my 1st week here but I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients.
Please be my Client and get any type of 'Accountancy', 'Excel', 'QuickBooks', Balance Sheet', 'Income Statement', 'Cashflows' and auditing related work with quality, efficiency and on reduced rates.
Note. The price is negotiable.
I will be available for any query round the clock even if the project is completed.
Regards
Arman Kakar
hello,
i did already similar work..i can start the work immediately once u awarding me .kindly chat with me we can discuss details and better understanding of your vision .i will provide u 100% correct work .thanks
Hello,
I have gone through with contents and understand the requirements. This is a pretty straightforward task and I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once.
I have a good knowledge of Tableau, Power BI, Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc.
Please check my portfolio to know more
Thanks,
Jitender Kumar
Hi, Greetings! ✅checked your project details.
I can create a Excel reports based on multiple Excel sheets.
I have completed the M.SC. (Statistics) . I Have 4 years of experience with Data entry, Data analysis, and MIS Management.
I have strong analysis, and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming.
If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high.
Please Ping me the chat box for further discussion.
Hello, Sir.
Expert of Data Processing, Excel is here.
I've gone through your project requirement and found my skill best suited in this one.
I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Processing.
I am the best suitable candidate to serve you.
If you hire me, I will provide you good result.
Let's discuss details about your job in chat.
Thanks, Good luck.
Hi
I have 10+ years of experience in VBa programming and database management.
I checked the requirement and the attached files . As per the requirement i can create a tool that helps you get the results with 100% accuracy.
if interested , we can connect via chat and get started.
Thanks
Shivani
Hi Hope you are doing good,
I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Kind Regards
Arun
Data Analyst
Dear Employer,
I can help you with Creation of some Excel reports based on multiple Excel sheets.
I have more than 5 years of experience in below listed skills:
Data Processing
Excel
Visual Basic.
Kindly click on chat for more discussion.
Regards,
Sunil
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA. I understand your requirement and I can give my full effort to deliver the project in on time with 100% quality and accuracy...I'm waiting for your kind response.
Hello!
I am really interested in this job. I’m data scientist working remotely with various analytical companies.
I’m offering best quality and highest performance at a price we are both comfortable with. I can complete your project on time and your will experience great satisfaction with me.
I’m well versed in R, python, SPSS, Stata, Excel etc
I have rich experienced in Data Processing and Excel.
For more information about me, please refer to my portfolios.
I’m ready to discuss your project and start immediately.
Looking forward to hearing you back and discussing all details..
Thank you!
Hello,
Please review my profile as I have the relevant skills and experience required for this project.
I can start working right now.
Kindly send me a message to discuss further for references, portfolio, and case studies.
Thanks,
Muhammad
Dear sir/madam,
I am offering my services on short
notice. Relevant Skills and Experience
Please consider me and give me a chance
to impress you by my quality services
Hi there,
Thanks for posting suitable project as per my skill. I am having 2 yrs similar experience and handled lots of projects.
I have reviewed your requirements well and I am ready to start this project with 100% accuracy, I will deliver before deadline with fair price.
Please let's start chat and discuss more details(if need) to start right now.
Thank you,
Virender
Hello, I have read your needs and I know that I am qualified for this job. I am a graduate student. I did pgdca on the computer. I have 5 years of experience. I can type at 40 speed. I excel in ms excel, ms word and its formatting.
Hi,
I am having experience of more than 10 Years in Hr & Admin profile. Works at Ms excel in preparing salary sheet, OT sheet & monthly attendance sheet and creating many MIS using (formulas, pivot table, chart, Data analyzing) and data entry work like that.
It would be great if we could connect to discuss your project in detail. I would appreciate it if you would provide an attachment or a sample of your data.
Looking forward to working with you :)
Thanks!
Hello, I work in the finance division of a pharmacy, I understand what kind of concept you want. an honor to be able to help complete the work that you give. thank you
I can get the job done as quickly as possible because I have a bachelor’s degree in accounting and I previously worked as an accountant and data entry at the same time. My nationality is Iraqi and I reside in Turkey
Hello,
I'm good with excel and data presentation. I can help you with your request. I know that I don't have a lot of comments or completed projects compared to others but it's because it's not a full-time job for me.
Also, to be honest this work is an opportunity for me to preserve my excel skills. So it's a win-win situation if you decide to work with me.
Felle free to contact me.
Regards
