How-To Geek on MSN

Everything You Need to Know About Array Constants in Excel

DefinitionArray Constants Work Differently Than They Used ToUsing Array Constants With Excel FunctionsNaming Array Constants in ExcelPoints to Note When Using Array Constants in ExcelArray constants ...
MUO on MSN

I wish I knew about these two Excel functions before struggling with pivot tables

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's happening and adjust analysis on the fly. If you're also comfortable with ...