Excel Statistics

Excel Statistics Training in NYC

The best decisions in business are those that are backed up by data.

Learn how to use statistics in Excel to analyze trends, calculate probability, and accurately forecast results to help you make better decisions.

  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Class 

tag-solid Call for pricing clock-solid 7 Hours display-solid Mac or PC provided help-line map-marker-solid 185 Madison Avenue, NYC users-solid In-person classroom training

Corporate & private training available

Email us for information

What you'll learn

  • Statistical & Ranking Functions
  • Statistical Analysis
  • Charts
  • Probability and Forecast Modelling

Full Course Syllabus

Download PDF Outline

Basic Statistics

Statistical Functions

  • These foundational statistical functions can be used to perform basic caluclations on ranges of values

Ranking Functions

  • Rank values to establish percentages and percentiles

Data Analysis Toolpack

  • Quickly and easily perform statistical calculations with the Data Analysis Toolpack add-in

Statistical Analysis

Descriptive Statistics

  • Compare two sets of data by 16 different, statistical measures

t tests

  • Calculates whether the means of two groups are statistically different from each other

Straight Line Analysis

  • Graphically estimate the relationship between two variables

Simple Linear Regrssion

  • Estimate the relationship between two variables

Multiple Regression

  • Estimate the relationship between more than two variables

Charts

Histogram

  • Divide values into intervals and represent the frequency of data values in each interval with a bar

Waterfall chart

  • Visually display how an intitial value is affected by a series of positive and negative values

Probability and Forecast Modelling

POISSON Distribution

  • Calculate the probability of a given number of events occurring in a fixed interval of time or space

Solver

  • Calculate optimal solutions to multi-variable decision problems

Monte Carlo simulation

  • Better understand the impact of risk and uncertainty in forecasting models

Resampling

  • Make statistical inferences from data by sampling with replacement
help-solid

Frequently Asked Questions

  • Do I need to bring a computer?

    No. We provide a computer with the necessary software for each attendee. Choose a Mac or a PC during the checkout process.

  • Are discounts available for this course?

    No. This course is not eligible for any discounts.

    We offer discounts for packages of classes, including our Excel Bootcamp, SQL Bootcamp, Data Analytics, and PowerPoint Bootcamp.

    We also provide discounts for ten or more classes purchased together. Please reach out for more information on our voucher programs.

  • Does this course come with a book?

    Yes. This course includes a complimentary book or manual at no additional cost.

  • What if I need to retake this course? May I retake it for free?

    Yes. You may retake this course for free once within six months, provided that the class is running with an available seat. For more information, visit our policies page.