Email: info@ic4rd.org | Contacts: +254 701 127 663, +254 773 569 632

Aim

This course gives advanced excel skills with participants being able to apply complex functions within Excel to manage, manipulate, analyze and visualize data. 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.

Course Objectives

At the end of this training you 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.

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

Topics are:

Data Validation; Referencing in Excel; Working with Structured tables; Formulas and Functions; What If Analysis; Pivot Tables and Pivot Charts; Excel Macros; Charts and Visualizations; Working External Data

Detailed Course Description

For detailed course description and content write to training@ic4rd.org

Registration

To register, please download the application form below and submit to training@ic4rd.org

Training topics can be requested by writing to training@ic4rd.org

Cost: USD 750 for individuals; 650 for groups above 10 participants.

Training fee includes conference package (training venue, tea/coffee, lunch, snacks, wifi etc)

icrd logo

©2020.All Rights Reserved.

International Centre for Research and Development.

Upcoming Events

Next Upcoming Event
21 June 2021
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Twitter Feeds

We all have bad dreams, but what these children are going through is nightly terror.

We're joining @UNICEF in calling attention to the importance of psychological support for children who’ve associated with armed groups.
#ChildrenNotSoldiers #RedHandDay

Load More...
× Talk to us!