Please enable JavaScript
Effective Data Analysis Skills using MS Excel – Eagle Infotech Consultants
Eagle Infotech Consultants
150 Orchard Road #06-14
Orchard Plaza Singapore 238841

Effective Data Analysis Skills using MS Excel

Course Objectives
At the end of the course, participants will be able to use Excel tools effectively to produce spreadsheet solutions.
Target Audience
This course is aimed at participants who need to manage and perform statistical analyse of data using Microsoft Excel.
Course Outline

USING EXCEL TABLE

  • Overview of Excel tables
  • Format as Excel Table
  • Managing data in an Excel table
  • Sorting and filtering
  • Formatting table data
  • Inserting and deleting table rows and columns
  • Using a calculated column
  • Displaying and calculating table data totals
    CONDITIONAL FORMATTING
  • Overview of Conditional Formatting
  • Creating a conditional format based on cell content
  • Creating a conditional format using formula to determine which cell to format
  • Editing the Conditional Formatting Rules
  • Deleting the Conditional Formatting Rules
    PERFORM WHAT-IF ANALYSIS
  • Using Scenarios to consider many different variables
  • Using Goal Seekto find out how to get a desired result
  • Use Data Tables to see the effects of one or two variables on a formula
    EXCEL ADD-INS
  • Project backward for more variables by using the Solver Add-in
  • Using Regression Analysis Tool in the Analysis ToolPak Add-in