Excel – Master in Excel

Microsoft® Office 2007

Course ID: HLT MSTR

Course Length: 2 days or 6 evenings

Course Description:
Advanced Functions and Formulas with Practical Business Applications. This course was developed with the Excel Power user in mind. All advanced Formulas and Functions will be presented with Practical Business Applications and hands on activities.

Prerequisites:
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification:
HyperLearning presents the student with a certificate of completion as a Master in Excel.

Course Content

Lesson 1: Advanced Functions
Topic 1A: Excel Shortcuts
Topic 1B: Logic Functions
Topic 1C: String Functions
Topic 1D: Financial Functions
Topic 1E: Array Functions
Topic 1F: Statistical Functions
Topic 1G: User Defined Functions

Lesson 2: Advanced Charting
Topic 2A: Advanced Charting Techniques
Topic 2B: Control Charts (Six Sigma Tool)

Lesson 3: Worksheet Controls
Topic 3A: Forms and ActiveX Controls
Topic 3B: Visual Basics

Lesson 4: Visual Basics
Topic 4A: The Macro Recorder
Topic 4B: Macro Logic
Topic 4C: Arrays
Topic 4D: UserForms
Topic 4E: VBA Programming Techniques
Topic 4F: Executing SQL Commands from VBA
Topic 4G: Automate Outlook (and other Microsoft Applications

Lesson 5: Pivot Tables
Topic 5A: Creating and Updating Pivot Tables
Topic 5B: Sorting and Grouping
Topic 5C: Custom Fileds