SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Microsoft Excel Training

I am enjoying the opportunity to learn additional functionality of the product. I am also enjoying the opportunity to understand how other government colleagues are utilizing this product.
Comment from PWSGC

1. Title

  • Intermediate Microsoft Excel for Business Users (EXCINT, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous experience using Microsoft Excel

3. Target Audience

  • Business Professionals who want to learn how to use Microsoft Excel for advanced data analysis

4. Dates and Pricing

Sep 5 to Sep 6, 2017$1,150.00/person
Nov 30 to Dec 1, 2017$1,150.00/person

5. Outline

Module 1: Review of Essential Concepts

Topic 1: Working with Absolute and Relative References

Topic 2: Working with Multiple Worksheets

Topic 3: Working with Advanced Functions

Topic 4: Working with Dates and Times

Topic 5: Customizing your Environment

Topic 6: Importing Data from External Sources

Topic 7: Excel Security

Module 2: Working with Data

Topic 1: The Mechanics of AutoFill

Topic 2: Creating a Data Series

Topic 3: Creating a Data List

Topic 4: Creating a Named Range

Topic 5: Implementing Sorting, Filtering and Searching

Topic 6: Creating a Graph for Impact

Module 3: Working with Formulas

Topic 1: About Complex Function Syntax

Topic 2: Using Functions to Summarize Data

Topic 3: Using Conditional Functions to Implement Advanced Analysis

Topic 4: Working with Functions and Dates

Topic 5: Implementing your Own Functions using VB

Module 4: Working with Pivot Tables

Topic 1: Working with Pivot Tables

Topic 2: Creating a Pivot Table

Topic 3: Pivot Table Options

Topic 4: Advanced Pivot Table Options

Topic 5: Pivot Tables and Custom Functions

Topic 6: Working with PivotChart

Module 5: Macros Part I: Creating Basic Macros

Topic 1: Preparing to Record a Macro: Absolute and Relative Mode

Topic 2: Recording a Macro

Topic 3: Testing the Macro

Topic 4: Understanding the Code

Module 6: Macros Part II: Modifying Macros

Topic 1: Working with Variables

Topic 2: Working with Cells

Topic 3: Working with Conditional Statements

Topic 4: Creating Support Functions

Topic 5: Modifying a Recorded Macro

Topic 6: If Time Permits - Advanced Macro Development

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette