Difference between revisions of "LibreOffice-Suite-Calc/C2/Introduction-to-LibreOffice-Calc/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 32: Line 32:
 
|-
 
|-
 
||00:21
 
||00:21
−
||How to save and Close a document in Calc.
+
||How to '''save''' and '''Close''' a document in Calc.
  
 
|-
 
|-
Line 56: Line 56:
 
|-
 
|-
 
||00:57
 
||00:57
−
||To 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.
+
||To 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:14
 
||01:14
−
||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4.
+
||Here we are using '''Ubuntu Linux''' version 10.04 as our operating system and '''LibreOffice Suite''' version 3.3.4.
  
 
|-
 
|-
 
||01:26
 
||01:26
−
||If you do not have LibreOffice Suite installed, Calc can be installed by using Synaptic Package Manager.
+
||If you do not have LibreOffice Suite installed, Calc can be installed by using '''Synaptic Package Manager'''.
  
 
|-
 
|-
 
||01:35
 
||01:35
−
||For 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.
+
||For 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.
  
 
|-
 
|-
Line 76: Line 76:
 
|-
 
|-
 
||01:56  
 
||01:56  
−
||Remember, when installing, use the “Complete” installation for Calc.
+
||Remember, when installing, use the '''Complete''' installation for Calc.
  
 
|-
 
|-
 
||02:01  
 
||02:01  
−
||If 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.
+
||If 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.
  
 
|-
 
|-
Line 88: Line 88:
 
|-
 
|-
 
||02:22
 
||02:22
−
||In order to access LibreOffice Calc, click on the “Spreadsheet” component in the new dialog box.
+
||In order to access LibreOffice Calc, click on the '''Spreadsheet''' component in the new dialog box.
  
 
|-
 
|-
Line 100: Line 100:
 
|-
 
|-
 
||02:40
 
||02:40
−
||The document in Calc is called a workbook. A workbook contains many sheets called as spreadsheets.
+
||The document in Calc is called a '''workbook'''. A workbook contains many sheets called as spreadsheets.
  
 
|-
 
|-
Line 124: Line 124:
 
|-
 
|-
 
||03:45
 
||03:45
−
||Apart from these toolbars, there are two additional fields, namely “Input line” and “Name box” at the top.
+
||Apart from these toolbars, there are two additional fields, namely '''Input line''' and '''Name box''' at the top.
  
 
|-
 
|-
Line 132: Line 132:
 
|-
 
|-
 
||04:02
 
||04:02
−
||Now you can see three sheet tabs at the bottom left corner of the spreadsheet namely, “Sheet1”, “Sheet 2” and “Sheet 3”.
+
||Now you can see three sheet tabs at the bottom left corner of the spreadsheet namely, '''Sheet1”, Sheet 2''' and '''Sheet 3'''.
  
 
|-
 
|-
Line 152: Line 152:
 
|-
 
|-
 
||04:53
 
||04:53
−
||The columns start at “A” and go on to the right, and the rows start at “1” and go down.
+
||The columns start at '''A''' and go on to the right, and the rows start at '''1''' and go down.
  
 
|-
 
|-
 
||05:01
 
||05:01
−
||These column and row headers form the cell references that appear in the “Name Box” field.
+
||These column and row headers form the cell references that appear in the '''Name Box''' field.
  
 
|-
 
|-
Line 164: Line 164:
 
|-
 
|-
 
||05:17
 
||05:17
−
||You 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.
+
||You 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.
  
 
|-
 
|-
Line 172: Line 172:
 
|-
 
|-
 
||05:39
 
||05:39
−
||Now we will learn how to build a “Personal Finance Tracker” in the spreadsheet.
+
||Now we will learn how to build a '''Personal Finance Tracker''' in the spreadsheet.
  
 
|-
 
|-
Line 184: Line 184:
 
|-
 
|-
 
||05:56
 
