Excel Function Archives

Dynamic KPI indicator with SEQUENCE and CEILING Function in Excel

April 18, 2023April 18, 2023 PKComments Off

In the competitive landscape of today's business world, tracking and analyzing key performance indicators (KPIs) is vital for assessing and improving your organization's performance. Microsoft Excel provides various functions to

Excel Tips and Tricks

LAMBDA Function in Excel with Example

December 19, 2022February 25, 2023 PKComments Off

In this article, you will learn how to use the LAMBDA Function in Excel with Example. By utilizing LAMBDA functions, you can generate personalized, reusable functions and give them a

Excel Tips and Tricks

IMAGE function in Excel to insert the image in Excel Cells

September 25, 2022September 25, 2022 PKComments Off

Image function is used to insert the image from a website into Excel cells. It can be the part of an Excel Table so you can use the sort and

Excel Tips and Tricks

Quick Productive Tips in Microsoft Excel

August 8, 2022August 8, 2022 PKComments Off

In this article, you will learn the quick tips in Excel to improve the productivity in Microsoft Excel. Tip #1: Auto Serial Number: We can Sequence function in Excel to

Excel Tips and Tricks

TEXT Function Use Cases in Excel

April 11, 2021April 11, 2021 PKComments Off

In this article, you will learn the use of TEXT Function in Excel. TEXT Function is very powerful function in Excel. You can convert numbers into text in desired format.

Excel Tips and Tricks

XLOOKUP and XMATCH Function Step by Step Tutorial

July 12, 2020February 15, 2023 PKComments Off

In this article, You will learn how to use XLOOKUP and XMATCH Function in Microsoft Excel. XLOOKUP is very powerful functions. This function is currently available to Microsoft 365 subscribers

VBA

UDF to get the frequency of specific word in a Paragraph

August 22, 2019February 6, 2023 PKComments Off

I. Introduction Data analysis - a critical aspect of modern business and organizations - provides valuable insights into various datasets, allowing informed decisions to be made. While Microsoft Excel boasts

VBA

UDF for Evaluate a Formula in Excel

April 18, 2019April 18, 2019 PKComments Off

In this article you will learn how to create a User Defined Function to evaluate a formula in Excel. You will also learn how to get text of formula using

VBA

VLOOKUP by cell background color

May 13, 2018April 17, 2023 PK0

VLOOKUP is a popular function in Microsoft Excel. It helps users to find and retrieve specific data from a large table or range of data. However, there is a limitation