Intro Course Spreadsheet and Statistics Training

Live Online & Classroom Enterprise Training

Looking for a private batch ?

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Intro Course Spreadsheet and Statistics Training about?

This course is ideal for anyone interested in building their professional toolkit and growing their career with hard skills such as:

Understanding the anatomy of a spreadsheet

Using formulas to automate manual processes.

The ability to work with data sets in Google Sheets

Knowing which data matters when answering a business question

Identifying the level of importance to assign to your results.

What are the objectives of Intro Course Spreadsheet and Statistics Training ?

Master the basics of data analysis in Google Sheets with formatting, formulas, calculations, and charts.

Prepare data by importing from disparate sources and reducing noise with data cleaning tactics.

Evaluate the quality of your data and how to best use it.

Utilize out-of-box statistical visualizations to aid in your exploratory data analysis.

Who is Intro Course Spreadsheet and Statistics Training for?

Anyone who want to take career Forword in spreadsheets and statistics.

What are the prerequisites for Intro Course Spreadsheet and Statistics Training?

None

Available Training Modes

Live Online Training

160 Hours

Self-Paced Training

50 Hours

Course Outline Expand All

Expand All

Module 1- Introduction to Spreadsheets

The anatomy of a spreadsheet

Applying basic formatting to data to improve readability.

Manipulating data using rows, columns, and ranges

Using Formulas and calculations

Creating charts in Google Sheets and using spreadsheets to communicate insights.

Module 2- Data Preparation

The importance of data preparation for effective data analysis

Importing data from different sources

Working with datasets in Google Sheets

Raw data characteristics and common issues Data cleaning

Using pivot tables to summarize data.

Creating dashboards in Google Sheets

Module 3- Statistics Fundamentals

Mean, median, and mode definitions and finding them in Google Sheets

Visualizing the mean in a chart

Identifying min, max, and range of a data set

Methods for inspecting data.

Using and interpreting bar charts, line charts, and histograms

Module 4- Exploratory Data Analysis

Identifying patterns of data distribution

Skew, distribution, and percentiles Calculating variance.

Calculating standard deviation

Calculating z-score and interpreting it visually

Creating and interpreting scatterplots

Who is the instructor for this training?

The trainer for this Intro Course Spreadsheet and Statistics Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree