ABIOLA »
Academy »
RASP »
Lightportal »
Cloud »

New: Exam Certification »
Courses
Points
Campaigns
Exam
Joy
Gallery
Blog
Other
- Academy
- Registration
- ABIOLA
- FAQ
- Pause
- Instructors
Login

Protected: LibreOffice Calc – V02 | soon

Password Protected

To view this protected post, enter the password below:

Password:

Course Navigation

Course Home

LESSON 1 – Important Information Copy

C1_00 | New: All topics with questions for Google Gemini Copy

C1_01 | Important questions/answers – Please study carefully! Copy

C1_02 | Tip and function overview Copy

C1_03 | Calc Shortcuts Copy

C1_04 | All tables as download for testing Copy

C1_05 | All videos for download for cost optimization Copy

LESSON 2 – Getting Started Copy

C2_01 | Create your first table Copy

C2_02 | Paste images into the comment box Copy

C2_03 | Write high numbers (X²) correctly and calculate with Copy

C2_04 | Using the LEFT and RIGHT Copy Function Copy

C2_05 | Calculate Age and Time Copy

C2_06 | Converting Units of Length Copy

C2_07 | Forming a sum using the molecular formula Copy

C2_08 | Merge Cells Copy

C2_09 | Format Cells Copy

C2_10 | Insert a data bar Copy

C2_11 | Merge Cells Copy

C2_12 | Average Function Copy

C2_13 | Split text into multiple columns Copy

Lesson 2 – Quiz / Questions Copy

LESSON 3 – Basics Copy

C3_01 | Absolute and relative data 1/2 Copy

C3_02 | Absolute and relative data 2/2 Copy

C3_03 | Freeze rows and columns Copy

C3_04 | Grouping Columns and Rows Copy

C3_05 | Insert a color scale Copy

C3_06 | Changing the spelling Copy

C3_07 | Editing the toolbar Copy

C3_08 | Gimmicks with Columns and Rows Copy

C3_09 | Inserting a Check Box Copy

C3_10 | Protect Spreadsheet Copy

C3_11 | Add Graphics Copy

C3_12 | Auto Filter Copy

C3_13 | Use the function wizard Copy

C3_14 | Analyze a table (by relative and absolute) Copy

C3_15 | Clone formulas Copy

Lesson 3 – Quiz / Questions Copy

LESSON 4 – Interesting Copy

C4_01 | Auto-format tables Copy

C4_02 | Use of checklists Copy

C4_03 | Edit Worksheets Copy

C4_04 | Characters and Words Count Copy

C4_05 | Trim Function Copy

C4_06 | Fill in the date automatically Copy

C4_07 | Day of Date Copy

C4_08 | Copying data from a web page (rigid) Copy

C4_09 | Convert value to another format Copy

C4_10 | Find and Replace Copy

C4_11 | IF Function 1/2 Copy

C4_12 | IF Function 2/2 Copy

C4_13 | Insert Watermark Copy

Lesson 4 – Quiz / Questions Copy

LESSON 5 – Challenging Copy

C5_01 | – Status bar at the bottom Copy

C5_02 | – Calculate between different worksheets Copy

C5_03 | – Mark blank cells Copy

C5_04 | – Working with Rounding Copy

C5_05 | – Vertical Reference Copy

C5_06 | – Quickly navigate your spreadsheet Copy

C5_07 | – Rate a result with stars Copy

C5_08 | – Use Random Numbers Copy

C5_09 | Rows and Columns – gimmicks Copy

C5_10 | Use special character Copy

C5_11 | – Display symbols on values. Copy

C5_12 | – Define rules for value input Copy

Lesson 5 – Quiz / Questions Copy

LESSON 6 – Ambitious Copy

C6_01 | Pivot Table 1/3 Copy

C6_02 | Pivot Table 2/3 Copy

C6_03 | Pivot Table 3/3 Copy

C6_04 | Calculate by Goals Copy

C6_05 | Special counting functions Copy

C6_06 | Graphic within a cell 1/2 Copy

C6_07 | Graphic within a cell 2/2 Copy

C6_08 | Cell Overflow Copy

C6_09 | Calculate a GPA Copy

C6_10 | Smart copy cells and areas Copy

C6_11 | Transpose Values Copy

C6_12 | Responding to Error Copy

Lesson 6 – Quiz / Questions Copy

LESSON 7 – Google Sheets Copy

C7_01 | Comparison MS-Excel ./. Google Sheets Copy

C7_02 | Introduction to Google Sheets Copy

C7_03 | Special help from Google Sheets Copy

C7_04 | Calculating with checkboxes Copy

C7_05 | Automatically translate cells and sheets Copy

C7_06 | Edit tables in the team at the same time Copy

C7_07 | Embedding data from foreign tables Copy

C7_08 | Graphics in Cells Copy

C7_09 | Tabels to Web Page Copy

C7_10 | Web Pages to Tables Copy

C7_11 | Analyzing with Column Statistics Copy

C7_12| Rolling Tables Copy

C7_13 | Google Sheets App for Smartphone Copy

Lektion 7 – Quiz / Questions Copy

LESSON 8 – Test it out – It works Copy

C8 _00 | Introduction Copy

C8_01 AVERGEIFS Copy

C8_02 | SUMPRODUCT Copy

LEESION 9 – Exam and Certificate Copy

COURSE EXAM | Test / Silver / Gold Copy

LESSON 10 – Authors / Conclusion Copy

Search

Search for:

Recent Posts

ExamFokus – Vocabulary Trainer 3. July 2026
GreenActivity – Environmental Portal 2. July 2026
Become an ABIOLA Creator & Expert 23. February 2026
Course Exam Rewards 21. January 2026
School Nigeria – Solar & PC 11. January 2023

Copyright © 2026 ABIOLA gGmbH

Academy
Courses
Exam
ABIOLA
Registration
Gallery

DonateDonate here for joy in Africa.