Three Essential Excel Skills Many people don't use or aren't aware of some of the key Excel concepts essential to being a good data analyst. There are Tables, Get & Transform (Power Query), and Pivot Tables. Let's start with Tables.