Excelling Time-saving techniques that take you from spreadsheet stress to superstardom

Walk through the analytical process one technique at a time.

 

Newest Tutorials

 

Import and Merge Datasets

Learn how to import, export, and merge datasets in Excel by using features such as text to columns, vlookup, and hlookup.

 

Organize Your Spreadsheets

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.

 

Clean Data and Recode Variables

Before you can analyze your data, you’ll need to check for missing data and recode some variables.

 

Explore Your Dataset

Use exploratory data visualization techniques like color-coding and sparklines find initial patterns.

 

Calculate Summary Statistics (with Formulas)

Summarize your data by finding the mean, median, standard deviation, and other descriptive statistics.

 

Calculate Summary Statistics (with Pivot Tables)

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.

 

Putting It All Together

Learn intermediate and advanced spreadsheet skills.

 

Extra Time-Saving Techniques

These extra tricks are the icing on the cake.

 

Showcase Key Findings in Graphs

After you’ve analyzed your data, design graphs to showcase the most interesting nuggets.

 

Communicate Better with Dashboards

Tips for designing static dashboards right inside of good ol’ Excel.