Help me do something with EXCEL
Project details
Hi!
I am currently working on a team where we all use the same excel spreadsheet as a base for our tasks but use separate files to track what we need to get done. I want to connect my excel spreadsheet in such a way that is connected with everyone’s excels and these can mutually update.
To better understand exactly what I need to get done please see the word document attached and take into consideration that I need the solution proposed to be fully functional and to be capable of working with over 3000 data every day and that contains Vlookups.
I pay 20 euros for a detail guide of how this was done and a fully working example that takes into consideration the amount of data and the existance of Vlookups. If you feel qualified please don’t doubt to contact me.
Thank you very much.
Awarded to:

Khizer T.
(5.0)
Awarded to:

Khizer T.
(5.0)
Project details
I am currently working on a team where we all use the same excel spreadsheet as a base for our tasks but use separate files to track what we need to get done. I want to connect my excel spreadsheet in such a way that is connected with everyone’s excels and these can mutually update.
To better understand exactly what I need to get done please see the word document attached and take into consideration that I need the solution proposed to be fully functional and to be capable of working with over 3000 data every day and that contains Vlookups.
I pay 20 euros for a detail guide of how this was done and a fully working example that takes into consideration the amount of data and the existance of Vlookups. If you feel qualified please don’t doubt to contact me.
Thank you very much.
skills of Khizer T.
skill ? | level ? | projects ? | ||
---|---|---|---|---|
Excel VB Capabilities |
55%
|
10 | ||
Excel VBA |
42%
|
21 | ||
Excel Macros |
41%
|
21 | ||
Data Analysis |
39%
|
10 | ||
Database Development |
38%
|
10 | ||
Excel |
38%
|
103 | ||
Word |
38%
|
21 | ||
Compensation and Benefits |
37%
|
1 | ||
Certified Public Accountant |
37%
|
1 | ||
Data Visualization |
37%
|
1 | ||
Data Analytics |
37%
|
1 | ||
Data Warehousing |
37%
|
1 | ||
Statistics |
37%
|
10 | ||
Microsoft Office |
37%
|
10 | ||
Accounting |
37%
|
31 | ||
Data Processing |
37%
|
51 | ||
Financial Analysis |
36%
|
10 | ||
Data Science |
36%
|
1 | ||
Financial Forecasting |
35%
|
1 | ||
Financial Crime |
35%
|
1 | ||
Financial Consulting |
35%
|
1 | ||
Financial Accounting |
35%
|
1 | ||
EBS Finance |
35%
|
1 | ||
Budgeting and Forecasting |
35%
|
1 | ||
Executive Compensation |
35%
|
1 | ||
Reward |
35%
|
1 | ||
Executive Reward |
35%
|
1 | ||
Statistics Tutoring |
35%
|
1 | ||
Data Mining |
35%
|
1 | ||
Data Entry |
35%
|
41 | ||
Financial Planning |
35%
|
1 | ||
Visual Basic |
35%
|
21 | ||
Business Analysis |
35%
|
10 | ||
Finance |
35%
|
10 | ||
MySQL |
35%
|
10 | ||
Financial Sales |
35%
|
1 | ||
Sticker Design |
34%
|
1 | ||
Textile Design |
34%
|
1 | ||
Advertisement Design |
34%
|
1 | ||
Sign Design |
34%
|
1 | ||
Poster Design |
34%
|
1 | ||
Packaging Design |
34%
|
1 | ||
Statistical Modeling |
34%
|
1 | ||
Banner Design |
34%
|
1 | ||
Book Cover Design |
34%
|
1 | ||
Brochure Design |
34%
|
1 | ||
Business Cards |
34%
|
1 | ||
Color Grading |
34%
|
1 | ||
Computer Graphics |
34%
|
1 | ||
Microsoft |
34%
|
1 | ||
Statistical Analysis |
34%
|
1 | ||
Logo Design |
34%
|
1 | ||
Database Administration |
34%
|
1 | ||
Database Design |
34%
|
1 | ||
Database Management |
34%
|
1 | ||
Package Design |
34%
|
1 | ||
Financial Markets |
34%
|
1 | ||
Label Design |
34%
|
1 | ||
Entrepreneurship |
34%
|
1 | ||
Graphic Design |
34%
|
10 | ||
Business Analytics |
34%
|
1 | ||
Business Coaching |
34%
|
1 | ||
Business Consulting |
34%
|
1 | ||
Business Intelligence |
34%
|
1 | ||
Business Plans |
34%
|
1 | ||
Business Requirement Documentation |
34%
|
1 | ||
Business Strategy |
34%
|
1 | ||
SAP Business Planning and Consolidation |
34%
|
1 | ||
Enterprise Architecture |
34%
|
1 | ||
Invitation Design |
34%
|
1 | ||
Financial Modeling |
34%
|
1 | ||
Financial Research |
34%
|
1 | ||
Creative Design |
34%
|
1 | ||
Design |
34%
|
1 | ||
Digital Design |
34%
|
1 | ||
eBook Design |
34%
|
1 | ||
Flyer Design |
34%
|
1 | ||
Icon Design |
34%
|
1 | ||
Infographic and Powerpoint Slide Designing |
34%
|
1 | ||
Database Programming |
34%
|
1 |
Some Khizer T. projects
Project Title | Skills required in the project |
---|---|
Excel Data Analysis. Comparison of datasets | Data Analysis Excel |
P&l balance sheet | Accounting Data Entry Data Processing Excel Word |
P&l balance sheet | Accounting Data Entry Data Processing Excel Word |
Excel Task Planner with planner and calendar | Excel Visual Basic |
review financial forecast and edit the balance sheet | Accounting Business Analysis Excel Finance Financial Analysis |
10 graphs from an excel spreadsheet (or Google Sheet) | Data Processing Excel Graphic Design |
Excel Pivot Expert – Advanced Level – Within 2 hours | Data Entry Data Processing Excel Microsoft Office |
Excel power query | Data Entry Data Processing Statistics Visual Basic |
database to track company car cost, oil changes, tire life, mileage use by program and repairs | Database Development MySQL |
Excel Order Form | Excel |
Build me an excel order form | Excel Excel Macros Excel VBA |
Flight SIM tracker | Excel Excel Macros Excel VB Capabilities Excel VBA |