Libreoffice Suite Calc

admin

Resources for recordingIntroduction to Calc

TimeNarration
00:00Welcome to the Spoken tutorial on Introduction to LibreOffice Calc.
00:06In this tutorial, we will learn about:
00:08Introduction to LibreOffice Calc.
00:12Various toolbars in LibreOffice Calc.
00:16How to open a new document in Calc.
00:18How to open an existing document.
00:21How to save and Close a document in Calc.
00:26LibreOffice Calc is the spreadsheet component of the LibreOffice Suite.
00:32Just like Writer deals largely with text information, spreadsheet deals largely with numeric information.
00:40It can be said to be a software for the language of numbers.
00:44It is the equivalent of Microsoft Excel in Microsoft Office Suite.
00:49It is a free and open source software. So, it can be copied, reused and distributed free of cost.
00:57To get started with 'LibreOffice suite', you can use either Microsoft Windows 2000 and its higher versions like MS Windows XP or MS Windows 7 or you can use GNU/Linux as your Operating System.
01:14Here, we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4.
01:26If you do not have 'LibreOffice Suite' installed, 'Calc' can be installed by using Synaptic Package Manager.
01:35For more information on Synaptic Package Manager, please refer to the Ubuntu Linux Tutorials on this website and download LibreOffice Suite by following the instructions on this website.
01:50Detailed instructions are available in the first tutorial of LibreOffice Suite.
01:56Remember, when installing use the Complete installation for Calc.
02:01If you have already installed LibreOffice Suite, you will find 'LibreOffice Calc' by clicking on the Applications option at the top left of your screen and then clicking on Office and then on LibreOffice option.
02:17A new dialog-box opens up with various LibreOffice components.
02:22In order to access LibreOffice Calc, click on the Spreadsheet component in the new dialog-box.
02:30This will open an empty document in the main Calc window.
02:35Now, let us learn about the main components of the Calc window.
02:40The document in Calc is called a workbook. A workbook contains many sheets called as spreadsheets.
02:48Each spreadsheet consists of cells arranged in rows and columns. Each row is identified by a number and each column by an alphabet.
02:58A particular cell which refers to an intersection of a row and a column is identified by its relevant row number and column alphabet.
03:09Cells can hold information like text, numbers, formulas and many more data elements for display and manipulation.
03:18Each spreadsheet can have many sheets and each sheet can have little more than one million rows and one thousand columns which gives us more than one billion or hundred crore cells in a single sheet.
03:33The Calc window has various toolbars like the title bar, the menu bar, the standard toolbar, the formatting bar, the formula bar and the status bar.
03:45Apart from these toolbars, there are two additional fields, namely- Input line and Name box at the top.
03:54The toolbars contain the most commonly used options which we will learn about as the tutorials progress.
04:02Now you can see three sheet tabs at the bottom left corner of the spreadsheet, namely- 'Sheet1', 'Sheet 2' and 'Sheet 3'.
04:13These tabs enable access to each individual sheet with the visible sheet having a white tab.
04:21Clicking on another sheet tab displays that particular sheet and its tab turns white.
04:28The main section of the spreadsheet where the data is entered, contains various cells in the form of a grid. Each cell is at the intersection of a column and a row.
04:41At the top of the columns and at the left end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers.
04:53The columns start at 'A' and go on to the right and the rows start at 1 and go down.
05:01These column and row headers form the cell reference that appears in the Name Box field.
05:07After learning about the various components in Calc, we will now learn how to open a new document in 'LibreOffice Calc'.
05:17You can open a new document by clicking on the New icon in the standard toolbar or by clicking on the File option in the menu bar and then clicking on the New option and then finally clicking on the Spreadsheet option.
05:33You see that a new Calc window opens up in both the cases.
05:39Now we will learn how to build a 'Personal Finance Tracker' in the spreadsheet.
05:45Let us see how to enter a data in a few of the cells in a spreadsheet.
05:50So, click on the cell referenced as 'A1' in the first sheet of the spreadsheet.
05:56Let us type the heading as 'SN' which denotes the serial number of the items which we will represent in the spreadsheet.
06:05Now click on the cell referenced as B1 and type another heading as Items.
06:11All the item names which we will use in the spreadsheet will be under this heading.
06:18Similarly, click on the cells C1, D1, E1, F1 and G1 one after the other and write the headings as 'Cost', 'Spent', “Received”, 'Date' and 'Account' respectively.
06:33We will insert the data under each of these columns later.
06:39Once done writing your spreadsheet, you should save it for future use.
06:44To save this file, click on File in the menu bar and then click on the Save As option.
06:51A dialog-box appears on the screen where you are required to enter the name of your file under the Name field.
06:59So, enter the name of the file as 'Personal Finance Tracker'.
07:04Below the Name field, you have the Save in folder field where you are required to enter the folder name which will contain your saved file.
07:14So, click on the down-arrow in the Save in folder field.
07:18A list of folder options appears. Here, we can choose the folder where we want our file to be saved.
07:26We click on the Desktop option.
07:28So, the file will be saved on the desktop.
07:34Now, click on the File type option in the dialog-box.
07:37It shows you a list of File type options or file extensions, under which you can save your file.
07:46The default file type in LibreOffice Calc is the 'ODF Spreadsheet' which provides the extension dot ods.
07:56ODF stands for Open Document Format which is an open standard.
08:01Besides saving in dot ods format which can be opened in LibreOffice Calc, you can also save your file in dot xml, dot xlsx and in dot xls format which can be opened in the MS Office Excel program.
08:20Another popular file extension which opens in most programs is dot csv.
08:28This is often used to store spreadsheet data in a text file format which reduces the file size hugely and is easily portable.
08:38We will click on the ODF Spreadsheet option.
08:43You see that the file type- ODF Spreadsheet and within brackets dot ods gets displayed, next to the File type option.
08:53Click on the Save button.
08:55This takes you back to the Calc window with the filename and extension of your choice on the title bar.
09:03In addition to the above formats discussed, the spreadsheet can also be saved in dot html format which is a web page format.
09:13This is done in the same way as explained before.
09:18So, click on the File option in the menu bar and then click on the Save As option.
09:24Now, click on the File Type option and then click on the 'HTML Document' and within braces 'OpenOffice dot org Calc' option.
09:36This option gives the dot html extension to the document.
09:41Click on the Save button.
09:44Now put a check on the 'Ask when not saving in ODF format' option in the dialog-box.
09:50Finally, click on the 'Keep Current Format' option.
09:54You see that the document gets saved with dot html extension.
10:00This format is used when we want to show our spreadsheet as a web page that can be opened by a web browser program.
10:10The document can also be exported to PDF format by simply clicking on the 'Export Directly as PDF' option in the standard tool bar.
10:20As before, choose the location where you wish to save.
10:24Alternately, you can do so by clicking on the File option in the menu bar and then clicking on the 'Export as pdf' option.
10:33In the dialog-box which appears, click on the Export option and then click on the Save button.
10:40A pdf file will be created.
10:44Let's close this document by clicking on File and then Close.
10:50Next, we will learn how to open an existing document in LibreOffice Calc.
10:56To open an existing document- click on the File menu in the menu bar, at the top, and then click on the Open option.
11:06A dialog-box appears on the screen.
11:09Here, find the folder where you saved your document.
11:14So, click on the small pencil button at the top left corner of the dialog box. It has the name- Type a file name.
11:23This opens a Location Bar field.
11:25Here, type the name of the file you are looking for.
11:30So, we type the name of the file as 'Personal Finance Tracker'.
11:35Now, in the list of file names that appears, choose Personal Finance Tracker dot ods.
11:43Now, click on the Open button.
11:45You see that the file 'Personal Finance Tracker.ods' opens.
11:51Alternately, you can open an existing file by clicking on the Open icon in the toolbar, at the top, and doing the further process in the same manner.
12:02You can also open files with dot xls and dot xlsx extensions which are used by Microsoft Excel in Calc.
12:13Next you will see how to modify a file and save it under the same file name.
12:20So, let us modify the file by making the headings Bold and increasing their font size.
12:26So, first click on the cell referenced as A1. Select the headings 'SN', “Cost”, “Spent”, “Received”, “Date” and 'Account' by clicking on the left mouse button and then dragging it along all the headings.
12:42This will select the text and highlight it. Now, release the left mouse button. The text should still be highlighted. Now, click on the Bold icon in the standard toolbar.
12:56The headings thus become Bold.
12:59Now, let us increase the font size of the headings.
13:03So, let's select the headings and then click on the Font Size field in the toolbar.
13:09In the drop-down menu, let us choose 14.
13:13So, you see that the font size of the headings increases.
13:17Now, let us change the font style we are using.
13:21So, click on the down-arrow in the Font Name field and then select Bitstream Charter as the font name.
13:31After making the required modifications, click on the Save icon.
13:36Once you have saved your document and you wish to close it, just click on the File menu in the menu bar and click on the Close option.
13:46This closes your file.
13:50This brings us to the end of the Spoken Tutorial on 'LibreOffice Calc'.
13:54To summarize, we learned about:
13:57Introduction to LibreOffice Calc.
14:01Various toolbars in LibreOffice Calc.
14:04How to open a new document in Calc.
14:07How to open an existing document.
14:10How to save and Close a document in Calc.
14:14COMPREHENSIVE ASSIGNMENT- Open a new document in Calc.
14:20 Save it under the name 'Spreadsheet Practice.ods'.
14:25Write the headings as 'Serial number”, “Name”, “Department” and 'Salary'.
14:31Underline the headings. Increase the font size of the headings to 16. Close the file.
14:39Watch the video available at the following link.
14:42It summarizes the Spoken Tutorial project.
14:45If you do not have good bandwidth, you can download and watch it.
14:49The Spoken Tutorial project team:
14:52Conducts workshops using spoken tutorials.
14:59Gives certificates for those who pass an online test,For more details, please write to: contact at spoken hyphen tutorial dot org.
15:05Spoken Tutorial project is a part of the Talk to a Teacher project.
15:10It is supported by the National Mission on Education through ICT, MHRD, Government of India.
15:17More information on this mission is available at:
15:21spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
15:28This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.

