Basic Microsoft Excel tutorials

Deselect with the CTRL key in Excel

Deselect with the CTRL key in Excel
Posted by Chris Menard on 12/27/2017

The CTRL key is used to select non-adjacent ranges which is a handy feature for charts and summing ranges. You can now deselect with the CTRL key. Huge improvement in Excel.

Use absolute reference in Excel to keep a cell constant when you copy or autofill

Use absolute reference in Excel to keep a cell constant when you copy or autofill
Posted by Chris Menard on 03/24/2017

If you need a cell to stay constant, you can make it an absolute reference cell to stay constant. Press the F4 function key to create an absolute reference.

Use the COUNTIF function in Microsoft Excel

Use the COUNTIF function in Microsoft Excel
Posted by Chris Menard on 12/28/2016

The Countif function in Excel is one of the top 10 functions to know. You can use Countif for text, numbers, greater than, and other criteria.