Excel: PivotChart
To build a graph while cross-referencing data, observe it come to life using the PivotChart.
Category: Excel
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.
Power Query: Import queries without leaving the editor
In Power Query, you forgot to select certain tables from a source? Don’t leave the editor, use recent sources.