Contributors and Content Editors

Libreoffice Suite Calc Tutorial

Madhurig, Minal, PoojaMoolya, Pratik kamble, Sandhya.np14

Libreoffice Calc Software

Questions and answers for LibreOffice. I have mis- set something = Calc will not perform calculations! Formulas do not work! The LibreOffice Calc installer is commonly called scalc.exe. This software was originally produced by Administrator. Our built-in antivirus checked this download and rated it as 100% safe. The software lies within Office Tools, more precisely Document management.

Retrieved from 'https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Calc/C2/Introduction-to-LibreOffice-Calc/English-timed&oldid=33603'

Learn LibreOffice now, start using the FREE suite: Calc. With the help of this course you can All you need to know about LibreOffice Calc, from the basics to taking advantage of all the major benefits it offers.

This course was created by Paolo Pelloni. It was rated 4.9 out of 5 by approx 12842 ratings. There are approx 68836 users enrolled with this course, so don’t wait to download yours now. This course also includes 3 hours on-demand video, 3 Articles, 2 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.

Calc
  • Calc is the free spreadsheet program you've always needed. Newcomers find it intuitive and easy to learn, while professional data miners and number crunchers appreciate the comprehensive range of advanced functions. Built-in wizards guide you through choosing and using a comprehensive range of advanced features.
  • LibreOffice is a free and powerful office suite, and a successor to OpenOffice.org (commonly known as OpenOffice). Its clean interface and feature-rich tools help you.
  • LibreOffice is a free and Open Source office suite application similar to Microsoft Office, it offers word processing, Spreadsheets, Publishing and presentation tools. As a small business operator, it provides considerable savings on the cost of a document creation software.

What Will You Learn?

  • Learn how to use Calc to produce great looking documents: budgets, collections, complex spreadsheets

  • Learn how to use Calc to arrange and manipulate data and feed it to other programs

COURSE LAST REVIEW: FEBRUARY 2018

JOIN OVER 800 STUDENTS IN MY LIBREOFFICE COURSES!

———————————————————————————————————————

LibreOffice is a powerful free suite, learn how to use it at best to make your documents look good and support modern open document formats.

Learn all you need to know to use LibreOffice to full advantage!You are going to see the different components of LibreOffice and a series of how-to guides.

Nicky romero kickstart plugin. Calc, the spreadsheet.

From writing a simple budget to organise a collection to all you need to know to create complex spreadsheets. Learn fast input, formulas and tools that will make you more productive and achieve better results in lesser time. Customize LibreOffice to your liking and learn tools and extensions available that will make your life easier.

Libreoffice Calc Tutorial

You will get:

Libreoffice Calc Download Windows 10

  • Full, free lifetime access
  • All future extra lectures and upgrades are always included for free
  • Unconditional Udemy 30 day money-back guarantee – that’s my personal promise of your success!

I am adding even more lectures and the price will soon go up again.

Rating:
4.7