This course demonstrates how to implement Excel features and functions, such as hide and protect features, the Conditional Formatting feature, the VLOOUP function, the SUBTOTAL function, and others. In addition, he discusses how to preserve key formulas, perform dual lookups, create self-updating report titles.
Course Publication Date:
May 25, 2018
This course is available with
NO ADDITIONAL FEE if you have an active
self study membership or
all access membership or
webinar membership or can be purchased for
$20.00!
| Author: | David Ringstrom |
| Course No: | COMP-EXCELSPD-12048 |
| Recommended CPE: | 2.00 |
| Delivery Method: | QAS Self Study |
| Level of Knowledge: | Basic |
| Prerequisites: | None |
| Advanced Preparation: | None |
| Recommended Field of Study: | Computer Software and Applications
Webinars - On Demand
|
|
|
|
Learning Objectives
- Apply techniques and features that will improve the integrity of your Excel spreadsheets.
- State how to hide and unhide multiple worksheets with a single command in Excel.
- Apply Conditional Formatting to identify unlocked cells into which data can be entered.