Intermediate Topics in Excel


Course: Intermediate Topics in Microsoft Excel

This one day course takes basic users of Excel into the more advanced topics that create value - subtotals, data validation, conditional formatting, styles, what-if analyseis and more.

If you are ready to become more sophisticated in your use of Excel, you will find this course useful and enjoyable.

Course Details


Start Date: April 23, 2014
Fee: $250.00
Number of Sessions: 1
Course Location: 551 Fifth Ave., 8th Fl, New York, NY  10176


Course Description

For users who have a working knowledge in Excel, this  course is designed to help you use Excel more efficiently, while creating more useful, professional-looking worksheets. Use templates, tables, data validation, and automatic subtotaling to speed data entry. Improve data management by learning to filter data, hide or remove duplicates, use conditional formatting, and create sparklines. Speed your utilization of Excel with these techniques. 


You Will Learn To

  • Use filters to select data meeting specific criteria
  • Use automatic subtotals
  • Use existing templates, and create and modify new ones
  • Use conditional formatting
  • Use and format Sparklines
  • Use data validation
  • Use Tables
  • Create, use and merge styles (optional)
  • Use what-if analysis (optional)

Who Should Enroll

Persons with knowledge of basic Excel data entry, formatting, copying, and windowing skills who want to further enhance their ability to use Excel efficiently.

Prerequisite: Introduction to Excel or working knowledge of MS Excel.



Course Format

One Day (9am- 4pm); offered weekdays; Instructor-led. Class runs from 9am-4pm.
COST: $250




Please contact us at (888) 561-7223 () or

Course Outline for Intermediary Topics in Microsoft Excel

Filters, Removing Duplicates and Data Validation
  • Objectives
  • Filters
  • Using Criteria
  • Using Wildcards in Text Searches
  • Using the Custom Filter
  • Filtering by the Value, Fill or Font Color, or Icon of a Single
  • Filter Scope
  • Duplication
  • Data Validation
  • Applying Data Validation to Cells that Already Contain Data
  • Removing Data Validation Rules
Automatic Subtotals
  • Automatic Subtotals
  • The Outline Display
  • Subtotal/Outline Scope
Creating and Using Templates
  • Using Existing Templates
  • Creating a New Template
  • Protecting a Worksheet
  • Modifying Templates
Conditional Formatting and Sparklines
  • Conditional Formatting
  • Conditional Formats Copying
  • Conditional Formatting Rules (Optional)
  • Editing and Clearing Rules
  • To Create a Conditional Formatting Rule Based on a Formula (Optional)
  • Sparklines
  • Formatting Sparklines
  • Understanding What a Sparkline is Showing
  • Tables
  • Converting a Table Back to a Range
Cell Styles (Optional)
  • What are Cell Styles?
  • Applying Styles
  • Using Styles and Themes Together
  • Creating a New Style
  • Merging Styles
What-If Analysis (Optional)
  • Data Analysis
  • Goal Seek
  • Data Table (Optional)
  • The Scenario Manager
  • Showing Scenarios
  • Using Defined Names in Scenario Manager (Optional
  • Multiple Value Scenarios
  • Modifying Scenarios