Excel-functions

92 posts

How to Get a List of User Defined Functions in Excel VBA?

Last Updated: 22 February 2023

Microsoft provides many built-in functions to speed up your work in Excel. However, you can technically create functions using VBA coding ca ...read more

Technical Scripter

Picked

Excel

Excel-functions

Excel-VBA

Technical Scripter 2022

Normdist() Function in Excel

Last Updated: 05 December 2022

The NORMDIST Function is one of Excel's Statistical functions. For a given mean and standard deviation, it will yield the normal distributio ...read more

Technical Scripter 2022

How to Generate All Prime Numbers Between Two Given Numbers in Excel?

Last Updated: 01 December 2022

A number greater than 1 with no positive divisors besides 1 and the number itself is referred to as a prime number. In this article, we will...read more

Technical Scripter 2022

Similar Topics

How To

2.3k+ articles

Website & Apps

580+ articles

Tips & Tricks

550+ articles

Excel

540+ articles

Microsoft Office

110+ articles

Excel-How To

100+ articles

excel

58+ articles

MSExcel

52+ articles

MicrosoftExcel

20+ articles

Excel Formulas

19+ articles

How to Separate Numbers and Percentages from One Cell in Excel?

Last Updated: 16 October 2022

While dealing with numbered data, we generally come across a variety of problems that hamper our work. One such problem of separating number...read more

How to Extract the last N Words from Text String in Excel

Last Updated: 06 December 2023

Excel is a tool for storing and managing a large amount of data. Data is entered in a rectangular block, which we called a cell. This tool c ...read more

Excel Formula to Get Next Day of Week

Last Updated: 02 June 2022

MS-Excel is a program that is part of the Microsoft Office suite. It is a multi-row and multi-column electronic spreadsheet that is used to ...read more

How to Calculate the Coefficient of Variation in Excel?

Last Updated: 21 March 2022

Coefficient of Variation is a statistical term that is used to measure the dispersion of data points with the arithmetic mean of all the dat...read more

Picked

Excel

Excel-functions

Geeks-Premier-League-2022

Geeks Premier League

How to Create Pivot Chart from Pivot Table in Excel using Java?

Last Updated: 06 December 2023

A Pivot Chart is used to analyze data of a table with very little effort (and no formulas) and it gives you the big picture of your raw data ...read more

Geeks-Premier-League-2022

How to Break Links in Excel?

Last Updated: 20 January 2022

In this article, we explain two different ways to break links in excel. When we move a sheet from different workbooks. There are chances of ...read more

Picked

Excel

Excel-functions

How to Split Cells in Excel: In 5 Easy Steps

Last Updated: 20 March 2024

Microsoft Excel is a powerful data tool used in various industries. Organizing data in separate cells is crucial for clarity and analysis. W...read more

How to Remove Hyperlinks in Excel? Different Methods

Last Updated: 06 December 2023

The HYPERLINK function generates a shortcut that opens a document saved on a server or the Internet or moves to another position in the exi...read more

How to Convert Multiple PowerPoint Files Into Pdf with Excel VBA?

Last Updated: 21 December 2022

Often clients need PPT files as PDFs. It helps to view on any device. Use below VBA Macro to convert PowerPoint files from a folder and save...read more

How to Create Excel Pivot Table Calculated Field with Examples

Last Updated: 06 December 2023

You can add calculated fields to a pivot table using your own unique algorithms that add up to other pivot fields. A calculated field has so...read more

Using the SUMIF Function to Add Cells if They Contain Certain Text

Last Updated: 01 November 2022

In Excel, sometimes we want to sum up the values based on some specific text values. Such as the cells which have text written as "ME" will ...read more

How to use CHOOSE Function in Excel

Last Updated: 08 November 2023

The CHOOSE function is technically part of Excel’s lookup function and can be incredibly useful. The CHOOSE function returns a value from ...read more

1 2 3 4 5 6 7 >>

1 2 3 4 5 6 >>

3 4 5 6 >>