Event Management 101: Step-by-step Instructions | Jeff | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Event Management 101: Step-by-step Instructions

teacher avatar Jeff, Product Marketing Manager + YouTuber

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

11 Lessons (34m)
    • 1. Welcome to the Class!

      1:34
    • 2. Background & Class Project

      1:05
    • 3. Spreadsheet Tab Management

      3:00
    • 4. Overview tab

      1:27
    • 5. Raw Data tabs

      5:45
    • 6. Key Information tabs

      7:01
    • 7. Pre-Event tabs

      6:37
    • 8. During Event tabs

      0:50
    • 9. Post-Event tabs

      3:30
    • 10. Advanced Project Management Tips

      2:23
    • 11. Final Thoughts

      0:45
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

201

Students

--

Projects

About This Class

Introduction to Event Management: The Basics

Think back to the last event you helped plan - it could be a small group activity, a surprise party, or even a team offsite. Now think about the biggest, fanciest, most over-the-top event you have ever attended in your life...

Pretty different experiences huh?

The (awesome) thing about event management is that while those two events could not be more different, the structure marketers use to plan those events and the processes we follow more or less stay the same.

Don't believe me?

  • Both events have attendees
  • Both events have some sort of registration or invitation process
  • Both events have a set agenda
  • Both events have communication channels...
  • And I can go on!

----------

In this course, I use a free and popular tool - Google Sheets - to walk you through step-by-step how I go about planning events at work as a Product Marketing Manager.

Over the past few years, I've been responsible for hundreds of offline and online events; ranging from small-scale C-level Roundtables that take place during a single afternoon to thousand people webinar series that last for several months

First - I go over the structure of my Event Management template on Google Sheets (i.e. how I set it up)

Second - I deep dive into each tab, explain the purpose of that tab, and go over adjustments I'd make "in real life"

Finally - I share advanced project management tips that extend beyond just events

WHO am I?

I'm Jeff, a full time Product Marketer. In my spare time I like to tinker with tools and create systems that help me get things done faster - or as one of my friends puts it: "Get better at being lazy"

Meet Your Teacher

Teacher Profile Image

Jeff

Product Marketing Manager + YouTuber

