LibreOffice Calc 77up

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

Current Status

Price

Free

Get Started

Course Content

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 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 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 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 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 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 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 Content

0% Complete 0/2 Steps

C8_01 | – Calculate with name (variables)

C8_02 | Find the best and the worst values

Ratings and Reviews

4.3

Avg. Rating

7 Ratings

5

3

4

3

3

1

2

0

1

0

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

Ruth Fiennain Teh

Posted 10 months ago

my thoughts on the course

This course has been really tough but it has been of great help to me. a great thanks to the author.

739 Limbe

Posted 1 year ago

Perfect

I love this course. It is a fantastic course

Tsam Ludovic Nyia

Posted 1 year ago

The course is necessary

Very educational and useful when put into practice.

JUMLACK FRANCO

Posted 1 year ago

Abiola academy

Love the initiative

BARNABAS OFORI

Posted 2 years ago

Much Much knowledgeable

It's very educative. I enjoyed the experience

WISDOM ATIMPO

Posted 2 years 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 years 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.