Quantitative Leveling

by El Paso Finance Center

Workshop

Thu, Jul 13, 2017

6:30 PM – 8:30 PM

Add to Calendar

Synchronous / Online Session - Link will be provided via email.

1900 Rice Boulevard, Houston, TX 77005, United States

View Map
26
Registered

Registration

Details

Using mini-cases, the session will cover some business math, summary statistics, and core Excel functions and features including:

Setup & Basic Math Functions, Short Cuts
o (), ^, *, /, +, -
o F2 ´âá <Type> ´âá Tab
o ATL
o Formula Checking
o Cell Locking F4
o AutoComplete
o CTRL+Z
o CTRL+C, CTRL+V, CTRL+ALT+V
o CTRL+SHIFT+arrow
o CTRL+R, CTRL+D

Statistical Functions
o Excel Add-in – Analysis ToolPak
o VAR.P, VAR.S, STDEV.P, STDEV.S
o COVAR.P, COVAR.S
o CORREL
o MIN, MAX, MEDIAN, MODE, AVERAGE

Where

Synchronous / Online Session - Link will be provided via email.

1900 Rice Boulevard, Houston, TX 77005, United States

Hosted By

El Paso Finance Center | Website | View More Events

Contact the organizers