Scrape Website Data into Excel with VBA
My Online Training Hub shows you how to use Excel VBA to scrape data from websites.
SUM on Dynamic Range in Excel
Excel Exercise shows you how to create a SUM formula that has a dynamic range, which you can adjust with a dropdown menu.
Happy Spreadsheet Day!
Happy Spreadsheet Day!
Excel Charts vs Power BI
Power Pivot Pro shares some examples of charts/dashboards in Excel and Power BI
Highlight Duplicates in Excel
Reddit to the rescue! u/finickyone helps provide a solution to highlight duplicates in Excel.
Find and Remove Unwanted External Links in Excel
The Spreadsheet Guru shows you how to find and remove those pesky external links from your Excel workbooks!
Random Samples in Excel with Power Query
Chandoo shows you how to use Power Query to generate random samples of data.
Shortcuts for Page Layout and Printing in Excel
Hot Key Excellence shares some shortcuts for setting up your page layouts and printing in Excel.
Excel Dashboard and Data Visualization Tools
The Smallman is here with some great Dashboard and Data Visualization tools for Excel!
Excel Power Pivot Introduction!
Excel is Fun gives you a great introduction to Power Pivot in Excel!
Consolidate Excel Worksheets Using VBA
Dinesh Kumar Takyar shows how to consolidate multiple Excel worksheets using VBA.
Sorting and Unsorting in Excel
Leila Gharani shows several methods of Sorting, as well as a tip on how to set up your data to allow “Unsorting”