You are an intern trying to keep track of who attended which leadership session, and what amounts you need to collect yet for everyone. Because you are new, you are trying impress your boss, so you want to put together an easy to read report that you can present later. Download Lesson_5_Excel.xlsx and make the following changes:
1) Put an X to mark the appropriate cells to show that everyone in Sales attended Part 2
2) Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3
3) Format Column H to be ‘Currency’ with 2 decimal places. Be sure it includes the $ automatically.
4) Each individual must pay $25 for each session they attended. Using a formula of your choice, fill Column H with the total owed for sessions attended, subtracting anything already paid. You may choose to add a header.
5) Sort the entire file (except the headers) A-Z by Last name
