Pictures in Excel reports:
This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.
This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes.
I will share what I have learnt about delivering high-impact demos
Estimated reading time 7 min.
Continue reading Demo Warriors: Power Query and Power BI best practices
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can be an even better solution. Estimated reading time 7 min
Continue reading Power Pivot Month Sorting using Time Table – Part 3
Here is the Power Pivot way of customizing sort order for any table.
Read the previous article first.
Estimated reading time 8 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 2
||If you use text month in a Power Pivot Table, it is sorted in alphabetical order.
Here is the solution to the problem.
Quick Solution time 2 min
Detailed reading time 15 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 1
||Excel 2013 Professional edition contains two very powerful add-ins – Power Pivot and Power View.
Unfortunately, most users who need these features do not even see these in their ribbon. Activate them NOW!
Estimated reading time 6 min
Continue reading Can you see Power Pivot and Power View in Excel 2013?
Data Analysis and Reports has been a major theme for my articles so far.
Here is a collection of 50+ articles, categorized and sorted in the recommended reading order.
Continue reading Knowledge Pack: Data Analytics