Course Outline
Excel - Advanced
Versions 97/2000/2002(XP)/2003/2007

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn various advanced techniques for analyzing, manipulating, and presenting data in Excel.

• Introduction to the Course
• Data Consolidation
• Data Consolidation with Links
• Linking Files
• Additional Database Functions
• Subtotal Feature
• Outlining
• Removing Subtotals
• Data Validation
• Count If and Sum If Functions
• Nested If Statements
• Vertical and Horizontal Lookup Tables
• Creating a Customized Toolbar
• Recording Macros
• Looking at the Visual Basic Code in Macros
• Quick Look at Visual Basic
• Assigning a Macro to a Toolbar Button
• Using the Macro Button
• Removing Macro Button From Toolbar
• Deleting a Customized Toolbar
• Macros
  • Assigning a Macro to a Button
  • Removing a Macro Button

• Macros Continued
  • Copying a Macro to Another File
  • Modifying Macro Code
  • Auto Execute Macro
• Text to Columns Feature
• Concatenation
• Pivot Tables
• Charting
• Setting Up Data
• Terminology
• Creating a Chart
• Formatting
• Editing a Data Series
• Editing an Axis
• Adding Drawing Objects
• Adding a Data Table to a Chart
• Inserting a Picture
• Moving a Chart to Another Sheet
• Creating a Combination Chart
• Adding a New Data Series to a Chart
• Adding New Data Within a Present Data Series
• Append New Data to an Existing Data Series (Manually)
• Append New Data to an Existing Data Series (Macro)
• Printing Multiple Charts on a Page
• Histogram
• Pareto Chart
• Cumulative Percentage Chart