LibreOffice-Suite-Calc/C3/Linking-Calc-Data/English

Resources for recording Linking in Calc

VISUAL CUE	NARRATION
Show Slide Welcome to the Spoken tutorial on Linking in Calc in LibreOffice Calc.	Welcome to the Spoken tutorial on Linking in Calc in LibreOffice Calc.
Show Slide Learning Objectives Reference other sheets in Calc. Use hyperlinks in Calc.	In this tutorial we will learn the following: How to reference other sheets in Calc. How to use hyperlinks in Calc.
Show Slide OS and Versions Ubuntu Linux version 10.04 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.
Show Slide Reference Cells You can reference A cell from another sheet to a cell in the current sheet A cell from another spread sheet If you have saved both the spreadsheets	LibreOffice Calc allows you to reference A cell from another sheet to a cell in the current sheet A cell from another spread sheet If you have saved both the spreadsheets.
Open “Personal-Finance-Tracker.ods”.	Let’s open “Personal-Finance-Tracker.ods”.
Click on “Sheet 1”.	The sheet 1 of our file contains the spreadsheet for “Personal Finance Tracker”.
Point to the columns “Spent” and “Received”. Point to the amounts entered there.	I have added some amounts in the columns “Spent” and “Received”.
Point to “Cost” and “Spent”	Now, let us find the sum total of the components under “Cost” and “Spent” respectively.
Click on cell C9->write “=SUM(C3:C7)” Press “Enter”.	Click on the cell referenced as C9 and enter the formula “is equal to SUM” and within braces “C3 colon C7” . Then press the “Enter” key.
Click on cell D9->write “=SUM(D3:D7)” Press “Enter”. Point to the totals.	Click on the cell referenced as D9 and using the same formula find the total.
Point to the total balance under “Cost” and “Spent”	Now, we will display the total balance under “Cost” and “Spent” on a different sheet using cell referencing.
Click on “Sheet 2”	Let’s click on the “Sheet 2” tab. This opens the new sheet.
Click on A1. Type “COMPONENT” inside it.	Now click on the cell referenced as A1 and type the heading “COMPONENT” inside it.
Click on cell B1 Type “BALANCE” inside it.	Click on the cell referenced as B1 and type the heading “BALANCE” inside it.
	Now, let’s enter the names of the components under the heading.
Click on cell A3 Type “COSTS” Pess “Enter”	Click on the cell referenced as A3 and type“COSTS” . Press “Enter”.
Click on cell A4 Type “Spent” and	Below “COSTS”, let’s enter the next component as “SPENT” in the cell referenced A4.
Click on cell B3	Now, click on the empty cell B3.
Point to the cells B3 and B4 Point to the text Cost in A3 and Spent in A4 Point to Sheet1 tab at the bottom.	The cells B3 and B4 will have the total balance under the heading “COST” and “SPENT”, which we calculated in “Sheet 1”. This will be done by referencing.
Click on “=” next to input line.	To make the cell reference in cell B3, click on the “equal to” sign next to the “Input line”.
Click on “Sheet 1” tab.	Now, on the Sheet tab click on “Sheet 1”.
Click on cell C9 which has the total for “Costs”	In this sheet, we will click on the cell C9 which contains the total under the column “Costs”.
Point to input line	Notice, that in the “Input line” the statement “Sheet 1 dot C9”, is displayed.
Click on “Checkmark”next to input line.	Now click on the check mark next to the “Input line”.
Point to the cell B3 which appears in the “Sheet 2”.	Notice, that the grand total of the data under “Costs” in the “Sheet 1” tab is automatically entered into the cell referenced as B3 in the “Sheet 2 “ tab.
	Similarly,we can enter the grand totals of other components through referencing.
