Learn Excel in 60 Minutes: Using Real Company Data

Filtering, SUMIFS, Pivot Tables, Conditional Formatting
Rating: 4.3 out of 5 (1,461 ratings)
22,298 students
Learn Excel in 60 Minutes: Using Real Company Data
Rating: 4.3 out of 5 (1,461 ratings)
22,298 students
Have a core understanding of Excel essentials (on a Mac)
Have familiarity in organizing and analyzing real business data

Requirements

  • Have Microsoft Excel (Mac or Windows) installed
  • Able to keep up with the fast-paced course
  • Be resourceful and use the internet to fill in any knowledge gaps
Description

Use Excel to organize a real company's accounting and customer data. Then apply key practices in data analytics to draw insights from the data. 

This course is very straightforward and targets people that want to pick up Excel as quickly as possible. Keep in mind that this course may not be for everyone because we move fast. Video tutorials are also done on a Mac, and it may be a little different on a Windows PC. 

You are not required to have any prior experience with Excel, but there will be some knowledge gaps if you are 100% unfamiliar with it. In any case, we have structured the course so that you can  easily follow along, but we expect students to be resourceful (i.e. Google) to fill in any gaps. 

Excel tools you will learn: Pivot Tables, SUMIFS, COUNTIFS, AVERAGEIFS, filtering, conditional formatting, copying formulas, using dollar signs, and more!


Who this course is for:
  • Beginners in Excel curious about how it applies to a real world business
  • Job seekers applying to internships or full-time jobs that require Excel proficiency
Course content
2 sections • 14 lectures • 50m total length
  • Introduction: The Current State
    01:07
  • Instructions on Getting the Company Data
    00:29
  • Organizing Raw Data (Filters)
    04:22
  • Automate the Process (SUMIFS)
    05:25
  • Data into Information (Conditional Formatting)
    05:17
  • Putting Everything Together (Pivot Tables)
    07:16
  • Assignment - Revenue Analysis Report
    00:47
  • A Better Assessment
    01:09
  • Instructions on Getting the Company Data
    00:29
  • Benchmark Against Competitor Performance (Date Ranges)
    05:54
  • Performance Metric #1 - Occupancy (COUNTIFS)
    07:19
  • Performance Metric #2 - ADR (AVERAGEIFS)
    04:08
  • Putting Everything Together (Dollar Signs)
    06:03
  • Bonus Lecture - Set Next Year's Goals
    00:37

Instructor
Hotel Manager
Tony Li
  • 4.3 Instructor Rating
  • 1,461 Reviews
  • 22,291 Students
  • 1 Course

Tony is a Hotel Owner/Operator, and has been helping and teaching students for more than 3 years.

As a business operator, he has a deep understanding of the "day-to-day" processes in a business, and he shares this with his students. This includes resources such as operational business data, training videos, and Excel workbooks.

Recently, he has compiled all of his educational material into a quick 60 minute online course that aims to get students to Excel proficiency as quickly as possible.