LearnExcel.io
Menu

Excel Formulas and Functions

In this category, delve into Excel's rich assortment of formulas and functions, which allows you to perform complex calculations, data analysis, automate data manipulation, and much more.

Page 2 of 11

Excel COUNT Function

Learn how to master the Microsoft Excel COUNT function, a key tool for efficiently managing numerical data in your spreadsheets.

April 23, 2024

Excel COUNTA Function

“Learn how to use the Microsoft Excel COUNTA Function to efficiently count cells with non-empty values in your spreadsheet.”

April 23, 2024

Excel COUNTBLANK Function

“Discover how to use the Microsoft Excel COUNTBLANK function to easily count empty cells in your spreadsheets and enhance your data analysis skills.”

April 23, 2024

Excel COUNTIF Function

Learn how to master the Microsoft Excel COUNTIF function to easily count cells that meet a specific condition, improving your data analysis skills.

April 23, 2024

Excel EXACT Function

“Learn how to use the Microsoft Excel EXACT Function to compare two strings for an exact match in this comprehensive guide.”

April 23, 2024

Excel FIND Function

Discover how to master the Microsoft Excel FIND function for searching text within cells effectively, enhancing your data analysis and management skills.

April 23, 2024

Excel KURT Function

Learn how to calculate kurtosis in Excel with the KURT function, including syntax, a worked example, how to read positive vs negative values, and fixes.

April 23, 2024

Excel LARGE Function

Discover how to use the Microsoft Excel LARGE Function to easily find the nth largest value in a data set, simplifying data analysis.

April 23, 2024

Excel LEFT Function

Discover how to master text extraction with the Microsoft Excel LEFT function, a simple guide to streamline your data management tasks efficiently.

April 23, 2024

Excel LEN Function

Explore the essentials of the Microsoft Excel LEN function, a tool for measuring text length in your spreadsheets, in our latest detailed guide.

April 23, 2024

Excel LOWER Function

Discover how to use the Microsoft Excel LOWER function to easily convert text to lowercase, streamlining your data preparation and analysis tasks.

April 23, 2024

Excel MAX Function

“Learn how to use the Microsoft Excel MAX Function to easily find the highest value in your data sets with our comprehensive guide.”

April 23, 2024

Excel MEDIAN Function

Learn how to use the Microsoft Excel MEDIAN Function to easily find the middle value in a data set, enhancing your data analysis skills.

April 23, 2024

Excel MID Function

Discover how to extract specific text from a cell using the Microsoft Excel MID Function, enhancing data manipulation skills with ease.

April 23, 2024