Create Pivot Table from Multiple Datasets in Excel
Everyday Office shows you how to use Tables and Relationships to create pivot tables from multiple datasets in Excel.
Can Excel Handle 10 Million Rows?
Access Analytic tests the limits of Excel by creating 10 Million Rows of Data. Can Excel handle it?
Dates for the Start and End of the Week in Power Query
Excel Unplugged shows you how Power Query can easily give you the dates for the start and end of each week.
Individual Data Points in Scatter Plots for Excel
Able Bits shares some best practices for working with individual data points in scatter plots.
You Can Pivot This or You Can Pivot That
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
Excel Custom Icons for Conditional Formatting
Andrew Excel shows you how to create custom icon sets for conditional formatting.
Improving Stacked Bar Charts in Excel
Depict Data Studio has some great advice on making your stacked bar charts easier to understand!
15 Must-Know Excel Shortcuts
Spreadsheets Made Easy shows you some Must-Know shortcuts in Excel!
Dynamic Images in Excel
Leila Gharani shows you how to create dynamic pictures that will update automatically.
Transpose Function in Excel
Hot Key Excellence explains the Transpose function.
Blanks vs Nulls in Power Query
Excel Guru talks about the difference between blanks and nulls in Power Query.
Excel Macro Button With Arguments
Excel Off the Grid shows you how to use macro buttons with arguments.