Microsoft Excel Advanced

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches students the skills needed to work with more complex features like Excel databases, PivotTables, views, outlining, named ranges, data validation, protection, macros, etc. Students will also learn how to write additional formulas that use the Subtotal and VLookup functions.

Prerequisites

In order to successfully complete this course, we recommend that you first take Softek’s Introduction and Intermediate Excel courses or have equivalent knowledge.

Is this the right level for you? Please contact our office at 202.682.4500 if you have any questions.

Using Excel As a Database

What Is An Excel Database?

Using The Data Form

Using The Autofilter Feature

Using The Advanced Filter

Using Database Functions

Summarizing And Analyzing Data

Using PivotTables To Summarize Data

Creating Scenarios

Grouping And Outlining Worksheets

Working With Custom Views

Creating Basic Macros

Using Conditional Formatting

Creating Basic Macros

Customizing Toolbars

Using More Advanced Functions

Using The Subtotals Feature

Using The VLOOKUP Functions

Creating Named Ranges

Using The ISERROR Function

Creating a Template

Validating Data Entry

Unlock Certain Cells

Protecting The Worksheet

Creating Basic Templates

Creating A New Workbook Based On A Template