• Email: training(@)globalkingprojectmanagement.org
  • Call: +254 114 830 889

Advanced Microsoft Excel

About the Course

Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of advanced Excel skills. This course 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 is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.

Course duration

 

5 Days

What you will learn

By the end of this training 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 PowerPivots.

Course Outline

Data Validation

  • Whole numbers and decimals
  • Date and time validation
  • Text length
  • Excel data validation list (drop-down)
  • Custom data validation rules

Referencing in Excel

  • Absolute referencing
  • Relative referencing
  • Structured reference

Working with Structured tables

  • Why you should use tables
  • Elements of an Excel table
  • Managing data in an Excel table
  • Using structured references with Excel tables

Formulas and Functions

  • VLOOKUP
  • HLOOKUP
  • INDEX and MATCH
  • SUMPRODUCT
  • SUMIF & SUMIFS
  • COUNTIF & COUNTIFS,
  • OFFSET & INDIRECT
  • Concatenating Functions 
  • IF and nested IF Functions
  • AND, OR, NOT Functions
  • Date Formulas and Functions

What If Analysis

  • Scenarios
  • Custom Views
  • Reports
  • Goal Seek
  • Data Tables

Pivot Tables and Pivot Charts

  • Preparing data for use with Pivot Table
  • Formatting a PivotTable
  • Working with Calculated Fields
  • Grouping Data
  • Filters and Advanced Filter
  • Advanced Data Field Settings
  • Creating Pivot Chart
  • Power Query

Excel Macros

  • Recording Macros
  • Copy a Macro from Workbook to Workbook
  • Exercise: Recording a Macro
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar
  • Managing Macro Security

Charts and Visualizations

  • Preparing data for charts
  • Choosing appropriate chart
  • Creating Different Charts
  • Dashboards

Working External Data

  • Linking Workbooks
  • Working with non-legacy databases
  • Extracting Data from the Web
  • Creating Collector Models

General Notes

·         All our courses can be Tailor-made to participants needs

·         The participant must be conversant with English

·          Presentations are well guided, practical exercises, web-based tutorials, and group work. Our facilitators are experts with more than 10years of experience

·          Upon completion of training, the participant will be issued with a Global King Project Management certificate

·         Training will be done at the Global King Project Management Centers (Nairobi Kenya, Mombasa Kenya, Kigali Rwanda, Dubai ,Lagos  Nigeria and More others).

·         A discount of 20% will be given to more than 4 participants from same organization.

·         Course duration is flexible and the contents can be modified to fit any number of days.      

·         Payment should be done before commencement of the training, to the Global King Project Management account, so as to enable us to prepare better for you.

·         For any inquiry to:  [email protected] or +254 114 830 889

·         Website: www.globalkingprojectmanagement.org

·         Tablet and Laptops are provided to participants on request as an add-on cost to the training fee

·          The course fee for onsite training includes facilitation training materials, 2 coffee breaks, a buffet lunch, and a Certificate of successful completion of Training. Participants will be responsible for their own travel expenses and arrangements, airport transfers, visa application dinners, health/accident insurance, and other personal expenses.

 

Course Schedule

Start Date End Date Action Duration Location Fee(Kes) Fee(Us$)
09/01/2023 13/01/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
06/03/2023 10/03/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
01/05/2023 05/05/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
29/05/2023 02/06/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
24/07/2023 28/07/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
21/08/2023 25/08/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
18/09/2023 22/09/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
16/10/2023 20/10/2023

Apply On-site

Apply Online

5Days Nairobi 100000 1200
06/02/2023 10/02/2023

Apply On-site

Apply Online

5Days Mombasa 120000 1500
03/04/2023 07/04/2023

Apply On-site

Apply Online

5Days Mombasa 120000 1500
26/06/2023 30/06/2023

Apply On-site

Apply Online

5Days Mombasa 120000 1500
13/11/2023 17/11/2023

Apply On-site

Apply Online

5Days Mombasa 120000 1500