Excel Analysis Summary
£20-250 GBP
Paid on delivery
I have a set of 20 woerksheets in Excel which detail attendees at a recent conference sessions (spread across a week). The conference had 22 separate sessions and each worksheet lists the attendeed and the time sepnt in the session. Not all the attendees joined in all of the sessions. What I need to do is generate an overall summary of everyone that attended the sessions, with the summary showing which sessions each person attended and the time spent in the session. The purpose of the summary table is as a simple lookup table that can be used to determin whether someone attended enough sessions to receive an attendance certificate and for follow-up discussions that will be running ins respect of some of the sessions
Each of the worksheets contains a list of names and duration of training for each session (ie. name (col A) time spent (col B)
The summary table should list all the attendess (col A) and each of the sessions should have a column with the attendance duration for each of the attendees listed in col A. The summary table thereby providing a one-sheet look-up for all the attendees, the sessions they attended, how long they were in the session.
Project ID: #28364718
About the project
Awarded to:
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I am now full- time freelancer after job experience of more than two decades. It included more than deca More
54 freelancers are bidding on average £98 for this job
Hi there, Sure thing, I will create a summary sheet for you as you have mentioned in the description, Do u have the list of all the attendees? or i have to make one from all the files? can we talk? Thanks Much, RK.
-- EXCEL EXPERT --- I CAN START RIGHT AWAY --- -- Hello sir, I have read your project details carefully. I can complete the analysis by maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro C More
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed pr More
Hi, As I understand you would like to perform analysis in Excel for data collected for conference. It would help to get a copy of the sheet. I am well versed with Excel and various formulas and can help on this. Loo More
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More
Esteemed employer, I hold a Master's degree in statistics making me a suitable person for your project on Excel Analysis Summary. I have more than 3 years of professional experience in statistical analysis. Besides, I More
Hello, I can help you with your project. I have read the details and yes I can help you create an automated training tracker attendance which consolidates the attendance of the partucupants per session and create detai More
Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can help you in your project. Feel free to discuss. Thanks
HI I am an expert in Excel and VBA application. Contact me now to discuss and I will help you fast and accurate. Regards!
Hello, I have read your project details and I would love to work on your project. I assure you accuracy and quality work. Looking forward for working with you. Regards, Hamid
Hi, I I am expert in Microsoft Excel moreover I have 7 years of experience in advanced Excel data analysis dashboards Vlookups pivot table data integration and data processing. I will do the project in time and delive More
Hello. I'm a specialist in Excel and macros programming. I think it can be done just with some formulas. Just PM me.
Hi, Understand that you are looking for a summary which captures the attended time the session name against each attendee. Will help you build the same. Will also add in further key inputs from the data so that you do More
Greetings for the day! I am Jay, a Mechanical Engineer with professional experience of around 3 years. During my tenure I have worked on various technical excel sheets which require such tasks to be performed using Ad More
Hey, Thanks for reading my response, I am Mahad, a Data Entry specialist. I have many years of experience in Data Entry. My first priority is to satisfy my clients with my work. I offer my services including Data Entr More
I hve good experience for your work.i do best work within your days and your budget. I m Professional work in Excel and all apps.
I will carry out the task very professionally and work on any modification you require in a manner that achieves your satisfaction and the desired of the file