Array, Vlookup(), Macro, Indirect(), Rows, Columns, Ranges, Tables, Add-ins, If functions, Developer tab, Conditional Formatting, Power Pivot, Pivot table, Value Field Settings, Column chart, Slicers, Sparklines, Absolute references, Relative references, F4, Eomonth(), Networkdays(), Power Query, Today (), Now(), Secondary Axis, Freeze Panes, Window, View, Arrange All, Hide, Gridlines, Print Area, Print Titles, Functions, Sumifs(), Countifs(), Datedif(), Merge and centre, Scaling, Row and column headings, GetPivotData, Index(), Match(), Iferror(), Concatenate, PMT(), Ceiling(), Round()