Microsoft® Excel

• Use this spreadsheet program to best record and interpret your data from a simple list to complex data.
• Learn document basics such as how to open and save a file, understand the program screen, and enter and edit data.
• Enhance your spreadsheet's appearance and therefore readability by formatting the spreadsheet, managing column width and row height and merging cells.
• Learn to calculate your data using the AutoSum or other simple formulas and functions.
• Organize your data by sorting and/or filtering it.
• Analyze your data using charts and lists and conditional formatting.
• Manage large workbooks by organizing the data onto multiple sheets, repeating column headings on multiple pages and by controlling what you see on your screen at once, using features such as freezing and splitting panes.
• Learn how to control what prints where by using print layout and printing features.

Needs Analysis Form

Quick Reference Cheat Sheet