ONLINE TRAINING ON  DATA ANALYSIS AND DASHBOARD IN MS EXCEL 2013/2016

0
227

ONLINE TRAINING ON  DATA ANALYSIS AND DASHBOARD IN MS EXCEL 2013/2016
Online Training Workshop
ABOUT COURSE
Microsoft Excel is most widely used productivity tool in today’s business world. Day to day corporate analysis, reporting tools and applications are prepared with Excel. organizations require highest level of Microsoft Excel proficiency. To managing and analyzing a group of related data easier, we can turn a range of cells into an Excel Table. And a Pivot Table gathers all the data in an Excel spreadsheet and presents a summary of this data in a table. Charts and graphs are used to make information clearer and easier to understand. And Dashboard reports allow managers to get high-level overview of the organization and help them make quick decisions. It will be an advantage for course attendees to learn practical and advanced usages of this mostly renowned Excel tools for their daily task in multiple ways
This online course covers the key skills you need to clean your data, analyze and prepare Interactive and Standard dashboards using Ms Excel 2013/2016.
WHAT IS THE OVERALL AIM OF THIS ONLINE COURSE?
The overall aim of this online course is to clean your data, analyze and create dynamic and standard dashboards with confidence.
THE FOLLOWING OBJECTIVES ARE PLANNED TO BE ACHIEVED BY THE END OF THE TRAINING:

Prepare your Data for Analysis
Analyze data
Create dynamic and standard dashboards with confidence

PRE-REQUISITES

To ensure your success, you will need to have a comfort level with the basic skills, working with data, functions and formulas.

TRAINING OUTLINE
Week 1: — WELCOME TO THE COURSE

Introduction to Course
Course objectives
How to work with this course
Course Expectations

Week 2: — PREPARE YOUR DATA FOR ANALYSIS

How to Create Template Form with Data Validations
How to Use Conditional Formatting to Check Duplicates
How to Create and Manage Tables to Remove Duplicates
How to Clean your Data

Week 3: — Analyze your Data (DATA ANALYSIS)

Introduction to Pivot
How to create and Manage Pivottables
How to create and Manage Pivot Charts

Week 4: — Create DASHBOARDS (DYNAMIC/INTERACTIVE OR STANDARD)

How to create dynamic/Interactive Dashboards
How to create standard Dashboards

TRAINING METHOD

This course is run over four weeks on SITCO Online learning platform and fully supported by our expert trainers. All lessons are recorded and you watch and do assignments at your own space.

COURSE FEE:  $100 50% Discount (50 Dollar Only)
STARTING DATE:  10 June 2019
ENDING DATE:    10 July 2019
INQUIRIES:
For further inquiry on the course, please contact the organizers on the following contacts:
Mobile: +252 (0)618333222/615191980
Email: info@sitco.so
To participate, please apply online through the link:
https://docs.google.com/forms/d/e/1FAIpQLSfqtbfCVTdoKmJb8EUwqQkueupE1p5YfoupuW1Y0N5hipeQ3A/viewform




SOURCE: ONLINE TRAINING ON  DATA ANALYSIS AND DASHBOARD IN MS EXCEL 2013/2016

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.