Intermediate Topics in Excel

Intermediate Topics in Excel

Mobile

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
icon iPhone

 

Date: Please Call for Dates

Days: 1

Fee: $250.00

Location:1 Martine Ave., White Plains, NY
9 a.m. to 4 p.m.

Course Number:

Date: June 16

Days: 1

Fee: $250.00

Location: 551 5th Avenue, NY NY
9 a.m. to 4 p.m.

Course Number:90514

icon

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.

Click for Detailed Course Description

icon

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)
icon

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.

icon

Course Format

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

CPE- 6 CREDIT HOURS

icon

Questions?

Please contact us at (888) 561-7223 or continuinged@pace.edu

Outline for Intermediate Topics in 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
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

 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

 

 

icon

PowerPoint

  icon

Windows 8.1

 

 

Word