Formula in Excel 2007 / 2003 / 2010 / 2013 / 2016

How to count cells by criteria

How to sum cells by criteria

Basic Formula operators

How to avoid misleading numbers

Using the formula bar as a calculator

Referencing cells outside the worksheet

Shortcut key to switch between relative, absolute and mixed references

Creating and using named ranges

Excel Formula Evaluator

How to insert cell content to the shape