Population Pyramid

This tutorial demonstrates creating a population pyramid in Excel using data from a cohort-component model. An abbreviated set of directions in text can be found by clicking here.

Click the image to begin streaming video (10 minutes).

How to Transfer an Excel Chart to Microsoft Word

This is a tutorial to show how to properly insert a chart created in Excel into a Word document for publication. Have you ever copied-and-pasted an Excel chart to Word and then found yourself trying to fix font sizes by trial and error? What a mess. Then this tutorial is for you. It shows how to properly size and format your chart in Excel prior to transferring to Word.

Click the image to begin streaming video (8 minutes).

Creating an Excel Chart: Comparing Income Inequality with Lorenz Curves

This tutorial demonstrates how to make a chart in Excel, with the example of comparing Lorenz Curves for changes in income inequality between 1967 and 2006 in the United States.

Click the image to begin streaming video (11 minutes).

Measuring Inequality: Calculate Dissimilarity Index

This tutorial demonstrates how to calculate a Dissimilarity Index in Excel. The example uses 2000 Census data to investigate income inequality among municipalities in Berrian County.

Click the image to begin streaming video (6 minutes).

Measuring Inequality: Create an Index

This tutorial demonstrates how to calculate an index, and how to use Excel's conditional formatting to visualize data. The example uses 2000 Census data to investigate income inequality in Berrian County.

Click the image to begin streaming video (6 minutes).

Excel Basics: Doing Calculations

This tutorial demonstrates basic calculations in Excel using 2000 Census data, including: entering formulas; copying and pasting; anchoring formulas; filling cells; and formatting cells.

Click the image to begin streaming video (11 minutes).