In the first two parts (part 1 and part 2) of the blog we explored the Show details functionality of a Pivot table in Excel. Now we look at another hidden feature that will help you limit distractions. Whenever you connect to...
Tag - Excel
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about increasing the records retrieved by...
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about Detail Rows Expressions.
Data Types has been part of Excel for some time now, but a lot of people is not familiar with it. You can find them under the Data tab. You might have wondered what they are for? They are built-in datasets about common...