Power Query: Comments in steps
As you build your file, be sure to rename and comment out each step to keep a clear history of your thought process.
Category: Excel
Excel: PivotChart
To build a graph while cross-referencing data, observe it come to life using the PivotChart.
Multi-selection with CTRL and/or SHIFT
To select multiple items in a list, whether contiguous or not, use the CTRL and SHIFT keys on your keyboard.
Excel: Check Performance
If your Excel file is unusually large or running slower than normal, it’s important to check its performance.
Excel: Scale to fit printing
To adjust the scale of your Excel document for optimal printing, you can modify the sheet size to fit the page width or a specified number of pages.