OCL Learning

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

Advanced Microsoft Excel Master Class 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

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 in Kenya and Live Online Advanced Microsoft Excel Training Live Online and Onsite.

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

Advanced Excel for Procurement Professionals Training 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

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

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

Create dependent lists with Excel INDIRECT Function

The Excel INDIRECT Function Use Cases - Create a Dependent List and Reference Named Range 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...

How to Create a project schedule in Excel

How to build a project task schedule with Excel - Advanced Excel Training in Kenya | OpenCastLabs Consulting 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