LibreOffice Calc 77up

Current Status

Not Enrolled

Price

Free

Get Started

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

0.0

Avg. Rating

0 Ratings

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

No Reviews Found!

Show more reviews

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

Course Content

Ratings and Reviews

Course Navigation

Search

Recent Posts