Excel Workshop

Excel is one of the most used computer programs in the world. It is a spreadsheet that collects data in rows and columns and allows you to perform calculations on the data. It can be used for many purposes, including bookkeeping, budgeting, statistics, plotting graphs, accounting, and more.

In this course, you will learn how to use advanced formula techniques. You will master sophisticated lookup functions. You’ll clean and prepare data for analysis and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for the big finale, where you will learn how to build professional dashboards in Excel.

The course is aimed at those who have taken an intermediate level excel course or have basic skills in excel. This course will build on that foundation of knowledge by providing a more detailed look at the capabilities of Excel 2016 for Windows.

Our goal is to prepare you with everything you need so that you’re an expert at creating high-quality dashboards in Excel.
If this sounds like something you’d be interested in, take a look at our full curriculum below or just click the enroll button below!

  • Overview and Background
  • Basic desktop navigation 
  • Creating a workbook and adding data 
  • Creating formulas and functions 
  • Formatting cells and tables for readability and analysis 
  • Creating and Formatting Tables 
  • Creating Graphs and Charts
  • Introduction to Macros and VBA 

Virtual Training Schedule

Start DateEnd DateLocationCostApply here
7th Feb 202211th Feb 2022Online$350/ksh35000Enroll
7th March 202211th March 2022Online$350/ksh35000Enroll