Review four corners:
1. Make a copy
2. Freeze Panes
3. Four corners test
4. Check the math
Excel and the Black cross copy function
5. Sorting
6. Percentage Change:
(New Number-Old Number)/Old Number *100
NICAR coursepack How to Filter in Excel Basics and Sorting in Excel Excel formulas Practice Rates and Ratios using this test data: Transit Basic Data Types: Importing Data into Excel
NICAR Coursepack: Basics and Sorting in Excel Open sample dataset: citybudget.xls 1. Make a copy 2. Four corners test 3. Check the math 4. Sorting 5. Percentage Change Formula: (New number-Old Number)/Old Number * 100 and use % symbol Background and Help: Tutorial Video Lynda.com tutorial videos on Excel. More on Lynda.com Excel: NICAR pack—Cohen reading: Think in ratios – construct a ratio on the student loan beat. Memorize common numbers on the beat———
More Basic Excel Tricks How to freeze panes in Excel
PIVOT TABLES
Basic introduction to pivot tables
Calculations and Pivot Tables
