12 Top Excel Tips for Data Analysts
Go to Master Data Analysis Have you ever asked yourself any of these Excel questions: How do I fill empty spaces on a table with the content above? Is there a way to automatically expand the source for a dropdown list, formula or PivotTable? How can I quickly see the overall trend of a series […]
How to work with drop down lists in MS Excel
Go to Master Data Analysis Have you ever wanted to create a drop down list in Excel to avoid data entry errors or to make the data entry process easier? In this post I’ll cover a whole range of tips on how to work with drop down lists in Excel including: How to create/modify drop down […]
10 great examples to master date functions in Excel (Part 1)
Go to Master Data Analysis There are many ways of working with dates in Excel. In this first part I’ll cover 5 out of 10 great examples to help you master date functions in Excel. Before getting started we need to understand how Excel deals with dates. If you type any date in Excel, for […]