How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.