Free Excel Tutorial - Learn Excel in 60 Minutes: Using Real Company Data

Description

In this course, you will learn:-

• Have a firm grasp of the fundamentals of Excel (on a Mac).
• Know how to organise and analyse real-world business data

Syllabus:-

• Introduction: The Current State

• Instructions on Getting the Company Data

• Organizing Raw Data (Filters)

• Automate the Process (SUMIFS)

• Data into Information (Conditional Formatting)

• Putting Everything Together (Pivot Tables)

• Assignment - Revenue Analysis Report

• A Better Assessment

• Instructions on Getting the Company Data

• Benchmark Against Competitor Performance (Date Ranges)

• Performance Metric #1 - Occupancy (COUNTIFS)

• Performance Metric #2 - ADR (AVERAGEIFS)

• Putting Everything Together (Dollar Signs)