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