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
Advanced Excel 2010
Session Format:
4 Hours Total
Introduction
This is an extension of the Intermediate Excel 2010 class and will cover advanced features and student requests. Course content includes various functions, math features, and macros.
Objectives
The participants will be involved in: (1) creating action queries, (2) creating macros, (3) linking to and grouping worksheets to creating a workspace in excel, (4) working with pivot tables and charts, (5) working with goal seeking, and (6) using more advanced formulas.
Content Outline
- Using date functions
- Statistical functions
- Creating databases
- Sorting and querying
- Vertical and horizontal lookups
- String functions
- Using databases
- Print Management techniques
- Other advanced topics
Who Should Attend
This seminar is intended for supervisors, managers, and mid-level managers who create spreadsheets on a regular basis.
(Prerequisite: Intermediate Excel 2010)
