Hello, this is my first post (I will be following up this post with another). I am Training & Development professional. This project is to design a peer-to-peer training tool in Excel. This will be available on the company's intranet, and will be used by all full time employees. There are 6 store locations.

The goal of the project is to encourage company wide collaboration; encourage training through peer pressure; encourage training through a channel that eliminates the need of an employee to ask "where can I get training on this?".
The problem is employees do not seek training because as of right now it is from management.

Details:
Excel 2013
Windows 8.1
Microsoft Outlook is the email server

Things to note: I am not very experienced in Excel; I am not experienced with VBA, macros. I can create scripts that import info from tabs into the main tab. I can create drop down lists with these scripts so that other cells are filled in with the related information.

Here is my Box link to show an example
https://app.box.com/s/z4anjv46cue2f1pmh6gv

Question:
I need each employee to use this spreadsheet...select their name, then select the topic they would like to be trained on. I have set it up so that when the user selects the topic, the name of the instructor is automatically populated.
? How can I set it up so that the user can press the cell next to the instructor's name and the "click" will bring up an [already populated] email [that would populate the instructor's email address in the "To:" field]...? Everything in the [would be ideal] but not necessary.
 I think that this feature would allow the employee seeking training to be in full control. The email could even already be populated with the following: "Can you teach me [insert the subject] within the next two weeks? Please email me with your availability."

Per the title of this post I am also looking to see if its possible to do the same with making an appointment in their Outlook Calendar.
" " " " if its possible to do the same with sending a reminder to the instructor [and to the user].

Just in case this is helpful, this is the script that creates the auto add of the instructor next to the subject:
=IF([@COURSE]="","",IFERROR(VLOOKUP([@COURSE],tblCourseList,2,0),"Not Found"))

how do I create a button so that the user can initiate this macro for the email. And would it be possible that the email "to" field is already filled per the instructor that was automatically entered per the user's choice of the subject? (refer to the Box link above for an example layout of my cells).



Also, the next column should have another button as a reminder email.


Possible?


Thank you for your time and help. I will do my best to provide any additional information.

Thanks!