Does your company do business in more than one state or country? If so, here's an Excel tip that makes it easy to display important data organized by location. Every self-respecting Excel user knows ...

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I need to map our ...

Many financial systems do a fine job of generating standard reports, but accountants often need more. In those cases, accountants can create custom solutions in Excel, but that approach has drawbacks.

One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...

When you compile data in a list, you often need to answer questions such as “How much revenue did the West Coast office generate last month?” or “What was the average number of customers served at ...

One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data. Excel has several features that ...