Excel-functions

92 posts

How to Round Date to Previous or Next Specific Weekday in Excel?

Last Updated: 06 December 2022

The WEEKDAY function produces a number between 1 and 7 that corresponds to specific days of the week. WEEKDAY, by default, assumes a Sunday- ...read more

Technical Scripter

Picked

Excel

Excel-functions

Technical Scripter 2022

VBA Strings in Excel

Last Updated: 28 August 2023

In the realm of Excel's Visual Basic for Applications(VBA), strings play a pivotal role in handling and manipulating text-based data. String...read more

XLOOKUP vs INDEX-MATCH in Excel

Last Updated: 16 June 2022

XLOOKUP can figure out the following more modest or the following bigger worth when there is no definite match. INDEX-MATCH can likewise do ...read more

Picked

Excel

Excel-functions

Similar Topics

How To

2.3k+ articles

Website & Apps

550+ articles

Excel

540+ articles

Tips & Tricks

530+ articles

Microsoft Office

100+ articles

Excel-How To

100+ articles

excel

55+ articles

MSExcel

48+ articles

MicrosoftExcel

20+ articles

Excel Formulas

19+ articles

How to Correctly Sum Numbers With Units in a Range in Excel?

Last Updated: 21 March 2022

In Excel, we can sum numbers in a range which are given along with their units. When we place numbers along with their units inside Excel th...read more

Picked

Excel

Excel-functions

Geeks-Premier-League-2022

Geeks Premier League

How to Calculate Frequency Distribution in Excel?

Last Updated: 07 March 2022

A frequency distribution table is an organized representation of the frequency of each element in a dataset/record. It helps us to visualize...read more

Geeks-Premier-League-2022

Geeks Premier League

How to Count Unique Values in Excel? 5 Easy Ways

Last Updated: 06 December 2023

Count Unique values in Excel is a feature that can help you to find the values that occur only once in the huge list of Excel. We often need...read more

How to Delete Every Other Row or Every Nth Row in Excel?

Last Updated: 16 December 2021

In this article, we will see how to delete every other row or every nth row in excel. Generally, deleting every other row in Excel boils dow ...read more

Picked

Excel

Excel-functions

Data Validation in Excel

Last Updated: 13 December 2023

Microsoft Excel is a powerful tool and is widely useful too. It has various features to ease our work. One such feature is Data Validation. ...read more

Picked

Excel

Excel-functions

Excel CHOOSE Function with Array

Last Updated: 19 September 2023

We often use the CHOOSE function in Excel to pick something from a list. In this article, we'll see how to use CHOOSE with a bunch of things...read more

How to use Autofill Feature in MS Excel ?

Last Updated: 06 September 2021

Every day in business or any other field lots of information are there that are required to store for future use. For anyone, it is very dif...read more

Excel

Excel-functions

Excel String Functions - LEFT, RIGHT, MID, LEN, and FIND

Last Updated: 21 August 2021

Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text data....read more

Picked

Excel

Excel-functions

How to Calculate the Midrange in Excel?

Last Updated: 30 July 2021

MS Excel is a spreadsheet developed by the company Microsoft. Excel provides various kinds of functions and we can insert the data in form o ...read more

Top Excel Data Analysis Functions

Last Updated: 11 September 2023

Have you ever analyzed any data? What does it mean? Well, analyzing any kind of data means interpreting, collecting, transforming, cleaning,...read more

Picked

Excel

Excel-functions

Average Cells Based On Multiple Criteria in Excel

Last Updated: 14 March 2024

An Average is a number expressing the central or typical value in a set of data, in particular the mode, median, or (most commonly) the mean...read more

Picked

Excel

Excel-functions

Excel DATEDIF Function

Last Updated: 20 September 2023

The DATEDIF is a date function that is generally used to find the number of total days, months, and years between two dates. It takes two da...read more

1 2 3 4 5 6 7 >>

1 2 3 4 5 6 >>

1 2 3 4 >>