Difference between revisions of "LibreOffice-Suite-Calc/C3/Linking-Calc-Data/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
'''Resources for recording'''
 
'''Resources for recording'''
 
[[Media:LinkinginCalc.zip |Linking in Calc]]
 
[[Media:LinkinginCalc.zip |Linking in Calc]]
−
 
−
 
  
  
Line 11: Line 9:
 
|-
 
|-
 
||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'''.  
  
 
|-
 
|-
Line 19: Line 17:
 
|-
 
|-
 
||00:10
 
||00:10
−
||* How to '''reference''' other sheets in Calc.  
+
||How to '''reference''' other sheets in Calc.  
  
 
|-
 
|-
 
||00:13
 
||00:13
−
||* How to use hyperlinks in Calc.  
+
||How to use hyperlinks in Calc.  
  
 
|-
 
|-
Line 34: Line 32:
  
 
|-
 
|-
−
||00:033
+
||00:33
−
||* 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:37
−
||* A cell from another spread sheet, if you have saved both the spreadsheets.  
+
||A cell from another spread sheet, if you have saved both the spreadsheets.  
  
 
|-
 
|-
Line 59: Line 57:
 
|-
 
|-
 
||01:11
 
||01:11
−
||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'''.
  
 
|-
 
|-
Line 71: Line 69:
 
|-
 
|-
 
||01:36
 
||01:36
−
||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'''.  
  
 
|-
 
|-
Line 79: Line 77:
 
|-
 
|-
 
||01:48
 
||01:48
−
||This opens the new sheet.  
+
||This opens the new '''sheet'''.  
  
 
|-
 
|-
Line 95: Line 93:
 
|-
 
|-
 
||02:12
 
||02:12
−
||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:19
−
||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:27
−
||Now, click on the empty '''cell B3'''.  
+
||Now, click on the empty cell '''B3'''.  
  
 
|-
 
|-
Line 116: Line 113:
 
|-
 
|-
 
||02:41
 
||02:41
−
||This will be done by referencing.  
+
||This will be done by '''referencing'''.  
  
 
|-
 
|-
 
||02:44
 
||02:44
−
||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'''.  
  
 
|-
 
|-
Line 128: Line 125:
 
|-
 
|-
 
||02:59
 
||02:59
−
||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”.  
  
 
|-
 
|-
Line 140: Line 137:
 
|-
 
|-
 
||03:20
 
||03:20
−
||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:34
−
||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:41
−
||Referencing can be very useful to summarize 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.  
  
 
|-
 
|-
Line 156: Line 153:
 
|-
 
|-
 
||03:55
 
||03:55
−
||You can use Hyperlinks to jump:  
+
||You can use Hyperlinks to jump:To a different location within a spreadsheet To different files or Even to web sites.  
−
 
+
−
* To a different location within a spreadsheet  
+
−
 
+
−
* To different files or  
+
−
 
+
−
* Even to web sites.  
+
  
 
|-
 
|-
 
||04:06
 
||04:06
−
||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”.  
+
  
 
|-
 
|-
Line 179: Line 169:
 
|-
 
|-
 
||04:25
 
||04:25
−
||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”.  
  
 
|-
 
|-
Line 187: Line 177:
 
|-
 
|-
 
||04:38
 
||04:38
−
||Now, select the text “Sheet 2” in the '''Input Line'''.  
+
||Now, select the text “SHEET 2” in the '''Input Line'''.  
  
 
|-
 
|-
Line 211: Line 201:
 
|-
 
|-
 
||05:08
 
||05:08
−
||Now, click on the “plus sign” next to the “Sheet” option.  
+
||Now, click on the '''plus sign''' next to the '''“Sheet”''' option.  
  
 
|-
 
|-
Line 227: Line 217:
 
|-
 
|-
 
||05:32
 
||05:32
−
||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.  
  
 
|-
 
|-
Line 259: Line 249:
 
|-
 
|-
 
||06:20
 
||06:20
−
||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:25
−
||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:31
−
||* Use hyperlinks in Calc.  
+
||Use hyperlinks in Calc.  
  
 
|-
 
|-
Line 284: Line 273:
 
|-
 
|-
 
||06:47
 
||06:47
−
||The Spoken Tutorial Project team: * Conducts workshops using spoken tutorials.  
+
||The Spoken Tutorial project team: * Conducts workshops using spoken tutorials.  
  
 
|-
 
|-
 
||06:52
 
||06:52
−
||* Gives certificates for those who pass an online test.  
+
||Gives certificates for those who pass an online test.  
  
 
|-
 
|-
 
||06:56
 
||06:56
−
||For more details, please write to:
+
||For more details, please write to:'''contact at spoken hyphen tutorial dot org'''.  
−
contact at spoken hyphen tutorial dot org.  
+
  
 
|-
 
|-
 
||07:03
 
||07:03
−
||'''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.  
  
 
|-
 
|-
Line 305: Line 293:
 
|-
 
|-
 
||07:15
 
||07:15
−
||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:25
−
||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 14:55, 23 March 2017

Resources for recording Linking in Calc


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

Contributors and Content Editors

Minal, PoojaMoolya, Pratik kamble, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Calc/C3/Linking-Calc-Data/English-timed&oldid=33681"