Have you ever asked yourself any of these Excel questions:

1. How do I fill empty spaces on a table with the content above?
2. Is there a way to automatically expand the source for a dropdown list, formula or PivotTable?
3. How can I quickly see the overall trend of a series of data points?
4. It is possible to change the title of a graph based on the contents of a cell?

I provided the answer to these and 8 additional questions in a guest post I created for the blog of www.investintech.com. The post is titled “Top Excel Tips for Data Analysts” and provides useful tips that you can use throughout all the stages of data analysis: Cleaning Analysis Visualization.

The links to the individual tips are included below:

TIPS FOR DATA CLEANING

TIPS FOR DATA ANALYSIS

TIPS FOR DATA VISUALIZATION

Click below to see the whole article or use the links above to go to a specific section
12 Top Excel Tips for Data Analysts