Walk through the analytical process one technique at a time.
Learn how to import, export, and merge datasets in Excel by using features such as text to columns, vlookup, and hlookup.
When you’re staring at a spreadsheet for hours on end, a little organization can go a long way. To stay organized, I create new sheets, freeze panes, and insert filters.
Before you can analyze your data, you’ll need to check for missing data and recode some variables.
Use exploratory data visualization techniques like color-coding and sparklines find initial patterns.
Summarize your data by finding the mean, median, standard deviation, and other descriptive statistics.
Pivot tables are the fastest, most accurate way to analyze your data — and they’re easier than you think. You can use pivot tables to summarize anything from demographic information to satisfaction survey responses.
Learn intermediate and advanced spreadsheet skills.
These extra tricks are the icing on the cake.
After you’ve analyzed your data, design graphs to showcase the most interesting nuggets.
Tips for designing static dashboards right inside of good ol’ Excel.