||05:56
−
||Let us type the heading as “SN” which denotes the serial number of the items which we will represent in the spreadsheet.
+
||Let us type the heading as '''SN''' which denotes the serial number of the items which we will represent in the spreadsheet.
  
 
|-
 
|-
 
||06:05
 
||06:05
−
||Now click on the cell referenced as B1 and type another heading as “Items”.
+
||Now click on the cell referenced as B1 and type another heading as '''Items'''.
  
 
|-
 
|-
Line 196: Line 196:
 
|-
 
|-
 
||06:18
 
||06:18
−
||Similarly, 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.
+
||Similarly, 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.
  
 
|-
 
|-
Line 208: Line 208:
 
|-
 
|-
 
||06:44
 
||06:44
−
||To save this file, click on “File” in the menu bar and then click on the “Save As” option.
+
||To save this file, click on '''File''' in the menu bar and then click on the '''Save As''' option.
  
 
|-
 
|-
 
||06:51   
 
||06:51   
−
||A dialog box appears on the screen where you are required to enter the name of your file under the “Name” field.
+
||A dialog box appears on the screen where you are required to enter the name of your file under the '''Name''' field.
  
 
|-
 
|-
 
||06:59
 
||06:59
−
||So enter the name of the file as “Personal Finance Tracker”.   
+
||So enter the name of the file as '''Personal Finance Tracker'''.   
  
 
|-
 
|-
 
||07:04
 
||07:04
−
||Below 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.
+
||Below 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:14
 
||07:14
−
||So click on the down arrow in the “Save in folder” field.
+
||So click on the down arrow in the '''Save in folder''' field.
  
 
|-
 
|-
Line 232: Line 232:
 
|-
 
|-
 
||07:26
 
||07:26
−
||We click on the “Desktop” option.
+
||We click on the '''Desktop''' option.
  
 
|-
 
|-
 
||07:28
 
||07:28
−
||So the file will be saved on the desktop.
+
||So the file will be saved on the '''desktop'''.
  
 
|-
 
|-
 
||07:34
 
||07:34
−
||Now click on the “File type” option in the dialog box.
+
||Now click on the '''File type''' option in the dialog box.
  
 
|-
 
|-
Line 248: Line 248:
 
|-
 
|-
 
||07:46
 
||07:46
−
||The default file type in LibreOffice Calc is the “ODF Spreadsheet” which provides the extension “dot ods”.
+
||The default file type in LibreOffice Calc is the '''ODF Spreadsheet''' which provides the extension '''dot ods'''.
  
 
|-
 
|-
 
||07:56
 
||07:56
−
||ODF stands for Open Document Format which is an open standard.
+
||'''ODF''' stands for '''Open Document Format''' which is an open standard.
  
 
|-
 
|-
 
||08:01
 
||08:01
−
||Besides 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.
+
||Besides 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:20
 
||08:20
−
||Another popular file extension which opens in most programs is dot csv.  
+
||Another popular file extension which opens in most programs is '''dot csv'''.  
  
 
|-
 
|-
Line 268: Line 268:
 
|-
 
|-
 
||08:38
 
||08:38
−
||We will click on the “ODF Spreadsheet” option.
+
||We will click on the '''ODF Spreadsheet''' option.
  
 
|-
 
|-
 
||08:43
 
||08:43
−
||You see that the file type, “ODF Spreadsheet and within brackets, dot ods” gets displayed next to the “File type” option.
+
||You see that the file type, '''ODF Spreadsheet and within brackets, dot ods''' gets displayed next to the '''File type''' option.
  
 
|-
 
|-
 
||08:53
 
||08:53
−
||Click on the “Save” button.
+
||Click on the '''Save''' button.
  
 
|-
 
|-
Line 284: Line 284:
 
|-
 
|-
 
||09:03
 
||09:03
−
||In addition to the above formats discussed, the spreadsheet can also be saved in “dot html” format which is a web page format.
+
||In addition to the above formats discussed, the spreadsheet can also be saved in '''dot html''' format which is a web page format.
  
 
|-
 
|-
Line 292: Line 292:
 
|-
 
