Drawing meaningful conclusions from data. Includes interpretation, dashboard creation, and data manipulation.
Make sense of unstructured data with enough precision to put it on a map.
Dynamically load data in smart pivot tables.
Effectively utilize conditionals such as IF statements in your Excel workflow.
Dealing With Dirty Data in Excel (continued).
Cleaning data Excel in the absence of tools designed to do so.
Taking a step back to reflect on the problems Excel intends to solve.
Power up your Excel Pivot Tables with these pro moves.
Unlock the secrets of Excel's Index Match.
Square one of cleaning your Pandas Dataframes: dropping empty or problematic data.