Month: October 2018
Access Analytic tests the limits of Excel by creating 10 Million Rows of Data. Can Excel handle it?
Excel Unplugged shows you how Power Query can easily give you the dates for the start and end of each week.
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.