Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us

Functions

This category is dedicated to covering all the functions and formulas of Excel.

Infographic - LARGE Formula Function in Excel

LARGE Function in Excel – Finding nth Largest Number

In our previous blog, we learned how to use the MAX function in Excel to find the largest number out of a list of numbers.… Read Article
Infographic - MAX Formula Function in Excel

MAX Function in Excel – Finding Largest Number

In the previous blog, we learn about the MIN function in excel that returns the smallest number out of a list of numbers. There is… Read Article
Infographic - MIN Formula Function in Excel

MIN Function in Excel – Returning Minimum Value

In this tutorial, we would learn how to find the minimum value or number using an excel in-built function called the MIN function in Excel.… Read Article
Infographic - COUNTBLANK Formula Function in Excel

Excel COUNTBLANK Function – Counting Number of Empty Cells

In our previous blogs, we learned about the COUNT and COUNTA function in excel to count numbers, text, formula errors, etc. in excel. In this… Read Article
Infographic - COUNTA Formula Function in Excel

Excel COUNTA Function – Count Cells Containing Values

In one of our previous blogs, we learned how to use the COUNT function in excel to count the number of cells that contain numbers.… Read Article
Infographic - COUNT Formula Function in Excel NEW

Excel COUNT Function – Count Cell Containing Numbers

Many a time, you may want to count the number of cells in excel which contains numbers. The COUNT Function in excel is an inbuilt… Read Article
Infographic - PV Formula Function in Excel

Excel PV Function – Calculate Present Value PV in Excel

The term PV represents Present Value. In this tutorial, we would learn about an excel formula function to calculate the present value (PV) of future… Read Article
Infographic - XNPV Formula Function in Excel

Excel XNPV Function – NPV With Irregular Cash Flows

In our previous blog, we learned how to calculate the NPV in Excel using the NPV excel function. The disadvantage of using the NPV formula… Read Article
Infographic - NPV Formula Function in Excel

NPV Function – How to Calculate NPV in Excel

The term NPV stands for Net Present Value. The Net Present Value refers to the discounting of the series of expected cash flows generated throughout… Read Article
Infographic - ADDRESS Formula Function in Excel

ADDRESS Function in Excel – Get Excel Cell Address

In this tutorial, we would how to use the ADDRESS function in excel to return the cell address using row and column numbers. We would… Read Article
Infographic - CHAR Formula Function in Excel

CHAR Function in Excel – Return Character By Code

In one of our previous blogs, we learned how to insert symbols and special characters in excel using an inbuilt ‘Insert’ ribbon tab > ‘Symbols’… Read Article
Infographic - CELL Formula Function in Excel

CELL Function in Excel – Get Information About Cell

The Excel CELL function is classified as an excel Information formula. In this tutorial, we would learn about how to use the excel CELL formula.When… Read Article
Older posts
Newer posts
← Previous Page1 … Page10 Page11 Page12 … Page24 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025