Lock and Unlock specific cells in Excel
Lock and Unlock specific cells in Excel
Abdelrahman Abdou Comments are off
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 for adding and subtracting months!
EDATE Function for adding and subtracting months!
Abdelrahman Abdou Comments are off
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
Excel Pivot Tables Error Handling
Excel Pivot Tables Error Handling
Abdelrahman Abdou Comments are off
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
Handling errors in Excel using IFERROR
Handling errors in Excel using IFERROR
Abdelrahman Abdou Comments are off
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,
IF function + Logical Functions (AND and OR) in Excel
IF function + Logical Functions (AND and OR) in Excel
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 using CEILING and FLOOR Functions in Excel
Rounding using CEILING and FLOOR Functions in Excel
Abdelrahman Abdou Comments are off
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
Weighted Average in Excel-How to calculate!
Weighted Average in Excel-How to calculate!
Abdelrahman Abdou Comments are off
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
Hide formula results based on Date in Excel
Hide formula results based on Date in Excel
Abdelrahman Abdou Comments are off
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
Keyboard Shortcuts for Every Excel user!
Keyboard Shortcuts for Every Excel user!
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
Negative numbers in Red in Excel?
Negative numbers in Red in Excel?
Abdelrahman Abdou Comments are off
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,
How to use a Wildcard in Microsoft Excel!
How to use a Wildcard in Microsoft Excel!
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
Using Goal Seek to find the input for a required output!
Using Goal Seek to find the input for a required output!
Abdelrahman Abdou Comments are off
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
Calculating Nominal and Effective Interest Rates in Excel
Calculating Nominal and Effective Interest Rates in Excel
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
How to extract data from a website using Microsoft Excel
How to extract data from a website using Microsoft Excel
Abdelrahman Abdou Comments are off
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
How to calculate hours worked in a shift using Excel!
How to calculate hours worked in a shift using Excel!
Abdelrahman Abdou Comments are off
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
How to calculate Age in Excel | Excel Formula to Calculate Age
How to calculate Age in Excel | Excel Formula to Calculate Age
Abdelrahman Abdou Comments are off
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
How to use the ERR object in Excel VBA to differentiate errors
How to use the ERR object in Excel VBA to differentiate errors
Abdelrahman Abdou Comments are off
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
How to calculate your loan Payment in a few easy steps: PMT function
How to calculate your loan Payment in a few easy steps: PMT function
Abdelrahman Abdou Comments are off
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: The key to manage large sets of data continued
Database functions: The key to manage large sets of data continued
Abdelrahman Abdou Comments are off
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
Database functions: The key to manage large sets of data
Database functions: The key to manage large sets of data
Abdelrahman Abdou Comments are off
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:
INDEX and MATCH functions in Excel
INDEX and MATCH functions in Excel
Abdelrahman Abdou Comments are off
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
VLOOKUP with Sorted List – AKA Approximate Match
VLOOKUP with Sorted List - AKA Approximate Match
Abdelrahman Abdou Comments are off
A lot of people know how to use the VLOOKUP function to do an exact match – That is to search for something specific and

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.