http://jones.adobeconnect.com/excel/ Session 7 - Statistical Functions   • Excel Add-in – Analysis ToolPak   • Name Ranges   • INDIRE...">
Loading

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

by El Paso Finance Center

Workshop

Thu, 15 Mar 2018

7:00 PM – 8:30 PM

Add to Calendar

218

6100 Main Street, Houston, TX 77005, United States

View Map
8
Tickets sold

Tickets

Description

Session Link: http://jones.adobeconnect.com/excel/

Session 7 - Statistical Functions
  • 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

Session 8 - Finance Functions & Advanced Math – Solver & Optimization
  • 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



Share with friends

Where

218

6100 Main Street, Houston, TX 77005, United States

Hosted By

El Paso Finance Center

Contact the organizers