Sebastian Expert

Sebastian has more than 16 years experience in the IT industry. Worked as software developer, architect, trainer. His clients were major IT, law and medical companies.
He likes writing about any concept precisely and concisely hoping it will help someone in their work or private life.

Author Archives: Sebastian Expert

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 »

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}

[Solved] Add, Attach or Insert A File in Excel 2013/2016 in 3 Easy Steps

By | November 20, 2017

This article will show you how to easily add/attach file like PDF, Word or any other to Excel 2013/2016 spreadsheet. Go to INSERT tab Click Object button or in case of smaller Excel 2013 window or any size Excel 2016 window: Click Create from file and browse for the file. Checking Link to file will cause file not… Read More »