Skip to content
  • Connect with us
  • Power Platform
    • 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
    • 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 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
    • 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 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
    • - 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

Category: Functions

Home/Category: Functions

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.

March 2, 2023adminFunctions
Lambda Excel

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.

August 29, 2022adminFunctionsExcel Functions Office 365, Lambda, Office 365

How to use MAXIFS Function

The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria

August 19, 2022adminFunctionsAdvanced Excel Training, Formulas and Functions, MAXIFS function

How to use VLOOKUP in Excel

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number,…

Read More

August 19, 2022adminFunctionsExcel Formulas for Finance, INDEX function, Match Function, Microsoft Excel, Office 365, VLOOKUP

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
Developed by Think Up Themes Ltd. Powered by WordPress.
  • Safety and Health Policy
  • Privacy Policy
  • Refund & Training Cancellation Policy
  • Templates & Models