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

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

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

• Introduction
• 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/Deleting a Customized Toolbar
• Macros
  • Recording Macros
  • Quick Look at Visual Basic
  • Assigning a Macro to a Toolbar Button
  • Using the Macro Button
  • Removing a Macro Button From Toolbar
  • Assigning a Macro to a Button on a Spreadsheet
  • Removing a Macro Button from a Spreadsheet
  • 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 a Chart
  • Editing a Data Series
  • Editing a Data Point
  • Editing an Axis Scale
  • Adding Cell Contents to a Chart
  • Adding a Callout to a Chart
  • Adding Drawing Objects
  • Inserting a Picture
  • Moving a Chart to Another Sheet
  • Creating a Combination Chart
  • Adding a New Data Series to a Chart
  • Adding a Trendline
  • 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