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...

Calendar 2014

A calendar is always handy specially when you plan your year ahead. It can become more than handy if its comes in Excel. Please find below ...

Excel Keyboard Shortcuts

Though the 2007+ versions have been making it easy to use, rather than adding new functionality to it, a few Excel shortcuts may come hand...

Enable or Hide Fill handle for Drag and Drop Editing

The Fill handle in excel is used for drag-and-drop editing. By default it is turned on in Excel so that you can drag the mouse to move and ...

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 'CONCATENATE' function in Excel

The CONCATENATE in Excel function is used to join two or more cells values, text strings or words. One can CONCATENATE upto 255 items altho...

Simple Statement Analyzer

Analyzing your monthly statement is the first step for an effective budget management. However, without effective tools, analyzing your st...

Using 'OR' function in Excel

The 'OR' function is one of the basic logical functions in Excel. It returns either 'TRUE' or 'FALSE' like most lo...

Using 'AND' function in Excel

The AND function is Excel is used to perform logical tests. The power of AND function multiplies when used with 'IF' function. T...