Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.

Last issue, I wrote about an Ajax-enabled Web application that has the potential to oust, or at least augment, Outlook. This issue, I have another Ajax Web application that hints at what could be done ...

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

With spreadsheets, you store and analyze sets of data, which is key in many businesses. Spreadsheets offer a range of automated functions to perform calculations on data in addition to building graphs ...

Mac: The "Sum" function in spreadsheets is great, but if you're not the type to do all your list-making in Excel, coder Brett Terpstra built an OS X System Service that allows you to total up any set ...

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

The SEQUENCE part creates a dynamic list of numbers (1, 2, 3...) that corresponds to the row index. For example, in the fifth ...

Spreadsheets are undeniably powerful. They can come in handy for all sorts of applications like tracking and forecasting cash flow, creating loan amortization schedules, analyzing sales data, and even ...

Google, after having swallowed up the web-based word processor Writely, is now poised to deliver an online spreadsheet application to complement it. Is this the next step towards Google ...

Whenever you create a new Excel document, you are opening what is called a "workbook." Each workbook can have multiple worksheets. If your small business sells fruit, you might have an Excel workbook ...