Last updated: May 27, 2022

Essential Excel Functions

In this module, we discuss some of the most basic and widely used functions available in Microsoft Excel.

Count Function EASY

This article will cover the excel sheet functions along with the examples.

Author Soumya Agrawal

2 upvotes

The Sum Function EASY

The SUM function in Excel is mainly used to sum a range of cells. In this article, we will learn about the SUM function, its syntax, and its types in detail.

Author GAZAL ARORA

3 upvotes

Min, Max, and Average EASY

In this blog, we will be studying some essential functions of excel, namely min, max, and average.

Author Prachi Singh

1 upvote

Logical Functions

In this Module, we are going to discuss the basic logical operations that are performed in mathematics and how to implement them in Excel.

Using the If Conditional in Excel VBA

In this blog, we will be studying one of the most commonly used functions in Excel VBA.

Author Prachi Singh

3 upvotes

Comparison Operators in Excel EASY

Comparison operators in Excel are mainly used to compare the values across two or more columns that have data. This article covers such comparison operators, syntax, and types in detail.

Author dhruv sharma

3 upvotes

AND & OR Function in Excel EASY

This blog will cover an AND and OR function with its needs and use cases with different examples.

Author devikaVarshney

2 upvotes

Contains Specific Text EASY

This blog helps us understand the concept of a cell containing specific text in Excel.

Author Sneha Mallik

2 upvotes

In this article, we will discuss the concept of blank cells in excel.

Author Aditya kumar

1 upvote

ABS Function EASY

This blog will cover an absolute value (ABS) function with its need and use cases with different examples.

Author devikaVarshney

1 upvote

Date Time Functions

In this Module, we are going to discuss the Date and Time time-related functions present in Excel.

Today and Now Function

This article discusses what is today and now function and their usage with proper examples and the difference between them.

Author Yukti Kumari

1 upvote

Days, Month and Year Function EASY

In this article, we will be learning about the Days, Month, and Year functions of Excel.

Author Komal Shaw

0 upvotes

Days and DATEDIF Function EASY

In this article, we will learn how to use the Excel Days and Datedif function.

Author Komal Shaw

1 upvote

Lookup Functions

In this module, we are going to discuss the lookup functions present in Excel and their uses in navigating through the data.

Index and Match Function

This article discusses index and match functions in Excel and their use in everyday life. We will also understand the applications of index and match functions and how powerful of a tool it is.

Author AbhayTrivedi

1 upvote

HLOOKUP Function EASY

In this article, we will look at the HLOOKUP Function of Excel which is used to find and retrieve a value from data in a horizontal table.

Author Komal Shaw

1 upvote

VLOOKUP Function

In this article, we learn about the VLOOKUP function in Excel

Author HET FADIA

2 upvotes

XLOOKUP Function EASY

In this article, we will learn how to use XLOOKUP in Excel

Author HET FADIA

3 upvotes