Category: Tips and Tricks
Excel Exercise shows you how to create a SUM formula that has a dynamic range, which you can adjust with a dropdown menu.
Power Pivot Pro shares some examples of charts/dashboards in Excel and Power BI
Reddit to the rescue! u/finickyone helps provide a solution to highlight duplicates in Excel.
The Spreadsheet Guru shows you how to find and remove those pesky external links from your Excel workbooks!
Chandoo shows you how to use Power Query to generate random samples of data.
Hot Key Excellence shares some shortcuts for setting up your page layouts and printing in Excel.
Excel is Fun gives you a great introduction to Power Pivot in Excel!
Dinesh Kumar Takyar shows how to consolidate multiple Excel worksheets using VBA.
Leila Gharani shows several methods of Sorting, as well as a tip on how to set up your data to allow “Unsorting”
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?