Advanced Excel for Data Analysis

Streamline your number crunching process and conduct more in-depth analysis with sophisticated techniques. Minimize manual labor, save time and perform more detailed analysis quickly. Develop more efficient ways to apply commonly used formulas. Discover often overlooked Excel formulas. Analyze data using functions such as pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis. Enhance your spreadsheets with data validation techniques, automation of alternate row shading and much more! Increase your Excel efficiency up to 75%.

Prerequisite: Intermediate proficiency using Excel.
Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Mac applications may not be as effective.

“Great class. Overall a very informative and thorough class.”—Anthony Achocki