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.
Date: June 16, 2015
Location: 551 5th Avenue, NY NY
9 a.m. to 4 p.m.
Course Number: 90514
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.
FILTERS, REMOVING DUPLICATES AND DATA VALIDATION
Using Wildcards in Text Searches
Using the Custom Filter
Filtering by the Value, Fill or Font Color, or Icon of a Single
Applying Data Validation to Cells that Already Contain Data
Removing Data Validation Rules
The Outline Display
CREATING AND USING TEMPLATES
Using Existing Templates
Creating a New Template
Protecting a Worksheet
CONDITIONAL FORMATTING AND SPARKLINES
Conditional Formats Copying
Conditional Formatting Rules (Optional)
Editing and Clearing Rules
To Create a Conditional Formatting Rule Based on a Formula (Optional)
Understanding What a Sparkline is Showing
Converting a Table Back to a Range
CELL STYLES (OPTIONAL)
What are Cell Styles?
Using Styles and Themes Together
Creating a New Style
WHAT-IF ANALYSIS (OPTIONAL)
Data Table (Optional)
The Scenario Manager
Using Defined Names in Scenario Manager (Optional
Multiple Value Scenarios