Excel Analysis Summary
Budget £20-250 GBP
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.
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
57 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.
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
-- 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
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
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
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
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'm a specialist in Excel and macros programming. I think it can be done just with some formulas. Just PM me.
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
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
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, With over 5 years of experience in Excel. I’ve gone through your complete project description. My main skills are as follows: Visual Basic, Excel VBA, Excel Macro Thank you for your attention. Hope to discuss det More
