OCL Learning

04/03/2024

Start your DATA Analyst Career Journey Today!

Go from starter analyst to a seasoned analyst when you take this in 8 Week program. The program is a blended self-paced program that combines instructor led training 2 times a week for 3 hours (20%), class assignments (30%), Class Videos (30%), Peer Learning (10%), Cornerstone Project (10%)

www.opencastlabs.co.ke/data

Live and In-person training at OCL Learning for groups and individuals. Get training from Foundation, Intermediate and Advanced Levels. The leading Advanced Excel Training company in Kenya and Eastern Africa

30/07/2021

This Advanced Microsoft Excel One on One or Live Online Training focuses on utilizing Microsoft Excel tools in financial reporting, data analysis, analyzing M & E Data and building budgets and forecasts among other topics throughout the 7 modules covered.

For groups you have the option of 2 to 3 days full day training.

The training combines onsite (2 to 3 full day for groups more than 5) or online classes each of 4 hours over 5 sessions and class assignments in between.

Advanced Microsoft Excel Training Live Online and Onsite.

22/02/2021

The function of today’s procurement professional involves collating and analyzing vendor data, developing and sharing performance dashboards and creating interactive business cases and sensitivity or scenario models – and this require the capability to effectively utilize the Microsoft Excel software. This intensive, hands-on course demonstrates the full capabilities of the MS-Excel program for the role of a procurement and supply chain professional

Learn how to conduct procurement analysis using Excel Advanced Microsoft Excel for Procurement Professionals The function of today's procurement professional involves collating and analyzing

22/01/2021

3 ways of splitting Excel Text: Text to Columns, Functions and Power Query
Full Video Here: https://t.co/szh9tz80Ww https://t.co/qEPPKsd6Ka

16/01/2021

Advanced Microsoft PowerPoint Training.
https://www.opencastlabs.co.ke/advanced-microsoft-powerpoint-training/

21/09/2020

How to summarize Excel data using SUMPRODUCT function
https://youtu.be/K-9ijqrLCcQ

20/06/2020

How to chart Income Statement Data with Excel Waterfall.

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based.
Full video: https://youtu.be/Avx_vY4Yz6w

23/05/2020

Create dependent lists with Excel INDIRECT Function

Use INDIRECT Function to create a dependent list and reference and named range. The INDIRECT Function returns the reference specified by a text string. Refer...

13/03/2020

10/03/2020

How to Create a project schedule in Excel

How to build a project task schedule (Gantt Chart) Using a combination of Excel Functions and Conditional Formatting, you can automatically change the task schedule based on the task status. Watch video below and Download Excel workbook https://youtu.be/0L3VSdbaTWk

01/12/2019

See how accountants and Financial professionals could use Excel to automate reports! Sing up for Training