Absolute vs$.$ Relative Cell References: know what they mean, why$/$when they are used, and how to use them.

Data Validation: You will be asked to put specific data validations for one or more cells.

Point$-$In$-$Time analysis $($remember the example, you were in London as of $09/01/2019$; that means you

arrived before $09/01/2019$ AND left either after $09/01/2019$ or you never left$)$ and how to translate point$-$in$-$

time into a formula.

How to perform conditional formatting of cells.

How to create Excel Tables from a range of data

The advantages of using Excel Tables

Data Analysis Lifecycle $($Data collection, data analysis, reporting and visualization$).$

What is data integrity$/$accuracy$?$ Why is it important? How is it accomplished.