Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Excel in 60 Minutes: Using Real Company Data
Rating: 4.4 out of 5(2,002 ratings)
35,789 students

Learn Excel in 60 Minutes: Using Real Company Data

Filtering, SUMIFS, Pivot Tables, Conditional Formatting
Created byTony Li
Last updated 8/2018
English
English

What you'll learn

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

Course content

2 sections • 14 lectures • 50m total length

  • Introduction: The Current State1:07

    Learn the mechanics of Excel to analyze 2016 hotel data and use real company data to inform a revenue analysis report that guides decision making.

  • Instructions on Getting the Company Data0:29
  • Organizing Raw Data (Filters)4:22

    Organize raw hotel accounting data with filters to reveal revenue by date, focusing on room charge on specific dates and summing dollar amounts in column K.

  • Automate the Process (SUMIFS)5:25

    Learn how to automate revenue calculations with the sumifs function in Excel, using criteria ranges and sum ranges to quickly total by date or category across sheets.

  • Data into Information (Conditional Formatting)5:17

    Turn data into information by comparing revenue by day of week using Excel sumifs and conditional formatting, transforming July 2016 hotel data into meaningful trends for decision making.

  • Putting Everything Together (Pivot Tables)7:16
  • Assignment - Revenue Analysis Report0:47

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

Report abuse