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 advanced data visualization in Excel
  • Create dynamic and flexible models in 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: Modeling and 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

Who should attend?

  • Statisticians
  • Data Scientist
  • Researchers
  • Consultants
  • Program officers 

Cost:

ZMK 1200 | USD 61.08

Venue:

See latest TIMETABLE

Registration:

All payments should be made using the link below:

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 click on the link below https://kenoinstitute.org/register/ and send a copy of the proof of payment, full details (Full Name, Address, Email Address, contact Number) to keno@kenoinstitute.org / keno.institute@gmail.com

Contact line: +260770346838 / +260761685388