Everyday Office shows you how to use Tables and Relationships to create pivot tables from multiple datasets in Excel.
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.