Month: October 2018
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.
The Smallman is here with some great Dashboard and Data Visualization tools for 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”