Difference between revisions of "LibreOffice-Suite-Calc/C3/Linking-Calc-Data/English-timed"
From Script | Spoken-Tutorial
Sandhya.np14 (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
'''Resources for recording''' | '''Resources for recording''' | ||
[[Media:LinkinginCalc.zip |Linking in Calc]] | [[Media:LinkinginCalc.zip |Linking in Calc]] | ||
| − | |||
| − | |||
| Line 19: | Line 17: | ||
|- | |- | ||
||00:10 | ||00:10 | ||
| − | || | + | ||How to '''reference''' other sheets in Calc. |
|- | |- | ||
||00:13 | ||00:13 | ||
| − | || | + | ||How to use hyperlinks in Calc. |
|- | |- | ||
| Line 35: | Line 33: | ||
|- | |- | ||
||00:033 | ||00:033 | ||
| − | || | + | ||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. |
|- | |- | ||
| Line 155: | 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. |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
||04:06 | ||04:06 | ||
| − | ||In the “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 262: | Line 253: | ||
|- | |- | ||
||06:25 | ||06:25 | ||
| − | ||To summarize, we learned how to: | + | ||To summarize, we learned how to: '''Reference''' to other sheets in Calc. |
| − | + | ||
|- | |- | ||
||06:31 | ||06:31 | ||
| − | || | + | ||Use hyperlinks in Calc. |
|- | |- | ||
| Line 287: | Line 277: | ||
|- | |- | ||
||06:52 | ||06:52 | ||
| − | || | + | ||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'''. | + | |
|- | |- | ||
| Line 304: | 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. | + | |
Revision as of 15:24, 26 October 2016
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:033 | 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. |
