Job Description
Course Description
In this short course, participants will acquire skills that will enable them to analyse and present data in a meaningful way. This is an essential skill for researchers, financial specialists and data analysts of all disciplines. Microsoft Excel is a tool of choice for people who need to analyze large amounts of quantitative data and is used as standard by a wide range of users who need to perform simple analysis by sorting, filtering, using formulas. It also has powerful tools such as pivot tables and data analysis toolpak for more complex analysis.
Many organisations and institutions are embracing the world of brilliant data visualisation to present data in a more attractive, meaningful, and easy to digest manner. Because Microsoft Excel is a software many organisations already use, this course will enable participants to maximise their use of a tool they already have and improve their data analysis and visualisation. The course is led by highly experienced trainers with many years of experience and involves working on several practical, hands on examples and exercises in a virtual environment
Learning Objectives
By the end of the training, you will be able to:
Become an Expert in Excel
Undertake data analysis in Excel
Apply data cleaning techniques in Excel
Do basic to intermediate data visualization in Excel
Understand the various components of intermediate excel such as the formulas and the shortcuts.
The uses of charts and pivot tables and their components
Effectively use Excel for Scheduling and cost planning
To do presentation and create reports using Excel.
Course Content
Session 1: Introduction and Fundamentals of Excel
Introduction
Tabs, Data Types
Sorting and Filtering Data
Session 2: Visualizing Data with Excel
Visualize Data with Charts
Modify and Format Charts
Apply Best Practices in Chart Design
Session 3: Analyzing Data with Formulas and Functions
Analyze Data with Formulas and Named Ranges
Analyze Data with Functions
Implement Data Validation, Forms, and Controls
Create Conditional Visualizations with Lookup Functions
Session 4: Analyzing Data with PivotTables
Create a PivotTable
Analyze PivotTable Data
Session 5: Presenting Visual Insights with Dashboards in Excel
Visualize Data with Pivot Charts
Filter Data Using Slicers and Timelines
Dashboards in Excel
Session 6: Creating Geospatial Visualizations with Excel
Create Map Charts in Excel
Customize Map Charts in Excel
Session 7: Using add-ins for data imports/exports
DAX Studio
Session 8: Getting and Transforming Data
Connect to Data with Queries
Clean and Combine Data
Shape and Transform Data
Session 9: Analyzing Data with Power Pivot
Install Power Pivot in Excel
Create Data Models with Power Pivot
Create Power Pivots
Perform Advanced Data Analysis and Visualization
Lesson 10: Presenting Insights with Reports
Plan a Report
Create a Report
When: 6th to 17th December, 2021
Method of Delivery: Virtual via Zoom
Who should attend?
Statisticians
Data Scientist
Researchers
Consultants
Program officers
Finance Officers
Accountants
Training Fee: ZMK 1600
Payments should be made using the link below:
Book Now
If you are unable to pay using the online methods listed above, please contact Keno Institute for alternative methods of payment.
Registration: Interested participants should register on the link below:
www.kenoinstitute.org/sign-up
Contact line: +260 971696 044 / +260 976715821
To apply for this job please visit www.kenoinstitute.org.
Job Summary
Similar Jobs
The largest community on the web to find and list jobs that aren't restricted by commutes or a specific location.
-
Investment and Project Manager
- AGIC ENERGY SOUTHERN AFRICA
-
Pharmacist
- Pact