Tagged: data analysis

List Unique Values In A Column

Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it...

Pivot Table ToolPack

If you are using Excel daily for data analysis and reporting, you need to know how to use pivot table effectively. Therefore I prepared a...

Using Data Form

Excel has a pretty unknown tool for data input assistance named Data Form. Here is how to benefit from this tool…

Power Pivot

Power Pivot takes the power of relational database queries to your desktop. Only requirement is Excel 2010 or 2013. And knowing how to use it...