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

Microsoft Excel Training

The course was very helpful for my career. It opened up my eyes on how the web has evolved. I would recommend this course to my colleagues.
Comment from Canada Revenue Agency

1. Title

  • Microsoft Excel Level 2: Mastering Data Analysis and Presentation (EXCPRO, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous experience with Microsoft Excel

3. Target Audience

  • Business professionals who want to learn how to master Microsoft Excel

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $1,150.00 per person

5. Outline

Module 1: Microsoft Excel Essential Skills Revised

Topic 1: Identifying and Referencing Cells

Topic 2: Working with Cell Contents

Topic 3: Formatting Cells

Topic 4: Working with Formulas

Topic 5: Business Graphics

Topic 6: Exercise: Setting up the Business Data

Module 2: Working with Data

Topic 1: Characteristics of a Database Layout

Topic 2: Using Cell Names to Prepare the Data

Topic 3: Using Filters to Sort and Filter the Data

Topic 4: Creating Custom Filters to Find the Data you need

Topic 5: Using Search and Find Functions to Locate the Data you need

Topic 6: Using Subtotals to Summarize the Data

Topic 7: Removing Duplicates

Topic 8: Using Custom Functions to Clean the Data

Topic 9: Exercise: Summarizing the Data with Excel Functions

Module 3: Advanced Functions: Conditional Logic

Topic 1: Using Conditional Formatting

Topic 2: Planning for Conditional Logic

Topic 3: Using a Single If Function to Implement Conditional Logic

Topic 4: Using Multiple If Functions to Implement Complex Conditional Logic

Topic 5: Using the AND and OR Functions to Implement Complex Criteria

Topic 6: Using Negation and DeMogan’s Theorem to Simplify Logic

Topic 7: Exercise: Implementing Complex Logic in Support of Data Cleanup

Module 4: Advanced Functions: Statistics and Finance

Topic 1: Review of Fundamentals: Working with Excel Functions

Topic 2: Dealing with Special Situations: Blank Cells

Topic 3: Working with Statistical Functions: Count, Median and Average

Topic 4: Working with Statistical Functions: Variance and Standard Error

Topic 5: Working with Statistical Functions: Frequency and Ranking

Topic 6: Working with Statistical Functions: Linear Regression and Correlation

Topic 7: Working with Statistical Functions: Probability Distributions

Topic 8: Performing Variance and Standard Error Calculations

Topic 9: Working with Financial Functions: Payments, Interest and more

Topic 10: Working with Financial Functions: NPV, IRR and More

Topic 11: Performing Financial Analysis: Probability and Earned Value

Topic 12: Exercise: Creating Statistical Summary Sheets for Corporate Data

Topic 13: Exercise: Analyzing NPV and IRR for Project Allocation

Module 5: Pivot Tables

Topic 1: Setting up the Data

Topic 2: Creating a Pivot Table

Topic 3: Changing Row, Column and Data Associations

Topic 4: Formatting the Pivot Table Headers

Topic 5: Formatting the Pivot Table Aggregate Values

Topic 6: Setting Pivot Table Options

Topic 7: Adding and Working with Splitters

Topic 8: Exercise: Using Pivot Tables to Analyze and Present Data

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