Suitable for

• Students that have the skills covered in our Excel fundamentals, Understand formulas and Work with functions workshops
• Students who wish to use the Excel Analysis Tools to analyse data

Look through the workshop objectives to ensure that this workshop is appropriate for your needs and abilities.  

Workshop objectives

By the end of the workshop your will be able to:

• Load the Analysis ToolPak
• Use of the Descriptive Statistics tool
• Use of the Regression Analysis tool
• Use of the t-Test: Paired Two Sample for Means tool
• Use of the t-Test: Two Sample Assuming Equals Variances tool
• Use of the ANOVA: Single Factor tool
• Create a histogram and frequency table
• Format a histogram
• Change horizontal axis labels

Course material

If you cannot attend the workshop this workbook covers all the topics listed above. The instructions for downloading the exercise files can be found on inside front cover of the workbook.