Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C3/Linking-Calc-Data/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
'''Resources for recording'''
 
[[Media:LinkinginCalc.zip |Linking in Calc]]
 
 
 
 
 
 
{| border=1
 
{| border=1
 
|| '''Time'''
 
|| '''Time'''
Line 11: Line 5:
 
|-
 
|-
 
||00:00
 
||00:00
||Welcome to the Spoken tutorial on Linking in Calc in LibreOffice Calc.  
+
||Welcome to the '''Spoken tutorial''' on '''Linking in Calc in LibreOffice Calc'''.  
  
 
|-
 
|-
 
||00:06
 
||00:06
||In this tutorial we will learn the following:  
+
||In this tutorial, we will learn the following:  
  
 
|-
 
|-
Line 22: Line 16:
  
 
|-
 
|-
||00:13
+
||00:14
 
||How to use hyperlinks in Calc.  
 
||How to use hyperlinks in Calc.  
  
 
|-
 
|-
||00:17
+
||00:18
||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4.  
+
||Here, we are using '''GNU/Linux''' as our '''operating system''' and '''LibreOffice Suite version 3.3.4'''.  
  
 
|-
 
|-
||00:29
+
||00:28
||LibreOffice Calc allows you to reference  
+
||'''LibreOffice Calc''' allows you to reference:
  
 
|-
 
|-
||00:033
+
||00:31
||A cell from another sheet to a cell in the current sheet  
+
||A '''cell''' from another sheet to a cell in the current '''sheet'''.
  
 
|-
 
|-
||00:37
+
||00:36
||A cell from another spread sheet
+
||A cell from another '''spreadsheet''', if you have saved both the spreadsheets.  
If you have saved both the spreadsheets.  
+
  
 
|-
 
|-
||00:44
+
||00:42
 
||Let’s open “Personal-Finance-Tracker.ods”.  
 
||Let’s open “Personal-Finance-Tracker.ods”.  
  
 
|-
 
|-
||00:49
+
||00:47
||The sheet 1 of our file contains the spreadsheet for “Personal Finance Tracker”.  
+
||The '''sheet 1''' of our file contains the spreadsheet for “Personal Finance Tracker”.  
  
 
|-
 
|-
||00:55
+
||00:53
 
||I have added some amounts in the columns “Spent” and “Received”.  
 
||I have added some amounts in the columns “Spent” and “Received”.  
  
 
|-
 
|-
||01:04
+
||01:03
||Now, let us find the sum total of the components under “Cost” and  
+
||Now, let us find the sum total of the components under “Cost” and “Spent” respectively.  
 
+
“Spent” respectively.  
+
  
 
|-
 
|-
||01:11
+
||01:10
||Click on the cell referenced as C9 and enter the formula “is equal to SUM” and within braces “C3 colon C7”.
+
||Click on the '''cell''' referenced as '''C9''' and enter the formula '''is equal to SUM''' and within braces '''C3 colon C7'''.
  
 
|-
 
|-
||01:24
+
||01:22
||Then press the “Enter” key.  
+
||Then press the '''Enter''' key.  
  
 
|-
 
|-
||01:27
+
||01:26
||Click on the cell referenced as D9 and using the same formula find the total.  
+
||Click on the cell referenced as '''D9''' and using the same formula find the total.  
  
 
|-
 
|-
||01:36
+
||01:34
 
||Now, we will display the total balance under “Cost” and “Spent” on a different sheet using cell referencing.  
 
||Now, we will display the total balance under “Cost” and “Spent” on a different sheet using cell referencing.  
  
 
|-
 
|-
||01:45
+
||01:44
 
||Let’s click on the “Sheet 2” tab.  
 
||Let’s click on the “Sheet 2” tab.  
  
 
|-
 
|-
||01:48
+
||01:47
||This opens the new sheet.  
+
||This opens the new '''sheet'''.  
  
 
|-
 
|-
||01:51
+
||01:50
||Now click on the cell referenced as A1 and type the heading “COMPONENT” inside it.  
+
||Now, click on the cell referenced as '''A1''' and type the heading “COMPONENT” inside it.  
  
 
|-
 
|-
||02:00
+
||01:58
||Click on the cell referenced as B1 and type the heading “BALANCE” inside it.  
+
||Click on the cell referenced as '''B1''' and type the heading “BALANCE” inside it.  
  
 
|-
 
|-
||02:07
+
||02:06
 
||Now, let’s enter the names of the components under the heading.  
 
||Now, let’s enter the names of the components under the heading.  
  
 
|-
 
|-
||02:12
+
||02:10
||Click on the cell referenced as A3 and type“COST” .  
+
||Click on the cell referenced as '''A3''' and type “COST”. Press '''Enter'''.  
 
+
Press “Enter”.  
+
  
 
|-
 
|-
||02:19
+
||02:18
||Below “COST”, let’s enter the next component as “SPENT” in the cell referenced A4.  
+
||Below “COST”, let’s enter the next component as “SPENT” in the cell referenced '''A4'''.  
  
 
|-
 
|-
||02:27
+
||02:26
||Now, click on the empty cell B3.  
+
||Now, click on the empty '''cell B3'''.  
  
 
|-
 
|-
||02:31
+
||02:29
||The cells B3 and B4 will have the total balance under the heading “COST” and “SPENT”,
+
||The cells '''B3''' and '''B4''' will have the total balance under the heading “COST” and “SPENT”
  
 
|-
 
|-
||02:38
+
||02:36
 
||which we calculated in “Sheet 1”.  
 
||which we calculated in “Sheet 1”.  
  
 
|-
 
|-
||02:41
+
||02:40
 
||This will be done by referencing.  
 
||This will be done by referencing.  
  
 
|-
 
|-
||02:44
+
||02:43
||To make the cell reference in cell B3, click on the “equal to” sign next to the “Input line”.  
+
||To make the '''cell reference''' in '''cell B3''', click on the “equal to” sign next to the '''Input line'''.  
  
 
|-
 
|-
||02:53
+
||02:52
||Now, on the Sheet tab click on “Sheet 1”.  
+
||Now, on the '''Sheet''' tab, click on “Sheet 1”.  
  
 
|-
 
|-
||02:59
+
||02:58
||In this sheet, we will click on the cell C9 which contains the total under the column “Cost”.  
+
||In this sheet, we will click on the '''cell C9''' which contains the total under the column '''“Cost”'''.  
  
 
|-
 
|-
||03:07
+
||03:06
||Notice, that in the “Input line” the statement “Sheet 1 dot C9”, is displayed.  
+
||Notice that in the '''Input line''', the statement “Sheet 1 dot C9” is displayed.  
  
 
|-
 
|-
||03:15
+
||03:13
||Now click on the check mark next to the “Input line”.  
+
||Now click on the check-mark next to the '''Input line'''.  
  
 
|-
 
|-
||03:20
+
||03:18
||Notice, that the grand total of the data under “Cost” in the “Sheet 1” tab is automatically entered into the cell referenced as B3 in the “Sheet 2 “ tab.  
+
||Notice that the 'grand total' of the data under “Cost” in the “Sheet 1” tab is automatically entered into the cell referenced as '''B3''' in the “Sheet 2 “ tab.  
  
 
|-
 
|-
||03:34
+
||03:33
||Similarly,we can enter the grand totals of other components through referencing.  
+
||Similarly, we can enter the grand totals of other components through referencing.  
  
 
|-
 
|-
||03:41
+
||03:39
||Referencing can be very useful to summarise data if there are many sheets, with a lot of data content.  
+
||Referencing can be very useful to summarize data if there are many sheets with a lot of data content.  
  
 
|-
 
|-
||03:49
+
||03:48
||Now, let’s learn how to create Hyperlinks in Calc sheets.  
+
||Now, let’s learn how to create Hyperlinks in '''Calc sheets'''.  
  
 
|-
 
|-
||03:55
+
||03:53
||You can use Hyperlinks to jump  
+
||You can use Hyperlinks to jump:
 
+
To a different location within a spreadsheet  
* To a different location within a spreadsheet  
+
To different files or  
 
+
Even to web sites.  
* To different files or  
+
 
+
* Even to web sites.  
+
  
 
|-
 
|-
||04:06
+
||04:05
||In “Personal-Finance-Tracker.ods”  
+
||In the “Personal-Finance-Tracker.ods”, the '''personal finance tracker''' is in “Sheet 1” and the rest of the content is in “Sheet 2”.  
the personal finance tracker is in “Sheet 1” and the rest of the content is in “Sheet 2”.  
+
  
 
|-
 
|-
||04:17
+
||04:15
||Let’s say we want to jump from Sheet 1 to Sheet 2.  
+
||Let’s say we want to jump from '''Sheet 1''' to '''Sheet 2'''.  
  
 
|-
 
|-
||04:22
+
||04:20
 
||First, click on the “Sheet 1” tab.  
 
||First, click on the “Sheet 1” tab.  
  
 
|-
 
|-
||04:25
+
||04:24
||Here let’s click on the cell referenced as B14 and enter ”Sheet 2”.  
+
||Here, let’s click on the '''cell''' referenced as '''B14''' and enter ”Sheet 2”.  
  
 
|-
 
|-
||04:33
+
||04:31
||You see that the name “Sheet 2” is displayed on the “Input line”.  
+
||You see that the name “Sheet 2” is displayed on the '''Input line'''.  
  
 
|-
 
|-
||04:38
+
||04:37
||Now select the text “Sheet 2” in the Input Line.  
+
||Now, select the text “Sheet 2” in the '''Input Line'''.  
  
 
|-
 
|-
||04:44
+
||04:42
||After selecting the text, click on the “Hyperlink” icon in the toolbar.  
+
||After selecting the text, click on the '''“Hyperlink” icon''' in the '''toolbar'''.  
  
 
|-
 
|-
||04:51
+
||04:50
||The Hyperlink dialog box appears.  
+
||The Hyperlink dialog-box appears.  
  
 
|-
 
|-
||04:55
+
||04:53
||On the left side, let’s select the “Document” option.  
+
||On the left side, let’s select the '''Document''' option.  
  
 
|-
 
|-
||04:59
+
||04:57
||Click on the “Target in document” icon in the dialog box.  
+
||Click on the '''“Target in document”''' '''icon''' in the dialog-box.  
  
 
|-
 
|-
||05:04
+
||05:02
||A new “Target in document” dialog box appears.  
+
||A new '''Target in document''' dialog box appears.  
  
 
|-
 
|-
||05:08
+
||05:06
||Now, click on the “plus sign” next to the “Sheet” option.  
+
||Now, click on the plus sign next to the '''Sheet''' option.  
  
 
|-
 
|-
||05:13
+
||05:12
||In the dialog box which appears, click on the “Sheet 2” option.  
+
||In the dialog-box which appears, click on the “Sheet 2” option.  
  
 
|-
 
|-
||05:18
+
||05:17
||Now click on the “Apply” button and then click on the “Close” button.  
+
||Now, click on the '''Apply''' button and then click on the '''Close''' button.  
  
 
|-
 
|-
||05:24
+
||05:23
||Now, from the Hyperlink dialog box, click on “Apply” and then click on “Close”.  
+
||Now, from the Hyperlink dialog-box, click on '''Apply''' and then click on '''Close'''.  
  
 
|-
 
|-
||05:32
+
||05:30
||The “Sheet 1” tab appears in front with the text “Sheet 2” highlighted in the cell.  
+
||The “Sheet 1” tab appears in front with the text “Sheet 2” highlighted in the '''cell'''.  
  
 
|-
 
|-
||05:40
+
||05:38
||Now, when we click on the text “Sheet 2”, it directly takes us to the sheet where we had entered the balance for Cost.  
+
||Now, when we click on the text “Sheet 2”, it directly takes us to the sheet where we had entered the balance for '''Cost'''.  
  
 
|-
 
|-
||05:51
+
||05:49
 
||We have created a hyperlink!  
 
||We have created a hyperlink!  
  
 
|-
 
|-
||05:55
+
||05:53
 
||To remove the hyperlink, first select the hyperlinked text “Sheet 2”.  
 
||To remove the hyperlink, first select the hyperlinked text “Sheet 2”.  
  
 
|-
 
|-
||06:01
+
||05:59
||Now right click and from the context menu, click on the “Default Formatting” option.  
+
||Now, right-click and from the '''context menu''', click on the '''Default Formatting''' option.  
  
 
|-
 
|-
||06:09
+
||06:07
||The the text is no longer hyperlinked.  
+
||The text is no longer hyperlinked.  
  
 
|-
 
|-
||06:12
+
||06:11
 
||It is just like any normal text in the document.  
 
||It is just like any normal text in the document.  
  
 
|-
 
|-
||06:16
+
||06:15
||Let us undo the changes.  
+
||Let us '''undo''' the changes.  
  
 
|-
 
|-
||06:20
+
||06:18
||This brings us to the end of the Spoken Tutorial on LibreOffice Calc.  
+
||This brings us to the end of the Spoken Tutorial on '''LibreOffice Calc'''.  
  
 
|-
 
|-
||06:25
+
||06:23
||To summarize, we learned how to:  
+
||To summarize, we learned how to: Reference to other sheets in Calc.  
Reference to other sheets in Calc.  
+
  
 
|-
 
|-
||06:31
+
||06:29
 
||Use hyperlinks in Calc.  
 
||Use hyperlinks in Calc.  
  
 
|-
 
|-
||06:36
+
||06:35
||Watch the video available at the following link  
+
||Watch the video available at the following link:
  
 
|-
 
|-
||06:40
+
||06:38
||It summarises the Spoken Tutorial project  
+
||It summarizes the Spoken Tutorial project.
  
 
|-
 
|-
||06:43
+
||06:41
||If you do not have good bandwidth, you can download and watch it  
+
||If you do not have good bandwidth, you can download and watch it.
  
 
|-
 
|-
||06:47
+
||06:45
||The Spoken Tutorial Project Team  
+
||The Spoken Tutorial Project Team: Conducts workshops using spoken tutorials.  
Conducts workshops using spoken tutorials.  
+
  
 
|-
 
|-
||06:52
+
||06:50
||Gives certificates for those who pass an online test  
+
||Gives certificates for those who pass an online test.
  
 
|-
 
|-
||06:56
+
||06:54
||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.
  
 
|-
 
|-
||07:03
+
||07:01
||Spoken Tutorial Project is a part of the Talk to a Teacher project  
+
||'''Spoken Tutorial''' Project is a part of the '''Talk to a Teacher''' project.
  
 
|-
 
|-
||07:07
+
||07:05
||It is supported by the National Mission on Education through ICT, MHRD, Government of India  
+
||It is supported by the National Mission on Education through ICT, MHRD, Government of India.
  
 
|-
 
|-
||07:15
+
||07:13
||More information on this Mission is available at  
+
||More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
 
+
spoken hyphen tutorial dot org slash NMEICT hyphen Intro  
+
  
 
|-
 
|-
||07:25
+
||07:24
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd  
+
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
 
+
Thanks for joining.
Thanks for joining
+

Latest revision as of 10:43, 21 February 2017

Time Narration
00:00 Welcome to the Spoken tutorial on Linking in Calc in LibreOffice Calc.
00:06 In this tutorial, we will learn the following:
00:10 How to reference other sheets in Calc.
00:14 How to use hyperlinks in Calc.
00:18 Here, we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4.
00:28 LibreOffice Calc allows you to reference:
00:31 A cell from another sheet to a cell in the current sheet.
00:36 A cell from another spreadsheet, if you have saved both the spreadsheets.
00:42 Let’s open “Personal-Finance-Tracker.ods”.
00:47 The sheet 1 of our file contains the spreadsheet for “Personal Finance Tracker”.
00:53 I have added some amounts in the columns “Spent” and “Received”.
01:03 Now, let us find the sum total of the components under “Cost” and “Spent” respectively.
01:10 Click on the cell referenced as C9 and enter the formula is equal to SUM and within braces C3 colon C7.
01:22 Then press the Enter key.
01:26 Click on the cell referenced as D9 and using the same formula find the total.
01:34 Now, we will display the total balance under “Cost” and “Spent” on a different sheet using cell referencing.
01:44 Let’s click on the “Sheet 2” tab.
01:47 This opens the new sheet.
01:50 Now, click on the cell referenced as A1 and type the heading “COMPONENT” inside it.
01:58 Click on the cell referenced as B1 and type the heading “BALANCE” inside it.
02:06 Now, let’s enter the names of the components under the heading.
02:10 Click on the cell referenced as A3 and type “COST”. Press Enter.
02:18 Below “COST”, let’s enter the next component as “SPENT” in the cell referenced A4.
02:26 Now, click on the empty cell B3.
02:29 The cells B3 and B4 will have the total balance under the heading “COST” and “SPENT”
02:36 which we calculated in “Sheet 1”.
02:40 This will be done by referencing.
02:43 To make the cell reference in cell B3, click on the “equal to” sign next to the Input line.
02:52 Now, on the Sheet tab, click on “Sheet 1”.
02:58 In this sheet, we will click on the cell C9 which contains the total under the column “Cost”.
03:06 Notice that in the Input line, the statement “Sheet 1 dot C9” is displayed.
03:13 Now click on the check-mark next to the Input line.
03:18 Notice that the 'grand total' of the data under “Cost” in the “Sheet 1” tab is automatically entered into the cell referenced as B3 in the “Sheet 2 “ tab.
03:33 Similarly, we can enter the grand totals of other components through referencing.
03:39 Referencing can be very useful to summarize data if there are many sheets with a lot of data content.
03:48 Now, let’s learn how to create Hyperlinks in Calc sheets.
03:53 You can use Hyperlinks to jump:

To a different location within a spreadsheet To different files or Even to web sites.

04:05 In the “Personal-Finance-Tracker.ods”, the personal finance tracker is in “Sheet 1” and the rest of the content is in “Sheet 2”.
04:15 Let’s say we want to jump from Sheet 1 to Sheet 2.
04:20 First, click on the “Sheet 1” tab.
04:24 Here, let’s click on the cell referenced as B14 and enter ”Sheet 2”.
04:31 You see that the name “Sheet 2” is displayed on the Input line.
04:37 Now, select the text “Sheet 2” in the Input Line.
04:42 After selecting the text, click on the “Hyperlink” icon in the toolbar.
04:50 The Hyperlink dialog-box appears.
04:53 On the left side, let’s select the Document option.
04:57 Click on the “Target in document” icon in the dialog-box.
05:02 A new Target in document dialog box appears.
05:06 Now, click on the plus sign next to the Sheet option.
05:12 In the dialog-box which appears, click on the “Sheet 2” option.
05:17 Now, click on the Apply button and then click on the Close button.
05:23 Now, from the Hyperlink dialog-box, click on Apply and then click on Close.
05:30 The “Sheet 1” tab appears in front with the text “Sheet 2” highlighted in the cell.
05:38 Now, when we click on the text “Sheet 2”, it directly takes us to the sheet where we had entered the balance for Cost.
05:49 We have created a hyperlink!
05:53 To remove the hyperlink, first select the hyperlinked text “Sheet 2”.
05:59 Now, right-click and from the context menu, click on the Default Formatting option.
06:07 The text is no longer hyperlinked.
06:11 It is just like any normal text in the document.
06:15 Let us undo the changes.
06:18 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
06:23 To summarize, we learned how to: Reference to other sheets in Calc.
06:29 Use hyperlinks in Calc.
06:35 Watch the video available at the following link:
06:38 It summarizes the Spoken Tutorial project.
06:41 If you do not have good bandwidth, you can download and watch it.
06:45 The Spoken Tutorial Project Team: Conducts workshops using spoken tutorials.
06:50 Gives certificates for those who pass an online test.
06:54 For more details, please write to: contact at spoken hyphen tutorial dot org.
07:01 Spoken Tutorial Project is a part of the Talk to a Teacher project.
07:05 It is supported by the National Mission on Education through ICT, MHRD, Government of India.
07:13 More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
07:24 This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.

Thanks for joining.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14