LibreOffice Calc 77up

by Academy director Christoph Köhler | Jul 1, 2023

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

LESSON 1 – Important Information 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

C1_01 | Important questions/answers – Please study carefully!

C1_02 | Tip and function overview

C1_03 | Calc Shortcuts

C1_04 | All tables as download for testing

C1_05 | All videos for download for cost optimization

LESSON 2 – Getting Started 14 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/14 Steps

C2_01 | Create your first table

C2_02 | Paste images into the comment box

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

C2_04 | Using the LEFT and RIGHT Copy Function

C2_05 | Calculate Age and Time

C2_06 | Converting Units of Length

C2_07 | Forming a sum using the molecular formula

C2_08 | Merge Cells

C2_09 | Format Cells

C2_10 | Insert a data bar

C2_11 | Merge Cells

C2_12 | Average Function

C2_13 | Split text into multiple columns

Lesson 2 – Quiz / Questions

Lesson 2 Quiz (LibreOffice Calc 77up)

LESSON 3 – Basics 16 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/16 Steps

C3_01 | Absolute and relative data 1/2

C3_02 | Absolute and relative data 2/2

C3_03 | Freeze rows and columns

C3_04 | Grouping Columns and Rows

C3_05 | Insert a color scale

C3_06 | Changing the spelling

C3_07 | Editing the toolbar

C3_08 | Gimmicks with Columns and Rows

C3_09 | Inserting a Check Box

C3_10 | Protect Spreadsheet

C3_11 | Add Graphics

C3_12 | Auto Filter

C3_13 | Use the function wizard

C3_14 | Analyze a table (by relative and absolute)

C3_15 | Clone formulas

Lesson 3 – Quiz / Questions

Lesson 3 Quiz (LibreOffice Calc 77up)

LESSON 4 – Interesting 14 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/14 Steps

C4_01 | Auto-format tables

C4_02 | Use of checklists

C4_03 | Edit Worksheets

C4_04 | Characters and Words Count

C4_05 | Trim Function

C4_06 | Fill in the date automatically

C4_07 | Day of Date

C4_08 | Copying data from a web page (rigid)

C4_09 | Convert value to another format

C4_10 | Find and Replace

C4_11 | IF Function 1/2

C4_12 | IF Function 2/2

C4_13 | Insert Watermark

Lesson 4 – Quiz / Questions

Lesson 4 Quiz (LibreOffice Calc 77up)

LESSON 5 – Challenging 13 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/13 Steps

C5_01 | – Status bar at the bottom

C5_02 | – Calculate between different worksheets

C5_03 | – Mark blank cells

C5_04 | – Working with Rounding

C5_05 | – Vertical Reference

C5_06 | – Quickly navigate your spreadsheet

C5_07 | – Rate a result with stars

C5_08 | – Use Random Numbers

C5_09 | Rows and Columns – gimmicks

C5_10 | Use special character

C5_11 | – Display symbols on values.

C5_12 | – Define rules for value input

Lesson 5 – Quiz / Questions

Lesson 5 Quiz (LibreOffice Calc 77up)

LESSON 6 – Ambitious 13 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/13 Steps

C6_01 | Pivot Table 1/3

C6_02 | Pivot Table 2/3

C6_03 | Pivot Table 3/3

C6_04 | Calculate by Goals

C6_05 | Special counting functions

C6_06 | Graphic within a cell 1/2

C6_07 | Graphic within a cell 2/2

C6_08 | Cell Overflow

C6_09 | Calculate a GPA

C6_10 | Smart copy cells and areas

C6_11 | Transpose Values

C6_12 | Responding to Error

Lesson 6 – Quiz / Questions

Lesson 6 Quiz (LibreOffice Calc 77up)

LESSON 7 – Google Sheets 14 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/14 Steps

C7_01 | Comparison MS-Excel ./. Google Sheets

C7_02 | Introduction to Google Sheets

C7_03 | Special help from Google Sheets

C7_04 | Calculating with checkboxes

C7_05 | Automatically translate cells and sheets

C7_06 | Edit tables in the team at the same time

C7_07 | Embedding data from foreign tables

C7_08 | Graphics in Cells

C7_09 | Tabels to Web Page

C7_10 | Web Pages to Tables

C7_11 | Analyzing with Column Statistics

C7_12| Rolling Tables

C7_13 | Google Sheets App for Smartphone

Lektion 7 – Quiz / Questions

Lesson 7 Quiz (LibreOffice Calc 77up)

LESSON 8 – Encores 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

C8_01 | – Calculate with name (variables)

C8_02 | Find the best and the worst values

LESSON 9- Authors / Conclusion

Ratings and Reviews

4.0

Avg. Rating

2 Ratings

5

1

4

0

3

1

2

0

1

0

What's your experience? We'd love to know!

WISDOM ATIMPO

Posted 1 week ago

Review

The course us very good and more practicals are involved. Hence I a little bit higher than basic students Needs to be review to meet the standard of such students

TILY GODWILL

Posted 2 months ago

A great course to study especially for us doing computer science in high school

My words can't say how much I love the time I spent studying this course I'm happy I studied it

Show more reviews

What's your experience? We'd love to know!

DonateDonate here for joy in Africa.