Excel and tips

Here are step-by-step guides to solve some common problems in Excel. I find them especially important because I rarely need to apply these tasks, but the instructions are all in one place when I need them.

  1. How to use Pivot Tables to make quick calculations and organize data
  2. Creating medians for multiple variables in an array using Excel
  3. Joining data in Excel (when you don't have Access available) with vLookup function
  4. Filling in blanks vertically for repeating variables

Excel step-by-step for more basic tasks

These step-by-step instructions were originally written for Microsoft Excel 2011 for Mac, but many of the same steps apply to other versions, years later.