Getting current Date and Time in Excel 2010/2013/2016

By | November 20, 2017

There are two functions which you can use to get current Date and Time in Excel: =TODAY() and =NOW(). You can use these functions as part of a text string by putting them into TEXT function with formatting string. It’s important to note that both of those functions are automatically recalculated each time you change or open your… Read More »

Change currency for a PayPal payment

By | November 20, 2017

Paypal uses the currency specified by the seller for payment. By default, it converts this currency to currency your card is in. This can be a problem since PayPal does not always have a good exchange rate. Fortunately, Paypal allows you to transfer currency exchange to your card issuer. In steps below, we will pay 15.11 USD for… Read More »

Change SIM Card PIN settings in MIUI 8

By | November 17, 2017

This will show you how to change PIN code for SIM Card in MIUI 8. MIUI 8 introduced a new search bar in settings window. You can use it to find settings a lot faster. If you use it now, you can skip right to step 4. Simply type in “sim“. In System Settings tap Additional Settings Enter… Read More »

How To View SSL Certificate Details in Google Chrome?

By | May 26, 2017

Newest version of Google Chrome removed ability to view SSL certificate details right from the URL bar. Now, you have to do view it in Developers Tools which requires few more clicks. Open Developer Tools by pressing F12 alternatively CTRL + SHIFT + I or Access it by using three dots menu on the right side:Menu->More tools->Developer tools… Read More »

How to Add Folder in Nova Launcher

By | May 26, 2017

Nova Launcher is the highly customizable, performance driven, home screen. It replaces your home screen with one you control and can customize. This launcher allows you to change icons, layouts, animations and more. It can be downloaded fromGoogle Play Store The common problem users seems to have is adding new folders. Nova has this functionality hidden deep in… Read More »

Cleanup local Git from deleted remote branches

By | January 9, 2017

When working with Git after some time local repository has excess branches which create a mess. There is an easy way to remove branches from local repo that were deleted from remote. Before Git 1.6.6 Two steps are needed: fetch and prune

your_remote – for example origin Git 1.6.6 and above This version introduced command that combines… Read More »

Git – Create New Branch From Existing Branch

By | March 10, 2017

To create a new branch from existing one you first have to checkout new branch locally, then push it to remote so other can see it. Below are the exact commands. Create new branch from existing branch locally git checkout -b {NEW_branch_name} {SOURCE_branch_name} Specifying -b causes a new branch to be created Push changes to origin git push origin {NEW_branch_name}