Interactive Excel Training - A1: Beginner
Last Updated 04/2025
English
30-Day Money Back Guarantee
Full Lifetime Access
Finish in
3h! Run Time
3h! Run Time
Made for for
Employees
and
Supervisors
Employees
and
Supervisors
Certificate
of Completion
of Completion
Mobile -
Friendly
Access
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.
Description
This A1 beginner course builds the Excel foundations every new user needs.
What this course covers:
- Basic cell formats, including combining, styling and formatting cells
- Formatting dates, text, percentages and numbers
- Sorting data using filters
- Adding design and security to a spreadsheet
- The use, logic and syntax of the most basic Excel functions
A solid first step toward working confidently in Excel.
System Requirements
See System Requirements in the Coggno Knowledge Base
Table of Contents
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
Interactive Excel Training - A1: Beginner
Interactive Excel Training - A1: Beginner
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.
Frequently Asked Questions
This course is designed for employees and supervisors who need to complete Interactive Excel Training - A1: Beginner 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.
OSHA Compliance
- Bloodborne Pathogens Training (21)
- Electrical Safety (73)
- Fire Safety Training (50)
- First Aid Training (34)
- Forklift Training (45)
- HazCom (Hazard Communication) (51)
- Lockout/Tagout (LOTO) (24)
- OSHA 10 Hour Training (6)
- OSHA 30 Hour Training (2)
- PPE (Personal Protective Equipment) (65)
- Slips, Trips & Falls (72)
- Workplace Safety (1001)