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

Month: October 2020

Office365

Microsoft overhauls Excel with live custom data types

Microsoft is overhauling Excel with the ability to support custom live data types. Excel users have been using Microsoft’s spreadsheet tool for decades to import, organize, and analyze data, but the basic data types have always been limited to text and numbers. While Microsoft has added dynamic arrays and some custom stocks and geography data…
Read more

Power Pivot: Powerful data analysis and data modeling in Excel

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.In both Excel and in Power Pivot, you can create a Data Model, a collection…
Read more

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

Top 5 Excel Add-Ins for Productivity

Boost productivity with these top 5 Excel Add-ins To start, let’s jump right in with the top 5 Excel add-ins to make you more productive. If you’re looking to up your productivity game, become more organized, and crush all your business goals this year, the Power User Excel add-in has your name on it. Keep in mind,…
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

Get Latest Purchase Date using MAX and IF Functions

Download Excel File Here: Watch Video Here: