Shortcuts - Today's Date

Do you need to enter today's date on a daily basis in excel? 

You can use the shortcut CTRL+; and today's date will automatically appear in the selected cell. 

You can also use the formula =TODAY()

Easily Excel at dating your sheet :)

Shortcuts - Current Date and Time

You can enter the current time in your Excel sheet by using the shortcut CTRL+SHIFT+:

You can use the formula =NOW() to enter the current date and time in a single cell

Happy Easily Excelling! :)

Concatenate Function

The name of the function does sound long and technical, however, it is one of the easiest functions to use in Excel.

Concatenate is useful when you want to join or 'string' together two or more pieces of text. What this means is that you can merge the content of two or more cells into one cell using the Concatenate function.

Try using this function in the practice file here.

There are two ways to use this function:

1) =concatenate(Cell1,Cell2,…)

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

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