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...
Tagged: data analysis
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...
How to Sort Data Horizontally in Excel
When you have your data arranged in a horizontal table instead of a vertical table, you may need to sort your data horizontally instead of...
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...
Data Analysis With Pivot Table Part – 2/2
(This is the second part of Data Analysis With Pivot Table Part – 1/2 post) You can also customize your pivot tables with custom...
