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
Session 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
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