Introduction
Libre Office Calc Basics Course - Free Spread Sheet Software
Quick Facts
particular | details | |||
---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
After splitting from OpenOffice.org in 2010, LibreOffice Calc underwent a significant overhaul of its external reference handling in order to fix numerous bugs in formula calculations involving external references and to improve data caching performance, particularly when referencing large data ranges. Calc is able to open and save the majority of Microsoft Excel spreadsheets. Additionally, Calc can save spreadsheets as PDF files.
As with the rest of the LibreOffice suite, Calc is available for Linux, macOS, Microsoft Windows, and FreeBSD, among others. Under the Mozilla public license, Calc is a free and open-source application. Libre Office Calc Basics Course - Free Spread Sheet Software certification is made available by Udemy to candidates who want to learn the cells, sheets, and spreadsheet documents in Libre Office.
Libre Office Calc Basics Course - Free Spread Sheet Software online training includes 1.5 hours of video and a digital certificate upon course completion.
Libre Office Calc Basics Course - Free Spread Sheet Software online classes consist of identifying cells, formatting, arithmetic calculation, data display, multi spreadsheets, and saving files
The highlights
- Full Lifetime Access
- 1.5 Hours of Video
- Access on Mobile and TV
- Certificate of Completion
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
Course and certificate fees
Fees information
certificate availability
Yes
certificate providing authority
Udemy
Who it is for
What you will learn
Libre Office Calc Basics Course - Free Spread Sheet Software certification course, the candidate will master creating a closing balance sheet using the free spreadsheet software Libre Office Calc and learn how to use it efficiently. The participant will gain an understanding of Libreoffice cells, sheets, and spreadsheets, as well as documents. The aspirant will acquire knowledge on how to enter data in Libre Office spreadsheet cells, how to create formulas and color cells in Libre Office.
The syllabus
Introduction
Getting Started
- How to Open Libre Office
- How to Identify Cells
- Entering Data in Cells
Formating
- Formating the Text Bold
- Changing the Case of Text
- Formating the Text Underline
- Entering Date
- Formating Date
- Entering the rest of the Data
- Pre Formating the Cells
Calculations
- Arithmetic Calculation of Total Sales
- Arithmetic Calculation of Closing Balance
- Automating Date Creation
- Filling up the Second Row
- Auto Copying Total Sales Formula to Other Cells
- Auto Copying Closing Balance Formula to Other Cells
- Auto Copying Opening Balance Formula to Other Cells
- Entering data for Sales, Returns, Discount and Expenses
- Creating Formulas for Column Totals
Data Display
- Creating a Border around Cells
- Coloring the Cells
- Creating Charts
- Copy and Paste Data
Multiple Spread sheets in a Workbook
- Creating a Second sheet in the Work Book
- Deleting Cells
- Deleting Data from Cells
Saving and Printing
- Saving Files
- Associating files with Libre Office Calc
- Printing Spread Sheets
- Outro