• ABIOLA »
  • Academy »
  • RASP »
  • Lightportal »
  • Cloud »
  • Mobile App »
  • Courses
  • Points
    • Courses & Points
    • MyFavorits
    • Top-X (various)
      • All points
      • Points 2022
      • Top-X (last 30 days)
      • My school
      • My school group
      • My country
      • Campaign Pickup Point Report
      • Others countries
        • Top-X Ghana
        • Top-X Benin
        • Top-X Nigeria
    • Top-X (schools)
      • Top-X | all
      • Top-X | 2023
    • Top-X (courses)
      • Top-X | all
      • Top-X | campaign
      • Top-X | 2023
    • Doku
      • Student
      • Teacher
      • Supervisor
      • Admin
      • Campaign 2022
  • Campaign
  • Gallery
  • ABIOLA
  • Other
    • Academy
    • Registration
    • Blog
    • FAQ
    • Exam
    • Pause
    • Instructors
  • Login
  • English
  • German

LESSON 3 – Basics Copy

by Academy director Christoph Köhler | Sep 9, 2023

LibreOffice Calc 77up Copy LESSON 3 – Basics Copy

LESSON 3 – Basics

In this lesson 3 – Basics, we will give you important tips to ensure that you are of lasting value.

Lesson Content
0% Complete 0/15 Steps
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 gamut Copy
C3_06 | Changing the spelling Copy
C3_07 | Editing the Copy toolbar Copy
C3_08 | Gimmicks with Columns and Rows Copy
C3_09 | Inserting a Check Box Copy
C3_10 | Protect Spreadsheet Copy Copy
C3_11 | Add Graphics Copy Copy
C3_12 | Auto Filter Copy Copy
C3_13 | Use the Copy function wizard Copy
C3_15 | Clone and compete formulas Copy
Lesson 3 – Quiz / Questions Copy
Previous Lesson
Back to Course
Next Lesson

Course Navigation

Course Home Expand All
LESSON 1 – Important Information Copy
3 Topics
C1_01 | Important questions/answers – Please study carefully! Copy
C1_02 | Tip and Function Overview Copy
C1_03 | All tables as download for testing Copy
LESSON 2 – Getting Started Copy
14 Topics
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 Copy 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
15 Topics
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 gamut Copy
C3_06 | Changing the spelling Copy
C3_07 | Editing the Copy toolbar Copy
C3_08 | Gimmicks with Columns and Rows Copy
C3_09 | Inserting a Check Box Copy
C3_10 | Protect Spreadsheet Copy Copy
C3_11 | Add Graphics Copy Copy
C3_12 | Auto Filter Copy Copy
C3_13 | Use the Copy function wizard Copy
C3_15 | Clone and compete formulas Copy
Lesson 3 – Quiz / Questions Copy
LESSON 4 – Interesting Copy
14 Topics
C4_01 | Auto-format tables Copy
C4_02 | How to Use Drop Down 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 | Date 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
13 Topics
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 Curves Copy
C5_05 | – Vertical Reference Copy
C5_06 | – Quickly navigate your Copy spreadsheet Copy
C5_07 | – Rate a result with stars Copy
C5_08 | – Use Random Numbers Copy
C5_09 | – Rows and Columns – Copy 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
13 Topics
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 Copy
C6_05 | Special counting functions Copy 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 Calc Copy
14 Topics
C7_01 | Comparison MS-Excel ./. Google Calc Copy
C7_02 | Introduction to Google Calc Copy
C7_03 | Special help from Google Calc 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 | Web Page Copy Tables Copy
C7_10 | Web Pages to Copy Tables Copy
C7_11 | Analyzing with Column Statistics Copy
C7_12| Rolling Tables Copy
C7_13 | Google Calc App for Smartphone Copy
Lektion 7 – Quiz / Fragen Copy
LESSON 8 – Encores Copy
2 Topics
C8_01 | – Calculate with name (variables) Copy
C8_02 | Find the best and the worst values Copy
LESSON 9- Authors / Conclusion Copy
Return to LibreOffice Calc 77up Copy

Search

Recent Posts

  • The right way to Install Wi fi Signal Enhancer 20. September 2023
  • Ways to Protect the individual Data Your business Has 20. September 2023
  • Ideal Antiviruses With respect to PC Game enthusiasts 20. September 2023
  • The Best Free Malware Software 20. September 2023
  • Mum Analysis Faults and Best Practices for Keeping away from Them 17. September 2023
Copyright © 2023 ABIOLA gGmbH
  • Academy
  • Courses
  • Exam
  • ABIOLA
  • Registration
  • Gallery
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account

Registration confirmation will be emailed to you.