## THE DATA PROTECTION ACT Kenya

The purpose of the Act is to give effect to Article 31(c) and (d) of the Constitution that contains the right to privacy which is a fundamental human right. Data protection is the process of safeguarding personal information, in accordance with

## Introduction to Power Automate Tutorial

Power Automate is an online workflow service that automates actions across the most common apps and services. For example, you can create a flow that adds a lead to Microsoft Dynamics 365 and a record in MailChimp whenever someone with more than 100 followers tweets about your company.

## How to use LAMBDA Function in Excel

Use a LAMBDA function to create custom, reusable functions and call them by a friendly name. The new function is available throughout the workbook and called like native Excel functions.

## How to Convert Numbers to Words in Excel

Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following NumberstoWords function code into a VBA (Visual Basic for Applications) module. This function lets you convert dollar and cent amounts to words with a formula, so 22.50 would read as Twenty-Two Dollars and Fifty Cents. This can be very useful if you’re using Excel as a template to print checks.

## Data Analysis Expressions (DAX) Reference Guide

Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.

## Top 10 Types of Financial Models

There are many different types of financial models.  In this guide, we will outline the top 10 most common models used in corporate finance by financial modeling professionals.

## Top 10 Excel Functions for Finance

Top 10 Microsoft Excel finance functions every every financial modeling professional should master.

## Quotation and Invoice Excel Template

Download this free Invoice & Quote template, add your company name, address and email. Works with any currency – but is customized to USD and Kenya Shilling.

## The SUMIF Function

Summary  The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=) and…

## Financial Projection Template

Building up forecast from payroll schedules, operating expenses schedules and sales forecast to the three financial statements

## Data Governance – Introduction to Microsoft Purview

Introduction to Microsoft Purview As the volume and variety of data increases, the challenges of effective data governance will only grow more difficult. Digital transformation technologies have resulted in an…

## Dynamically pick a List based on a cell content using INDIRECT Function

The INDIRECT function in Excel can be used to dynamically reference a cell or range of cells based on the text string entered into another cell.

## Unlocking the Full Potential of Data Analysis with Power Pivot in Excel

Are you tired of struggling with piles of data and missing out on valuable insights due to limited analytical tools? Well, worry no more! It’s time to unlock the full…

## Create a box and whisker chart

Box and whisker charts, also known as box plots, are a type of graphical representation that display the distribution of a dataset. They are often used in statistics to visualize…

## What is Data Science, the Software, Careers and Principles

Data science is an interdisciplinary field that involves using various statistical, mathematical, and computational techniques to extract insights and knowledge from data. It encompasses a range of activities, including data cleaning, data preparation, data analysis, data visualization, and machine learning.

## Project Management Template with Task Status

Here is a smart project management template with task status and task health. Create smart projects with start dates that fall in weekdays only. What is more, you can us…

## Free Research and Data Scientist Courses

Data Analysis L https://lnkd.in/ggwKPfH3 Harvard – Data Wrangling: https://lnkd.in/gnArki9W Harvard – Probability: https://lnkd.in/gRA-sCrU Harvard – Linear Regression: https://lnkd.in/gCqYdf_W Harvard – Inference and Modelling: https://lnkd.in/gSnuYTMW Johns Hopkins – Advanced Statistics for…

## What is a Virtual Desktop?

In computing, a virtual desktop is a term used with respect to user interfaces, usually within the WIMP paradigm, to describe ways in which the virtual space of a computer’s…

## Get started with Azure DevOps

DevOps is the union of people, process, and products to enable continuous delivery of value to your end users. Azure DevOps is a set of services that gives you the…

## Descriptive, Predictive, Prescriptive, and Diagnostic Analytics – Definitions

What is Data Analytics? Data analytics is the science of analyzing raw data to make conclusions about that information. Many of the techniques and processes of data analytics have been…