Job Description

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