Course Details
Course Details
Course ID
3152
Course Name
On-Line: Advanced Microsoft Excel 2003
Contact Hours
24.0
Approved Industry
Drinking Water and Wastewater
Partner Name
Luzerne County Community College, Division of Continuing Education
Primary Contact
Susan Spry
sspry@luzerne.edu
570-740-0480 Ext.
Website
Description
In this practical, hands-on course, you'll learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety ofadvanced pivot table technique, like creating calculated fields and items. You will be able to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become proficient at consolidating and importing data and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how to nest one function inside another to accomplish just about anything Excel has to offer.
Course Level
Advanced
Course Content
* Customize Excel
* Use a data form to manage an Excel table
* Effectively use data validation
* Create custom controls
* Effectively use the consolidate and outline features
* Import data
* Create tables
* Learn to use Goal Seek, scenarios and Solver
* Master Excel PivotReports and PivotCharts
* Master Analysis ToolPak and new 2003 features
Target Audience
Anyone who uses Microsoft Excel 2003
Training Format
Virtual Asynchronous