Management >> Office Admin Secretary

Analyzing Data Through Excel

MO206

Location

Duration

Date

Fee inclusive of VAT

Course Overview

In thispracticalcourse, we are going to focus on how to performdata analysisusingMicrosoft Excel. Excel is avery used toolin several companies and has verypowerful data analysis capabilitiesthat can be used by data analysts and marketing experts. Even if you work with a lot ofstatisticsyou'd be surprised at how valuable Excel is for calculatinghypothesis testsand themost common metricsyou can calculate on a dataset. There are several basic and advanced functions you can use toget the best from your dataand that's why Excel is a very useful tool for anybody who needs tocrunch dataand perform analyses of various kinds.

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.

Course Objective

  • Learn the basics and functions of Microsoft Excel.
  • Learn about data organization and search tools VLOOKUP, HLOOKUP
  • Apply filters, pivot tables, and charts.
  • Application of advanced graphics and charts.

Who Should Attend?

This course is intended for anyone responsible for analyzing data with Excel. This includes -and not limited to: Data analysts, Marketing experts, Supervisors and Managers.

Course Outline

Microsoft Excel - The Essentials

  • Getting started
  • Entering and editing data
  • Modifying a worksheet
  • Functions

Managing Data and Large Workbooks

  • Managing workbooks and worksheets
  • Advanced formatting
  • Cell and range names
  • Data structure and tables
  • Documenting and auditing
  • Templates and settings

Data Analysis and Reporting

  • Advanced functions and formulas
  • Lookups and data tables
  • Advanced data management
  • Advanced charting
  • PivotTables and PivotCharts
  • Preparing Data & Creating PivotTables
  • Analyzing Data Using PivotTables
  • Working with PivotCharts

Application of graphics and charts

  • Data Visualization Best Practices
  • Customizing Charts in Excel
  • Mastering Basic Charts & Graphs

Training Methodology

This is a very hands-on, non-intimidating, course – delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with the nuances of Excel’s functions.

You need a laptop with pre-installed Excel

Terms & Conditions

ACTrain reserves the right to alter the Course Schedule without Prior Notification, Fees Quoted are Subject to Terms & Conditions Outlined in ACTrain's Registration Policy

Upcoming Courses

The Development of Innovative & Creati

This program is designed for people in charge of making work environm

Read more

Project Management Methodology

We equip the business professional with leading methodologies and pra

Read more

Triangle of Excellence for Engineering

In today’s world middle and senior level Managers, engineers an

Read more

Purchase System: Correspondence, Negot

Define the objectives and functions of materials management (purchasi

Read more

Customer Relationship Management

In today’s customer-oriented business environment, "people

Read more

The Art of Dealing with The Public Com

This art of dealing with the public communication skillstraining cour

Read more

Customer Service Management

Please see Arabic outline

Read more

The Art of Dealing with The Public Com

This art of dealing with the public communication skillstraining cour

Read more