Microsoft Excel 2003 is a powerful tool that business owners can use to craft presentations for clients, employees and business partners. The program allows you to take a large amount of data and use ...

Microsoft's Office suite of desktop publishing software includes several applications that facilitate customer management, including Word, PowerPoint and Excel. Small businesses commonly use the Excel ...

If you're tired of repeated calculations, hard-to-read formulas, and sluggish Excel worksheets, the LET function is your ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

I'm using Excel 2003 and I want to compare two spreadsheets side by side, but I want them in seperate windows, not tiled like the Side-by-Side option gives you. I'm using two monitors and I want each ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel. Weekends and holidays are important to most of us. Besides enjoying the ...

Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...