Introduction to Excel II - Session 3 (Cleaning Data) & Session 4 (Logic Functions)

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

<b> Session 3 - Cleaning Data </b>
┬á • Text to Columns
┬á • TRIM
┬á • SUBSTITUTE
┬á • VALUE
┬á • TEXT
┬á • LEFT, RIGHT, & LEN
┬á • FIND
┬á • PROPER, UPPER, LOWER
┬á • CONCATENATE, &
┬á • Grouping

Session 4 - Logic Functions
┬á • IF
┬á • IFERROR
┬á • COUNTIF, COUNTIFs
┬á • SUMIF, SUMIFS
┬á • What If Analysis
┬á Ôùª Goal Seek
┬á Ôùª Data Tables
┬á • Data Validation

File Attachments: Cleaning Data.xlsx, Logic Functions.xlsx

El Paso Finance Center | Website | View More Events

Contact the organizers