Computer Sense, LLC (330) 262-2343

Outline subject to change without notice.
Please contact us with any questions.

EXCEL ADVANCED

Upcoming Classes

April 20, 2012
May 21, 2012
June 19, 2012
July 19, 2012

COURSE DESCRIPTION
Excel Advanced is intended for proficient users of Excel. Topics covered
offer an in-depth view of advanced spreadsheet capabilities.

Pre-requisite: Excel Basics and Intermediate or equivalent experience

Full Day Class Only $175.00 (Unless otherwise specified full-day
classes are weekdays from 9am to 4pm)

COURSE HIGHLIGHTS

Working with Advanced Functions
Nesting Functions
Using Table Lookup Functions
Using Text Functions
Using One-Input and Two-Input Data Tables
Using Automatic Outlining
Consolidating Information by Position or Category
Inserting Subtotals
Creating an Advanced Filter
Using Database Functions
Using PivotTables
Using the PivotTable and PivotChart Wizard
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Refreshing and Enhancing a PivotTable
Formatting a PivotTable
Working with Summary Functions
Sorting and Grouping Data in a PivotTable
Creating a Calculated Field
Creating Charts from PivotTables
Working with Data Analysis Tools
Creating Scenarios
Using Goal Seek
Understanding Solver
Generating a Report of Results and Alternate Solutions
Recording a Macro
Executing a Macro
Creating a Macro Button
Importing and Exporting Data
Working with Hypertext Links
Using Shared Workbook Features
Highlighting Tracked Changes
Merging Workbooks

CALL
(330) 262-2343
or
CLICK HERE TO
REGISTER NOW!