OpenCastLabs

28/12/2021

Happy Holidays.

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.

31/08/2020

How to create relationships within Excel Sheets using the Excel Data Model.

Create relationships in Excel tables so that you can analyze data from multiple related sheets using the Excel Data Model. Data residing in Power Pivot’s Dat...

31/08/2020

Using conditional formatting and IF Function to compare Actuals and Budgets in Excel.

Use a combination of Conditional Formatting in Excel and IF Function to compare actuals and budgets. Color cells with arrows pointing up or down depending on...

31/08/2020

Data Analysis and Business Modeling with Excel.

Master business modeling and analysis techniques with Microsoft Excel 2016/2019, and transform data into bottom-line results. Adopted from award-winning educator Wayne Winston book, this hands on, sce

31/08/2020

Using Microsoft Excel RIGHT & LEFT functions to split text.

A combination of RIGHT, LEFT, LEN and FIND functions to easily split text strings, first name and last names, numbers and much more. Discover text manipulati...

31/08/2020

Budgeting and Forecasting with Excel

Go beyond manual budgeting and Forecasting processes. Deliver quicker and more efficiently using our standard budgeting processes, methodologies and standard to develop, audit, consolidate and share your Budgets within the environment you operate in.

31/08/2020

Microsoft Excel is one of the most popular tools to integrate financial models in an effective and secure manner. It is a primary financial management tool that has the ability to identify and track all the connecting points that help to manage enormous volumes of calculations involved in building a scalable financial model.

Microsoft Excel is one of the most popular tools to integrate financial models in an effective and secure manner. It is a primary financial management tool that has the ability to identify and track a

31/08/2020

Data Analysis with Excel for the Data Analyst;The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis.

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Exce

31/08/2020

Using the SUBSTITUTE function to clean Excel Data containing spaces.
https://youtu.be/qXtyCLPLafI

Join us this Wednesday and every Wednesday for 3 hours Formulas and Functions Bootcamp. Time: 12PM - 3PM (GMT +3) Cost: Kes. 2000.00/Person. Among other functions we will cover: Formulas for Summarizi

19/08/2020

3 Most Powerful Free AddIns for PowerPoint.

Power-User is a comprehensive add-in that brings various tools to boost your presentations. Get ready-made templates, icons, diagrams, and maps directly in PowerPoint, as well as powerful charts such

19/08/2020

3 Statement Financial Model Template.

Free Download. 3 Statement Financial Model Template