|
Description: Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.
Objectives
* Create and modify Pivot Tables
* Create and Modify Macros
* Form Control
* Use Advanced Functions
* Trace Dependents and Precedents
* Create and Modify Scenarios
Outline
* Section 1 - Pivot Tables
o What is a Pivot Table?
o Creating a Simple Pivot Table
o Changing the Layout of a Pivot Table
o Creating a Spreadsheet for each Page of the
o Pivot Table
o Multiple Field Headings on Page Axis
o Refreshing a Pivot Table
o Structured Selection
o Formatting a Pivot Table
o Adding or Removing Fields
o Renaming Fields
o Sorting Field Items
o Hiding Details
o Showing the Top or Bottom Items in a Field
o Showing Details behind a Data Value
o Grouping and Ungrouping Data
* Section 2 - What-If Analysis
o What-If Analysis Basics
o Creating a Scenario
o Adding, Deleting and Editing Scenarios
o Creating a Scenario Summary Report
o Using Goal Seek
o Using Solver
* Section 3 - Macros
o Recording Macros
o Playing a Macro
o Macro Security
o Recording a Relative Reference Macro
o Running a Relative Reference Macro
o Assigning a Keystroke to a Macro
o Copying a Macro from a Workbook or Template
o The Visual Basic Editor
* Section 4 - Advanced Functions
o Working with Array Formulas
o Using the VLOOKUP Function
o Using Logical Functions
* Section 5 - Using Forms
o What is a Form Control?
o Adding a Control to a Worksheet
o Assigning a Macro to a Control
o Using Form Control
Pre-Requisites: Microsoft Excel 7 Level 2 or equivalent experience
Certificates offered: Certificate of completion
Duration Details: 1 day
8:30am - 4:30pm
Facility Location: On Track Computer Training Center
1600 - 650 West Georgia Street
Vancouver
British Columbia
Canada
V6B 4N7
| 
