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
04 October 2021
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Twitter Feeds

We are now offering Nature Based Solution training for professionals in need of 2 weeks course both online and in person. Write to training@ic4rd.org for booking! #naturebasedsolutions; #climateresilience; #disasterresilience

IC4RD in partnership with Tangaza University College has organized this short course for professionals interested in Climate Change Adaptation (CCA) in Africa. Book your slot by registering and get knowledge, skills and certificate!

New report on human-wildlife coexistence by @WWF & UNEP calls on policymakers to consider the needs of communities when making decisions about conservation & land use, which would dramatically improve the prospects of several endangered species. https://bit.ly/3xtXGGf

Solar panels being integrated into canals in India giving us Solar canals. it helps with evaporative losses, doesn't use extra land and keeps solar panels cooler.
I'd love for every nearby farmer to lobby for it as well. Give them some of the cheap electricity.🤔
#Tiredearth

Load More...
× Talk to us!