|-
 
||09:18
 
||09:18
−
||So click on the “File” option in the menu bar and then click on the “Save As” option.
+
||So click on the '''File''' option in the menu bar and then click on the '''Save As''' option.
  
 
|-
 
|-
 
||09:24
 
||09:24
−
||Now click on the ”File Type” option, and then click on the “HTML Document and within braces OpenOffice dot org Calc” option.
+
||Now click on the '''File Type''' option, and then click on the '''HTML Document''' and within braces '''OpenOffice dot org Calc''' option.
  
 
|-
 
|-
 
||09:36
 
||09:36
−
||This option gives the “dot html” extension to the document.
+
||This option gives the '''dot html''' extension to the document.
  
 
|-
 
|-
 
||09:41
 
||09:41
−
||Click on the “Save” button.
+
||Click on the '''Save''' button.
  
 
|-
 
|-
 
||09:44
 
||09:44
−
||Now put a check on the “Ask when not saving in ODF format” option in the dialog box.
+
||Now put a check on the '''Ask when not saving in ODF format''' option in the dialog box.
  
 
|-
 
|-
 
||09:50
 
||09:50
−
||Finally click on the “Keep Current Format” option.
+
||Finally click on the '''Keep Current Format''' option.
  
 
|-
 
|-
 
||09:54
 
||09:54
−
||You see that the document gets saved with dot html extension.
+
||You see that the document gets saved with '''dot html extension'''.
  
 
|-
 
|-
Line 324: Line 324:
 
|-
 
|-
 
||10:10
 
||10:10
−
||The document can also be exported to PDF format by simply clicking on the “Export Directly as PDF” option in the standard tool bar. As before,  
+
||The document can also be exported to PDF format by simply clicking on the '''Export Directly as PDF''' option in the standard tool bar. As before,  
  
 
|-
 
|-
Line 332: Line 332:
 
|-
 
|-
 
||10:24
 
||10:24
−
||Alternately you can do so by clicking on the “File” option in the menu bar and then clicking on the “Export as pdf” option.
+
||Alternately you can do so by clicking on the '''File''' option in the menu bar and then clicking on the '''Export as pdf''' option.
  
 
|-
 
|-
 
||10:33
 
||10:33
−
||In the dialog box which appears, click on the “Export” option and then click on the “Save” button.
+
||In the dialog box which appears, click on the '''Export''' option and then click on the '''Save''' button.
  
 
|-
 
|-
Line 344: Line 344:
 
|-
 
|-
 
||10:44
 
||10:44
−
||Lets close this document by click on File and then Close.  
+
||Lets close this document by click on '''File''' and then '''Close'''.  
  
 
|-
 
|-
Line 352: Line 352:
 
|-
 
|-
 
||10:56
 
||10:56
−
||To open an existing document, click on the “File” menu in the menu bar at the top and then click on the “Open” option.
+
||To open an existing document, click on the '''File''' menu in the menu bar at the top and then click on the '''Open''' option.
  
 
|-
 
|-
Line 364: Line 364:
 
|-
 
|-
 
||11:14
 
||11:14
−
||So click on the small pencil button at the top left corner of the dialog box. It has the name, “Type a file name”.
+
||So click on the small pencil button at the top left corner of the dialog box. It has the name, '''Type a file name'''.
  
 
|-
 
|-
 
||11:23
 
||11:23
−
||This opens a “Location Bar” field.
+
||This opens a '''Location Bar''' field.
  
 
|-
 
|-
Line 376: Line 376:
 
|-
 
|-
 
||11:30
 
||11:30
−
||So we type the name of the file as “Personal Finance Tracker”.
+
||So we type the name of the file as '''Personal Finance Tracker'''.
  
 
|-
 
|-
 
||11:35
 
||11:35
−
||Now in the list of file names that appears, choose “Personal Finance Tracker dot ods”.
+
||Now in the list of file names that appears, choose '''Personal Finance Tracker dot ods'''.
  
 
|-
 
|-
 
