Tag Archives: tips
How to Convert Date to Weekday Name in Microsoft Excel 2016 ?
Assume that you have a date in a cell “A1” and you wish to display only the Weekday name for example : saturday in one of the cells. How to Convert Date to Weekday Name in Microsoft Excel...
How to quickly delete all hyperlinks from a worksheet in Microsoft Exc...
It might be a time consuming task to delete all the hyperlinks from a worksheet in Excel if the user had to do it manually one by one. How to quickly delete all hyperlinks from a worksheet in Microso...
How to remove Blank or empty rows in Microsoft Excel 2016 ?
You can use the “Go To Special Command” in Microsoft Excel 2016 to remove the blank or empty rows in a worksheet. How to remove Blank or empty rows in Microsoft Excel 2016 ? 1. Open your ...
How to fill Blank Cells with a specific value in Microsoft Excel 2016?...
There are times when you have to fill the blank cells within your worksheet in Microsoft Excel 2016 with the specific value or for ex: 0. How to fill Blank Cells with a specific value in Microsoft Ex...
Changing the background color of a cell based on value in Microsoft Ex...
This blog post will explain how the users can change the background color of a cell based on its value in Microsoft Excel 2016. Assume a scenario where you have a list of students along with their ma...
Useful Keyboard shortcuts in Microsoft Excel 2016 that you must know &...
There are plenty of shortcut keys available in Microsoft Excel that lets you to do few repeated tasks quickly. In the part 1 of the series of the blog post on excel tips and tricks , I list out some ...
C# 7.0 : Pattern Matching
In one of the previous blog post , we saw the Out variables enhancements in C# 7.0. This blog post will explain one of the new features in C# 7.0 called Pattern matching and how developers can levera...