Challenge: Mastering Event Planning Challenge

You are creating a simplified contact database for a project that includes names, contact information, and additional notes about each person. The goal is to make the sheet easy to navigate, connect with contacts, and store extra information.

1. Create a table named "Contact List" and add the following columns:

• Full Name;
• Email;
• Company;
• Project Comments;

2. Enter data

Enter data for 4–5 contacts. In the "Full Name" column, list full names in the format "Last Name First Name".
(Type the contact names in the format "Last Name First Name" (e.g., "Smith John") in the "Full Name" column, starting from row 2. Then, enter the corresponding email, company, and project comments.);

3. Split text into columns:

In the "Full Name" column, use Split Text to Columns to separate the last and first names into individual columns. Rename the new columns to "Last Name" and "First Name".

(Select the "Full Name" column, go to the menu, click Data > Split text to columns, and choose "Space" as the separator. Rename the new columns to "Last Name" and "First Name".)

4. Trim extra spaces:

• Check the "Email" column for any extra spaces and remove them using Trimming Whitespaces to ensure data is ready for emailing.

(Select the "Email" column, go to Data > Data cleanup > Trim whitespace to remove any leading or trailing spaces in the email addresses.)

5. Add links for convenient contact:

• Convert the email addresses in the "Email" column to hyperlinks for quick access to email.
• In the "Company" column, add external hyperlinks to the company's website for easy access.

(Select the email addresses in the "Email" column, go to Insert > Link, and type e.g. "smith@example.com"). For the "Company" column, select the company names, click Insert > Link, and paste the website URL.)

6. Auto-fill:

• In the "Project Comments" column, add comments for a few contacts, such as "Priority" or "Project Lead".
• Use Autofill to apply the same comments to other contacts.

(Enter the comment in the first cell of the "Project Comments" column, then click and drag the small circle at the bottom right of the cell down to auto-fill the same comment in the other cells.)

7. Add notes for key information:

• Click on the cell with the name of a key contact and add Notes, such as "Update project status next week" or "Requested contact via messenger".

(Right-click the cell with the contact's name, select Insert note, and type your note (e.g., "Follow up next week"). The note will appear when you hover over the cell.)