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

Microsoft Excel Training

Great material that I can take back to the workplace. Good case and exercises. Monitor setup is good and easy to follow.
Comment from Giant Tiger

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