If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how. You don’t have to import an Excel ...

One nice thing about Microsoft Office applications is that they’ve been designed to talk to each other. For example, you can take an Excel chart and place it in a Word document to illustrate a report.

Q. I would like to collaborate with my colleagues on an Excel document and specify the areas where they should focus. What is the best way to do that? A. Many tools are available for collaboration. A ...

Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users click a ...