Click on Sheet 1 then back on Sheet2	Referencing can be very useful to summarise data if there are many sheets, with a lot of data content.
Show Slide Create Hyperlinks Use Hyperlinks to jump To a different location within a spreadsheet To different files or Even to web sites	Now, let’s learn how to create Hyperlinks in Calc sheets. You can use Hyperlinks to jump To a different location within a spreadsheet To different files or Even to web sites.
Switch to “Personal-Finance-Tracker.ods” Point to “Sheet 1” and then to “Sheet 2”.	In “Personal-Finance-Tracker.ods” the personal finance tracker is in “Sheet 1” and the rest of the content is in “Sheet 2”. Let’s say we want to jump from Sheet 1 to Sheet 2.
Click on “Sheet 1”	First, click on the “Sheet 1” tab.
Click on cell B14 Enter “Sheet 2” inside it.	Here let’s click on the cell referenced as B14 and enter ”Sheet 2”.
Point to “Input line”	You see that the name “Sheet 2” is displayed on the “Input line”.
Select text “Sheet 2” in the input line.	Now select the text “Sheet 2” in the Input Line.
Click on the “Hyperlink” icon on the toolbar.	After selecting the text, click on the “Hyperlink” icon in the toolbar.
Point to the Hyperlink dialog box that appears.	The Hyperlink dialog box appears.
Click on “Document”	On the left side, let’s select the “Document” option.
Click on “Target in document” icon.	Click on the “Target in document” icon in the dialog box.
Point to “Target in document” dialog box.	A new “Target in document” dialog box appears.
Click on the “plus” sign next to the “Sheet” option.	Now, click on the “plus sign” next to the “Sheet” option.
Click on “Sheet 2”.	In the dialog box which appears, click on the “Sheet 2” option.
Click on “Apply” and click “Close”	Now click on the “Apply” button and then click on the “Close” button.
Click on “Apply” and then click on “Close”	Now, from the Hyperlink dialog box, click on “Apply” and then click on “Close”.
Point to highlighted text “Sheet 2”	The “Sheet 1” tab appears in front with the text “Sheet 2” highlighted in the cell.
Click on the text “Sheet 2”	Now, when we click on the text “Sheet 2”, it directly takes us to the sheet where we had entered the balance for Costs. We have created a hyperlink!
Point to the hyperlinked text “Sheet 2” in “Sheet 1”	To remove the hyperlink, first select the hyperlinked text “Sheet 2”.
Right click and click on “Default Formatting”	Now right click and from the context menu, click on the “Default Formatting” option.
Point to the text which no longer is a hyperlink.	The the text is no longer hyperlinked. It is just like any normal text in the document.
Undo the changes.	Let us undo the changes.
Show Slide Number 3 SUMMARY Reference to other sheets in Calc. Use hyperlinks in Calc.	This brings us to the end of the Spoken Tutorial on LibreOffice Calc. To summarize, we learned how to: Reference to other sheets in Calc. Use hyperlinks in Calc.
Show About Slide About the Spoken Tutorial Project Watch the video available at http://spoken-tutorial.org/What_is_a_Spoken_Tutorial It summarises the Spoken Tutorial project If you do not have good bandwidth, you can download and watch it	Watch the video available at the following link It summarises the Spoken Tutorial project If you do not have good bandwidth, you can download and watch it
Show About Slide Spoken Tutorial Workshops The Spoken Tutorial Project Team Conducts workshops using spoken tutorials Gives certificates for those who pass an online test For more details, please write to contact@spoken-tutorial.org	The Spoken Tutorial Project Team Conducts workshops using spoken tutorials. Gives certificates for those who pass an online test For more details, please write to contact at spoken hyphen tutorial dot org
Show Acknowledgement Slide Acknowledgements Spoken Tutorial Project is a part of the Talk to a Teacher project It is supported by the National Mission on Education through ICT, MHRD, Government of India. More information on this Mission is available at http://spoken-tutorial.org/NMEICT-Intro	Spoken Tutorial Project is a part of the Talk to a Teacher project It is supported by the National Mission on Education through ICT, MHRD, Government of India More information on this Mission is available at spoken hyphen tutorial dot org slash NMEICT hyphen Intro
Show About the contributor Slide About the Contributor This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd www.desicrew.in Thanks for joining	This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd Thanks for joining

Contributors and Content Editors

Chandrika