Locking and unlocking cells in Excel is an important skill to learn, especially if you’re sharing files with other people, as it is important to
EDATE Function: The easiest way to add or subtract months to your dates! We deal with a lot of Date variables in Excel and to
Like summarization formulas in Excel, the Pivot Tables also throw errors like #DIV/0! and #NULL. It’s very annoying when this happens. You can refer to
Various functions in Excel result in an error in certain situations. It’s annoying to look at them when the errors are unavoidable. In this article,
Lots of people would have already used IF function in Excel and some would have used the Logical functions (AND, OR and NOT) of Excel.
Rounding numbers is a frequently occurring need. There are plenty of use cases where you would like to round off the given number to the nearest
Calculating weighted average is a more advanced way of averaging numbers where different weights are given to different numbers unlike equal/uniform weights given in the
Sometimes, you would like to compute certain information or show some results only for the dates till date. In other words, you would like to
All Excel users, whether beginners or advanced users, often have to modify rows and columns, no matter what they work on. Copying/Pasting, Inserting, Moving, Deleting
Want to learn how to Differentiate Negative Numbers in Excel? You’ve come to the right place! Whenever you deal with a large set of numbers,
In this article, you will learn how to use a wildcard in Excel! Sometimes you come across various situations where you have a huge set
There might be several instances where you might want to find out what is the value the input should take achieve the desired output. We’ll
Introduction The interest rate has many types in finance: real, nominal, effective, annual and so on. The difference between Nominal and Effective Rates (Two of the
There might be some cases where we might need to extract data from a website into Excel and update it automatically in the future. Excel
One of many features of Excel is that you can easily calculate the number of hours worked during a shift. Even though it is a really
In Excel, it is possible to calculate age from Birthday/Date of Birth. Just like we would figure out someone’s age by subtracting their birthdate to the
What is the ERR object in Excel VBA? The ERR object in Excel VBA is an object that contains information about different Run-time errors. 438
Introduction PMT is a financial function that calculates the periodic payment for a loan, mortgage or investment, with constant payments and interests rate and a
Database Functions Part 2: 12 formulas that cover all common calculation needs If you are still unsure about what Dfunctions are and how to use
Part 1: DFunctions in Excel, what they are and how to use them. The database functions perform a range of standard calculations to calculate statistics:
Most of the times the INDEX and the MATCH functions are used together or referred to together, this makes it difficult to understand their functionality
A lot of people know how to use the VLOOKUP function to do an exact match – That is to search for something specific and