Excel 2003 - foundation

course description
after completing this course, participants will be able to:

• plan and create worksheets incorporating different data types
• construct and edit formulas and functions
• use a variety of formatting techniques to enhance worksheet presentation
• print and select print options
• manage large worksheets, multiple sheets and workbooks
• generate and print charts using the chart wizard
• sort long lists quickly

topic
getting started-screen layout, navigation tools, help
data entry-data types, autocorrect, autocomplete, pick from list, autofill, custom lists, find & replace, import text file, undo/redo, move/copy cells
file management-save, open, close workbooks
formula construction-mathematical operators, order of calculation, autocalculate, relative/absolute cell references, range finder, range names
printing-preview, headers and footers, page break preview, view and print formulas, set print areas
formatting-alignment, fonts, indent text, borders, numeric formats, format painter, custom formats, conditional formats, freeze panes
auditing toolbar-trace formulas, comments
worksheet management-column widths, insert/delete rows/columns, insert delete move worksheets, name worksheets
data validation-input messages, data restrictions, drop-down list boxes
functions-statistical;, date and time, logical
group and outline-automatic, manual, select visible cells
multiple sheets and workbooks-create, name, delete and view sheets; copy/move data to other sheets; group editing, workspaces, copy to other worksheets, copy to other workbooks, link sheets/ workbooks
sorting lists
charts-chart types, modify elements, add labels titles, legends, scales and gridlines