Skip to content
Excel Unlocked

Let’s Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us

Functions

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

infographics rank function in excel

RANK Function in Excel – Usage with Examples

The RANK Function is one of the most easiest and useful excel functions. In this blog, we would learn the syntax and arguments required by… Read Article
infographics named ranges in excel part 2

Named Range Excel – Updating, Data Validation

In the previous blog, we learned what are named ranges in excel, how to use them, the types of named ranges, and a lot more.… Read Article
infographics named ranges in excel

Named Ranges in Excel – Define, Usage, and Types

Named Ranges play a fundamental role in defining efficient and easy-to-read excel functions and formulas. It can also be used in Data Validation and hyperlinks.… Read Article
infographics XOR Function Excelunlocked

XOR Function in Excel – Usage with Examples

In the previous blog, we did the usage of OR Function. The XOR stands for exclusive OR and is very different from the OR Function.… Read Article
infographics T Function excelunlocked

T Function in Excel – Usage with Examples

The T Function of Excel is used in exceptional cases. It is a type of Worksheet function. It is one of the most straightforward functions… Read Article
infographics applications of SUMPRODUCT Function in Excel

Applications – SUMPRODUCT Function in Excel

In the previous blog, we focused on understanding the basic usage of the SUMPRODUCT formula, its syntax and arguments, and some of the functions it… Read Article
infographics SUMPRODUCT Function in excel

SUMPRODUCT Function in Excel – Usage with Examples

The SUMPRODUCT function in Excel is a very versatile function that can replace the SUM Function, COUNTIF Function, and SUMIF Function. The SUMPRODUCT Function can… Read Article
infographics INDEX MATCH lookup in excel

How to INDEX MATCH in Excel? – Lookup Formula

In the previous blogs, we did the usage of INDEX and MATCH Function in Excel. The combined INDEX and MATCH Function use enables us to… Read Article

Applications – FILTER Function in Excel

In the previous blog, we did the basic usage of the FILTER function in Excel. In this blog, we will learn some of the most… Read Article
infographics UNQUE Function

Applications of UNIQUE Function in Excel

In the previous blog, we used the UNIQUE Function of Excel to understand the basic functionality of the UNIQUE Function. In this blog, we will… Read Article
infographics UNIQUE Function in excel

UNIQUE Function in Excel – Usage with Examples

UNIQUE Function in Excel is a quite easy-to-use function and is one of the useful Dynamic Array Functions. The usage of the UNIQUE Function is… Read Article
infographics sort function in excel

SORT Function in Excel – Usage with Examples

There can be a number of ways to sort the data in excel. We can do it either by using Excel sorting features or we… Read Article
Post navigation
Older posts
Page1 Page2 … Page19 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 298 other subscribers

Recent Comments

  • Parth Gupta on Show Negative Numbers in Bracket and in Red Color
  • Shailesh on Sparkline in Excel – Insert, Edit and Delete
  • Dhrunil Bhatt on Stack Data from One Column into Multiple Columns

Archives

Categories

  • Charts (67)
  • Functions (222)
  • Templates (0)
  • Tips and Tricks (59)
  • Uncategorized (2)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.

  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ Excelunlocked.com 2022