Data Analysis Using MS Excel

 

Organizations need to make business decisions more quickly and accurately than ever before. Basing these decisions on data and best practice analysis techniques, therefore, a solid foundation of data gathering, analysis, and presenting data using best practice and effective tools will help effective and efficient business communication and data driven decisions.

In addition, the fields of Business intelligence and big data depends largely on Data analysis tools and techniques in order to formulate effective decision-making process. Therefore, Data analysis will help business driver to complete assempling the data puzzle.

In this course. You will learn to gather, analyze, and presenting data including creating different types of reports like dashboards, and other reporting formats; using the most common and easy data analysis and reporting tools “MS Excel”.

In order to achieve the best outcomes from this training, we have to learn data gathering and analysis best practice then to be reflected on earning the best use of Microsoft Excel. Reporting types, design, content will also help trainees to use MS Excel features effectively, and facilitate communication and data based decision.

 
We deliver Data Analysis Using Microsoft Excel Courses in Amman - Jordan, Riyadh, Jubiail, Khobar - Saudi Arabia KSA, UAE and More.
 
 
 

 

 

Learning Outcomes 

By the end of this Course, trainees should be able to:  

  • Understand the Scope and application of data analysis
  • Understand the Impact of analytics on gaining competitive advantage and decision support
  • Carry out data gathering process, tools, and techniques effectivly
  • Perform different data analysis types and methods effectivly
  • Present data analysis results profrssionaly
  • Apply visual presentation of results
  • Creating tables, grapgh, charts, and dashboards
  • Forecasting based on data analysis
  • Capable of  Interpreting results and draw sound and relevant conclusions on business
  • Apply data analysis process via excel
  • using excel in data formatting
  • Perform data analysis using excel analysis tools and function.
  • Using excel in reporting design
  • Using excel visualize and presenting tools
  • Integrate excel with other presenting tools

Training Methodology 

It is a twelve modules content workshop with 40 training hour.

We will use our customized learning aids like MS EXCEL, Mind Management, Real case studies, and formal real assignment.

The workshop modules are developed as shown below in the modules section.  

This workshop will be carried out by two instructors. The first half of the training will be carried out by management background instructor, while the other half will be carried out by Microsoft Excel expert.

This workshop has been customized to fit for both face to face learning and distance learning alike using our customized distance learning tool and technology.

This Workshop outlines have been developed in accordance with the KPIs Institute Data Analysis Outlines.

Who Should Attend

Anyone involved in operations, project management, business analysis, or management who needs an introduction to Data Analysis, would benefit from this class:

  • Business Analyst, Business Systems Analyst, Staff Analyst
  • Systems, Operations Research, Marketing, and other Analysts
  • Project Manager, Team Leads, Project Leads, Project Assistants, Project Coordinators
  • Data Modelers and Administrators, DBAs
  • Technical & other Subject Matter Experts (SMEs)
  • IT Staff, Manager, VPs
  • Finance Staff, Manager
  • Operations Analyst, Supervisor
  • External and Internal Consultants
  • Risk Managers, Operations Risk Professionals
  • Operations Managers, Line Managers, Operations Staff

 

Data Analysis Using MS Excel Training Modules


 

Module 1: Introduction to Data Analysis

  • Definition and history
  • Current technology, the growing availability of data, and increasing challenges
  • Applications for gaining competitive advantages
  • Relationship Between Data Analysis  and Business Intelligence
  • Relationship Between Data Analysis  and Big Data
  • The Value and Usage of Data

Module 2: Data Gathering

  • Determine needed information
  • Data Gathering Planning
  • Data Gathering Techniques
  • Data Gathering Skills
  • Organizing Gathered data

Module 3: Data Analysis

  • Qualitative Analysis
  • Quantitative Analysis
  • Objective based analysis
  • Fitting data analysis to the business process design
  • Trend Analysis
  • Varience Analysis
  • Standard deviation
  • Histograms
  • Dependancies and correlations
  • Forecasting
  • Linear Regression
  • Theoretical Framework
  • Presenting Results tips

Module 4: Presentation Development

  • Overview
  • Planning for presentation
  • Understanding the Audience
  • Content Development
  • Developing Visuals
  • Presentation development 
  • Presenting Skills

Module 5: Graphical Presentation

  • Overview
  • Incorporation graphics into your writing
  • Graphics and Charts
  • Tables
  • Maps and Images
  • Typography

Module 6: Creating Dashboards

  • Design Tips
  • Design Foundations
  • Structure of Dashboard
  • Information Design
  • Role Foucused Dashboards
  • Rendering Dashboars
  • Interactive dashboards

Module 7: Getting your data ready for analysis in Excel

  • Importing Data
  • Data clean up functions
  • Naming cells
  • Joining text strings
  • Text to Columns
  • Text Functions
  • Removing duplicates
  • Transpose Data

Module 8: Approaching basic functions smarter

  • Absolute vs. Relative references
  • Automating repetitive tasks using Macros
  • Arrays

Module 9: Formatting

  • Conditional Formatting using rules
  • Data Filters
  • Data Validation

Module 10: Analysis tools

  • Vlookups
  • Goal Seek
  • Scenarios
  • Data Tables

Module 11: Creating Reports

  • Format as a table
  • Pivot Tables
  • Group & Outline
  • Consolidate Data
  • Spark Lines
  • Bar Chart, Line Chart & Pie Chart
  • Creating different types on dashboards

Module 12: The Excel Data Model

  • Using an Excel Data Model
  • External Data
  • Add Multiple Tables
  • Create Relationships
  • Add External Data
Apply Now