How to add a trend or Moving Average line to a chart in Excel

In statistics, a moving average (rolling average or running average) is a calculation to analyze data points by creating a series of aver...

Split Cell Data to Columns

In this tutorial, I will be walking through another fantastic facility provided by MS Excel. You may have encountered the of copying the t...

Using 'COUNTIF' function in Excel

The COUNTIF function counts the number of cells within a range meeting the specified criteria. For example, you can count the number of ti...

Implementing IF-ELSE logic in Excel

Like any programming language, you can implement IF-ELSE logic in Excel. The only difference if the way it is implemented. Lets consider t...

Using Nested 'IF' function in Excel

If you understand the IF function in Excel then please continue to understand how to use nested IFs. Otherwise please go through the below...

Import Text Data (Delimited) to Excel

In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful when you have text file ...

Import Text Data (Fixed length) to Excel

In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful when you have text file a...

VLOOKUP Function in Excel

While working with Excel, quiet often you will feel the need the search a table in excel and get some value from it.  There are few in-b...

HLOOKUP Function in Excel

While working with Excel, quiet often you will feel the need the search a table in excel and get some value from it.  There are few in-bui...