Excel Moudlar Classes

Formulas & Functions
List Management
Charting
Pivot Tables
Tips & Techniques

Formulas & Functions

Length: 3 Hours                     Prerequisite: Excel Basics Course or equivalent

Formulas and functions are at the heart of Excel.  This session provides ample practice in creating formulas and working with many commonly used functions.  In addition, “must-know’ tips and techniques are covered that save time and increase productivity when working with formulas and functions

1. Order of operation
2. Absolute/relative references
3. Advanced Filling
4. Linking worksheets & workbooks
5. Auditing formulas
6. Viewing formulas
7. Using names
8. Error handling
9. Functions covered:

Other functions upon request.

Please Note:
We can incorporate your company data by customizing exercises for this class.  This increases retention and provides participants with real world scenarios.

List Management

Length: 2-3 hrs                       Prerequisite: Excel Basics Course or equivalent

Maintaining lists of hundreds or thousands of items is one of Excel’s strengths.  This session explores techniques including sorting, filtering, and pivot tables. A major part of the session is devoted to the use of Pivot Tables as a means of manipulating and reporting data without the use of formulas.

1. Sorting
2. Filtering
3. Auto-outlining
4. Grouping   
5. Validating data
6. Hiding/Unhiding
7. Using Pivot Tables

Please Note:
We can incorporate your company data by customizing exercises for this class.  This increases retention and provides participants with real world scenarios.

Charting

Length: 2-3 hrs                       Prerequisite: Excel Basics Course or equivalent

Creating meaningful and easy to understand charts requires understanding of  charting techniques that users learn in this session.  This session explores all aspects of creating Excel charts by exploring many timesaving tips and techniques.

1. Chart wizard vs. manual charting
2. Charting options
3. Customizing charts
4. User defined charts
5. Advanced formatting
6. Dual Axis Charts
7. Pictographs

Please Note:
We can incorporate your company data by customizing exercises for this class.  This increases retention and provides participants with real world scenarios.

Excel – Pivot Tables

Length: 2-3 hrs                       Prerequisite: Excel Basics Course or equivalent

Overview:
Pivot Tables is a powerful Excel tools that allows you to generate reports, analyze data, and print a variety of reports, without having to use formulas.  This often overlooked and misunderstood is a must-know topic allowing you to perform the above activities in a fraction of the amount of time using traditional worksheet techniques.

Your data files can be included in the course exercises.

Topics:

1. Pivot table overview
2. Formatting worksheet data for Pivot tables
3. Using the Pivot Table Wizard
4. Editing a Pivot Table’s design
5. Selecting Pivot Table calculations
6. Updating worksheet data options
7. Drilling down in Pivot Table data
8. Generating Pivot Table charts
9. Using external data sources
10. Using Pivot Table options
11. Using the Pivot Table toolbar
12. Additional topics upon request

Excel 2003 Tips & Techniques

Length: 2-3 hrs                       Prerequisite: Excel Basics Course or equivalent

A host of new or often overlooked Excel features will be covered in this session.

TOPICS COVERED IN THIS COURSE

1. Protecting workbooks and worksheets; setting protection levels
2. Create custom views of a worksheet to time and minimizes repetitive manipulation.
3. Publishing worksheets for web usage.
4. Importing web data into Excel.
5. Use custom filling to reduce typing.
6. Sharing workbooks as a collaboration time saver.
7. Creating, editing, and printing comments.
8. Using conditional formatting Excel can format data based on up to three criteria.
9. Reduce errors by learning how to use Excel validation command.
10. How to obtain onscreen statistics without creating formulas.
11. Easy techniques to link worksheets and workbooks.
12. Using F4, Format Painter, and Styles to save time formatting and insure consistent formatting.
13. And More!