# Learn Excel and Master 5 Essential Features Premium class

## Conlan ORourke, Excel Expert, Non-Profit Co-Founder

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
43 Videos (1h 52m)
• Trailer

1:56
• What is Excel

1:14
• How to Use Excel

1:17
• Using Excel for Lists

0:45
• Why Excel is Valuable

2:40
• Explore Excel

2:11
• Our Course Focus

0:54
• Download Sample Guest List

0:26
• Look at the List

0:33
• Add Titles

4:37
• Freeze Panes

2:04
• Why we need a system of tracking

0:52
• Track Invitation Mailings

3:03
• Track RSVP Responses

1:50
• Track Bride and Groom Guests

1:57
• Track Total Guests

1:06
• Track Table Names

1:42
• Track Meal Selections

3:25
• Don't spend all day typing

0:57
• Create a Data Validation Table

4:31
• Create a Drop-Down Menu

4:13
• Create the Other Drop-Down Menus

7:00
• Enter RSVP details

0:52
• Working with a complete guest list

0:54
• Organizing the List

0:45
• Sort the List

4:48
• Create Bride & Groom Guest Lists

5:03
• Filter the List

4:49
• The List is All Organized

0:42
• Summarize with Formulas/Functions

1:14
• Sum

5:48
• Count

5:22
• Sumif

6:21
• Countif

3:33
• Add, Subtract, Multiply, and Divide

5:39
• Taking Care of all your Calculation Needs

1:03
• Don't Forget about Reception Seating

0:57
• What is a Pivot Table

1:10
• Pivot Table Inputs

3:25
• Create the Pivot Table

7:43
• Expand the Pivot Table

1:21
• Congratulations! You now know Excel

1:05
• Design Away!

0:42

#### About This Class

Need to learn how to use Excel and don't want to bother learning about interfaces or keyboard shortcuts?

My beginner-level course will teach you not only why Excel is so valuable to have as a skill, but also the 5 most essential features. Most importantly, I'll teach in a form of English that people actually speak, and with a topic that is fun: Wedding Planning!

Who should take my class: Whether you are a beginner or have a little experience with Microsoft Excel, my course is the perfect way to confidently put Excel on your resume or strenghthen your knowledge of the program.

Trust me, you'll understand: If you still have that feeling of "I really don't know if I'm going to understand it once I try", don't worry. This is exactly why I've chosen a fun and real-life example  to ease you into beginning to use Excel. I'll guide you through (in plain English!) the overwhelming number of buttons in Excel, so you'll gain a solid understanding of the program.

Learn seriously useful features: You'll learn how to use the 5 most important features of Excel in your everyday work and personal life. They are features that every boss in the world will appreciate you knowing. They will allow you to work more quickly and more accurately, so you can reach conclusions faster and make the best decision possible.

How so? You may ask: By working with my sample guest list of 150 names, you will learn how to create your list in less time and quickly organize it by RSVP/Regrets Only, seating arrangement, preferred meal, etc. You will also learn how to track when and which invitation mailings were sent to your guests. Finally, you will learn how to make sense of the entire list by creating reports that summarize the important details.

It won't take long to complete: Most students finish the course in about 3 hours total. Whether you prefer to cruise through in one sitting, or you like to spread your learning out over a couple weeks, my class allows you to do either. It is broken down into 42 video lessons which are each 5 minutes or less. That means it's easy to save your spot and come back later to keep learning. And remember that you have lifetime access! So, if you want to come back a year from now, it is very easy to find any particular feature want to review.

Fear not, my friend! Acquiring new skills is extremely rewarding, but learning them can often be a painful process. However, I don't believe it should be painful! So, my goal is to make learning Excel an enjoyable process for you. Here's your chance to learn a valuable skill on your own terms.

#### 27 of 29 students recommend

It is very well done and easy to understand, like other recommended comments. Its at a great pace.
##### Tungy Tran
The most challenging part of this course was trying to download the pre-made spreadsheets for practice. I ended up just creating my own. The steps are broken down at the perfect speed for someone just truly learning how to use excel!
##### Amy Scarano
Easy exercises to get a grip on how excel can be used to track and sort data.

573

Students

5

Projects

#### Conlan ORourke

Excel Expert, Non-Profit Co-Founder

Having worked for years in investment-banking and between various departments in Accounting, HR, Operations, and Marketing, I am an expert at Microsoft Excel and the other Office products. My deep understanding of Excel has allowed me to design systems of data organization and analysis directly within Excel. I design my reports so that raw data is input and beautiful, easily understandable reports are output within minutes. They save the companies I've worked for hundreds of hours of work. For this reason, my reports have been praised by the highest levels of management at some of the world's largest banks.