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 ...

In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have if ...

Q. I would like to add some color to my Excel workbooks. What are some ways of doing that? A. There are several ways to add color to your Excel workbooks. Some reasons you may want to do this are to ...

SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet" button ...

When you’re running a business, you have to pay close attention to the numbers. Customer traffic, orders, profits and losses — all of these numbers are crucial to your business. That’s why it’s ...

Let’s talk about formatting shortcuts in Excel. Say you need to format several areas quickly. These six Excel hacks show how to do the job in a tenth of the time it would usually take. Shaun from ...

I'm making an accounting workbook with the following criteria: In the first sheet called "Account", all the transactions will be listed on table that goes from C6-H6, and on down for every entry. One ...

Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...