excel add formula arguments Quickly access Excel 2010 formula requirements
Ok.. so you want to use an Excel formula and you know it is, say, SUMIF that you want to use, but what data does it need and where?

Before you go searching through help or cranking up your browser, let Excel do the work for you. Just type =SUMIF in a cell and press Control + Shift + A and Excel will give you the list of data required. It’s dead simple and it saves heaps of time.

 

Helen Bradley

Related posts:

  1. Excel 2003 lists
  2. Excel 2007 makes Lovely Lists
  3. Excel – cell reference in SumIF
  4. Go To a cell in a formula in Excel
  5. 5 Cool Excel 2010 tips and tricks