Skip to main content
Get a Quote
Course Enquiry
Contact Us

Excel for Statistical Analysis Course Details


Excel course for Statistics

Audience:

Any person currently using Excel at an advanced level and needs to use Excel tools to draw statistical analyses on data.

Pre-Requisites:

Proficiency in Excel with evidence of experience in tools from Basic to Advanced. Complete our Basic to Advanced Excel Course if not.

Duration:

2 day

Price:

$436.00 If you are currently resident in South Africa you will need to pay VAT at 14%.

PC Hire:

$50   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About Excel for Statistical Analysis

Course Outline


  • Introducing Excel Tables
    • Simple statistics
    • Sorting
    • AutoFilter
    • Custom AutoFilter
    • Advanced Filtering
  • Cleaning Data
    • Importing into Workbook
    • Move, copy, resize and delete columns and/or rows and/or sheets
    • Format cell contents
    • Clear formatting and cell contents
    • Find and Replace data
    • Cleaning Data with Text Functions
    • Conditional Formatting
  • Working with PivotTables
    • Running the PivotTable Wizard
    • Pivot Table Field Options (right click)
    • Pivot Table Design and Options
  • Building PivotTable Formulas
    • Adding Another Standard Calculation
    • Creating Custom Calculations
    • Using Calculated Fields and Items
    • Reviewing and changing solve order (new sheet)
    • Retrieving Data from a Pivot Table (new sheet)
    • Arguments of the GETPIVOTDATA function
  • Working with PivotCharts
    • Running the PivotChart Wizard
    • Filter data
    • Refresh data
    • Group data
  • Customizing Charts
    • Selecting a Chart Type
    • Working with Chart Styles
    • Changing Chart Layout
    • Changing a Chart’s Location
    • Formatting 3-D Charts
  • Ten Things You Ought to Know about Statistics
    • Descriptive Statistics Are Straightforward
    • Averages Aren’t So Simple Sometimes
    • Standard Deviations Describe Dispersion
    • An Observation Is an Observation
    • A Sample Is a Subset of Values
    • Inferential Statistics Are Cool but Complicated
    • Probability Distribution Functions Aren’t Always Confusing
    • Parameters Aren’t So Complicated
    • Skewness and Kurtosis Describe a Probability Distribution’s Shape
    • Confidence Intervals Seem Complicated at First, but Are Useful
  • Ten Tips for Presenting Table Results & Analyzing Data
    • Work Hard to Import Data
    • Design Information Systems to Produce Rich Data
    • Don’t Forget about Third-Party Sources
    • Just Add It
    • Always Explore Descriptive Statistics
    • Watch for Trends
    • Slicing and Dicing: Cross-Tabulation
    • Chart It, Baby
    • Be Aware of Inferential Statistics
  • Using the Statistics Functions
    • Counting Items in a Data Set
    • Means, Modes, and Medians
    • Finding Values, Ranks, and Percentiles
    • Standard Deviations and Variances
    • Normal Distributions
  • Using the Statistics Functions cont.
    • z-standard deviations
    • t-distributions
    • f-distributions
    • Binomial Distributions
    • Chi-Square Distributions
    • Regression Analysis
    • Correlation
    • Some Really Esoteric Probability Distributions
  • Descriptive Statistics
    • Using the Descriptive Statistics Tool
    • Creating a Histogram
    • Ranking by Percentile
    • Calculating Moving Averages
    • Exponential Smoothing
  • Inferential Statistics
    • Using the t-test Data Analysis Tool
    • Performing z-test Calculations
    • Creating a Scatter Plot
    • Using the Regression Data Analysis Tool
    • Using the Correlation Analysis Tool
    • Using the Covariance Analysis Tool
    • Using the ANOVA Data Analysis Tools
    • Creating an f-test Analysis
    • Using Fourier Analysis
    • Box and Whiskers Chart
    • Pareto Chart
  • Ten Tips for Visually Analyzing and Presenting Data
    • Using the Right Chart Type
    • Using Your Chart Message as the Chart Title
    • Beware of Pie Charts
    • Consider Using Pivot Charts for Small Data Sets
    • Avoiding 3-D Charts
    • Never Use 3-D Pie Charts
    • Be Aware of the Phantom Data Markers
    • Use Logarithmic Scaling
    • Don’t Forget to Experiment
    • Get Tufte

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Scheduled Dates


To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date Duration  
Mon 19 Mar 2018 2 day Book Now
Mon 11 Jun 2018 2 day Book Now
Mon 13 Aug 2018 2 day Book Now
Thu 4 Oct 2018 2 day Book Now
Mon 3 Dec 2018 2 day Book Now