Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...

There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets. Fortunately there a couple of ways you can combine multiple ...

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Each IF function in an Excel spreadsheet returns one of two messages. The first -- the "if" message -- displays if cells meet criteria that you specify. The second -- the "otherwise" message -- ...

How to calculate conditional running totals in an Excel revenue sheet Your email has been sent Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a ...

The open source community has created many open source Java projects, which range from charting software to game frameworks to word processors. In this post, I introduce an open source library project ...

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.