Skip to content
  • Connect with us
  • Power Platform
    • Data Analysis with Python
    • Data Analysis and Visualization with Microsoft Power BI
    • Introducing Microsoft Dynamics 365 Business Central
    • Microsoft Power Automate RPA Developer
    • Data Transformation with Power Query
  • Data Analytics
    • Data Analyst Training Accelerator (DATA) Certification Program
    • Data Visualization with Tableau Desktop
    • Data Engineering on Microsoft Azure
    • Advanced Google Analytics Training
    • Data Analysts Recruitment Services
    • Microsoft Azure Fundamentals
  • Microsoft Courses
    • Comprehensive Financial Modeling with Excel Training
    • Advanced Excel Training for Auditors
    • Excel Formulas and Functions Training
    • Advanced Excel Training
    • Comprehensive Microsoft Word Training
    • Certificate Course in Graphic Design
    • Advanced Excel for Procurement Professionals
    • Querying Data with Microsoft Transact-SQL training
    • Budgeting and Forecasting with Excel
    • Advanced Microsoft PowerPoint Training
    • Microsoft Project 2019 Training
    • Macros and VBA Excel Training
    • Microsoft Office Specialist (MOS)
    • Data Analysis for the Modern Business Analyst
    • Advanced Microst Visio 2019/365
    • Digital Marketing Master Classs
    • Advanced Excel Training in Uganda
    • Advanced Excel Training in Kigali, Rwanda
    • Microfinance Professionals
    • Advanced Excel Training in South Sudan
  • Corporate Solutions
    • Data Collection
    • Data Protection Act Training
    • Instruction Design for e-Learning Projects
    • e-Learning Solutions
    • Business Automation with Airtable
    • Power BI Deployment Services
  • Templates & Models
  • Happy Customers
  • About Us
  • Contact OCL Learning
  • Monitoring and Evaluation Training in Rwanda
  • Power BI Training in Rwanda
OCL Learning
  • Power Platform
    • Data Analysis with Python
    • Data Analysis and Visualization with Microsoft Power BI
    • Introducing Microsoft Dynamics 365 Business Central
    • Microsoft Power Automate RPA Developer
    • Data Transformation with Power Query
  • Data Analytics
    • Data Analyst Training Accelerator (DATA) Certification Program
    • Data Visualization with Tableau Desktop
    • Data Engineering on Microsoft Azure
    • Advanced Google Analytics Training
    • Data Analysts Recruitment Services
    • Microsoft Azure Fundamentals
  • Microsoft Courses
    • Comprehensive Financial Modeling with Excel Training
    • Advanced Excel Training for Auditors
    • Excel Formulas and Functions Training
    • Advanced Excel Training
    • Comprehensive Microsoft Word Training
    • Certificate Course in Graphic Design
    • Advanced Excel for Procurement Professionals
    • Querying Data with Microsoft Transact-SQL training
    • Budgeting and Forecasting with Excel
    • Advanced Microsoft PowerPoint Training
    • Microsoft Project 2019 Training
    • Macros and VBA Excel Training
    • Microsoft Office Specialist (MOS)
    • Data Analysis for the Modern Business Analyst
    • Advanced Microst Visio 2019/365
    • Digital Marketing Master Classs
    • Advanced Excel Training in Uganda
    • Advanced Excel Training in Kigali, Rwanda
    • Microfinance Professionals
    • Advanced Excel Training in South Sudan
  • Corporate Solutions
    • Data Collection
    • Data Protection Act Training
    • Instruction Design for e-Learning Projects
    • e-Learning Solutions
    • Business Automation with Airtable
    • Power BI Deployment Services
  • Templates & Models
  • Happy Customers
  • About Us
  • Contact OCL Learning
  • Monitoring and Evaluation Training in Rwanda
  • Power BI Training in Rwanda
  • Power Platform
    • - Data Analysis with Python
    • - Data Analysis and Visualization with Microsoft Power BI
    • - Introducing Microsoft Dynamics 365 Business Central
    • - Microsoft Power Automate RPA Developer
    • - Data Transformation with Power Query
  • Data Analytics
    • - Data Analyst Training Accelerator (DATA) Certification Program
    • - Data Visualization with Tableau Desktop
    • - Data Engineering on Microsoft Azure
    • - Advanced Google Analytics Training
    • - Data Analysts Recruitment Services
    • - Microsoft Azure Fundamentals
  • Microsoft Courses
    • - Comprehensive Financial Modeling with Excel Training
    • - Advanced Excel Training for Auditors
    • - Excel Formulas and Functions Training
    • - Advanced Excel Training
    • - Comprehensive Microsoft Word Training
    • - Certificate Course in Graphic Design
    • - Advanced Excel for Procurement Professionals
    • - Querying Data with Microsoft Transact-SQL training
    • - Budgeting and Forecasting with Excel
    • - Advanced Microsoft PowerPoint Training
    • - Microsoft Project 2019 Training
    • - Macros and VBA Excel Training
    • - Microsoft Office Specialist (MOS)
    • - Data Analysis for the Modern Business Analyst
    • - Advanced Microst Visio 2019/365
    • - Digital Marketing Master Classs
    • - Advanced Excel Training in Uganda
    • - Advanced Excel Training in Kigali, Rwanda
    • - Microfinance Professionals
    • - Advanced Excel Training in South Sudan
  • Corporate Solutions
    • - Data Collection
    • - Data Protection Act Training
    • - Instruction Design for e-Learning Projects
    • - e-Learning Solutions
    • - Business Automation with Airtable
    • - Power BI Deployment Services
  • Templates & Models
  • Happy Customers
  • About Us
  • Contact OCL Learning
  • Monitoring and Evaluation Training in Rwanda
  • Power BI Training in Rwanda

Blog

Home/Blog

Overview of formulas in Excel

Get started with Excel Functions and Formulas. Download Excel workbook on formulas at the bottom of post. What more? Browse our page for individual and corporate training

June 4, 2022adminFunctionsFormulas and Functions

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…

Read More

March 24, 2022adminFunctionsFunctions

Power BI Embedded Analytics

Power BI embedded analytics allows you to embed your Power BI content such as reports, dashboards and tiles, in a web application or in a website.

January 17, 2022adminPower BIAZURE, dashboards, Embedded Analytics, Microsoft, Power BI, Power BI training

REIT Financial Model Template

This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will help you get an understanding of the financial workings of…

Read More

January 3, 2022adminUncategorized

Financial Projection Template

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

January 2, 2022adminFinancial Modelingfinancial Modeling, Financial Projection, Forecasting

Kenya Revenue Authority PAYE Formula 2021

Use this template to calculate PAYE based on gross salary. This band of tax calculation was released in 2021. [download id=”380″]

January 2, 2022adminUncategorized

Year 2022 Calendar

Download Microsoft Excel Calendar for the year 2022 – monthly. Download Here Another One

December 31, 2021adminUncategorized

Kenya Revenue Authority PAYE 2021 Excel Formula

Download KRA PAYE Formula Template

November 30, 2021adminUncategorized

Financial Reporting with Power BI

November 30, 2021adminUncategorized

Formulas and Functions Training

November 30, 2021adminUncategorized

Posts pagination

1 … 3 4 5
Developed by Think Up Themes Ltd. Powered by WordPress.
  • Safety and Health Policy
  • Privacy Policy
  • Refund & Training Cancellation Policy
  • Templates & Models
1

WhatsApp us