Microsoft Excel Data Analysis Essential

  • 17-10-2022

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you’ll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.


  1. Managing Raw Data
  • Excel Versions and features
  • Working with Raw Data
  • Data Housekeeping
  1. Import Data
  2. Text to Column Tricks
  3. Troubleshooting merged data
  4. Working with Unnecessary Spacings
  5. Troubleshooting Wrong Date and Time
  6. Data Cleaning and Trimming
  7. Working Text Functions
  8. Validating Data

 

  1. Working with a Single Dataset
  • Transform Manual Database to Smart Datasets
  • Smart Table Magics
  • Smart Table Conditions
  • Working with Data Sources
  1. Working with Data Analysis
  • Preparing Functions 
  1. LOOKUPS in Excel
  • Quick Report with Pivot Tables
  • Pivot Table Conditions
  • Pivot Table Connection
  • Handling Queries
  • Working with Simplified Reports
  1. Working with Multiple Datasets
  • Advance Filter
  • Consolidating Data
  • Combining data from Multiple Dataset
  1. Working with Data Reporting
  • Pivot Table Data Sources
  • Pivot Tables Queries and Solutions
  • Pivot Table Data Grouping
  • Pivot Table Subtotals
  • Pivot Tables – Format Number 
  • Pivot Table Functions

Organizer:

Shabeenah Bee bt Mohd

  • Time : 9:00 am - 5:00 pm (Asia/Kuala_Lumpur)

Registration Deadline Expired!!

Related Events