Putting It All Together

These videos combine techniques shown in earlier videos so you can learn how to apply your new skills to a variety of datasets.

Advanced tutorials include:

Or, watch the entire putting it all together playlist in YouTube.

& and Proper

Transform “ANN EMERY” into “Emery, Ann” without typing any names by hand.

How to create satisfaction survey data tables

Learn how to analyze your satisfaction survey data and organize the findings in a table – in just 4 minutes.

Satisfaction survey data tables and the =countif() function: Easy troubleshooting

How to automate dashboards using Word and Excel

Automatic data tables in Excel using =countifs() and drop-down menus

Automatic snapshots in Excel using nested IF arrays and drop-down menus

Easy appendices for open-ended survey data


Return to top

Jump to: Excel for Evaluation homepage | Importing and MergingHousekeeping | Cleaning and Recoding | Exploring | Descriptives | Pivot Tables | Charts | Extras | Putting It All Together

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s