A data analyst gathers, cleans, models, analyses, and interprets data.

Here's my list of what I know are the top Excel functions for data analysts.

As a bonus I also tell you the functions that you don't need to worry about learning so much.

Sparklines are small charts that fit inside individual cells.

They can reveal patterns in data sets in a concise and highly visual way.

Sparklines can show trends in data or highlight maximum and minimum values.

Opens the Save As dialog so you can save your workbook with a different name and/or in a different location.