Most function-key shortcuts also work in Google Sheets, but you may need to enable compatible spreadsheet shortcuts from the Help menu to access some familiar Excel shortcuts.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

To be able to effectively use the SCAN function within Microsoft Excel spreadsheet software, an understanding of its parameters is essential.

Learn how to use the secret hidden Excel FILES function in your Microsoft spreadsheets to easily retrieve file names and metadata ...