Teacher

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Welcome to the Class!: Over the past few years, I've been in charge of hundreds of offline and online events. These events span from sea level roundtables that go for just several hours, all the way up to 1000 people, webinar series that last for several months. While these may sound like very different events, the cool thing about event management is at the structure you use and the process you follow, more or less stays the same. It's just a scale that is very different. Hi Ryan, my name is Jeff. I'm a Product Marketing Manager at a large tech company. And on the side I make YouTube videos on the topics of career and productivity. This course is designed for beginners with no event management experience. I will show you step-by-step how to use a free and popular tool, Google Sheets, to plan and manage a hypothetical event that is very representative of actual events I'm responsible for at work. Specifically, this course is broken down into three parts. First, I'll go over the structure of the spreadsheet and talk about the pre, during and post method. Then I'll deep dive into each tab and explain the purpose of those tabs before finally sharing some more advanced project management tips that will extend beyond just events. I have linked to Google Sheets template down the project and resources tab down below. So feel free to make a copy and follow along. And although I've already filled out most of the information to save you awesome time, I will be making some key edits and adjustments throughout the course so you can see how I deal with real life situations. The idea is that this template and the concepts from this course are applicable whether you're planning a birthday party, your next team offsite or large-scale proc announcement. Let's get started. 2. Background & Class Project: Hi, thanks so much for enrolling. Before we begin, please make a copy of my Google Sheets template. And as you follow along, I highly recommend you make this template your own by coming up with their own event, planned a surprise party plan, Apple's next big launch event. And as I go through these concepts, see how they apply to your specific scenario. Because trust me, you're going to learn so much quicker this way. For example, for my hypothetical offline event, the confirmation messages are sent by e-mail. E-mail is the communication channel here. If you're having a less formal event, for example, happy hour, your communication channel is going to be something like WhatsApp or iMessage, assuming you have no Android friends, smog disclaimer to prevent any confusion, since we're sticking with Google Sheets a whole time, we're not going to be talking about that execution, like how to set up a stage for an offline event, or how to set up a live stream, right? That gets way too deep into the weeds. And for marketers, we generally work with dedicated event agencies who specialize in event execution with all that out the way, let's dive into spreadsheet tab management. 3. Spreadsheet Tab Management: Right off the bat, you'll notice I've split this dual sheets into six different sections. Overview, key information, pre-event, during the event, post events, and raw data using these empty tabs as section headers. And these are all color-coded as well, right? And do this for two reasons. Number 1, you're going to receive a lot of questions about the event from different stakeholders and you need to find the information as quickly as possible. And number two, because there are so many teams involved in event planning, you want the spreadsheet to be as self-explanatory as possible. The idea of the overview tab is very simple. Imagine someone with 0 background of the event comes across this spreadsheet after they looked through the information on this tab, they should have a general understanding of what the event is about without having to ask you directly key information taps include RSVP, snapshot, agenda, promotion channels, and comms timeline. And the way to think about these four tabs is also very simple. Just imagine if someone were very senior like your manager or another team's director message you about the event? What would they be asking about? Nothing I percent of the time, the answer can be found in one of these four tabs. They might ask about how many people have signed up so far. Rsvp snapshot, how the content is coming along. Agenda tab, which promotion channel is driving the most silos, promo channels and one resending the next conformation or reminder email out comes timeline for us, the project managers, every single one of these tabs within the spreadsheet is important, right? But trusting want to tell you, very few senior managers will care about all the specific details and will only want like the high-level information that you have. So thoughtfully already consolidated in the key information section here, pre-event taps, this is where the pre, during and post method comes in. Broadly speaking, this part just helps you organize all the things you need to plan before the event actually takes place. Hence, pre-event during the event tabs list out the things you need to take care of during the event and you guessed it, post here means post-office. No post-event tabs help you organize the things you need to do after the event is complete. Quick note these yellow, purple, and green tabs are by no means an exhaustive list of tabs you need for each section. But this provides a very good start. And as long as you think about it in this way, like before, during and after the event, we decrease the chances of missing something important. Rod, as tabs, this is exactly like it sounds. This is where you keep all the raw data you collect throughout the event planning and execution process, like registration data, attendee data, engagement data, a post-event survey data that all kept here. And I like to mark these in gray. Over the next few lessons, I'm going to deep dive into each one of these tabs and explained that tabs purpose, go over the formatting and formulas within and make adjustments based on real life situations. Okay, Let's dive. 4. Overview tab: As mentioned in the overview tab, provides context for someone with absolutely no background and has all the basic information. You definitely want the event title, the event date, the time, the location, and the days until event, and simply subtracting today's date from the event date. So everyone is very clear on how far the event is from today. There are two reasons to include the event objectives here. One, they remind everyone we're all working towards and to the objectives actually influence event execution. For example, if one of the key objectives is to increase user retention during the event, more resources should be invested towards the content, the games, and the Q&A during the event itself, right? Instead of spending that money on paid media to increase sign-ups. Because sign-ups does not. More sign-ups does not mean more user retention, event format and topics are pretty self-explanatory team meeting notes. So you would usually have weekly project update meetings with cross-functional teams. And it's great to link the meeting notes like right here so everyone can see it. For useful links. This is where you want to hyperlink to other documents with read information that's not included in the spreadsheet. For example, if this is an annual event as probably smart to include last year's, all of last year's documentations so you can reference them, draw inspiration, and remind yourself of learnings. 5. Raw Data tabs: All right, Now the overview tab is done. We're actually going to jump all the way to the right and look at the raw data. First, we're going to jump around a bit here, but I promise you it's all gonna make sense. Rsvp Data tab captures all the registration information. And I can see I've included two hyperlinks up here. The first is for a Google Forms, where people actually use to sign up for the event. And the second is the output worksheet from the Google Forms. You won't have access to the Google forums, but don't worry, you don't need it. You will have access to this form Response tab, and that's all you need quickly. Now note there are a lot of platforms that help you manage event registrations. I'm just using Google Forms as an example here, most of the more advanced platforms will allow you to use something called UTM parameters, which basically just tells us help you track where people saw your sign-up form. If you've never heard about something like that, don't worry about it. We're not going to use UTM parameters for this course. Instead, we're just going to add a question in a Google forums asking them how they came across our event. And we're going to assume they're going to answer honestly. Now after people sign up, their information is automatically going to be populated into an output like spreadsheet. And what you wanna do is you want to actually import this raw response information over to your RSVP Data tab using the import range function. You do this because you don't want to mess with the wall response data, but you need to make additional calculations based on their responses. The import range function is very easy to use. First, I always have a highlight cell telling people, Hey, there's import range function right below, so don't mess with it. And import rand function is actually right here. And c equals import range. Quotation marks, the URL of the tricks or worksheet you want to import over. And quotation mark and comma quotation mark again, the name of the tab of that worksheet. So Form responses. One, an exclamation mark, and the columns you want to import over in this case is a all the way to D, right? And then you press Enter. After that you might see an error message, but don't worry, just click Allow Access or whatnot. You should see the information input over something like this without the formatting. Yeah, of course. Now that information is imported over, you can mess with this or make formatting adjustments without affecting the original light output spreadsheet. And as more people sign up, it will automatically populate down below the four green columns. Here are additional calculations you need to do. First, you want to assign a UID or unique ID to each person so you can identify and track them later. I like to use, use a combination of left, right, and, and functions. To do this, I'm basically just taking two characters from random sells for one person and just mashing them together to come up with random string of characters. And once you do this for one person, let's delete this for now. You can simply select it, hold it down, press Command D or Control D. And this will apply to all of the different rows. The user segment is important because usually there are different types of people coming to your event and you want to bucket them into different segments, will assume everyone with a.edu email is a student. Everyone with an business e-mail are a business professional and someone with, let's say Gmail is obviously personal and since they told us how they came across or heard about this event, will have a channel code here as well. Don't worry, you'll see how both the segment and the channel code comes into play a bit later. The deduplication or D cube column is simply checking whether someone's signed up more than once. I'm simply using a COUNTIF function here that tracks this person's e-mail in relationship to the one that comes above it. If this person signed up twice using the same email, this will actually be too. We'll see an example of how this plays out again in a little bit. Moving over to the attendee data tab. This is simply a record of everyone who attended your event for offline events, this is when people would check into the offline space rights. There are 10. This 10 dense is recorded and for all at events is when they log in to, let's say the online live shin URL. And similar to RSVP data, usually there is a raw output data, especially somewhere, and you want to import them information over before making formatting adjustments and making additional calculations. For the purposes of this course, I'm just going to copy and paste it over and not have another input range function for the segment and channel columns. Here I use a v lookup formula that reference the unique ID and their segment and channel from the RSVP Data tab. Don't worry about the IF error formula and the VIP phrase here. We're going to come back to this. It's all going to come together. Don't worry. Generally you want your attendees to fill out some sort of post event survey after the event and their responses are captured here in this survey data tab. Again, same deal. There's usually a raw, raw data, especially somewhere you import range that over and for additional calculations, since the people who put something into the survey can only be a function of attendees. You can actually use a simple VLookup formula on the attendee data tab. This time, now that we have all the tabs up and running for RSVP attendee and survey. We could go back to the key information tabs and see how all this ties together. 6. Key Information tabs: The RSVP snapshots tab gives you registration numbers like at-a-glance. So no to dig through all the raw data. And as you can see this broken down to RSVP type summary and promotion channels summary. And within RSVP type summary, I further break this down to suit two types of registrations. Eligible registration like people I want to come to my event and others that may not be suitable to come to my event. And this is dependent on their user segment, right? And this is where the segment I mentioned earlier comes into play for the register column because we're able to segment out our registration data in RSVP Data tab. We can just use a COUNTIF function that references the RSVP Data tab and the segment column. If you remember a column G here, and count up all the people we've defined as student. And therefore students, we apply the same thing for businesses. And that's another four, right? Assuming that this event has already occurred and the event is completed, we can do the exact same thing for a number of attendee attendees out of these segments by referencing the attendee data tab, right. And how many of those filled in a survey based on the survey data tab for VIPs a nominations. Don't worry about this for now. We're going to come back to this once we get to the nominations tab, hopefully you now see why I went through the raw data tabs before coming back to key information and in particular RSVP snapshot tab. Moving down here you can see that we have like two total signups. What does this mean? What does the difference? Well, total RSVP simply as a sum of everyone who signed up and total eligible is more meaningful because of the, some of the segments that actually want to come to my event, right. So since there are two personal sign-ups here, who may I may not want to attend this tech tuber roundtable. We don't include them in total eligible. And what is this yellow highlight, 30 percent drop-off target? Well, if you've ever had any sort of event, you know that people cancel last-minute whatnot. And usually the industry benchmark for offline event show up rate is around 70 percent, right? So therefore there's a 30 percent drop off. So we just simply multiply the total eligible sign-ups by 0.7 or 70% to guesstimate how many people would show up and prepare accordingly. Now, again, assuming that the event has already occurred, we can actually just use the number of attendance to divide by total eligible sign up to get the attendance rate. In this case, it's 50 percent rather low. And the survey fill rate is the number of people who filled out a survey divided by the number of people actually came. Great news is time, a 100 percent of our attendees filled out a post-event survey for promotion channels summary, this is where you can see which promotion channels drove the most sign-ups. Again, I use a COUNTIF formula here. And remember, for raw data, for the RSVP data rather we have the chow that used to sign up, right? So all we need to do is use countif and count the number of sign-ups per channel and record it here. If you really want to get fancy, you can actually highlight all of this and use conditional formatting and give them a color color scale. And let's say assign the most sign-ups using green color and red being the least. Now some of you might have already noticed that the total RSVP number here, ten does not match up to the total hours. We pin number here 12. Remember there's not total eligible, this total RSVP. And this is because of the nomination row here. Again, don't worry, we're gonna come back to this, I promise. For the agenda tab, this is just a place to keep track of all the content that's going to be shared during the event. You have the start time, the how long each section's going to take, the topic, the speakers, and their role. The green columns are what you as a project manager responsible for. The headshots of the speakers, write their script, their slides, and the status column, not started working progress done. So from a design standpoint, I like to use like, I like to use alternating colors here, like white, blue, white blue to separate the rows like visually. And for status, for the Status column we can do. You can also add conditional formatting. For example, if the text is WIP, which is work in progress, you can change it to yellow, for example, right? So this is also able to show other people at a glance what the status of that particular piece of content is. The promo channel tab lists out all the promotion channels you're using to promote the event. For example, you have the channel type, channel name and channel code for, let's say Marquez. She's going to use his empty VHD YouTube channel and his Instagram to help promote the event by sent sharing the link to the Google form that we talked about earlier. Dave, through his email newsletters, website, and we have even have paid media such as the verge and Andrew police helping out the asset format slash deliverables column is just the format of the asset. Is it a video, Instagram posts or story or simply pure text, right? The go-live date, the link to the assets so we can reference them easily, the ultimate owner and the status column again, I like to have that today's date using that today formula of top to see how far we are from the go-live dates and the comments column is just notes. I want to remind myself of the comms Timeline tab lists out all of the communication materials you need to send out to registered individuals at attendees. There are different categories of communications. So for example, RSV become formation simply is an automated, automatically generate a message telling them that they've signed up, right? The confirmation email, assent to those eligible sign-ups telling them they're confirmed to come. And reminder e-mails are sent out closer to the event date reminding them to come. And generally you want to send out these emails in different waves. Why? Let's say you start sign-up today and your event is in three months. You don't want to wait 2.5 months to send your first confirmation email out because someone could have signed up tomorrow, right? That's why you want to stagger out the confirmation reminder e-mails. So there are different touch points for all registered individuals for invitational events like this one I have here. You can also include like a rejection email and the best-practice. There's a direct them to another resource since they're not able to attend this particular event. Moving over, I've the one-line summary of the communication itself, the CTA or a call to action embedded at the end of that communication. Material, the time is going to be sent out, the date is going to be sent out on the status. Again, the link to the communication, copywriting for easy review and approval by either yourself or your manager or the PRT. And that wraps up the key information tabs. Let's tackle the pre-event tabs next. 7. Pre-Event tabs: Action items is just like it sounds, is just a list of actions that you and anyone else involved in the event needs to take to ensure a successful event. Don't let this seemingly complex tab scare you though. It's actually pretty simple. Once you break it down on the left, you can see categories and subcategories under categories is worth pre-event during the event and post event. As you can see, I like to think about action items in chronological order as well. Prep work are things that you have to do even before we can start thinking of planning of the event. For example, selecting an external agency if you're working with one, or at least aligning with cross-functional teams to make sure you get their buy-in straight from the beginning. Pre-event can be further broken down into content. Who says what promotion, The promotion channels we just talked about creative, the overall design elements of the event and logistics. I just use as a catch-all for things that don't fall into the other subcategories for doing event. They're definitely logistics needs to take care of or take note of during the event on site, of course. And for post event, you need to analyze, clean up the data, and perhaps write a recap of the event to share both internally and externally. Move over to the other columns. I'm not gonna go through each one of these action items. One because it's not comprehensive, but it should give you a very good starting point. And to, the point is to think through as many steps as possible using the structure, write it down and refine as you go along the structure as what's going to help you have a successful event and not the specific rows and action items in this tab, the owner is the person ultimately responsible for that action item deadline, what is due? Reference, linking to relevant slides or documents, the common column and the status column, of course, letting you know what has been completed and what to do next. All right, Now, let's talk money. Money, money, money must be funny in it, okay, to switch it up somehow. In marketing and the cost tab, a big part of your job is managing the budget allocated to you. So you need to first figure out how much you might need to spend on this event and see whether you can even afford to spend that amount based on the budget that you have. And again, you want to bucket the cost into different categories. Here I've promotion, communications, creatives, delocalization, and offline setup. And obviously there are a lot more items I fall into each one of these categories, right? For example, for offline setup, that might be lighting costs that are made because to buy the raw materials, there might be marketing agency labor costs, right? All of those optimizations should be linked in a different proposal document. Here. This tab should just serve as a high-level overview of how much your total cost is going into each cost bucket. Because to be very honest, your manager is only going to care about this total cost number here, alright, and total wireless tab. So this something a lot of people miss. Basically if you're hosting an event, there's gotta be an internal channel for your other team members or your, for your colleagues to sign up. This has beneficial for many reasons. For example, number 1, you can quickly send an internal email to these team members telling them what to expect during the event and how they can help out even or when they sign in if it's an offline event, they can get a special employee badge that helps identify them to other guests. As you can see, there is a dummy proof instructions up here. And usually when I'm planning an event, I will send an email out to all the relevant teams with an action item hyperlinked to this tab directly, telling them to sign up and put their team, their email and their name. And I have a deduplication or D do but column here that catches people like this who sign up twice. As you can see, this just again be counted formula. And because this person has his or her email twice, this shows as two and it's highlighted. What I can do before sending out an email blast, I can just create a filter. Choose this, de-select all the twos or threes or fours if people saw that four times, press. Okay. And I'm now left with a list of just one time sign-ups. All right. The nomination tab that I've been teasing you all about, basically this is the same as internal waitlist before external, guess. If you host any sort of large corporate event, I guarantee you they're going to be people messaging you, asking if they can bring someone who's like not eligible or another VIP who just needs to come to this event. This tab is for them. So how this works is that the internal employee nominates that guest, hence nominations by inputting their own team and email here, the guests information here. And this is where again, marketing D Duplicates, confirms or rejects that person and assigns a unique ID. Some of you might be wondering, why don't these people just set up the normal way? Well, some of these people might be very senior and they're not down to input information in Google Forms. Or as I mentioned, they're not relevant to the business, but a senior leader want them to join and you can't really say no. Now that we know what nominations are, we can go back to some of the other tabs and update the formula starting with attendee data. Remember, for a tiny data, we're using the RSVP data in the VLookup. But for nominations, they don't fall under normal RSVP's. And that's why I've the IF error formula here, that if they don't show up in RSVP, which they shouldn't. We will have the VIP allocated to them and they sign up using nomination channel. Makes sense now, Yeah, by the same logic and the RCV snapshot tab for the VIPs for registered. There, we're not going to find them in the RSVP Data tab, right? Like businesses and students, rather, we got to actually go to the nomination tab and countif, countif all the confirmed nominations. And that's how it updates. Here. Moving down, we apply the same logic for promotion channel summary. For nomination. We shouldn't be actually referencing the RCP data tab, but rather the nomination tab. So I'm gonna go all the way here to the right nomination, select here, and choose the criteria to be the word comfort, like so. And we should see the number of g here and the total RSVP 12 is going to align with the total US would be 12 up here. Don't you just love it when everything comes together? 8. During Event tabs: Moving on to the during event tabs, or rather just the one tab I have here, singular. And this is because this during part is so dependent on the actual event you have that there's no point go over very specific details. For example, for small offline gatherings involving senior guess, there's usually a seating chart involve different team leaders might want to sit with their respective clients and maybe clients from the same industry. You want to be on the same table. Now compare that with an online live stream event. Tabs you want to include in the during section, there would include information like the life and platform do you or Alto use for rehearsal, the actual event itself? What a Washington according afterwards, instructions on how different speakers from different locations can dial in, et cetera. 9. Post-Event tabs: Onto the post-event tabs, First up post of analysis. So this can be based on the survey data your attendees fill out. So imagine you create a survey on Google Forms and your attendees filled them out after the event, starting with the snapshot table top here, number of registration, these are example numbers, obviously a number of attendees, number of service filled, and the logistics and content satisfaction rate. So this is actually a pro tip. I generally like to ask the audience, again, me feedback on logistics and content separately as opposed to giving me a score out of five for the vet in general. The reason I do this is if you think about it, marketing is more responsible for the logistics, right? The operations and the speakers are more responsible for the content. And by bringing these two parts out, we're able to get more insight into what we can do even better next time. For example, if the logistics scores low 4.1 out of five, but the current scores high 4.8 out of five. We know that the speakers and an excellent job and we need to figure out what went wrong operationally, average watch time and average view duration percentage. These are mainly for online events where we can track how long each viewer State Online for it. So for each one of these following tables, each representing a survey question, you'll see that I broke down the answers by users segment for example, students, businesses, and VIPs. This is extremely important to do versus looking at just the overall all attendee score because different segments may resonate with different topics. And by looking at these broken down numbers, you'll find a lot more interesting insights. For example, if the overall event were targeted towards businesses and working professionals. But those is one topic that received a much higher rating from students. It may be worthwhile to expound this topic in a follow-up event with this target audience, right? If you didn't break these numbers down by segment, you'll just be stuck with an overall average number that tells you almost nothing. Puts it here. Each one of these questions, I should have a purpose. Aka you should not be asking questions just for the sake of asking post-event survey questions. Answers should help shape how you think about the next event or how you follow up with these attendees. For example, if you want to keep engaging the same target audience, ask about what they want to hear next time and see if you can deliver. See how which promotion channel they recall to be top of mind. Because even though you might have used UTM parameters to track where they signed up, it's always interesting to see what they say versus what you tracked. And I always include one question, the very end, asking the attendees to tell us one thing we could have done better be at the food at offline event or was it a bit laggy when signing on to the live stream or with a color for the charge a little bit off, you know, because no event is perfect and there's always room for improvement. The recap tab here has all the information you need to send out either an internal recap e-mail to your colleagues and teammates or an external blog post, right, summarizing the content that was shared during the event similar to the objective tab is always smart to include a reference links, for example, files or blog posts from last year that you can reference. So you don't really have to reinvent the wheel. Okay, So that wraps it up for all the tabs within the spreadsheet. Now let's quickly go over some advanced project management tips for Google sheets that will extend beyond just events. 10. Advanced Project Management Tips: First off, I call these advanced project management tips because they're definitely not necessary to have a successful event or project, but they will make your life easier. And other professionals, I promise you will take notice tip number one for shared spreadsheets that you own, it's always great to include instructions or notes on the top left corner of each tab, no matter how obvious it seems to you, you've seen examples of this already. So for the RSVP tab, I've included the two links here, right? Because information in these two links is related to the information within this tab or something like even the recap tab. Add a couple of rows here on the top-left, I might write something like this tab has all the information needed to write. Recap e-mails for this event. Event sounds extremely obvious to me and you write, but we have to assume someone with 0 background is going to come across the spreadsheet and these tabs. And you actually don't want these random people messaging you and asking you all these questions. So it's actually in your best interest to make sure each tab can be standalone. Tip number 2, use data validation whenever possible. So a good example of this is within the nominations tab here under status, I have a data validation we will set up where you can only type in rejected or confirmed. If i've I tried to type in anything else and press Enter, it doesn't. Let me write. Very good example of why this is important is if you use a formula somewhere else to reference the information in this column. If someone else or you make a typo and you don't have that data validation, that formula will mess up, right? It's a domino effect. So you might as well just limit what you can write here and know for a fact that Google Sheets will not make a typo and your formula down the line referencing this column will also not make a mistake. Tip number three. And this is very relevant for the Action Items tab. And it's that the owner should always be one person, not two, not three, not a team, but one. For situations where your contact is like a team e-mail alias or a team alias, try your best to identify a POC or point of contact you can hold accountable or responsible. Because as a deadline ears, you need someone right to reach out to and give you that information. 11. Final Thoughts: All right, a few final thoughts. Although this is by no means a comprehensive course on event management. The core principles I shared and the structure I went through should be more than enough for you to host your first ever corporate event. And please let me know down in the review section or the discussion section, if you end up using this template in some shape or form, speed up the template. I really hope you make it your own by planning a wedding, a team offsite, or surprise party for Jeff. If you did, feel free to upload it into the project section. And I love to take a look and see what we came up with. Lastly, if you enjoyed this course, I just want to learn more about event or project management in general. Please let me know. In the meantime, I'll see you over on my YouTube channel. Have a great one.