Fill in a Spreadsheet with Data

Hello, I need to compile an organized excel chart of every professor at the “American University in Dubai” All professors will be found on the [login to view URL] website via this link: [login to view URL] - We are only concerned will collecting the information of the professors in the “ACADEMIC UNIT TAB” - After selecting academic unit tab, I need to create a very clean and organized excel document that will list all professors in the following form: Department - Professor Name- Email- Bio Link- Courses: NOTE: I need to collect all the courses offered for each professor between Spring 2017 and Fall 2017, That includes the 2 summer sessions offered in between. LIST FOR SPRING 2017: [login to view URL] LIST FOR SPRING 2017(Graduate Program): [login to view URL] LIST FOR SUMMER 1 -2017: [login to view URL] LIST FOR SUMMER II – 2017: [login to view URL] LIST FOR FALL 2017: [login to view URL] LIST FOR FALL 2017(Graduate Program): [login to view URL] Here is an example of how it should look (with steps): Step 1. Visit the professor’s directory link: [login to view URL] Step 2. Click “academic unit” Step 3. Click “School of Architecture, Art and Design” Step 4. Click “SAA&D Administration” Step 5. Convert the following each professor in an organized manner categorized by department Department - Professor Name- Email- Bio Link- Courses- Step 6. Check to see which courses the following professor has offered at AUD and input the “course description” and “course code” into excel. HERE IS AN EXAMPLE of how the first one shows up: • Department – Architecture • Professor Name: NABYL CHENAF • Email: nchenaf@[login to view URL] • Link: [login to view URL] • Courses (Course description followed by course code): - Architectural Design Studio IV - ARCH202 - Architectural Design Studio VII - ARCH401 - Internship - ARCH561 / Internship - IDES478 - Interior Lighting – IDES363