Libre Office Calc Basics Course - Free Spread Sheet Software

Libre Office Calc Basics Course - Free Spread Sheet Software

This Course teaches you the basics of how to use Libre Office Calc 6.3,to create a Closing Balance Stock Sheet. This course will introduce you to opening, entering data, formatting data, editing, creating charts, saving and printing the stock sheet in Libre Office with full compatibility with Microsoft Word 365 and below. You will also be shown how to create a Work Book, coloring, copy, paste,cut, chart, arithmetic commands, and many other essential items that you will need to create a Closing Balance Stock Sheet in Libre Office Calc.

Course Content:

1 - Introduction

Getting Started

2 - How to Open Libre Office

3 - How to  Identify Cells

4 - Entering Data in Cells

Formating

5 - Formating the Text Bold

6 - Changing the Case of Text

7 - Formating the Text Underline

8 - Entering Date

9 - Formating Date

10 - Entering the rest of the Data

11 - Pre Formating the Cells

Calculations

12 - Arithmetic Calculation of Total Sales

13 - Arithmetic Calculation of Closing Balance

14 - Automating Date Creation

15 - Filling up the Second Row

16 - Auto Copying Total Sales Formula to Other Cells

17 - Auto Copying Closing Balance Formula to Other Cells

18 - Auto Copying Opening Balance Formula to Other Cells

19 - Entering data for Sales, Returns, Discount and Expenses

20 - Creating Formulas for Column Totals

Data Display

21 - Creating a Border around Cells

22 - Coloring the Cells

23 - Creating Charts

24 - Copy and Paste Data

Multiple Spread sheets in a Workbook

25 - Creating a Second sheet in the Work Book

26 - Deleting Cells

27 - Deleting Data from Cells

Saving and Printing

28 - Saving Files

29 - Associating files with Libre Office Calc

30 - Printing Spread Sheets

31 - Outro

This Course teaches you Libre Office Calc 6.3 and how to Create a Closing Balance Stock Sheet as an Absolute Beginner

Url: View Details

What you will learn

• You will learn how to Use, quickly get up and running with the free Libre Office Calc Spreadsheet software and Create a Closing Balance Stock Sheet
• You will learn what Cells, Sheets and Spread Sheet Documents are in Libre Office.
• You will learn how to enter Data in Libre Office Spread Sheet Cells

Rating: 4.625

Level: Beginner Level

Duration: 1.5 hours

Instructor: Tambo Ngambi