The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how ...

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.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

How to Use .NET Class Library in Excel VBA. Your business's software developers can work with Microsoft's .NET framework to create powerful Excel macros for your spreadsheets. The .NET framework ...

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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