Office Q&A: Excel referencing, Word field codes, and a table trick Your email has been sent It’s been a month of easy answers for the most part. The problems seem big, but as usual, there’s an easy ...

You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of your worksheet. The sum of a column of zeros ...

Whether you're interviewing for an Excel-related job or teaching a beginner, using the right terminology is crucial. Above all else, knowing the difference between a range and an array is the key to ...

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting. Excel offers numerous ways to ...