Tables Syllabus

Tables

This course covers Tables and consists of 11 topics.

Worksheet Templates – This video shows that if you need a worksheet for each state set up in an identical format, how to easily use worksheet templates to set up the 50 needed worksheets.
Three Dimensional Formula – This video shows how three dimensional formulas can be used to sum data across worksheets.
Paste Special – This video shows how the Paste Special Menu can be used to transpose data and divide “spread out cells” in a worksheet by 100
Tables Introduction – This video shows how making data a Table ensures that formulas update automatically when new data is added.
Table Graphs – In this video we show how making data a Table ensures that charts update automatically when new data is added.
Table Slicers – In this video we show how slicers can be used to “slice and dice” the data in Tables.
Table Extended – In this video we show how tables make drop down boxes, VLOOKUPS, SUMIF formulas and NPV calculations automatically update when new data is added.
Aggregate Function With Slicers – In this video we show how the AGGREGATE function is needed to ensure calculations based on Table Slicers are correct.
Conditional Formatting Tables – In this video we show how to make Conditional Formats based on Formulas update automatically when new data is added.
Copying Formulas Across Tables – This video shows how copying formulas across a table can be tricky.
Vignere Code – In this video we use VLOOKUP, ROW(), CHAR, MOD functions and the Table feature to encode and decode messages using the Vignere Code.
Learn More