Computer Training
- Advanced Access 2007
- Advanced Access 2010
- Advanced Excel 2007
- Advanced Excel 2010
- Advanced Excel II 2007
- Advanced PowerPoint
- Advanced Word
- Intermediate Access 2007
- Intermediate Access 2010
- Intermediate Excel 2007
- Intermediate Excel 2010
- Intermediate Word
- Introduction to Access 2007
- Introduction to Access 2010
- Introduction to Computers
- Introduction to Excel 2007
- Introduction to Excel 2010
- Introduction to PowerPoint
- Introduction to PowerPoint 2010
- Introduction to Word
- MS Project
- Overview of Microsoft Office 2010
- Software Applications
Intermediate Excel 2007
Session Format:
4 Hours Total (One 4-Hour Session)
Introduction
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.
Objectives
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.
Content Outline
- 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)
