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 2010
Session Format:
4 Hours Total
Introduction
Prerequisite: Experience entering data into Microsoft Excel 2010, familiarity with Windows and basic computer skills
This course will introduce Excel users to charting features and database management in Microsoft Excel 2010. Participants will design worksheets that meet Excel criteria for database functions such as sorting and filtering. Database design criteria, Subtotals, PivotTables and PivotCharts will be covered in depth.
Objectives
The participant will learn: (1) how to link sheets and files together (2) how to use the conditional functions (3) how to use essential list management
Content Outline
- Differences in the ribbon and the toolbar
- 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 and have mastered Introduction to Excel 2010.
