KHDA Approved | Telephone: +971 4 4356074|info@bostonmc.com

Data Analysis

/Data Analysis
Data Analysis 2019-08-08T12:35:34+00:00

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

PREPARING DATA & CREATING PIVOTTABLES

  • 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

ANALYZING DATA USING PIVOTTABLES

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

WORKING WITH PIVOTCHARTS

  • 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

Subscribe to our newsletter

Sign-up to get the latest upcoming courses straight to your inbox.
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.