Excel Analysis Summary

Completed Posted 3 years ago Paid on delivery
Completed 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.

Excel Data Processing

Project ID: #28364718

About the project

54 proposals Remote project Active 3 years ago

Awarded to:

professional800

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

£20 GBP in 1 day
(41 Reviews)
4.7

54 freelancers are bidding on average £98 for this job

rahul62544

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.

£89 GBP in 1 day
(255 Reviews)
6.9
AnowarRatul

-- 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

£59 GBP in 1 day
(283 Reviews)
6.4
Devrits

Hi Hiring manager I am IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life More

£250 GBP in 5 days
(66 Reviews)
6.2
narsim3128

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

£35 GBP in 7 days
(65 Reviews)
6.0
finecodervw

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

£80 GBP in 3 days
(80 Reviews)
6.2
rIbrarahmed

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

£35 GBP in 1 day
(35 Reviews)
5.3
kelvinm094

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

£80 GBP in 2 days
(37 Reviews)
5.3
sevillajk01

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

£70 GBP in 3 days
(63 Reviews)
5.4
IgeS

Hi there, Need to have the data from 20 worksheets consolidated and analysis? Please message me if this is any of what you need to know about the attendance of each attendees in the seminar. I'll b standing by to he More

£40 GBP in 1 day
(36 Reviews)
5.2
MMG2019

Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can help you in your project. Feel free to discuss. Thanks

£100 GBP in 2 days
(30 Reviews)
4.8
Barroga17

HI I am an expert in Excel and VBA application. Contact me now to discuss and I will help you fast and accurate. Regards!

£20 GBP in 1 day
(31 Reviews)
4.7
hamidr2020

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

£20 GBP in 2 days
(19 Reviews)
4.5
realtechsl

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

£20 GBP in 1 day
(21 Reviews)
4.1
VbaStudio

Hello. I'm a specialist in Excel and macros programming. I think it can be done just with some formulas. Just PM me.

£30 GBP in 3 days
(11 Reviews)
3.8
Emmyope93

Hi, Good day. I understand you need a good attendance analysis done n Excel. An excel work that provides accurate computations and great presentation while being easy to understand. I will like to assist you on this pr More

£85 GBP in 2 days
(5 Reviews)
3.7
Akshayarajan

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

£100 GBP in 2 days
(8 Reviews)
3.1
jaynanda70

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

£56 GBP in 1 day
(0 Reviews)
0.0
mahadmughal1310

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

£100 GBP in 3 days
(0 Reviews)
0.0
dishasarvaiya53

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.

£135 GBP in 10 days
(0 Reviews)
0.0
houinita1980

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

£135 GBP in 3 days
(0 Reviews)
0.0