||This intermediate course will focus on working with “nested” If- function and LookUp function. We will examine If-analysis feature and will also explore some statistical and text functions like CountA, CountIF, Clean, Trim, and Concatenate. We will look at several options for conditional formatting of your data. And finally, we will review various options for electronic distribution of your Excel files. Pre-requisites: intermediate level of Excel 2007/2010 knowledge or having attended “Formulae & Functions in Excel 2010 (Part II)” class. To register for a class online, go to http://jagaspx.usouthal.edu/semself/logon.aspx?tg=1.