I need an excel document amended
- or -
Post a project like this3148
£10(approx. $12)
- Posted:
- Proposals: 6
- Remote
- #1140421
- Awarded
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer
Colombo
WordPress Data Entry, Data Scraping, Website research, PDF to Excel/Word, Micfosoft Office, Contact synchronization in Excel, Photoshop, InDesign
Zagreb - Centar
1229784985342104922057152611964631249289
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I need the attached sales statistics amended (Just Deliveries_Admin_Sales Statistics_2016).
I would like to add two columns under each profit centre. Columns to be: a) Received b) Pending.
Profit centres are:
1. The Range, Slough
2. Any Van
3. The Man and Van
4. Rico
5. Hermes
6. New Contract
7. New Contract
8. New Contract
9. New Contract
10. New Contract
I would also like two additional total columns added after 10. New Contract and before Total Income. These two columns should be entitled: a) Total Income Received b) Total Income Pending.
All formulas should remain intact, but the following additional formulas need to be added:
1. All income received from the profit centres should automatically total up under the column entitled: Total Income Received.
2. All income pending from the profit centres should automatically total up under the column entitled: Total Income Pending.
3. Total Income Received + Total Income Pending should show in Total Income column.
The above formulas should reflect in the quarterly figures at the bottom of the spreadsheet (I have attached a template used for one of my other companies - for you to use as an example).
This should be created in Excel format - printable form (margins set).
I would like to add two columns under each profit centre. Columns to be: a) Received b) Pending.
Profit centres are:
1. The Range, Slough
2. Any Van
3. The Man and Van
4. Rico
5. Hermes
6. New Contract
7. New Contract
8. New Contract
9. New Contract
10. New Contract
I would also like two additional total columns added after 10. New Contract and before Total Income. These two columns should be entitled: a) Total Income Received b) Total Income Pending.
All formulas should remain intact, but the following additional formulas need to be added:
1. All income received from the profit centres should automatically total up under the column entitled: Total Income Received.
2. All income pending from the profit centres should automatically total up under the column entitled: Total Income Pending.
3. Total Income Received + Total Income Pending should show in Total Income column.
The above formulas should reflect in the quarterly figures at the bottom of the spreadsheet (I have attached a template used for one of my other companies - for you to use as an example).
This should be created in Excel format - printable form (margins set).
Bookmyobc Ltd
99% (271)Projects Completed
301
Freelancers worked with
166
Projects awarded
59%
Last project
15 Dec 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies