Purpose: make advanced mathematical ideas and methods accessible for non experts.
Tool: replace commonly used, and for most people horrifying formulas with a more accessible shorthand writing convention based on Excel formulas and range naming. The only obstacle in the way of doing this is the commonly held belief, that the cell coordinates and dollar signs based referencing convention is the only possible one in Excel. Which is not the case. Range naming is an alternative, and this method lends itself as a bridge between natural language and mathematical operations.
For the easiest possible understanding nested formulas should be written as outlined lists, rather than using nested brackets.
Target group: people, who are not math experts, but are familiar with Excel.
History: present mathematical shorthand convention (formulas used in school and math books) dates back to several hundred years, when computers did not exist. This old convention has become obsolete for now.
Example: portfolio variance in the new notation looks like this:
Portfolio variance =
MMULT
_MMULT
__TRANSPOSE
___portfolio_weights
__covariance_matrix
_portfolio_weights
Confer this with with the conventional formula in the Wikipedia article on Modern Portfolio Theory
