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

Category: Uncategorized

Formulas and Functions Dictionary

Here is a Microsoft Excel Functions workbook with over 100 commonly used functions you can download. We have outlined the definition, syntax (function structure) and an example. Feel free to share/download.

Download Periodic Table Template

The periodic table, also known as the periodic table of elements, is a tabular display of the chemical elements, which are arranged by atomic number, electronic configuration and recurring chemical properties. The structure of the table shows periodic trends. Periodic table, in full periodic table of the elements, in chemistry, the organized array of all…
Read more

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. These names only apply within the scope of the LET function. Similar to variables in programming, LET is accomplished through Excel’s native formula syntax. To use the LET function in Excel, you define pairs of…
Read more

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, [average_range]) AVERAGEIFS: Returns the average (arithmetic mean) of all cells that meet multiple criteria.Syntax AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) Watch Video Below

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, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Functions are just built-in formulas that are designed to accomplish specific tasks—in this case, converting text case.…
Read more

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 benefits of a modern technology platform, better understand the advantages of a cloud-based solution, and know what questions to ask when evaluating your options. Why choose Microsoft Dynamics 365 to run your business? Microsoft Dynamics…
Read more

Project Gantt Chart Template

Download free Excel Gantt Chart/Project task schedule template and customize for own use. Share with friends and colleagues.