Excel [Excel] Shortcut Collection
Below is a compilation of convenient shortcuts I use on a daily basis.
File Operations
Alt + F2: Save As
Ctrl...
Excel Excel [Excel] Simple Data Lookup Using XLOOKUP and Tables
Introduction
For a long time, VLOOKUP has been a staple Excel function for data lookup and reference. However, its limi...
Excel [Excel] How to Use 3D References for Consolidating Data Across Multiple Sheets
Introduction
In Excel, you may often find yourself needing to consolidate large amounts of data across multiple sheets....
Excel [Excel] How to Exclude Blanks and Errors in Function References
When processing raw data with Excel functions for analysis, the presence of blank cells or errors can lead to incorrec...