Excel 2002 (xp) - foundation
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
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
Facilities
Location
Start date
Start date
Reviews
Course programme
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
Excel 2002 (xp) - foundation