Schedule: This is a one-day class held on Friday, January 20
Take-home book used in this class:  Course ILT: Excel 2010 Basic – Included in the class fee

This class presents beginning features of Microsoft Excel 2010.  Learn how to enter and edit data, labels and formulas, work with functions, format cells, print worksheets, create charts and work with large worksheets.  

• Identify the components of the Excel interface; use the Help window; navigate worksheets
• Enter and edit text, values and formulas; examine the order of operations; insert pictures; use AutoFill; save and update a workbook
• Move and copy data and formulas; use the Office Clipboard; use Paste Link; work with relative and absolute references; insert and delete ranges, rows and columns
• Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT and COUNTA functions to perform calculations in a worksheet
• Format cells, rows and columns; merge cells; apply color and borders; format numbers; create conditional formats; copy formatting; apply table styles; sort data
• Check spelling; find and replace text and data; preview and print a worksheet; set page orientation and margins; create and format headers and footers; print gridlines
• Create, format, modify and print charts based on worksheet data; work with various chart elements; and apply chart types and chart styles
• Freeze panes and split a worksheet; open and arrange a new window with the current worksheet content; hide and unhide data; set print titles and page breaks to optimize print output; insert different even and odd headers; manage multiple worksheets
• Represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales and icon sets); insert and modify SmartArt graphics; insert and modify screenshots