Data Analysis
Prepare reports and draw meaningful conclusions from data. Learn to clean and manipulate datasets to draw meaningful conclusions from existing information.
Welcome to SQL: Modifying Databases and Tables
Brush up on SQL fundamentals such as creating tables, schemas, and views.
Geocoding Raw Datasets for Mapbox
Make sense of unstructured data with enough precision to put it on a map.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
Getting Iffy With it: Conditional Statements in Excel
Effectively utilize conditionals such as IF statements in your Excel workflow.
Taking Out the Trash: Dirty Data in Excel
Dealing With Dirty Data in Excel (continued).
Dealing with Dirty Data in Excel
Cleaning data Excel in the absence of tools designed to do so.
Doing the Excel Data Dance
Taking a step back to reflect on the problems Excel intends to solve.
Adventures in Excel: Power to the Pivot
Power up your Excel Pivot Tables with these pro moves.
The One Excel Formula to Rule Them All
Unlock the secrets of Excel's Index Match.
Dropping Rows of Data Using Pandas
Square one of cleaning your Pandas Dataframes: dropping empty or problematic data.
