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 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
infographics binom.inv function in excel

BINOM.INV Function in Excel – Inverse Cumulative Distribution

In the previous article, we implemented the BINOM.DIST Function. In this blog, we would learn the usage of another essential function – BINOM.INV Function in… Read Article
Older posts
Page1 Page2 … Page24 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • wout on How to Insert Picture or Image in Excel Comment
  • ALAMIN ABUBAKAR ZARMA on TRUE and FALSE Function in Excel
  • Matthias Lüpke on How to Send Email From Excel Automatically

Archives

Categories

  • Charts (69)
  • Functions (280)
  • Tips and Tricks (73)
  • VBA and Macro (52)

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.

Excel Unlocked
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2023