Data Analysis

Data Analysis 2020-12-13T15:42:40+00:00

Our trainings are available in-person or virtual online with live instructor via MS Teams

Introduction to Data Analysis using Excel

Learn Excel for data analysis from basic to expert level and be able to apply this practical skill in any field. It explores spreadsheet software’s most relevant features which will help you become an expert as beginner, achieve proficiency as basic user or polish skills and finish learning curve as an intermediate one. All of this while using real-world data together with practical exercises done step-by-step.

2 Days

 MS Excel Data Analysis

7 PDUs

Personal Development Unit

MS Excel Data Analysis


  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source


  • Summarize PivotTable Data
  • Organize PivotTable Data
  • filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data


  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

Advanced Tools

  • Using the Database Functions
  • Using the Statistics Functions
  • Descriptive Statistics Functions
  • Inferential Statistics
  • Optimization Modeling with Solver

Workshop Wrap-Up

At the end of the course, students will have an opportunity to ask questions.

Best Training Institute in Dubai
View All
Soft Skills Courses
View All
PMP Project Management Professional Exam Prep Training Course Certification in Dubai
View All