Key Concepts

Review core concepts you need to learn to master this subject

Cells in Excel can be filled formulaically

A formula begins with the = sign followed by an expression using built-in Excel functions and standard mathematical operations.

Exploring Data
Lesson 1 of 2
  1. 1
    Excel lets us store, organize, and analyze our data all in the same place. This makes Excel a great one-stop-shop for exploring a dataset prior to performing a formal analysis. In this lesson, we’l…
  2. 2
    Let’s start by taking a tour of the Excel interface! When you first open up Excel, the sheer number of features can be a little overwhelming. But once you understand the structure behind Excel’s la…
  3. 3
    Let’s start by exploring numeric data! In the learning environment, we’ve loaded a dataset containing the number of new cars produced in the US by year (from the [Bureau of Transportation Statistic…
  4. 4
    The raw data we get often isn’t in precisely the form we would like to analyze. For example, our new vehicle data contains the number of new vehicles for each type of vehicle, but what if we wanted…
  5. 5
    Since Excel is often used to store and display data, we can scroll to explore, too. If the data is randomly arranged, it’s hard to get any insight by just scrolling. But if the data is organized in…
  6. 6
    Sorting is excellent for organizing data, but finding specific data in a sorted table can still take a lot of scrolling. To answer questions about data with specific features, we’re better off usin…
  7. 7
    In this lesson, you’ve learned how to explore datasets in Excel using three key methods: * formulas to summarize and transform data * sorting to organize data for visual inspection * **fil…

What you'll create

Portfolio projects that showcase your new skills

Pro Logo

How you'll master it

Stress-test your knowledge with quizzes that help commit syntax to memory

Pro Logo