fbpx
Madonna House, Westlands Road - Nairobi
+254790706395
info@opencastlabs.co.ke

Free Excel Tips, Templates, Videos and Tutorials

Uncategorized

The new Microsoft Excel LET Function

The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula....
Read More
Uncategorized

How to use the AVERAGEIF and AVERAGEIFS Functions

AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.Syntax AVERAGEIF(range, criteria,...
Read More
Uncategorized

How to change text cases in Microsoft Excel

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER,...
Read More
Fetching Live Data from Kobo using Power Query
Power Query

Fetching Live Data from Kobo using Power Query

Power Query for Excel allows you to fetch/pull your Live Data from Kobo Data Collection database (submissions). Use the power of Power Query to Extract, Transform and Load your data to Excel
Read More
Dynamics 365 Business Central Adoption Guide
Microsoft Dynamics Power BI

Dynamics 365 Business Central Adoption Guide

The most successful companies are already reaping the rewards of digital transformation. Digital transformation enables organizations to attract the best talent, empower employees, and deliver innovative products and services all with streamlined operations—centered around exceptional customer experiences.
Read More
Uncategorized

Business Owners Guide to Replacing Accounting Software

Replacing your accounting software is easier and more affordable than you may think. Use this guide to learn about the...
Read More
Excel Add-In for Dynamics NAV
Microsoft Dynamics

Excel Add-In for Dynamics NAV

Excel Add-In for Dynamics NAV Read, Write, and Update Dynamics NAV from Excel Your Dynamics NAV Data, Your Way! The...
Read More
How to Connect QuickBooks Data to Excel
Data Connectors & ODBC

How to Connect QuickBooks Data to Excel

As an accounting application designed for small businesses, QuickBooks and QuickBooks Online have relatively robust reporting options. In addition to...
Read More
Download Inventory Control Template
Inventory Control

Download Inventory Control Template

Use this Stock Control Template to monitor your stock in, stock out and sales. Use the summary sheet to get the YTD, Week to Date, and Month to date this year and last year reports
Read More
Functions & Formulas

Kenya Revenue Authority PAYE 2021 Excel Formula

Here is a beautiful formula to help you calculate the new Income Tax amount based on 2021 Rates
Read More
1 2 3 5