Find Jobs
Hire Freelancers

Creating a excel project budget dashboard

$8-15 USD / hour

Terminado
Publicado hace más de 7 años

$8-15 USD / hour

Hi The assigment at hand is a school work that i need help with. I got an dataset of information, it concernes multiple projects in a goverment company. The task is to take the informatin and turn it in to a general dashboard and one for the project managers. It has to be a "one-pager". So the use of slicer should be implemented. Now i tried to do it on my own and understood that i laked the necessary excel skills so im turning to you for help. The KPIs i would like to have are: Planned value (PV), Earned value analysis (EVA) Cost Variance (CV), Overdu projects/crossed deadlines, Schedule Variance (SV) and precentage of projects completed on time. Feel free to ask anything. The KPI:s are pretty simple. Best regards, Adis This is the assigment : The assigment ” One-pager” This tab represents a "one-pager" whose purpose is to give a quick overview of the ongoing investments. General information This file is the controllers main tools. It contains all investments and is directly conected to the accounting system, which means that data is always fresh. The role of an controllers includes determining the annual budget (business plan / VP) for all investment projects. Throughout the year every project is to be followed upp according to this budget. Partly to ensure that projects adheres to the budget but also to ensure that the projects planned in the budget really gets started. Throughout the year, the investment economist also updates the project managers forecasts on their projects and the status of submission forecast shown in the "investment list". (See the tab named forecasts) There are several departments in the company that are interested in the data contained in this file, so the "one-pager" should not only aims to meet the controllers own monitoring needs. It may be that individual project managers or department managers want to view the data based on their own perspective. By meeting also their need for follow-up and analysis you create a great added value to the company. The companys investment portfolio is divided in three different budgetframes; "Within the framework", "Extended scope", and "PU". These must be monitored separately The entire investment framework, in addition to being broken down by the different budget, is also divided into two categories. On the one hand, the companys own estates ( named FSK) and on the other hand, the sporting estates (named IDF). The two categories must not be mixed (ie, projects can not prioritized between these two), but they must be followed up separately. A project is thus combined with both a framework and a category, which gives a total of six possible combinations. Explanation of ”the investment list" The first columns that has a green main menu refers to the basic data for projects such as budgetfram, unit and department, division between the IDF and FSK etc. Status of whether the forecast is filed or not shown in the column labeled "status of the forecast submission" (note that the data is initially only available in a separate tab) The columns that are of the most interest in addition to the columns with green main menu is the outcome columns, forecast columns, VP columns (ie budget). Get Started Tips Be sure to do the one-pager foreseeable and mix graphs and tables. Useful formulas can for example be VLOOKUP, Index / fit, COUNTIFS, SUMIFS, year, today, displacement and much more. Note that the column for the forecast submission is empty and that the data is in a separate file. Be sure to do the one-pager "dynamic" so as to provide accurate data, not just for today but for every day of a year. The file's data refers to end of the month of November / December. Also think about how you can meet several needs at once. It is OK to remove or add lines and tabs, make your own assumptions etc. It is not corecctnes of the numbers that is important but the way they make possible the analysis and presentation that is in focus! Good luck!
ID del proyecto: 12539858

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I am currently an Excel Application Developer working in a civil engineering firm located in Taiwan. My job requires me to develop Excel Dictator Applications for project management purposes. I'm bilingual in English and [login to view URL] current job includes: - Implementing PMP(Project Management Professional) concepts to our current project management system - Electronising the ISO 9001 form - Developing Excel Applications - Analysing Account Receivables I am here to look for Excel related jobs as I am familiar with Excel's existing functionalities and VBA programming. I think I could help you out with the project and I am excited for this opportunity.
$12 USD en 2 días
5,0 (1 comentario)
0,6
0,6
10 freelancers están ofertando un promedio de $22 USD /hora por este trabajo
Avatar del usuario
Hi, I am good at Excel vba. I have seen the details. I would like to discuss the KPI and presentation part in the allocated 4 boxes and a slide bar. Looking forward to discuss in the chat.
$40 USD en 2 días
5,0 (316 comentarios)
7,0
7,0
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD en 3 días
4,9 (123 comentarios)
6,4
6,4
Avatar del usuario
Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.
$15 USD en 2 días
5,0 (86 comentarios)
5,3
5,3
Avatar del usuario
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$50 USD en 7 días
4,8 (20 comentarios)
5,3
5,3
Avatar del usuario
A proposal has not yet been provided
$24 USD en 10 días
4,8 (29 comentarios)
4,6
4,6
Avatar del usuario
Hi, I have seen the description file and the excel. Plz explain me of KPI to formulate as required. Happy to support on the project completion.
$22 USD en 3 días
5,0 (10 comentarios)
2,4
2,4
Avatar del usuario
Administrative Assistant who goes above and beyond basic administrative tasks and takes on multiple projects at once. Excellent work ethic and strength in boosting company morale. Good proficiency with excel spreadsheets and reports using pivot tables and charts. • Dedicated Team Player • Multiple Tasks • Proficiency with Excel Spreadsheets • Data Entry • Monthly Reports • Creative problem solver • Exceptional communication skills • Quick learner • Microsoft Office Proficiency • Receptionist Area
$8 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi,I am a new honest and punctual freelancer with Strong Educational background. and will be giving my 100 % to give u best result. I read your project details and understood. We can move ahead for a reasonable budget. Fee free to ask any Question. So, PM me for further discussions. Best regards. Asif Mehmood
$13 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWEDEN
Stockholm, Sweden
5,0
6
Forma de pago verificada
Miembro desde oct 24, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.