Excel Survival Skills

<big><center><b> Excel Survival Skills </big></center></b>

<b> File Link: </b> <u> https://www.dropbox.com/sh/pfxobvsvvws425r/AAA1rCDjUnGNEYA6hDfuFRN2a?dl=0 </u>

<ahref="https://www.dropbox.com/sh/pfxobvsvvws425r/AAA1rCDjUnGNEYA6hDfuFRN2a?dl=0 /">Dropbox</a>

<b> Component One – Core Math (Computations and Algebra) Total Time: 1.5 Hours </b>

Topics Covered:

• Order of Operations
<p style="margin-left: 40px"> o PEMDAS
o Power, Exponents, and Logs </p>
• Solving Equations
• Graphing Equations
<p style="margin-left: 40px">o Use Excel to Graph </p>
• Derivatives for Business
• Basic Data Manipulation
<p style="margin-left: 40px">o Moving Data into Excel
Sorting, Filtering </p>
• Cell Referencing & Formatting
<p style="margin-left: 40px">o Absolute References </p>
• Commonly Used Excel Functions
<p style="margin-left: 40px">o SUMIF
o MAX, MIN, IF, & COUNTIF
o VLOOKUP, HLOOKUP </p>
• Finding and tracing formulas
<p style="margin-left: 40px">o CTRL + ~, tracing dependents </p>

<u> Session Breakdown: </u>
• 10-20 Minutes Review of Topics
• 20-30 Minutes Instructor-Led Examples in Excel – Baseball Hitting
• 20-30 Minutes Student Examples in Excel
• 10-20 Minutes Open Q&A

<i> Files:
1) Excel Session Overview (Excel)
2) Baseball Hitting – Instructor Led (Excel)
3) Baseball Pitching – Student Practice (Excel) </i>

<b> Component Two – Basic Statistics (Variables, Relationships, and Distributions) Total Time: 1.5 Hours </b>

Topics Covered:
• Mean, Median, Mode, Min, Max, Count
• Variance, Standard Deviation
• Correlations
• Covariance
• Distributions

<u>Session Breakdown:</u>
• 10-20 Minutes Review of Topics
• 20-30 Minutes Instructor-Led Examples in Excel – Tuition vs. Rank
• 20-30 Minutes Student Examples in Excel – Rank vs. GMAT
• 10-20 Minutes Open Q&A

<i>Files:
1) Types of Distributions (Word)
2) MBA Program Comparison (Excel)
3) Other Examples– Further Practice (Excel) </i>

https://www.dropbox.com/sh/pfxobvsvvws425r/AAA1rCDjUnGNEYA6hDfuFRN2a?dl=0

El Paso Finance Center | Website | View More Events

Contact the organizers