Libre Office Calc Basics Course - Free Spread Sheet Software

BY
Udemy

Learn how to use the spreadsheet software Calc to create a closing balance stock sheet.

Mode

Online

Fees

₹ 999

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
₹ 999
certificate availability

Yes

certificate providing authority

Udemy

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

  • 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

Instructors

Mr Tambo Ngambi
Trainer
Freelancer

Other Bachelors, Other Masters

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books