www.excelrange.com

Microsoft Excel’s styling capabilities have improved over the time. But there are still lackings on some areas. One thing I personally miss is the ability to attach styles to Pivot table items. For example you have in one table the sums of revenues and sums of quantities – and you wish the revenues to be formatted differently. Of course, you can manually change the formatting of each revenue cell, but this is not a very modern way to handle it – considering we use styles for such formatting tasks in MS Office and other programs nowadays.

I have a little tip for those of you who face the same problem – you can still attach different color to different Pivot table items. Read more…

Excel cell format, data visualization, Pivot table, time saving

Here is one tip for improving the readability of larger data tables – use in-cell graphics. This is based on using ordinary characters as graphic elements. It is possible to repeat the characters using Excel REPT() function. Read more…

Excel charting, data visualization, formulas, function

Excel has built-in data tables and charts. There are situations when you have a large nicely formatted table and you just need to add there little diagrams to envision the trend. Regular charts are too uncomfortable to use, because you would have to give up all the formatting of the excisting data table and create everything anew in the chart. The solution is to use sparklines charts. Read more…

Excel charting, data visualization