||11:43
 
||11:43
−
||Now click on the “Open” button.
+
||Now click on the '''Open''' button.
  
 
|-
 
|-
 
||11:45
 
||11:45
−
||You see that the file Personal Finance Tracker.ods opens.
+
||You see that the file '''Personal Finance Tracker.ods''' opens.
  
 
|-
 
|-
 
||11:51
 
||11:51
−
||Alternately 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.
+
||Alternately 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:02
 
||12:02
−
||You can also open files with “dot xls” and “dot xlsx” extensions which are used by Microsoft Excel in Calc.
+
||You can also open files with '''dot xls''' and '''dot xlsx''' extensions which are used by Microsoft Excel in Calc.
  
 
|-
 
|-
Line 408: Line 408:
 
|-
 
|-
 
||12:26
 
||12:26
−
||So first click on the cell referenced as A1. Select the headings “SN”, “Cost”, “Spent”, “Received”,  “Date” and “Account” by clicking on the left  
+
||So 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.
 
mouse button and then dragging it along all the headings.
  
 
|-
 
|-
 
||12:42
 
||12:42
−
||This 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.
+
||This 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:56
 
||12:56
−
||The headings thus become bold.
+
||The headings thus become '''bold'''.
  
 
|-
 
|-
 
||12:59
 
||12:59
−
||Now let us increase the font size of the headings.
+
||Now let us increase the '''font''' size of the headings.
  
 
|-
 
|-
 
||13:03
 
||13:03
−
||So lets select the headings and then click on the “Font Size” field in the toolbar.
+
||So lets select the headings and then click on the '''Font Size''' field in the toolbar.
  
 
|-
 
|-
 
||13:09
 
||13:09
−
||In the drop down menu, let us choose “14”.
+
||In the drop down menu, let us choose '''14'''.
  
 
|-
 
|-
Line 437: Line 437:
 
|-
 
|-
 
||13:17
 
||13:17
−
||Now let us change the font style we are using.
+
||Now let us change the '''font''' style we are using.
  
 
|-
 
|-
 
||13:21
 
||13:21
−
||So click on the down arrow in the “Font Name” field and then select “Bitstream Charter” as the font name.
+
||So click on the down arrow in the '''Font Name''' field and then select '''Bitstream Charter''' as the font name.
  
 
|-
 
|-
 
||13:31
 
||13:31
−
||After making the required modifications, click on the “Save” icon.
+
||After making the required modifications, click on the '''Save''' icon.
  
 
|-
 
|-
 
||13:36
 
||13:36
−
||Once 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.
+
||Once 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.
  
 
|-
 
|-
Line 489: Line 489:
 
|-
 
|-
 
||14:20
 
||14:20
−
|| Save it under the name “Spreadsheet Practice.ods”
+
|| Save it under the name '''Spreadsheet Practice.ods'''
  
 
|-
 
|-
 
||14:25
 
||14:25
−
||Write the headings as “Serial number”, “Name”, “Department” and “Salary”.  
+
||Write the headings as '''Serial number”, “Name”, “Department''' and '''Salary'''.  
  
 
|-
 
|-
 
||14:31
 
||14:31
−
||Underline the headings. Increase the font size of the headings to 16. Close the file.  
+
||Underline the headings. Increase the font size of the headings to '''16'''. Close the file.  
  
 
|-
 
|-
Line 525: Line 525:
 
|-
 
|-
 
||15:00
 
||15:00
−
||For more details, please write to contact at spoken hyphen tutorial dot org
+
||For more details, please write to '''contact at spoken hyphen tutorial dot org'''
  
 
|-
 
|-
Line 541: Line 541:
 
|-
 
|-
 
||15:21
 
||15:21
−
||spoken hyphen tutorial dot org slash NMEICT hyphen Intro
+
||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''
  
 
|-
 
|-

Revision as of 17:11, 4 February 2015

Resources for recording Introduction to Calc

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

And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching. 

 Thanks for joining

Contributors and Content Editors

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

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