Home > Courses > Microsoft > Excel – Master in Excel

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: Advanced Functions
Topic 1B: Logic Functions
Topic 1C: Array Functions
Topic 1D: Statistic Functions
Topic 1E: Financial Functions
Topic 1F: String Functions
Topic 1G: User Defined Functions

Lesson 2: Worksheet Controls
Topic 2A: Form and ActiveX Controls
Topic 2B: Advanced Charts Techniques

Lesson 3: Visual Basics
Topic 3A: The Macro Recorder
Topic 3B: Macro Logic
Topic 3C: Arrays
Topic 3D: UserForms
Topic 3E: Automate Outlook (and other Microsoft Applications

Lesson 4: Pivot Tables
Topic 4A: Creating Pivot Tables
Topic 4B: Sorting and Grouping
Topic 4C: Updating
Topic 4D: Calculations
Topic 4E: Pivot Charts