Statistical Formulas for Excel Data Analysis

Add a variety of statistics to your spreadsheets using Excel’s statistical formulas.  Whether you need to find the average of a product’s sales or a count of certain items, this course will teach you all the functions needed to automatically calculate these values.  Take the next step in your career and improve your data analysis techniques.

You will learn how to: 

●     Use the SUMIF, COUNTIF, and AVERAGEIF functions for basic, statistical calculations

●     Reference cell values for criteria

●     Handle multiple conditions within the formulas

●     Utilize wildcards to dynamically match data

●     Implement the SUMPRODUCT function

●     Combine SUMPRODUCT with arrays and other statistical formulas