Working With Numbers and Diagram Using MS Excel


Delegates should have attended or familiar with Excel Introduction Course

Course Outline:

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas

Basic Formulas

  • Create Formula
  • Basic Steps for Creating Formulas
  • Auto Sum
  • Borders and Shading
  • Manual Formula

Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Analysing Data with Functions and Conditional Formatting

  • Analyse Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Organizing and Analysing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts

  • Creating Charts using the Chart Wizards
  • Editing and Formatting Charts
  • Printing Charts
  • Using the Drawing Toolbar

Analysing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyse PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers