This video is essentially an introduction to subsequent videos which can be found on our Videos page. Range names are used to define a cell, table, row or column within Excel. They are an alternative to Excel's basic "A1" row/column system of referencing.
Data validation is a tool that derives its name from its ability to control or validate data being entered in cells. However, it is also very useful for creating dropdown lists that can save you time when typing.
IF, SUMIF and VLOOKUPs are some of the most commonly used functions for creating formulas in Excel. They are essentially logical tests which can be used widely, especially when creating new spreadsheets.