Excel 2016 tutorial on how to have Excel treat a part of your worksheet as a separate datasheet by converting that range of cells into a table.
18th Aug 2017
Excel 2016 tutorial how to work with single and multi-cell arrays, and they're used to do multiple calculations on a group or range of cells, known as an array, simultaneously.
17th Aug 2017
Excel 2016 tutorial on the LOOKUP function that will look in one row, or column range, or vector range, for a value and a return value from the same position in one row or column.
14th Aug 2017
Excel 2016 tutorial on how to assign your own name to a cell, or range of cells. This can be very helpful when using a familiar name of a cell, or range of cells instead of Excel's default names, and also these names are links that when selected will take you right to that named cell, or range of cells; additionally these names you assign can also be used in formulas too! …
1st Aug 2017
Excel 2016 tutorial on how to set a cell, or range of cells as a print area that will be the only part of your spreadsheet that prints, and how to scale down you font size to allow more to fit onto your printed page prior to printing in this Excel 2016 training video. …
24th Jul 2017