Exploring Data
Learn how to leverage Excel to explore data.
Start
Key Concepts
Review core concepts you need to learn to master this subject
Cells in Excel can be filled formulaically
Cell References
Formula Recalculation
Dragging Formulas in Excel
Using dollar signs in Excel
Sorting in Excel
Filtering in Excel
Pivot Tables
Cells in Excel can be filled formulaically
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
- 1Excel 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…
- 2Let’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…
- 3Let’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…
- 4The 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…
- 5Since 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…
- 6Sorting 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…
- 7In 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
How you'll master it
Stress-test your knowledge with quizzes that help commit syntax to memory