Selecting and Formatting Blank Cells

How do you select all the blank cells in the selected range?

1) Select the range of cells and press F5.

2) Click on 'Special', click 'Blanks' and click OK.

This could be used to format all the blank cells in a particular theme.

Easily Excel by selecting all the blank cells in a few seconds and formatting them!

Another way to format the blank cells in the sheet is by using conditional formatting:

Calculate Working Days

You can easily calculate the number of working days between two specified dates using NETWORKDAYS function in Excel.

You need to mention if there are any holidays between the two dates.

The function is: =NETWORKDAYS(start_date,end_date,[holidays])

Where:

start_date is the first date of the period

end_date is the last date of the period

Calculate Sum Automatically

1. Select the cell immediately below the column of values to be summed.
2. Press Alt + = (Alt and 'Equal to' sign)
3. Excel will automatically write the Sum function and select the numeric range
4. Hit Enter!

Understand how to format your Excel sheet in few easy steps: http://learnexceleasily.blogspot.in//2013/11/quick-formatting-and-beautification.html

Use of Text Boxes

Download the Practice file here.

Excel is considered to be very rigid when it comes to formatting options. The gridlines restrict your formatting options as well as creativity.

At this moment, it makes sense to use a Text Box which floats on the sheet rather than being a part of it.

A Text Box is a rectangular object (you can create them in any shape that you want from Insert Menu -> Choose the ‘Shapes’ option from ‘Illustrations’ panel).

Following are the advantages of using a Text Box:

Quick Formatting and Beautification

Download the practice file here.

Delete the sheets which do not have any data in it. By default, Excel includes three sheets for each workbook. The remove the ones that do not have any data.

In the view menu, in the ‘Show’ panel, uncheck the option of gridlines. This makes the sheet look neater and adds elegance to the sheet.

Color the background of the cells across the sheet according to the theme that you are using (for your company or organisation). You can do this by selecting the cells that need to be colored and changing the color by going on the ‘Home’ menu and selecting the paint bucket in the ‘Font’panel.

Change the color of the text too in order to bring it in alignment with the theme. To do this, select the font color option on the ‘Font’ panel form the ‘Home’ menu.

Use the F4 key while formatting to repeat the last action. For example, if you colored a particular cell as orange and next you want to color another cell orange, you can select the next cell and hit F4. It can be used not only for formatting but for any action.

Learn how to use Text Boxes to make your Excel sheet look elegant and neat here

Please share your feedback here.

Count Function

Download the practice file here

The COUNT function counts all of the cells in a range with numeric values. Formula =COUNT(range)

IF Function

IF functions are very useful for performing logic, and they vary from simple to complex. 

For example, Amazon believes that if the stock level of mobile phones is less than 50, an order should be placed to bring the stock level back to 200. If the stock level is above 50 units, no action shall be taken.

Download the file here. 

Enter the formula =IF(condition,Value_IF_True,Value_IF_False), where condition is any condition that is either true or false, Value_IF_True is the value of the formula if the condition is true, and Value_IF_False is the value of the formula if the condition is false.

What this means is that If the condition mentioned is true, the formula will return Value_IF_False, if false, it will return Value_IF_False