Introduction to Excel IV - Session 7 (Statistical Functions) & Session 8 (Finance & Advance Math)

<b> Session Link:</b> <a href=""> http://jones.adobeconnect.com/excel/ </a href="">

<b> Session 7 - Statistical Functions </b>
┬á • Excel Add-in – Analysis ToolPak
┬á • Name Ranges
┬á • INDIRECT
┬á • VAR.P, VAR.S, STDEV.P, STDEV.S
┬á • COVAR.P, COVAR.S
┬á • CORREL
┬á • MIN, MAX, MEDIAN, MODE, AVERAGE
┬á • TREND

<b> Session 8 - Finance Functions & Advanced Math – Solver & Optimization </b>
┬á • PV
┬á • NPV
┬á • PMT
┬á • IRR
┬á • SUMPRODUCT
┬á • MMULT
┬á • Solver

File Attachments: Data Analysis & Finance_Practice.xlsx, Data Analysis & Finance_Solutions.xlsx, Excel Data Analysis Cheatsheet.docx, Mini Case - Managing Parents Portfolio.docx

El Paso Finance Center | Website | View More Events

Contact the organizers