Make a Phone Call in Yosemite

You can make phone call in your mac with the following conditions

1. Mac with Yosemite installed.
2. iPhone with IOS 8 or above.
3. Both your Mac and iPhone are connected to the same wireless network.
4. Both devices are signed in with the same iCloud account.
5. Both devices are bluetooth turned on.


If you have satisfied all above conditions, you can make your phone call in you Mac......

But how ??
There is no dial pad in Yosemite, right ?

Here are the situations to make phone calls in Yosemite:

1. Click the phone icon in a contact's details within the Contacts app

2. Click the phone icon next to a valid phone number detected by Safari

3. Manually select a phone number and right-click it to call through a context menu

If you want  dial pad, you may try the following

Continuity Keypad  US$0.99 from the Mac App Store.

MS Excel Formula for Calculate Age by Entering Date of Birth

Formula: =TRUNC((DAYS360(D1,today(), FALSE))/360, 0)

D1:  is your target cell for input date of birth
today(): is the formula to return the date of today




Then, the cell with this formula returns the age of input.



Easy!

Rename a Group of Files in Yoesmite

In previous OSX, you need to use Automator to help you to change the name file of a group of files.

But in Yoesmite,
you can easily do it by Finder.
1. Highlight all your files.
2. Right-click and select "rename items"
3. A select "format" dropdown to apply a new nomemnclature to the whole list.

Re-size Your Windows in Yosemite

In Yoesmite,
If you click the green button, it will make your current windows expands to full screen.

But you just want the "old" way, how to do it ?

You just need to hold down the option key when clicking green button.

Microsoft Excel 2011 -- Move the cursor to the beginning of the line within a cell

How to move the cursor to the beginning of the line within a cell ??

Windows: Home
Mac: option + "left arrow"

Where is "Network Utility" in Yosemite ?

1. Open Finder
2. Under go menu
3. click "go to Folder"
4. Enter  /System/Library/CoreServices/Applications

Then, you will find it.

Mac OS X Useful Keyboard Shortcut. Tips and Tracks !

COMMAND + C                 Copy
COMMAND + V                 Paste
COMMAND + X                 Cut
COMMAND + A                 Select All
COMMAND + Z                  Undo
COMMAND + S                  Save
COMMAND + F                  Find
COMMAND + Q                 Quit Program
COMMAND + W                Close Window (program is not quit)
COMMAND + TAB            Program Switch
CTRL + SPACE                   Open SPOTLIGHT