Online Courses Professional Development Personal Development Interactive Excel Training - A1: Beginner Course

Interactive Excel Training - A1: Beginner Course

Created by: Ninja Excel

5.0 860 views Prime

English

30-Day Money Back Guarantee

Full Lifetime Access

Self-Paced
Finish in
180 mins!

Made for for
Employees
only

Certificate
of Completion

Mobile -
Friendly
Access

What you'll learn

Students who achieve level A1 will understand basic cell formats such as combining, styling and formatting cells (date, text, percentage, number, etc.).

In addition, they will be able to sort data using filters, adding design and security to the spreadsheet.

Finally, they will understand the use, logic, and syntax of the most basic Excel functions.

Skills covered in this course

Excel microsoft office software leadership Operations human resources

Students who achieve level A1 will understand basic cell formats such as combining, styling and formatting cells (date, text, percentage, number, etc.). In addition, they will be able to sort data using filters, adding design and security to the spreadsheet. Finally, they will understand the use, logic, and syntax of the most basic Excel functions.

Unit 0: Introduction A1

Unit 1: Excel Format Course
• Center text across multiple cells
• Change text orientation
• Merge Cells
• Applying Cell Styles
• Format Numbers in Cells
• Format Text in Cells
• Format Numbers as Percentages
• Format Numbers as Currency
• Create a Cell Style
• Summary & Glossary 1
• Control 1

Unit 2: Sort Data
• Data Preparation
• One-Level Sort
• Multi-Level Sort
• AutoFill
• Flash Fill
• Drop-down List
• Cells and Range Names
• Summary & Glossary 2
• Control 2

Unit 3: Filter Data
• Prepare Data to Filter
• Clear Filters
• Filter by specific words
• Text Filters
• Filter by specific dates
• Filter Multiple Columns
• Summary & Glossary 3
• Control 3

Unit 4: Page Layout and
Spreadsheet Printing
• Create and Apply Custom Views
• Page Layout
• Reference data in another
workbook
• Summary & Glossary 4
• Control 4

Unit 5: File Protection
• Protect Sheet
• Unlock Cells
• Hide Formulas
• Protect Workbook
• Summary & Glossary 5
• Control 5

Unit 6: File Protection
• What is a Formula?
• Addition, Subtraction, Multiplication, and Division
• Calculation Order
• Cell References
• Copy and Paste Formulas
• Absolute References
• Mixed References
• 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.

Helping businesses stay compliant since 2007

You can also gain access to this course with a Coggno Prime Subscription

Price per license

$140.00

No. of licenses

Total

$140.00

Interactive Excel Training - A1: Beginner Course

What you'll learn

Skills covered in this course

Overview

Included Modules

Description