There are shortcuts that you can use in Microsoft Office to fasten your work. You need to press the same keys together.
1) Ctrl + A - to select all
2) Ctrl + C - to copy the selected.
3) Ctrl + V - to paste
4) Windows + D - to minimize all and go to the desktop
5) Ctrl + X - to cut
6) Alt + F4 - to close the current project
7) Ctrl + S - to save
8) F5 - to refresh
9) Ctrl + O - to open options
10) Ctrl + P - to print
To connect strings in Microsoft Excel, simply use '&'.
Example :
This will return the following results:
Using TEXT formula to calculate time.
Use =TEXT(End time-Start time,"format to use") to calculate between two times. Simply replace the format to use with:
h = hour
mm = minutes
ss = seconds.
Example:
You can also personalize the formula.
This will return the result based on each preference.
How to calculate between two times?
 |
To get the time difference, just use End Time - Start time. In this case, it would be =B2-A2.
The answer should be 9:14:30, 9 hours 14 minutes and 30 seconds.
Or you can use HOUR, MINUTE and SECOND formula.
The result would depend on which formula that you choose.
To calculate age using Microsoft Excel, just use the simple formula DATEDIF. Example would be =DATEDIF(date to compare, current date, "y")
For example,
Here's the two dates to compare. In selected destination cell, type =DATEDIF(A2,B2,"y")
Formula AVERAGE is used to search the average value. Example of formula is =AVERAGE(RANGE X:RANGE Y)
Example 1 : To find the average value of a row or column.
Hit the enter button to get the average result.
Example 2 : To find average value of multiple rows or columns.
How to increase and decrease the decimal value?
1) Choose the selected cell.
2) Go to Home->Number
