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

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 | November 23, 2016

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} 4.6

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

By | November 16, 2016

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 »

Git – Delete Both Local and Remote Branch

By | September 30, 2016

Deleting branches in Git is something done frequently, especially in GitFlow. Here are commands to delete local and remote branches. Remove a local branch from your machine git branch -d {the_local_branch_name} (use -D instead to force deletion, without checking merged status) Remove a remote branch from the server git push origin --delete {the_remote_branch_name} 4.5

Import iCalendar ICS or vCalendar VCS files to Outlook

By | August 2, 2016

Steps below will show how to import iCalendar (.ics) or vCalendar (.vcs) file into Outlook. Go to File tab Click Open & Export tab, next in main window click Import/Export button In Import and Export Wizard select Import an iCalendar (.ics) or vCalendar file (.vcs) option Now you can choose if you want to Import or Open as… Read More »

Solve: This value doesn’t match the data validation restrictions defined for this cell

By | June 10, 2016

When you try to input some value in a cell and you get an error message in Excel 2016: or in Excel 2013: This means that someone has set Data Validation on that cell. To view its configuration and remove if needed follow these steps: Select cell and go to Data -> Data Validation Depending on the size… Read More »

Could not find USBtiny device (0x2341/0x49)

By | June 1, 2016

If you get above error message while trying to burn new bootloader to your Arduino board in Arduino Studio follow those steps to resolve it. Make sure that Programmer option is set to Arduino as ISPNOT as ArduinoISP. Also verify if the port is correct. Now you can select Tools / Burn Bootloader