Pricing
Book a Demo
Price $140.00/ license
Online Courses Professional Development Personal Development Interactive Excel Training - A2: Elementary

Interactive Excel Training - A2: Elementary

Created by: Ninja Excel
5.0 1,441 views Prime
Last Updated 04/2025
English
Export to your LMS
Full Lifetime Access
Finish in
3h! Run Time
Made for for
Employees
and
Supervisors
Certificate
of Completion
Mobile -
Friendly
Access

What you'll learn

Students who complete level A2 will be able to use a wide variety of mathematical and statistical functions, as well as other logical and conditional functions.
They will also be able to create and modify basic tables and graphs from already processed data.

Skills covered in this course

Excel microsoft office software leadership Operations human resources

Overview

Included Modules

FAQs

Description

Level A2 builds on the basics and expands what you can do with Excel functions and data.

What this course covers:

  • Mathematical and statistical functions
  • Logical and conditional functions
  • Creating and modifying basic tables
  • Building graphs from processed data

Strengthen the everyday Excel skills you use most.

Table of Contents

Unit 0: Introduction A2

Unit 1: Intro to Functions
• What is a Function?
• Create a Function
• Advantages
• Operations within functions
• Errors
• Summary & Glossary 1
• Control 1

Unit 2: Mathematical and Statistical Functions 1
• ROUND Function
• SUM Function
• COUNT and COUNTA Function
• COUNTBLANK Function
• MAX and MIN Functions
• Functions within Functions
• Summary & Glossary 2
• Control 2

Unit 3: Mathematical and Statistical Functions 2
• AVERAGE, MEDIAN and MODE.SNGL functions
• SUMPRODUCT Function
• LARGE and SMALL Functions
• RAND and RANDBETWEEN Functions
• More mathematical Functions
• Summary & Glossary 3
• Control 3

Unit 4: Logical and Conditional Functions 1
• If Function
• AND / OR Functions
• Nesting IF, AND, OR Functions
• SUMIF Function
• COUNTIF Function
• COUNTIFS Function
• SUMIFS Function
• IFERROR Function
• IFS Function
• Summary & Glossary 4
• Control 4

Unit 5: File Protection
• Create a Table
• Table Styles
• Sort and Filter
• Slicer
• Convert and Resize Table
• Table Style Options
• Summary & Glossary 5
• Control 5

Unit 6: File Protection
• Chart Essentials
• Creation and elements of a chart
• Chart Formatting
• Bar Charts
• Line Charts
• Combo Charts
• Pie Chart
• Doughnut Charts
• Funnel Charts
• Sparklines
• Summary & Glossary 6
• Control 6

FINAL EXAM

System Requirements

See System Requirements in the Coggno Knowledge Base

Author

Ninja Excel

7 Courses

Ninja Excel specializes in Professional Development and Software Skills training, with a focus on Microsoft Excel. Courses range from beginner Excel basics to advanced data analytics and reporting. Training is structured with real-world business examples to boost efficiency and accuracy. Professionals use Ninja Excel to strengthen data analysis, reporting, and productivity. The content supports career advancement by building practical, in-demand workplace skills.

Interactive Excel Training - A2: Elementary

Interactive Excel Training - A2: Elementary
Interactive Excel Training - A2: Elementary
Students who complete level A2 will be able to use a wide variety of mathematical and statistical functions, as well as other logical and conditional functions. They will also be able to create and modify basic tables and graphs from already processed data.

Frequently Asked Questions

This course is designed for employees and supervisors who need to complete Interactive Excel Training - A2: Elementary training

Yes. This course is designed to meet applicable federal requirements and commonly mandated state standards. Always confirm specific state or industry requirements with your local regulations.

The course takes approximately 180 minutes to complete and can be paused and resumed at any time.

Yes. Learners receive a downloadable certificate upon successful completion, which can be used for compliance records and audits.

Yes. You can assign this course to individuals or groups using Coggno’s LMS, or purchase multiple seats for your team.

Yes. This course can be exported for delivery in most learning management systems (SCORM compatible).

Yes. The course is fully self-paced and available 24/7.

Yes. This course includes a knowledge check to reinforce learning and verify completion.

Learners have lifetime access from the date of purchase.

Yes. A preview is available so you can review the course format and content before purchasing.

Yes. Content is reviewed and updated as regulations and best practices change.

Yes. This course is available for free with an active Prime Subscription.

Yes. Refund requests can be submitted within 30 days of purchase.