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

Transfer Samsung Note 4 Contacts into Google Account

1. On Samsung Note 4, click Contacts.

2. Tap on overflow menu (denoted by three vertical dots located on top right hand side)

3. Tap Settings > Contacts > Import/export contacts > Export to device storage

4. Confirm export: OK

5. Tap Settings > Contacts > Import/export contacts > Import from device storage

6. Save contact to: Google

7. Importing in progress

8. Tap OK

URL: http://www.techrepublic.com/article/pro-tip-migrate-all-of-your-android-contacts-to-google/

Upgrade iPhone 3GS to iOS 6.1.6

WARNING: Before perform the update, always perform phone backup! The author will NOT be held responsibility under any circumstances.

PRE-CHECK LIST

1. Make sure the phone battery is fully charged or connect to direct power source (recommended).

2. 'Wi-Fi' is connected to download the iOS 6 package.

3. Full iPhone 3GS backup using iTunes. Follow this guide to install iTunes; http://emanduel.blogspot.com/2012/07/install-itunes-on-windows-xp-pro-sp3.html.

4. Once backup completed, disconnect the phone.

UPDATE!

1. On iPhone 3GS, To view installed version:

   Settings > General > About. Look for Version: 5.1.1

2. Settings > General > Software Update

3. Install Now > Agree

4. The device will reboot and upgrade on progress.

5. Once finish, it'll reboot. Swipe to continue.

6. Update Completed: Continue

7. Location Services: Disable Location Services. Next > OK

8. Apple ID Sign ID: . Next > Agree > Agree

9. Messaging: Check only 'Your Phone Number'. Next

10. Thank you: Start Using iPhone

Transfer iPhone 3GS to Samsung GALAXY Note 4 Using Samsung SmartSwitch

1. Connect iPhone 3GS to PC USB port.

2. Open iTunes.

3. File > Devices > Backup

4. Once backup completed, disconnect iPhone 3GS. Quit iTunes.

5. Download Samsung SmartSwitch for Windows or MAC OS.

6. Install Samsung SmartSwitch and reboot the PC.

7. Connect Samsung GALAXY Note 4 to PC USB port

8. Run SmartSwitch

9. Click Restore > Change data to restore

10. Under 'Select backup data to restore', click 'Non-Samsung device data'

11. Check 'Select all (7 selected)' > OK

12. Click 'Restore now'

13. Wait till the restoration completed.

14. Click Confirm.

15. Disconnect Samsung GALAXY Note 4. Quit SmartSwitch.

URL: http://www.wondershare.com/mobile-phone/contacts-from-iphone-to-galaxy-s3.html#part%202