Pivot Table Project for Excel

Hi, I am an expert in Excel and Power bi data analysis, data visualization and dashboards. I can create a master file that combines all agents worksheets ane when you have a new agent it will be added automatically then I will create dynamic dashboard that will be updated automatically when you add new data. I will guide you on how to use the dashboard and update the data in a demo video too. I have completed many similar projects before, you can check some of my previous works here. Agent Target: [login to view URL] Please send me the files and clear specifications, I'll complete for free and will send you after checking the result you can award me. Thanks

Dear Employer, I understand you need a tool wherein 30 agents will share their data at some shared location and then data can be picked up from there and graphs and other analytical tools can be created from them. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash

Hi, can you provide sample agent files, and let discuss the logic of the dashboard you want to design. You said the dashboard will gather all data from agents, ok, but also you are talking about updating, mean you need not only to read from that files but also write, is it ?

Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

Hi, I create creative and sophisticated financial, statistical and KPI modules in a simplified and logical manner. My Module in MS Excel analysis trends, performances, operating metrics, valuation methodology, and ratios based on chosen parameters. The reports show results per period, project, cost centre, person, working group and company levels. My modules allow filling information on forms (with drop-down list ) or pulling external databases, manipulating and merging the info in structured tables and populating results in build-in reports and forms. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. I have considerable experience working with Excel, and I consider myself a guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts).

Dear client Let's talk point by point. 1. A dashboard for all 30+ agents performance. 2. One master file for the dashboard. 3. That dashboard file updates itself from all 30+ individual files. I can do it. Kindly contact me. Roy

Hi, Would you like to see a quick demo of your project on developing Managers Dashboard that will pull data from over 30 Excel workbooks completed before you award the project? You can consider it professionally done in less than 24 hrs. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Visual Basic 2. Excel Macro 3. Excel 4. Data Entry/Processing I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi

Hi, Greetings. Working with pivot table makes most of the task simple, specially while we are looking for analysis data, particularly visual (chart, graphs..). I went through the resources and have planned to design and develop a interactive dashboard which will take info from every 30 agents data and create visual presentation of the analysis. Please let me know if you are interested. Thank you.

Sir,      I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards 

I can definitely help you with that. I am a professional Data analyst and Data Visualization expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to develop highly dynamic and automated dashboards. I will be happy to discuss in detail how I am highly suitable for this project.

Dear Sir, I will develop a tools in Microsoft excel with buttons where you will select agent and criteria then it will show you all the info. Please share your agent files and grant access to the share folder so that I can proceed further. I will charge fixed amount of $500 for this project. Kind Regards Gopal

Hi There, I can help you to create a Managers Dashboard, i have done project like this, please check my profile for sample dashboard i have create. Thanks. Regards.

Hi, I can plan to put something like this together, if you will provide a sample of the file the 30+ guys use and detail which are the data that will pop into the various shapes you have in your dashboard. That will help to a better estimate of time & cost regards. Reuben

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks

Hi Sir, I’m a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel free to contact me. Thanks

Hi, i can address your project, if the 30+ files are in one system. Pl clarify, where and how these files are shared. It is very important to address this EXCEL. But for file locations, your request is addressable.

hello can u contact me please to share more details i can show an example before starting ty

✅LOW BID, I'M WORKING ON A REPUTATION✅ Hello! I suggest you to do it as follows. 1. I will create a macro that will collect all your data into a single MS Access database. 2. I will create an Excel dashboard that will use data from the Access database. For a small amount of data, this should take no more than one day. Two days is the insurance reserve, because I did not see your data. Using the Access file as a data source will allow you to make the Excel data model more flexible and convenient. You do not need to install Access in your system. In addition to fifteen years of programming experience, I have an economic background, so I can better understand economic challenges. If you are interested in my offer, please open a chat for more details.

Hi there, I can create a very nice, dynamic dashboard for you. I can do it with pivot tables & pivot charts or with functions & regular charts. With slicers or with drop-down selections. I recently finished a very similar project for 8 salespeople in a sharefolder, and I believe I can easily finish your project. I will need the correct paths in the sharefolder with IP in the beginning as well as the sales rep excel files. I can also record a video tutorial on how to use the solution. The template can be macro free or macro enabled, depending on your preferences. I can complete it within 5 days from agreeing, and I can revise it as many time as needed. I will only consider it done when you are 100% happy with it. It is not possible to attach examples in my bid, but I would be glad to send you some of my templates in the chat. You can also check my profile and see what other clients think of me. Thanks for your attention! Salion

Dear, Well, if you have excel 2013 and above "hopefully 2016 or 2019" and if you are on PC then i trust i can greatly assist in this task. using Excel new power tools we can do alot with your data. Keeping all the shared folders "and its contents" untouched and querying all the data to the dashboard file with all the data transformations required whether it is data cleansing or data modeling, then visualizing the same on a neat dashboard it will be very doable. one comment though is the gauges they are not out of the box in excel vislauzations tools. Looking forward working with you on this job. regards. Ahmad.