Excel Function =TODAY() Formula Sending The CURRENT DATE Automatically | Exceltip2day Blog

Do you know that in Excel office program having a function calculate “DATE”?


Yes, the function of date value calculation is form with the syntax “=today()”

The benefits of this formula:

It will give the automatically value of the “CURRENT DATE” whenever it is loaded,-auto refresh.
  • The following is the step handling the function:
  • Click into any cell in your Excel worksheet.
  • Fill out the syntax formula =today().
Edit its format to display as your determine.

Fill out =today() into any cell.

 The result is given as the DATE shown.

 The "Format Cell" function for edit your format.


Does it help?

<> 

See more other tips:
Would you like to surf more my other blogs?



What Does It The Excel Function =NOW() Use For? | Exceltip2day Blog

In Excel office program, there are many functions to help users to handle their job easily.

Today, this blog “Exceltip2day” is going to describe you all the method of how to find out the “CURRENT TIME” with formula.

The following is the syntax of Excel function:

=now()

The benefits of formula:

It will give the automatically updating date and time whenever that Excel sheet file is opened, - auto refresh.

See the image below for more ease understanding.

To fill out the syntax formula into a cell.

 The date/time value is given as above

In addition, the image that below is to tell you how to use the function “Format Cell” to adjust your value feature, as you want.


Does it help?

<> 

See more other tips:
Would you like to surf more my other blogs?



Quick Way To Copy and Paste The Entered Data To The Immediate Underneath Cell | Exceltip2day Blog

In Excel worksheet, if you want to make the copy and paste function the entered data of above cell to the adjacent below cell.

The Exceltip2day blog has already described you the quick ways and illustrated image for understanding and follow it by yourself.

Do the below steps;

1] Find the cell you want to copy. For example, you will see the image below supposing to copy the entered data from the cell B3.


2] Go to the immediate underneath cell you want to paste data into. It's the cell B4.




3] Press the button Ctrl and "(Quotation mark). Then, suddenly the data will appear in the cell B4 as the same as the data of the cell B3 above.

Do you think it is useful for you?

See more other tips:
Would you like to surf more my other blogs?



Little Known Ways: Simply Deleting Cell(s) in Excel Worksheet - [Ctrl] + [-](Minus button)

Let’s come together to see the simple task but it’s very beneficially for everybody who uses Excel office or love to learn more new way to deal with it.

Here I am going to tell you how to delete empty cell(s) or cell(s) with the data entered.

Do the following:
  1. Selecting any cell(s) to be deleted
  2. Press the keyboard button "Ctrl" and "-"(Minus button)
  3. Click to select any deleting type (Shift cells left, Shift cells up, Entire row, Entire column)
  4. Then click to “OK” button
See more images below for more clear.

Selecting the cell A5 and click Ctrl, - together 

Select one of the 4 choices above as you desired

Image of the completion after the task done.

See more other tips:
Would you like to surf more my other blogs?



How To Use "Select Object" Selecting All The Rectangular Region Of Pictures And Deleting

Do you know how to use the “Select Object” tool in Excel?

The “Select Object” tool is very good function to handling all about the object like pictures, shapes, SmartArt…

Today, I am going to tell you how to use the “Select Object” for SELECTING multi-objects and delete them all.

Do the following:
  • On the ribbon bar, click the “Find & Select”
  • Click over the “Select Object” tool.
  • Press and hold down SHIFT button.
  • Drag mouse to select all over the objects you want.
  • Press the “Delete” button.
Click the "Select Object"
Drag over the objects
All objects be selected
Empty cell after deleting 
See more other tips:
Would you like to surf my other blogs?



How To Format The Entire Cells In A Workbook With Just Only A Single Click

Do you know the very shorter way to format the entire cells in a worksheet?

Fortunately, this following method is the best trick as far as I have ever known. It helps you to format the entire cells in a workbook to be the only one unique format. More, it does not complicate at all.

Here comes the step-by-step shortcut:
  • Select the original format cell as wanted. (Ex. Cell B3).
  • Click on the “Format Painter” icon on the top left corner.
  • Press the “Ctrl” “A” buttons on your keyboard.
Done! The outcome should be the same as the images beneath.

Before format
After format
See more other tips:
Would you like to surf my other blogs?



Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Paste

How can I use “Format Painter” for unlimited multiple paste?

As you might know that using the “Format Painter” Excel function is very useful and save time. 

Nevertheless, not many people know the trick and enjoy using it in a very simple way.

Trick is:

1] Select the specific cell(S) that you want to copy the format. (Ex. as the image below is cell "A2")
2] To click twice quickly without moving the mouse (Double-clicking) onto the “Format Painter” function button.
3] Click to any cell(s) you want to paste the format to.
4] Click on the “Format Painter” again to inactivate the task regards no more use.


Before "Format Printer"

Processing "Format Printer"

After "Format Printer"
See more other tips:
Would you like to surf my other blogs?



Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]

Do you know the result of percentage not the same if there is “0” figure in the Range of Average Formula?

Therefore, how do you solve this problem?

To obviously visible what the difference of using Average Formula between the range of figure “Including 0” and “Exclude 0”.

1] Let us have a look the first sample. We have the table of the whole year of sales amount. However, there are the two months, which are with the “0” sales amount, July and August.


We use Excel formula “=AVERAGE(AB5:AB16)” to calculate the percentage average from January-December. The outcome is 76.11%. That would be true?

2] The second sample, we use all the same data as the number one. By the way, we have changed the formula to use “=AVERAGEIF(AB5:AB16,"<>0")” instead. Here we gain 91.33%


It does not matter what is our calculation criteria. Here, my article is just only to show you how the two formula work in different way. You can pick any of them and use it as you want.

See more other tips:
Would you like to surf my other blogs?