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

Category: 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

Split Excel Text in 3 Ways

You can split Excel text Using Text to Columns, Power Query and Excel Text Functions. Watch video.

Financial Model and Key Finance Ratios

Download this model with model inputs and Key Finance Ratios for your organization performance

SUMIF Excel Function

How to use the Excel SUMIF Function

Description The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a…
Read more

Guidelines and examples of array formulas Tutorial

Applies to: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel for iPad Excel for iPhone An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as…
Read more

Microsoft Excel Shortcuts for PC and Mac

Get all Excel shorts for PC and Mac when you download this file. Subscribe to blog for more posts as this. Get the training you need for yourself and your team mates

3 Statement Financial Model Template

This free template includes assumptions, an income statement, a balance sheet, a cash flow statement, and a supporting schedules section to calculate depreciation, amortization, and interest on the debt.