Courses for Computer Training:
Intermediate Excel 2007
4 Hours Total (One 4-Hour Session)
Today’s work environment demands that employees move beyond basic spreadsheet application to more advanced skills. This session introduces other features of Excel such as relative versus absolute value, naming ranges, grouping worksheets, ungrouping worksheets, charting, and designing lists.
The participant will learn: (1) the use of functions for mathematical, statistical and string applications, (2) logical functions, (3) date and time functions, (4) database management functions, and (5) print management.
- Using date functions
- Vertical/horizontal lookups
- Statistical functions
- String functions
- Creating databases
- Using databases
- Sorting and querying
- Print management techniques
Who Should Attend
This seminar is intended for supervisors, managers, and mid-level managers who create spreadsheets on a regular basis.
(Prerequisite: Introduction to Excel 2007)
Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.
Note: documents in Excel format (XLS) require Microsoft Viewer,
Note: documents in Word format (DOC) require Microsoft Viewer,
Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,