Excel spreadsheet
- or -
Post a project like this3490
$$
- Posted:
- Proposals: 18
- Remote
- #755133
- Awarded
Excel consultant, Business Consultant, Accountant, Business Plan writer, Excel design, Forecasting, Excel specialist, Market Researcher, financial modelling, CT600, VBA Excel,
Harrow
Purchase Audit, Data Entry, Statement reconciliations, Admin, Customer Services, Writing, Proof reading
Wallington
50666893483208270363659278803195397873482234687513586695939443720693044
Description
Experience Level: Intermediate
General information for the business: we are a training broker
Industry: Business
Description of excel work: I need a spreadsheet that needs to be created that will allow me to track sales along with training dates.
Column 1 = Booking Number ( this is just a text column, no formula)
Column 2 = Buyer (this is just a text column, no formula)
Column 3 = Provider (this is just a text column, no formula)
Column 4 = Course title (this is just a text column, no formula)
Column 5 = Date of Course (this is a date column which will be manually entered)
Column 6 = Date of Booking (this is a date column which will be manually entered)
Column 7 = No of places (this is just a text column, no formula)
Column 8 = Course Cost (this is a pound column which will be entered manually)
Column 9 = Course Cost Inc VAT ( this needs to be a formula which enters column 8 figure plus 20%)
Column 10 = Sale Price (This needs to be a formula that enters column 8 figure plus 15%)
Column 11 = Sale Price Inc VAT (this needs to be a formula that enters column 10 figure plus 20%)
Column 12 = Profit ( this needs to be a formula that enters the difference between Column 8 and column 10)
Column 13 = Payment Terms (this needs to be a number column which is manually entered)
Column 14 = Payment Due in (this needs to be formula which enters column 6 date plus the figure entered in column 6)
Column 15 = Payment Due out (this needs to be a formula which enters column 5 plus 30 days)
Column 16 = Invoiced out (this is just a tick column)
Column 17 = Invoiced out (this is just a tick column)
Extra notes: This needs to be completely editable so any future changes can be made
Industry: Business
Description of excel work: I need a spreadsheet that needs to be created that will allow me to track sales along with training dates.
Column 1 = Booking Number ( this is just a text column, no formula)
Column 2 = Buyer (this is just a text column, no formula)
Column 3 = Provider (this is just a text column, no formula)
Column 4 = Course title (this is just a text column, no formula)
Column 5 = Date of Course (this is a date column which will be manually entered)
Column 6 = Date of Booking (this is a date column which will be manually entered)
Column 7 = No of places (this is just a text column, no formula)
Column 8 = Course Cost (this is a pound column which will be entered manually)
Column 9 = Course Cost Inc VAT ( this needs to be a formula which enters column 8 figure plus 20%)
Column 10 = Sale Price (This needs to be a formula that enters column 8 figure plus 15%)
Column 11 = Sale Price Inc VAT (this needs to be a formula that enters column 10 figure plus 20%)
Column 12 = Profit ( this needs to be a formula that enters the difference between Column 8 and column 10)
Column 13 = Payment Terms (this needs to be a number column which is manually entered)
Column 14 = Payment Due in (this needs to be formula which enters column 6 date plus the figure entered in column 6)
Column 15 = Payment Due out (this needs to be a formula which enters column 5 plus 30 days)
Column 16 = Invoiced out (this is just a tick column)
Column 17 = Invoiced out (this is just a tick column)
Extra notes: This needs to be completely editable so any future changes can be made
Steven H.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
29 May 2015
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