Excel spreadsheet with charts Report
$30-250 USD
Πληρώθηκε κατά την παράδοση
I have a standard spreadsheet which I need productionised to professional template:
1. Optimise layout of tables and charts on 1 or 2 pages, in a professional manner, with corporate identity (logos provided).
2. Macro, or other method, to add another period to the chart data (in the example sheet, this would be 1H16).
a. The charts must always show the past 9 data points
b. Chart colours consistent with corporate ID (to be provided).
3. The user will enter data on “data sheet”.
4. The charts must automatically update.
- Some Object insertion with text depending on formula in first chart
- Eg. If HEPS in chart 1 is lower than consensus, Banner shape must state “Miss consensus”. If higher, then “Beat consensus”. If within 2% of consensus, then “In Line”
- For all other charts, a directional arrow for the last period (upwards, downwards, flat), colour coded if possible (green = up, red = down).
5. Method for user to copy sheet in email body, so it is readable to clients on various devices.
Ταυτότητα Εργασίας: #8598233
Σχετικά με την εργασία
41 freelancers κάνουν προσφορές κατά μέσο όρο $137 για αυτή τη δουλειά
Hello! I'm an Excel expert and I'd like to help you with your project. Please contact me to discuss further details. Regards.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Περισσότερα
Hello, my name is Andrés. First of all thank you for considering my offer. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within thi Περισσότερα
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Περισσότερα
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards R Περισσότερα
Hello There, I reviewed the spreadsheet and also the details you shared. What you are looking for can be best done thorough use of macros and some formulas. I will arrange the charts such that they print well on Περισσότερα
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Περισσότερα
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Περισσότερα
i have a very good experience in excel and VBA(Macros) for it. also i have worked on similar projects.
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Περισσότερα
I am very interested in your project. I have experience in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I will give you my best possible work. I would like to thank yo Περισσότερα
Hello, I am a native Spanish speaker and a full-time freelance, I have the skills and resources required to get done your project on time. I am sure, that you'll be 100% satisfied with my work; I hope you give Περισσότερα
Sir/Madam, Good day! I'm a degree holder and I'm an expert in excel/spreadsheet with 8 years experienced. I'm good in macros, vb in excel, charts, formulas, vlookup, etc. I'm also a virtual assistant for 3 years as Περισσότερα