Transfer MI 3W Contacts into Google Account

1. On MI 3, click Settings > Contacts

2. Import/Export contacts > Export to storage > OK

3. Import from storage > Google > OK

4. Message "... will be imported shortly" will appear

5. Login to Google Contacts using the same google account as in MI 3. Contacts from phone will appear under 'All Contacts'.

Upgrade Windows 8.1 to Windows 10

1. Right hand click on Get Windows 10 icon on taskbar

2. Click Go to Windows Update

3. On Upgrade to Windows 10, click Get started

4. Click Accept

5. Click Start the upgrade now

6. Upgrading Windows
    - Copying files
    - Installing features and drivers
    - Configuring settings
    - Reboot

7. On Hi there, welcome back!, enter the user password. Click Next

8. On Get going fast, click Use Express settings

9. On Customize settings, turn Off for Personalization and Location. Click Next

10. Turn On for Browser and protection and turn Off for Connectivity and error reporting. Click Next

11. Click Next on New apps for the new Windows

12. This won't take long Setting up your apps

13. Taking care of a few things Don't turn off your pc

14. Windows 10 upgrade completed successfully.

URL: http://www.techrepublic.com/article/how-to-upgrade-to-windows-10-a-step-by-step-walkthrough/

Invalid Certificate Error After Install Security Update 2015-004 on Maverick

SYMPTOM:

1. Unable to access App Store (blank screen)

2. Unable to Access Skype using Microsoft Account

3. Unable to Access iTunes with error, 'iTunes can't verify the identity of the server ...'

4. Access to multiple website with https return with error, 'Safari can’t verify the identity of the website...'

ROOT CAUSE:

1. After install Security Update 2015-004

SOLUTION:

1. Launchpad > Other > Keychain Access

2. Click 'login' under 'Keychains'

3. Look for 'VeriSign Class 3 Public Primary Certification Authority - G5'

4. Right hand click > Export "VeriSign Class 3 Public Primary Certification Authority - G5"

5. Select ' Desktop' next to 'Where:' > Save

6. Right hand click > Delete "VeriSign Class 3 Public Primary Certification Authority - G5"

7. Apple icon > Restart...

URL: http://apple.stackexchange.com/questions/180570/invalid-certificate-after-security-update-2015-004-in-mavericks

Enable Power Query on Microsoft Excel 2013

REMARK: Supported on following Office versions: 

. Microsoft Office 2010 Professional Plus with Software Assurance

. Microsoft Office 2013 Professional Plus, Office 365 ProPlus or Excel 2013 Standalone

1. Download Power Query 32 bit/ 64 bit.

2. Execute PowerQuery_2.21.3974.242 (64-bit) [en-us].msi.

3. Click Next.

4. Check 'I accept the terms in the Licence Agreement'. Click Next.

5. Click 'Change...' to change Installation Folder or click Next to use the default.

6. Click Install.

7. Click Finish.

8. Run Excel 2013. 'Power Query' menu had been added to Menu bar.

URL: http://support.office.microsoft.com/client/Introduction-to-Microsoft-Power-Query-for-Excel-6E92E2F4-2079-4E1F-BAD5-89F6269CD605?NS=EXCEL&Version=15

Delete/ Merge Duplicate Google Contacts

1. Open Contacts Preview using Chrome browser

2. Clik Find duplicates

3. All duplicate contacts will shown on right hand side.

4. Check individual duplicate contacts. Click Merge icon at the top right of the page.

   OR

5. To merge all the duplicates, click the Merge all icon at the top right of the page.

URL: https://support.google.com/mail/answer/165334?hl=en