Completed

Excel Analysis Summary

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.

Skills: Excel, Data Processing

See more: set simple linux server tasks, world flag icon set simple, set simple website, set simple viewer dreamweaver, add add install excel analysis toolpak vba, set simple commerce website free, excel analysis toolpak vba, excel analysis toolpak gpo, set simple site vps, phone bill excel analysis report, expertise spss excel analysis, survey qualitative excel analysis, drupal set simple shop, excel form stored long binary data, free lancer project excel analysis, long takes develop simple software, online job excel analysis, set simple equation simulink, set simple form website

About the Employer:
( 4 reviews ) Stockport, United Kingdom

Project ID: #28364718

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
(21 Reviews)
4.3

57 freelancers are bidding on average £98 for this job

(265 Reviews)
8.0
(147 Reviews)
6.7
(63 Reviews)
6.6
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
(147 Reviews)
6.3
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
(61 Reviews)
6.0
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
(65 Reviews)
6.1
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
(216 Reviews)
6.2
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
(67 Reviews)
5.9
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
(34 Reviews)
5.2
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
(29 Reviews)
5.1
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
(53 Reviews)
5.2
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
(35 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
(23 Reviews)
4.5
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
(20 Reviews)
4.0
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
(8 Reviews)
3.6
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
(8 Reviews)
3.6
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
(4 Reviews)
3.2
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
(7 Reviews)
3.0
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
(6 Reviews)
2.2
marinaparshina05

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

£135 GBP in 2 days
(2 Reviews)
3.6