Learn Excel in 60 Minutes: Using Real Company Data

Learn Excel in 60 Minutes: Using Real Company Data, available at Free, has an average rating of 4.67, with 14 lectures, based on 1880 reviews, and has 33469 subscribers.

You will learn about Have a core understanding of Excel essentials (on a Mac) Have familiarity in organizing and analyzing real business data This course is ideal for individuals who are Beginners in Excel curious about how it applies to a real world business or Job seekers applying to internships or full-time jobs that require Excel proficiency It is particularly useful for Beginners in Excel curious about how it applies to a real world business or Job seekers applying to internships or full-time jobs that require Excel proficiency.

Enroll now: Learn Excel in 60 Minutes: Using Real Company Data

Summary

Title: Learn Excel in 60 Minutes: Using Real Company Data

Price: Free

Average Rating: 4.67

Number of Lectures: 14

Number of Published Lectures: 14

Number of Curriculum Items: 14

Number of Published Curriculum Objects: 14

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Have a core understanding of Excel essentials (on a Mac)
Have familiarity in organizing and analyzing real business data

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Organize and Analyze

Lecture 1: Introduction: The Current State

Lecture 2: Instructions on Getting the Company Data

Lecture 3: Organizing Raw Data (Filters)

Lecture 4: Automate the Process (SUMIFS)

Lecture 5: Data into Information (Conditional Formatting)

Lecture 6: Putting Everything Together (Pivot Tables)

Lecture 7: Assignment – Revenue Analysis Report

Chapter 2: Draw Insights

Lecture 1: A Better Assessment

Lecture 2: Instructions on Getting the Company Data

Lecture 3: Benchmark Against Competitor Performance (Date Ranges)

Lecture 4: Performance Metric #1 – Occupancy (COUNTIFS)

Lecture 5: Performance Metric #2 – ADR (AVERAGEIFS)

Lecture 6: Putting Everything Together (Dollar Signs)

Lecture 7: Bonus Lecture – Set Next Year's Goals

Instructors

Tony Li
Hotel Manager

Rating Distribution

1 stars: 25 votes
2 stars: 50 votes
3 stars: 261 votes
4 stars: 764 votes
5 stars: 780 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu