Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Use Excel Like A Pro. Fast.
Rating: 4.7 out of 5(1,509 ratings)
5,418 students

Use Excel Like A Pro. Fast.

Go from spreadsheet rookie to rockstar
Created byKieran Luke
Last updated 3/2021
English

What you'll learn

  • Ability to design and build well structured models from scratch
  • An understanding of how to use what functions, when
  • Mastery of time-saving keyboard shortcuts

Course content

10 sections • 15 lectures • 2h 25m total length

  • Setting the scene1:01

    This chapter sets the scene, explaining the problem we are tasked to solve. In the rest of the course we will solve the problem together.

  • Develop your model blueprint6:06

    In this chapter we cover two concepts:
    - Start by clarifying the problem you are solving
    - Design your model on paper before building it in Excel

    In the resources you can download:
    - Keyboard shortcuts (for PC and Mac)
    - Raw data files

  • Set up new tabs and author the About page9:04

    In this chapter we cover:

    Concepts:
    - Always include an "About This Spreadsheet" tab in your model
    - Color coding is critical for good spreadsheet hygiene

    Operations:
    - Save as
    - Insert tab
    - Rename tab
    - Recolor tab
    - Resize columns
    - Wrap text
    - Remove gridlines
    - Insert rows

    In the resources you can download:
    - Keyboard shortcuts (for PC and Mac)
    - The raw data file "Sales data.xlsx"
    - "Market analysis-v1.xlsx"

Requirements

  • None

Description

This two-hour Excel crash course is the quickest way to go from spreadsheet rookie to rockstar. It's an accelerated 'learn-by-doing' approach: we'll solve a business problem by designing a model, collecting data and building a spreadsheet. Along the way, we'll cover the keyboard shortcuts, functions and insider 'best practices' to make your spreadsheets sizzle! 

Who is this for? 

Anyone who has to build Excel models from scratch. If you fall into one of these groups, this course will suit you particularly well: 

  • Business professionals (consultants, analysts, marketers etc) 

  • Students using Excel to analyze data or entering business careers 

  • Entrepreneurs who use Excel to run their startups, to analyze opportunities and to present to investors

What makes this course different? 

- It's practical. The instructor worked in consulting at BCG for eight years. That's a lot of Excel. His practical knowledge of how to use Excel in real life, as well as pitfalls and traps to avoid, will save you hundreds of hours of spreadsheet anxiety 

- It's efficient. 2.5 hours of the highest quality content

- It uses the 'case-method' pedagogy. By teaching in the context of a real example, retention is significantly higher than a traditional 'formula-led' approach 

Who this course is for:

  • For students going into business careers and professionals / entrepreneurs seeking to improve their excel skills

Report abuse