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.

This course is available for private and corporate training. Email or call us for more information. For regularly scheduled courses, see all our Excel classes in NYC.

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

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we'll work with you to ensure your setup is perfect.

Classes are activity-based and taught by a live instructor.

You can hear the instruction, ask questions, and share your screen—all in real-time.

Retake the course for free (in-person or live online) within one year.

See What Students Are Saying About Live Online

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

Frequently Asked Questions

Does this course require any prior knowledge or experience?

Students must be comfortable using a computer. No other prior knowledge is required.

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.

Can I take this course online (remote learning)?

You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?

Students can attend this training remotely through screen sharing software (we use Zoom).
Participants can hear the instruction, ask questions, and even share their screen with the instructor.
For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!

What if I don’t have the software on my computer?

Upon registration, please email contact@nyimtraining.com and we will help you get set up with the software or anything else needed for an optimal training experience.

Corporate & Onsite Excel Statistics Training

For over two decades, NYIM Training has created and delivered the highest-rated corporate training programs in New York. We have extensive experience developing curriculum for a variety of training sessions, both onsite and in our Midtown offices. Our program can be completely customized to suit your training needs.

What you'll learn

Workbook Included

Computer Provided

Small In-Person Classes

Free Retake