Microsoft Office brings support for Visual Basic for Applications (VBA) macros back to the Mac. But if you haven’t used VBA before, you might be wondering what you can actually use it for and how ...

In this video, you'll learn how to insert a search bar into your worksheet so that you can quickly search large data sets for any value. You'll be able to type anything into the search bar, and all ...

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business. In just a few minutes, you can ...

There are several ways to create maps in Microsoft Excel 2007. While you can always paste map images into a worksheet or even draw your own maps using the shape and line tools, most businesses need ...

If you have a number of Microsoft Excel worksheets that contain related data, you’ll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...

Convert your daily General Journal data into a more extensive, yet focused, General Ledger using Excel in this tip from Mary Ann Richardson. Many businesses keep a journal of their daily transactions, ...