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.

infographics R1C1 reference style in excel

How to Use R1C1 Reference Style in Excel?

In Microsoft Excel, we have two different types of reference styles. By default, the reference style that everybody uses is the A1 reference style while… Read Article
infographics dynamic named range in excel using the INDEX formula

Dynamic Named Range using the INDEX function

In the previous article, we learned about how to make dynamic named ranges with the help of the OFFSET function. The disadvantage of the OFFSET… Read Article
infographics dynamic named range in excel

Dynamic Named Range – OFFSET and COUNTA

Today, we are going to learn one of the advanced and important topics of excel which is to create dynamic named ranges. Let us see… Read Article
infographics sec function

SEC Function in Excel – Usage with Examples

Previously, we implemented the COS Function. In this blog, we would learn the fundamentals of the SEC Function. It is an important type of Trigonometric… Read Article
infographics tangent function in excel

TAN Function in Excel – A Trigonometric Ratio

In the earlier articles, we learned to find the Sin and Cosine of the angles using the functions in Excel. In this blog, we would… Read Article
infographics cos function in excel

COS Function in Excel – Usage with Examples

In the previous blog, we implemented the SIN Function. In this blog, we would now learn another important Mathematical Function, which is the COS Function… Read Article
infographics SIN Function in Excel

SIN Function in Excel – Mathematical Function

The SIN Function in Excel is an essential type of Mathematical Function The function is easiest to learn and implement. So let us begin learning… Read Article
infographics CHISQ.INV Function in Excel

CHISQ.INV Function in Excel – Inverse Chi Square Distribution

Previously, we implemented the CHISQ.DIST Function. In this blog, we will learn another important function that is closely related is CHISQ.INV Function in Excel. So… Read Article
infographics CHISQ.DIST.RT Function in Excel

CHISQ.DIST.RT Function in Excel – Statistical Formula

In the earlier blogs, we implemented the CHISQ.DIST Function. In this blog, we will now learn another related function known as CHISQ.DIST.RT. Let us see… Read Article
infographics chisq.dist function in excel

CHISQ.DIST Function in Excel – Chi-Square Distribution

In the previous blogs, we implemented the NORM.DIST and BINOM.DIST Function. In this blog, we would learn another type of distribution with the help of… Read Article
infographics covariance.p function in excel

COVARIANCE.P Function in Excel – Population Covariance

In the previous blog, we implemented the COVARIANCE.S Function. In this article, we are going to implement another interesting and useful function which is COVARIANCE.P… Read Article
infographics covariance.s function in excel

COVARIANCE.S Function in Excel – Sample Covariance

The COVARIANCE.S Function is an important Staticlal Function of Excel. It is easy to learn as well as implement. The Function has a very good… Read Article
Older posts
Page1 Page2 … 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