Tuesday, May 5, 2015

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

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...'

1. After install Security Update 2015-004

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

Tuesday, April 28, 2015

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

Monday, April 27, 2015

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.


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.


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 iTunesFollow 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.


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