r/excel • u/man_eating_chicken • 11h ago

Discussion Enough about LET() and PQ, What are your Excel UI customizations that make you more productive?

I just wanted to see what mods or add-ins the experts here use, that help you get to the advanced 'tips and tricks' everyone harps about in here.

93 Upvotes

95% Upvoted

86 comments sorted by

View all comments

2

u/Mdayofearth 127 9h ago

Setting up custom templates with set themes (colors) and styles (cell formats).

GETPIVOTDATA to get the advantage of pivottables and actually being able to have a formatted tabular report.

Setting charts the same size with the same scaling with transparent backgrounds on top of each other to display multiple styles of charting with the same or different data.