Book a Demo
Price $140.00/ license
Online Courses Professional Development Personal Development Interactive Excel Training - B1: Intermediate Course

Interactive Excel Training - B1: Intermediate Course

Created by: Ninja Excel
5.0 1,097 views Prime
Last Updated 04/2025
English
Export to your LMS
Full Lifetime Access
Self-Paced
Finish in
180 mins!
Made for for
Employees
and
Supervisors
Certificate
of Completion
Mobile -
Friendly
Access

What you'll learn

Students who obtain level B1 will be well versed in time, date, and text functions.
They will also be able to outline and forecast data.
Finally, they will be able to build dynamic pivot tables and graphs.

Skills covered in this course

Excel microsoft office software leadership Operations human resources

Overview

Included Modules

FAQs

Description

Students who obtain level B1 will be well versed in time, date, and text functions. They will also be able to outline and forecast data. Finally, they will be able to build dynamic pivot tables and graphs.

Table of Contents

Unit 0: Introduction B1

Unit 1: Text Functions
• RIGHT and LEFT
• SEARCH - FIND
• MID
• REPLACE - SUBSTITUTE
• CONCAT
• TEXTJOIN
• TEXTBEFORE - TEXTAFTER
• TRIM
• PROPER - UPPER - LOWER
• LEN
• Summary & Glossary 3
• Control 1

Unit 2: Time and Date Functions
• Sum Time
• Convert Time Units
• TIME
• HOUR – MINUTE – SECOND
• NOW - TODAY - TODAY+N
• DATE - DAY - MONTH - YEAR
• EDATE - EOMONTH
• DATEDIF
• WORKDAY
• NETWORKDAYS
• WORKDAY.INTL
• NETWORKDAYS.INTLS
• Summary & Glossary 2
• Control 2

Unit 3: Outline
• Group
• Auto Outline
• Subtotals
• Summary & Glossary 3
• Control 3

Unit 4: Data Forecast
• Show Scenarios
• Create Scenarios
• Goal Seek
• Create Forecast
• Data Table
• Summary & Glossary 4
• Control 4

Unit 5: PivotTable
• Pivot Table and its characteristics
• Create Pivot Tables, Drag and Sort fields
• Pivot Table Options
• Refresh Pivot Table
• Working with tables for Pivot Table design
• Value Field Settings
• Filter and Sort Pivot Tables
• Design and Move Pivot Tables
• Manual and Automatic Groupings
• Protection of Pivot Tables
• Summary & Glossary 5
• Control 5

Unit 6: Pivot Charts
• Create Interactive Charts from Tables
• Create Pivot Chart
• Pivot Chart tools
• Summary & Glossary 6
• Control 6

FINAL EXAM

System Requirements

Please note the following minimum requirements for an optimal course experience:

>Stable internet access with a minimum speed of 100 Mbps.
>A modern browser (such as Chrome or Firefox).
>Windows 10 or higher operating system.
>Allow access to domains.

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 - B1: Intermediate Course

Interactive Excel Training - B1: Intermediate
Interactive Excel Training - B1: Intermediate
Students who obtain level B1 will be well versed in time, date, and text functions. They will also be able to outline and forecast data. Finally, they will be able to build dynamic pivot tables and graphs.

Frequently Asked Questions

This course is designed for employees and supervisors who need to complete Interactive Excel Training - B1: Intermediate Course 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.