This Excel tutorial explains how to solve the problem of Excel Security Warning - Macros have been disabled.
Excel Security Warning - Macros have been disabled
This Excel Security Warning is one of the most annoying warnings in Excel. If you click on the Options button, you will see the below message.
In fact, this message does say something about the reason for this alert, it explained that this error is caused by encrypted Macro. What it means encrypted is that the Workbook contai...

More
# Chapter 6 – By Excel Topic

# Excel VBA find all Cells contain Named Range

This Excel VBA tutorial explains how to find all Cells contain Named Range using Macro.
You may also want to read:
Find all external links and broken links in workbook
Replace Named Range with formula
Find all Cells contain Named Range
In Excel spreadsheet, we can define Named Range under Name Manager (Formulas > Name Manager)
We can refer to Name Manager to see the formula the Named Range is referring to, but it does not tell which Cells are using the Named Range. Therefore...

More
# Excel extract text in brackets

This Excel tutorial explains how to extract text in brackets or in defined text in Excel spreadsheet and VBA.
Extract text in brackets in Excel spreadsheet
In the previous post, I demonstrated how to remove text in brackets or in any defined text, in this post I will explain how to extract the text in brackets or in any defined text.
In Excel spreadsheet, you can extract any substring using Mid Function.
To recap the syntax of Mid Function
MID( text, start_position, number_of_characte...

More
# Access Excel capitalize first letter in a sentence

This Access Excel tutorial explains how to capitalize first letter in a sentence using VBA custom Function.
Capitalize first letter in a sentence
In Excel spreadsheet, there is a Function called Proper, which converts all the first letter of each word to capital letter.
Example
Using Proper Function
he is a boy. she is a girl.
He Is A Boy. She Is A Girl.
he is a boy. his name is John. mary is a girl.
He Is A Boy. His Name Is John. Mary Is A Girl.
Mr. smith is happy
...

More
# Excel Days360 Function to calculate day difference

This Excel tutorial explains how to use Excel Days360 function to calculate day difference between two dates.
Excel Days360 Function
You can easily calculate the number of days between two dates by a simple deduction using Excel formula, however when you try to calculate the number of years between two dates, most people simply divide the day difference by 365. However, because every month has different days, and due to leap year, dividing the difference by 365 is totally incorrect.
Excel D...

More
# Excel currency converter template

This Excel tutorial explains how to create a currency converter template to convert one currency to another currency.
Excel currency converter template
In my previous post, I have demonstrated how to get currency exchange rate using VBA custom function and get the exchange rate via website. However I didn't make a convenient currency converter template to convert one currency to many different currencies or convert many different currencies to a single currency. In this tutorial, I will show y...

More
# Excel world time converter template

This Excel tutorial explains how to create a world time converter template in Excel.
Excel world time converter template
There are a lot of websites that allow you to enter time of one country and convert to time of another country, or even convert to time of multiple countries. These websites work absolutely fine with the exception that they do not allow you to save your searched result. It is absolutely time wasting to select your desired country from the country list of hundreds of countrie...

More
# Excel T.TEST Function to perform Student’s T Test

This Excel tutorial explains how to use T.TEST Function to perform Independent Sample T Test and Paired-samples T Test.
What is Independent T Test
In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the population standard deviation and population mean are known, we can use Z test to interference the population mean from sample mean.
In reality, we do not have data of the whole population. Without the popul...

More
# Excel CORREL Function to calculate coefficient of correlation

This Excel tutorial explains how to use Excel CORREL Function to calculate coefficient of correlation.
Coefficient of Correlation
Covariance is a measure of how much two random variables change together. After calculating covariance, we can check the sign whether it is negative or positive. Positive covariance means positive relationship (y increases as x increases), negative covariance means a negative relationship (y decreases as x increases).
In order to measure the strength of relation...

More
# Excel calculate covariance using COVARIANCE.S and COVARIANCE.P

This Excel tutorial explains how to calculate sample covariance using COVARIANCE.S and calculate population covariance using COVARIANCE.P
Covariance
Covariance is a measure of how much two random variables change together.
The below formula is for calculation of Population Covariance. For Sample Covariance, divide n-1 instead of N.
While σx is denoted as standard variation of x, σxy is denoted as Covariance.
After we calculate the covariance, we can check the sign whether it is ne...

More