Category: Tips and Tricks
Able Bits shares some best practices for working with individual data points in scatter plots.
Combining two of my favorite pastimes, #Excel and #Hiphop . All credit and respect for the music goes to @DresBlacksheep . This is just for fun@msexcel pic.twitter.com/QxyqviIIWK — SpreadsheetAllstars (@StarSpreadsheet) October 9, 2018
Andrew Excel shows you how to create custom icon sets for conditional formatting.
Depict Data Studio has some great advice on making your stacked bar charts easier to understand!
Leila Gharani shows you how to create dynamic pictures that will update automatically.
Excel Guru talks about the difference between blanks and nulls in Power Query.
Excel Off the Grid shows you how to use macro buttons with arguments.
How To Excel shows you how to import/export data between Excel and Sharepoint. This is great for collaborating with many users!
Excel Solutions shares a little known formula that helps you repeat strings – REPT.