Index
A
Absolute references
Additional functionality
Advanced Formula Environment (AFE)
add-in
formula creation
Home tab
LAMBDA functions
creation
import from GitHub Gist
management experience
named formulas
Name Manager in Excel
Sync names with Name Manager in Excel
AGGREGATE function
adding criteria
advantages
cell value
in Excel 2010
function_num
ignore error values in the range
ignore hidden rows
list options
sales data
syntax options
Ampersand character
AND and OR functions
AND function
Australian financial year
AVERAGEIFS function
B
BYCOL function
BYROW function
C
#CALC! error
Case of text
CEILING function
CEILING.MATH function
CEILING rounds
Cell F2
Cell references
absolute
definition
making absolute
mixed
relative reference
sheet
workbook
Chart data series
Chart labels
Charts
CHOOSECOLS ...
Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
