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 - ISLOGICAL Function Formula in Excel

ISLOGICAL Function in Excel – Checking for Boolean TRUE/FALSE

The ISLOGICAL Function is a part of IS formula in excel. These functions are mainly used in dashboards interfaces.There are two logical values in excel… Read Article
Infographic - TIMEVALUE Formula Function in Excel

TIMEVALUE Function in Excel – Returning Serial Number of Time

While working with date and time in Excel, we may sometimes feel a need of performing arithmetical calculations on the time. Unfortunately, excel cannot perform… Read Article
Infographic - EOMONTH Formula Function in Excel

EOMONTH Function in Excel – Getting Last Day of Month

The EOMONTH function in excel has a very appreciable usage in performing an arithmetic operation on dates. In this tutorial, we would learn how to… Read Article
Infographic - EDATE Formula Function in Excel

EDATE Function in Excel – Adding Months to a Specific Date

Many times, while working with dates in Excel, you may wish to calculate the upcoming or past date having a difference of a specific number… Read Article
Infographic - MONTH Formula Function in Excel

MONTH Function in Excel – Finding Month From Date

Sometimes, while working with dates in MS Excel, we might want to know the value of a month of a specific date. In that case,… Read Article
Infographic - DAYS360 Formula Function in Excel

DAYS360 Function In Excel- Counting Number of Days

In our recent blogs, we learned about the DAYS Function of Excel that returns the number of days between two dates. The usage of the… Read Article
Infographics - DAYS Function Formula in Excel

DAYS Function In Excel – Number of Days Between Two Dates

Many a time, while working with dates in excel, you may wish to calculate and count the number of days between two dates. For example,… Read Article
Infographics DATEDIF Function Formula in Excel

Excel DATEDIF Function – Find Difference Between Dates

The DATEDIF Function in Excel calculates the difference between two dates. This blog explains the entire usage of the DATEDIF formula in Excel.Here we go… Read Article
Infographics AVERAGEIFS Function Formula in Excel

Excel AVERAGEIFS Function – Multiple Criteria Average

In our recent blog, we learned how to use the AVERAGEIF function to find the average by applying one condition. In a similar manner, the… Read Article
Infographic - SLN Formula Function in Excel

SLN Function in Excel – Calculate SLM Depreciation

Depreciation refers to a decrease in the value of a fixed (non-current) asset due to time, wear and tear, obsolescence, etc. There are various methods… Read Article
Infographic - DDB Formula Function in Excel

Excel DDB Function – Compute Depreciation Using Formula

The DDB function in excel is one of the financial Excel formulas. This function is useful for calculating depreciation on fixed asset in excel. In… Read Article
Infographic - DB Formula Function in Excel

Excel DB Function – Formula to Calculate Depreciation

In this tutorial, we would learn how to calculate depreciation on a fixed asset using excel formula. Depreciation refers to a decline in the value… Read Article
Older posts
Newer posts
← Previous Page1 … Page8 Page9 Page10 … 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