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

Color Palette in Excel VBA

Many a times you will need to show colors at run time for your cool Excel application. A good mix of Colors can make a application more att...

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

Get List of Files and Sub-Folders in a Folder

While working with VBA, one of the many common things to do will be, getting a list of files and sub-folder in a folder . The following cod...

Cricket Score Sheet - 50 Overs

If you play professional cricket every now and then, you will also love to maintain the scorecards in an organized manner. The below score...

Currency Exchange Rate Reporter

Do you regularly keep check on the currency rates? If the answer is yes, the below will prove more than useful to you. The below is a smal...

Using 'COUNT' function in Excel

This tutorial will cover the COUNT function of Excel. This function can be used to count the number of cells, within the specified range, ...

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