Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Training on Advanced Data Modelling and Analytics Using Excel

By: Devimpact Institute

Kenya

04 - 08 Mar, 2024  5 days

Follow Event

  

USD 950

Venue: Nairobi

Other Dates

Venue Date Fee  
Nairobi, Kenya 18 - 22 Mar, 2024 USD950.00

Microsoft Excel is the most used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of advanced Excel skills. This course on Advanced Data Modelling and Analytics Using Excel is aimed at taking your Excel skills to the next level. You will be able to apply complex functions within Excel to manage, manipulate, analyze, and visualize data.

Target Participants

This course on Advanced Data Modelling and Analytics Using Excel is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.

Course Duration

Online    7 Days

Classroom – Based    5 Days

What you will learn

By the end of this course the participants will be able to:

  • Master advanced formulas and functions
  • Consolidate data, link, and export data.
  • Create sophisticated outputs including tables, charts, and graph.
  • Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
  • Increase interactivity by automating spreadsheets with macros and VBA.
  • Turn raw data into ‘must make’ decisions using PivotTables and Power Pivots.

Course Outline

Introduction to Excel Environment

  • Cell referencing, cell formatting and entering formula.
  • Variables in Excel
  • Introduction to Excel Tables
  • Filtering data
  • Sorting data
  • Use of conditional formatting

Integrating Excel with Other Data Sources, Software and Platforms

  • Link with Google Sheets,
  • Link with SharePoint Lists
  • Link with Mobile Data Collection Tools
  • Link with Databases (Postgres, Oracle, SQL)
  • Link with CRMs

Data Cleaning and Transformation Using Power Query

  • Use first Row as Columns
  • Rename Columns
  • Replace Cell Data & Missing Values
  • Remove Rows & Columns
  • Data Types
  • Auto IDs
  • Find Duplicates
  • Combine & Split Multiple Fields
  • Custom Formatting (Currency, Phone numbers)
  • Group Data with Merge & Append Queries

Advanced Excel Formula and Functions

  • Conditional Functions
  • Lookup Functions
  • Text Functions
  • Date Time Functions

Data Modelling Using Excel Power Pivot

  • Activate Excel Power Pivot
  • Add Data to the Data Model
  • Create Relationships Between Tables
  • Create Pivot Tables Using Data Models

Advanced Pivot Tables

  • Data Refresh-Configure self-updating dynamic Pivot tables and Pivot charts.
  • Rank in pivot table
  • Pivot Table Calculated Field
  • Link multiple Pivot tables to one slicer
  • Running Total in pivot table
  • Create Many Pivot Tables from one
  • Export Pivot Table to PowerPoint & Word

Build Interactive Dashboards Tools/instruments on excel.

  • Interactive Dynamic Dashboards,
  • MIS tools
  • Custom Page Navigation using Links.
  • Custom filters using Slicers and timeline.
  • Configure Advanced Custom Charts & KPIs
  • Configure Custom Pictographs in excel.
  • Configure Dynamic thermometer with dynamic colors.
  • Dynamic Chart Titles in Excel
  • Share Excel Data and Reports to Power point, Share point, Power BI
  • Case Study

Training Approach

This course on Advanced Data Modelling and Analytics Using Excel is delivered by our seasoned trainers with vast experience as expert professionals in their respective practice fields. The course is taught through a mix of practical activities, presentations, group work and case studies. Training manuals and additional reference materials are provided to the participants.

Certification

Upon successful completion of this course, participants will be issued a certificate.

Tailor-Made Course

We can also do this as a tailor-made course to meet organization-wide training needs. A training needs assessment will be done on the training participants to collect data on the existing skills, knowledge gaps, training expectations and tailor-made needs.

 

Nairobi Mar 04 - 08 Mar, 2024
Nairobi, Kenya 18 - 22 Mar, 2024

Registration: 00:00:am - 00:00:am

Class Session: 08:00:am - 04:00:am

USD 950.00 + 47.50 (VAT)(Classroom-based)
USD 600.00 + 30.00 (VAT)(Online)
(Convert Currency)

Devimpact Institute +254714349537

Related Courses

Training on Advanced M&E and Data Management for Health Programs Training on Advanced M&E and Data Management for Health Programs

5 days, 04 - 08 Mar, 2024 

2024-03-04 12:03:00 2024-03-04 12:03:00
Kenya

Devimpact Institute

Monitoring and Evaluation helps in collecting, analyzing, and transforming health data into strategic information for informed decision making, improved effectiveness and enhanced advocacy in health ...

Training on Cost Estimation, Budgeting and Cost Control Training on Cost Estimation, Budgeting and Cost Control

5 days, 04 - 08 Mar, 2024 

2024-03-04 12:03:00 2024-03-04 12:03:00
Kenya

Devimpact Institute

Projects and/or businesses cannot be successful without accurate and timely project cost estimating. Estimating is a practice that occurs throughout the project/ business management lifecycle, and so ...

Training on Mobile Data Collection and Data Management using CommCare Training on Mobile Data Collection and Data Management using CommCare

5 days, 11 - 15 Mar, 2024 

2024-03-11 12:03:00 2024-03-11 12:03:00
Kenya

Devimpact Institute

CommCare is an open-source cloud-based, mobile, and web platform for non-programmers that lets you make apps that you can deploy on Android devices, in the cloud and other cell phone ...

Training on Business Analytics with Excel Training on Business Analytics with Excel

5 days, 04 - 08 Mar, 2024 

2024-03-04 12:03:00 2024-03-04 12:03:00
Kenya

Devimpact Institute

Microsoft Excel is the most used analytics, reporting, and strategy software. This Training in Business Analytics with Excel will equip the participants with data analytical skills using ...