
ONLINE TRAINING ON DATA ANALYSIS AND DASHBOARD IN MS EXCEL 2013/2016
- Anywhere
- Course
- Job category: Education
- Post date:28 May 2019
- Share job:
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
Apply for this Job
- No Tags
2271 total views, 1 today