Learn Excel and Master 5 Essential Features

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

      Picture of Excel Ribbon on PC.jpg
      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

      Where to find the Freeze Panes button on PC.png
      Where to find Freeze Panes on Mac 2008.png
      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

      Where to find Pivot Table on Mac 2008.png
      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