About this document

Excel 2013: Defined Names & Functions by sarav10 is a document available to read on EtoBox.

1) The document discusses videos about Excel functions including defined names, aggregate functions, calculations with multiple criteria using AND, BETWEEN, OR criteria, IF and IS functions, rounding functions, and the SUMPRODUCT function. 2) It provides examples of using functions like SUMIFS, COUNTIFS, AND, OR with criteria to perform calculations on a table with data like dates, invoice numbers, revenues. 3) A new function introduced in Excel 2010 called AGGREGATE can help avoid errors when performin

Author

sarav10

Language

EN