Dollar Sign In Excel Cell’s name

The Dollar ($) in Excel formula indicates absolute reference. What does that mean?

It means that the value that immediately succeeds the dollar sign will not change.

In Excel a single cell can be used in 4 different ways:

Let’s take cell B4 as an example:

you can have:

B4

No $ sign this one is relative. It will change if a column/formula that references this column is copied to a different cell.

$B4

If a cell references this column, the "B" will never change bit the "4" will change. Only the "B" is Frozen

B$4

If a cell references this column, The "B" will change but the 4 is frozen. So if you use this in a formula, the 4 is absolute.

$B$4

If a cell references this column, it will NOT change if that cell is copied to a different cell. The whole cell is frozen.

Useful Links:
https://www.ablebits.com/office-addins-blog/2015/11/25/relative-absolute-reference-excel/

VMWARE : Could not open the client device. Check that the device exists…

check that the device exists

If you get this error “VMWARE : Could not open the client device. Check that the device exists and that it is not being used by another program” while trying to connect vsphere client to a CD-ROM try the following:

Run vsphere client as an administrator. Right click on the VSphere client icon and select "Run as Administrator"

That did it for me on Windows 10, hopefully this post will help someone out there.

Using Git on Windows

First

Download git for Windows here : https://git-for-windows.github.io/

Second

Change your "Start in" folder accordingly
set up git for windows

Third (optional)

This step is very important if you change the default location of your Git config file:
Do this step only if you want to change default home that git
for windows pulls from your system.

Add a windows environment for HOME and point it to the 
location of your new home folder.