Script | Spoken-Tutorial - User contributions [en]

OBS-Studio/C2/Audio-and-Output-settings-in-OBS/English

2021-10-25T17:22:36Z

Arvindpillai90: Created page with "Title: Audio and Output settings Author: Nikita Misal {| border="2" |- || '''Visual Cue''' || '''Narration''' |- || '''Slide''': Title || Welcome to the '''spoken tutoria..."

Title: Audio and Output settings

Author: Nikita Misal

{| border="2"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide''': Title
|| Welcome to the '''spoken tutorial''' on '''Audio and Output settings'''
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn to '''configure''':
* '''Video '''settings
* '''Output '''settings and
* '''Audio '''settings

|-
|| '''Slide: '''OS and Versions

|| '''OBS Studio '''can '''run''' on any of the following operating systems''':'''

* '''Microsoft Windows 8''' or higher versions
* '''GNU/Linux OS 18.04 '''or higher''' '''and
* '''Mac OS X 10.13 '''or higher versions

|-
|| Slide:
|| This tutorial is recorded using
* '''Windows 10'''
* and '''Firefox web browser'''.

You can use any '''web browser''' of your choice.
|-
|| Slide: High Quality videos

|| In order to produce'''high-quality videos''', it is important to understand:

* How'''video resolution''' matches to'''canvas aspect ratio '''and
* How to avoid'''resampling audio tracks'''.

|-
|| Slide: What is Video resolution
||
* '''Video resolution''' is the image size visible to the viewer.
* Its width and height in'''pixels''' is called ''''Video Resolution''''.
* Usually, a video plays in'''full resolution''' on the'''screen'''.
* It is wise to make'''videos compatible''' with common video players. For eg:'''VLC Player'''

|-
|| Slide: What is Audio Sample rate
|| What is '''Audio Sample rate'''? * Each sound '''stream''' consists of a number of

'''digit samples flow. '''

* That number must exceed at least twice the''' highest frequency''' of the '''sound stream'''.
* Human ears can recognize '''frequencies''' upto '''20000 Hz'''.
* Hence, the most common '''audio sample rates''' are '''44100 Hz''' and '''48000 Hz'''.

|-
|| Only Narration
|| Now let us learn how to set'''video resolution''' for our'''recording.'''

I have already opened the'''OBS studio interface '''in my system.

Please do so on your system.
|-
|| Click on the '''Settings''' button

Point towards the '''Settings''' dialog box
|| At the bottom right, click on the '''Settings''' button.

The '''Settings''' dialog box pops up.
|-
|| Click on the '''Video''' tab

Hover over each option as per the narration
|| On the left side panel, click on the '''Video''' tab.

Under the '''Video''' tab on the right side, 4 options are displayed.
|-
|| Slide: Video Options
|| '''Base (Canvas) Resolution '''defines the Canvas preview aspect ratio and '''Canvas size'''.

'''Output (Scaled) Resolution '''defines the main '''Output resolution.'''

'''Downscale Filter''' specifies the '''filters''' used in '''scale operations'''.

This '''filter''' changes how '''OBS''' shrinks the '''video'''.

It decides what details are to be kept and which to discard in the '''video'''.

'''Common FPS Values '''specifies sets of''' frame rates (fps).'''

It is the '''rate''' at which OBS Studio will '''render''' its output.
|-
|| Click on the drop down next to '''Base (Canvas) Resolution'''

Select '''1920 x 1080'''
|| Now on the '''OBS interface''', click on the drop-down next to '''Base (Canvas) Resolution.'''

'''Resolution''' options are displayed.

I will select '''1920 x 1080.'''
|-
||

Type, 1920 x 1080
|| Next, we will change the value of our '''Output (Scaled) Resolution.'''

We want our '''output''' to be the same size as the''' Canvas resolution.'''

So, I will type '''1920 x 1080''' here.
|-
|| Click on the drop down next to '''Downscale Filter '''>>''' '''select '''Bilinear'''

Select '''30fps'''
|| Click on the drop-down next to '''Downscale Filter '''and select '''Bilinear.'''

Under '''Common FPS Values, '''I will select '''30fps.'''
|-
|| Click on the '''Apply''' button >> click on the '''OK''' button
|| Click on the '''Apply''' button and then on the '''OK''' button at the bottom of the window.
|-
|| '''Controls >> Start Recording''' button

|| Under the '''Controls''' panel on the right, click on the '''Start Recording''' button.

Minimize the '''screen''' and record any other window of your choice.
|-
|| Open Firefox web browser >> '''Spoken Tutorial website'''.
|| I am '''recording''' my '''Firefox web browser''' screen.

I will briefly record the '''Spoken Tutorial website'''.
|-
||

Click on the '''Stop Recording '''button
|| After '''recording''' is done, switch back to the '''OBS''' window.

And click on the '''Stop Recording '''button.
|-
|| Click on '''File'''

Click on '''Show Recordings'''
|| To locate the '''recording''', click on the '''File''' menu on the top left of the '''OBS''' interface.

Click on '''Show Recordings.'''
|-
|| Right-click on it >> '''Open with''' option

Select '''VLC player'''

|| To view the '''recording''', first right-click on it and from the '''context menu,''' select '''Open with''' option.

From the sub-menu, select any '''Player''' available on your system.

I will select''' VLC player.'''
|-
|| Only narration
|| Notice that the '''video''' is not very clear even in '''1920 x 1080 resolution.'''

The '''Downscale Filter''' has degraded the '''output quality'''.

This is done in order to '''render''' the '''video''' quickly.
|-
|| Switch to '''OBS''' >> click on '''Settings'''

Point towards settings dialog box
|| Go back to the'''OBS''' window.

At the bottom right under '''Controls, '''click on the '''Settings''' button.

The '''Settings''' dialog box pops up.
|-
|| Click on the Video tab

Under''' Downscale Filter '''select''' Lanczos'''
|| On the left panel, click on the '''Video''' tab.

Under''' Downscale Filter, '''select''' Lanczos.'''
|-
|| Click on the '''Apply''' button >> click on the '''OK''' button
|| Click on the '''Apply''' button and then on the '''OK''' button at the bottom of the dialog box.
|-
|| Controls>>Start Recording button
|| Under the '''Controls''' panel on the right side, click on the '''Start Recording''' button.
|-
||

Open Firefox web browser >> '''Spoken Tutorial website'''.
|| Now, go to the same screen as we did earlier.

Here, I have already opened the '''Spoken tutorial website.'''
|-
||

Click on the '''Stop Recording '''button
|| After '''recording''' is done, switch back to the '''OBS''' window.

And click on the '''Stop Recording '''button.
|-
|| Click on '''File >> '''Click on '''Show Recordings'''

Right-click on it >> '''Open with''' option >> Select '''VLC'''
|| At the top left, click on the '''File menu''' and select n '''Show Recordings.'''

'''Play''' the '''video''' as demonstrated earlier.
|-
|| Point towards the video
|| Notice, the '''quality''' of the '''video''' has changed and the '''file size''' has increased.
|-
|| Point towards '''Downscale filter''' option
|| Depending on the '''video quality''' and '''file size''' we can adjust the '''Downscale filter''' option.

'''Downscale filter '''can be adjusted according to:
* '''Video quality'''
* '''File size'''

|-
| | Only narration
|| Next, let’s learn about'''Audio properties''' in'''OBS.'''
|-
||

Switch to '''OBS''' >> click on '''Settings'''

Point towards settings dialog box
|| Go back to the'''OBS''' window.

At the bottom right under '''Controls, '''click on the '''Settings''' button.

The '''Settings''' dialog box pops up.
|-
|| Click on the '''Audio''' tab

Select''' 44.1khz '''and''' Stereo'''

Point towards '''Global Audio Devices''' by default '''Desktop''' '''Audio'''

|| On the left panel, click on the '''Audio''' tab.

Under the '''General''' section, let’s use '''Sample rate''' of '''44.1 kHz''' and '''Channels''' as '''Stereo.'''

In my case under '''Global Audio''' '''Devices''' by default '''Desktop''' '''Audio''' is set to '''Default.'''

It may vary depending on your system settings.
|-
|| Point towards '''Mic/Auxiliary Audio'''
|| '''Mic/Auxiliary Audio'''is set to '''Default '''and everything else is '''Disabled.'''
|-
|| Click on the '''Apply''' button>> click on the '''OK''' button
|| Click on the '''OK''' button.
|-
|| Point towards the '''Restart OBS''' dialog box

Click on the '''Yes''' button
|| The '''Restart OBS''' dialog box pops up.

Here, click on the '''Yes''' button.
|-
|| Point towards '''OBS is already running''' dialog box

Click on the'''Launch anyway''' button
|| If '''OBS''' doesn’t '''restart''' correctly, the “'''OBS is already running”''' dialog box appears.

Here, click on the'''Launch anyway''' button.
|-
||
|| We see that the '''OBS''' window restarts with our new '''configuration.'''
|-
| | Only narration
|| Next, let's learn to add'''filters''' to our'''Audio.'''
|-
|| Select '''Scene 002'''.

'''Sources''' panel select the '''Arvind’s external mic'''
|| Select '''Scene 002'''.

In the '''Sources''' panel, select '''Arvind’s external mic.'''
|-
|| '''Audio mixer panel, '''the''' Device '''option is set to''' Default.'''

Select''' Microphone (Realtek High Definition Audio)'''
|| Above the''' Audio mixer panel, '''the''' Device '''option is set to''' Default.'''

Click on the drop-down next to '''Default.'''

Then select '''Microphone (Realtek High Definition Audio).'''
|-
||

Point towards thenew '''Audio''' track
|| It may vary depending on your '''system settings''' and the '''headset '''you are using.

Note: If no '''Audio''' is detected, check your '''system settings''' and add an '''audio input'''.

We see a new '''Audio track''' gets inserted in the '''Audio mixer '''panel.
|-
|| Click on'''Start recording '''button
|| Now click on the'''Start recording''' button at the bottom right.

I will narrate the following sentences “'''Welcome to the spoken tutorial on Audio and Output settings'''

'''In this tutorial, we will learn:'''
* '''Video settings'''
* '''Output Settings'''
* '''Audio settings'''

|-
|| Click on the '''Stop recording '''button
|| Click on the '''Stop recording '''button.
|-
|| Click on'''File >> Show recordings'''

|| Then click on the '''File''' menu at the top left of the '''OBS''' interface.

Click on '''Show Recordings.'''
|-
|| Right click on it >> Open with option >> Select '''VLC'''
|| '''Play''' the '''video''' as demonstrated earlier.
|-
|| Point towards the audio
|| Notice that the '''audio''' has '''disturbance''' in it.

We will remove this by adding some '''filters''' to our '''audio'''.
|-
|| Click the '''gear''' icon next to the '''volume''' button

>>Select '''Filters'''
|| In the '''Audio Mixer''' window, click the '''gear''' icon next to the '''volume''' button.

From the '''context menu,''' select '''Filters.'''
|-
|| Point towards '''Audio Input Capture'''
|| '''Filters for ‘Arvind’s external mic’''' window appears.
|-
|| Left side >> click the '''+''' button >> Select the '''Noise suppression''' filter
|| To add a '''filter''', click the '''+ plus''' button on the left side of the window.

Let us select the '''Noise suppression filter.'''
|-
|| Point towards '''Filter name'''

click on the '''OK''' button
|| A dialog box saying “'''Filter Name”''' appears.

I will keep the name as it is and click on the '''OK''' button.
|-
|| Right side >> click on '''Method '''drop-down >> select '''RNNoise'''
|| On the right side, click on the drop-down next to the '''Method''' option.

Here, we will select '''RNNoise.'''
|-
|| Click on the '''+''' button >> Select the '''Compressor''' filter
|| Then again click on the '''+ plus '''button on the left side and select the '''Compressor filter'''.
|-
|| Point towards '''Please specify the name of the filter'''

Click on the '''OK''' button
|| A dialog box saying “'''Please specify the name of the filter”''' appears.

I will keep the name as it is and click on the '''OK''' button.
|-
|| Hover over each option
|| Here we see different options with adjusting '''levels.'''

We will keep them as they are.
|-
|| Click on the '''Close''' button
|| And click on the '''Close''' button at the bottom of the window.
|-
|| Click on '''Start recording '''button >> Narrate
|| Now click on the '''Start''' '''recording '''button.

I will again narrate the same sentences as earlier.
|-
|| '''Stop recording >> File '''>>'''Show recordings'''

Right-click on it >> '''Open with''' option >> Select '''VLC player'''
|| Then click on the '''Stop recording '''button.

And '''play''' the '''recording''' as demonstrated earlier.
|-
| |
|| Notice the difference in the'''audio'''.
|-
|| Only narration
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt how to '''configure''':

* '''Video settings'''
* '''Output settings '''and
* '''Audio settings'''

|-
|| '''Slide''': Assignment

|| As an assignment

* Try different '''Base (Canvas) Resolution '''and''' Output (Scaled) Resolution settings'''
* Use the '''Downscale filter''' and note the difference in the '''quality''' of the output.
* Add other '''Noise filters''' to your '''audio''' and make a note of the difference.

|-
|| Slide: About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken tutorial workshops
||
* We conduct workshops using spoken tutorials and give certificates.
* For more details, please contact us.

|-
|| '''Slide''': Answers for THIS Spoken Tutorial
|| Pls post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
|| Spoken Tutorial project is funded by the Ministry of Education (MoE), Govt. of India
|-
| |
| | This is Arvind Pillai along with Nikita Misal from IIT Bombay signing off.

Thank you for joining.
|-
|}

OBS-Studio/C2/Getting-familiar-with-OBS/English

2021-10-25T16:23:58Z

Arvindpillai90: Created page with "Title: Getting familiar with OBS Author: Nikita Misal {| border="2" |- || '''Visual Cue''' || '''Narration''' |- || '''Slide''': Title || Welcome to the '''spoken tutorial''..."

Title: Getting familiar with OBS

Author: Nikita Misal

{| border="2"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide''': Title
|| Welcome to the '''spoken tutorial''' on '''Getting familiar with OBS interface'''
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn:* About the '''OBS''' work''' '''area

We will also learn to
* Use '''Edit '''menu
* Take '''Screenshots'''
* Use '''Filters '''in OBS
* Use '''Transform '''options and
* '''Cropping '''

|-
|| '''Slide: '''OS and Versions

|| '''OBS Studio '''can '''run''' on any of the following operating systems''':'''

* '''Microsoft Windows 8''' or higher versions
* '''GNU/Linux OS 18.04 '''or higher''' '''versions
* '''Mac OS X 10.13 '''or higher versions

|-
|| '''Slide:''' Prerequisite

|| To practice this tutorial, you should have basic knowledge of '''computers.'''

You should also know how to use a '''web browser'''.
|-
|| '''Slide:''' System Requirements
|| This tutorial is recorded using
* '''Windows 10'''
* '''Firefox web browser'''.

You can use any '''web browser''' of your choice.

The steps demonstrated are exactly the same on '''Linux''' and '''Mac OSX'''.
|-
|| Click on '''Start menu>> '''Type '''OBS>> '''Double-click on '''OBS Studio icon'''
|| Let us open '''OBS Studio.'''

For that, click on the Search''' icon''' at the bottom left of the screen.

Type '''OBS''' in the '''search bar''' and press '''Enter'''.

Double-click on the '''OBS''' icon to launch it.
|-
|| Point to the '''Scenes''' and the associated '''Sources'''
|| We see that the interface reflects all the activities done in the previous tutorial.

We see '''scenes''' with the names '''Opening Scene 001''' and '''Scene 002'''.

We also see '''sources''' listed as '''Screen capture 001''', '''Screen Capture 002'''

And '''Arvind’s external mic'''
|-
|| Only narration
|| First of all, let us learn how to '''Lock Screen Preview''' using the '''Edit menu.'''
|-
|| Click on '''Edit '''menu >> Click on''' Lock Preview '''option >> Point towards '''✓''' symbol
|| To do so, click on the '''Edit menu''' on the '''menu bar.'''

Then from the sub-menu, click on the''' Lock Preview '''option.
|-
|| Click on '''Edit '''menu >> Point to the''' Lock Preview '''option >> Point towards '''✓''' symbol
|| Click on Edit menu, then move cursor towards Lock Preview to view the tick mark

A '''tick mark''' symbol appears in front of''' '''the '''Lock Preview '''option.
|-
|| Point towards '''✓''' symbol

Text on screen:“Lock Preview prevents the editing of any '''scene''' by accident.”
|| The '''tick mark '''indicates that we cannot edit the '''source position '''or '''size '''in the '''preview window.'''

This '''setting''' prevents the editing of any '''scene''' by accident.
|-
|| Click on '''Edit '''menu >> Click on the''' Lock Preview '''
|| Click on '''Lock Preview '''option again to enable editing in the '''Preview '''window.
|-
|| Only narration
|| Next, let us learn about '''Preview Scaling.'''
|-
| | Right-click on the '''preview area'''

'''Preview Scaling'''>>'''Output(1024*614)'''

| style="background-color:transparent;border:0.75pt solid #808080;padding:0.035cm;" | To scale the '''Preview '''window to a fixed size of '''output''', right-click on the '''Preview area.'''

From the '''context menu,''' select '''Preview Scaling.'''

From the sub-menu, select''' <span style="background-color:transparent;color:#252525;">Output (1280x720) '''<span style="background-color:transparent;color:#252525;">option.
|-
||
|| On my system, '''1280x720''' is the current output '''resolution'''.

Choose the option that appears in your system.
|-
|| Point towards the enlarged '''Preview'''

Hold '''Spacebar''' and drag the window first to the left and then to the right
|| Notice that the '''Preview '''size has enlarged.

Hold '''Spacebar '''key and with the mouse drag and navigate the '''Preview''' window.
|-
|| Only narration
|| Next, let us learn how to take a '''screenshot '''in '''OBS.'''
|-
|| Point to the '''Scene '''menu

Right-click on '''Opening-scene-001 '''>> select '''Screenshot (Scene)'''
|| To do so, go to the '''Scene menu''' at the bottom left of the screen.

Right-click on '''Opening-scene-001''', and from the context menu select '''Screenshot (Scene).'''
|-
|| Click''' File '''>>''' Show Recordings '''

And point towards the''' PNG '''files
|| All '''screenshots''' are saved in '''PNG '''format under the same directory as the '''recordings'''.
|-
|| Only narration
|| Likewise, try taking some more '''screenshots''' of other '''Sources '''on your own.
|-
|| Only narration
|| Next, let us learn about '''filters '''in '''OBS'''.
|-
|| Right-click on '''Opening-scene-001 '''>> select

Context menu select '''Filters'''
|| To apply a '''filter''', under the '''Sources '''pane right-click on '''Opening-scene-001.'''

From the '''context menu''' select '''Filters.'''
|-
|| Point towards '''Filters '''button on the '''Source toolbar '''
|| Alternatively, you can click on the '''Filters '''button on the '''Source toolbar '''too.
|-
|| Point towards '''Opening-scene-001''' dialog box
|| '''Filters for Opening-scene-001''' dialog box opens in the first case

Whereas, '''Filters for Screen Capture 001''' opens up in the second case

This is because, in the second case we have selected the source
|-
|| Point towards '''Effect Filters'''
|| On the left side we see '''Effect filters.'''
|-
||

Click on the '''+ '''button
|| All the '''filters''' that we add will be visible here.

Let us see an example.

On the bottom left click on the '''+ '''button.
|-
|| Point towards all the '''filters''' >> Select the''' Luma key'''
|| A '''context menu''' with a list of '''filter '''options opens up.

Here, we will select the''' Luma key.'''
|-
|| '''Filter name '''dialog box

Click on the '''OK '''button
|| '''Filter name '''dialog box pops up.

I will not change anything here and then click on the''' OK '''button.
|-
|| Point to '''Luma key filter settings'''

Change the value of '''Luma Max''' to '''0.7000 '''
|| On the right side, a number of '''Luma key filter settings '''appears.

Here, let’s change the value of '''Luma Max''' to '''0.7000 '''

We will leave the other options as they are.
|-
|| Click on the '''Close '''button
|| Now, click on the '''Close''' button at the bottom right of the dialog box to complete the changes.
|-
|| Point towards the white''' '''colors turned to '''greyish '''black
|| In the '''Preview window '''notice that the white''' '''colors have turned to greyish black now.
|-
|| Press''' CTRL Z'''
|| Select the '''Preview Area''' and press''' CTRL Z''' to undo the changes.
|-
|| Only narration
|| Now, we will learn about '''Transform '''options in '''OBS.'''
|-
|| Slide: Transform
||
* '''Transform''' option changes the appearance of the video
* It helps control the '''size''', '''mirroring''', '''rotation''' and '''cropping''' of the video

|-
|| Right-click on '''Sources '''>> select '''Display Capture'''

Context menu select '''Transform'''
|| To transform '''Source''', right-click on the '''Screen Capture 001 '''in the '''Sources''' list pane.

From the '''context menu''' select '''Transform.'''
|-
|| Click on the '''Edit '''menu >> '''Transform'''

Click on '''Edit Transform'''
|| Alternately, click on the '''Edit '''menu on the''' Menu bar''', and click on '''Transform.'''

From the '''context menu,''' click on '''Edit Transform.'''
|-
|| Point towards '''Scene Item Transform '''dialog box

Rotation >> 90
|| '''Scene Item Transform '''settings dialog box appears.

Under '''Rotation''', we’ll change the value to '''90'''.
|-
|| Click on the arrow besides''' Position Alignment'''

Select '''Center-Left'''
|| Then click on the arrow besides the''' Position Alignment '''field'''.'''

From the drop-down, select '''Center-Left.'''
|-
|| Click on the '''Close '''button
|| Click on the '''Close '''button at the bottom right of the dialog box to complete the changes.
|-
|| Point towards the '''Preview screen'''
|| Notice that in the '''Preview '''window''' '''the alignment of the '''Scene '''has changed.
|-
|| Only narration
|| This method of '''transformation''' is very useful while creating long duration video films.

It helps to keep all the scenes in uniform size and proportion throughout the video.
|-
|| Press '''CTRL Z '''
|| Press '''CTRL Z '''to undo the changes.
|-
|| Only narration
|| Next, let’s perform '''manual transformation''' of the '''source''' in the '''Preview''' window.

We do '''manual transformation''' to resize the screen visually as per our requirement.
|-
| style="color:#252525;" | Move the cursor a per the narration
|| Move the cursor over a small''' red square handle''' at the bottom right of the '''source bounding box.'''
|-
|| Click and drag the mouse as per the narration >> release''' '''mouse button
|| Click and drag the mouse diagonally towards the left side and release the mouse button.

This will resize the screen keeping the original height and width proportions.
|-
|| Press '''CTRL Z'''
|| Press '''CTRL Z''' to undo the changes.
|-
| style="color:#252525;" | Point to the side handles for height and then for width
|| We can also change only the height or width by resizing using the side '''square handles'''.
|-
|| Only narration
|| Next, let us learn how to '''crop''' the screen in '''OBS.'''
|-
|| Slide: Crop
||
* '''Crop''' option removes unwanted portions of a video to create '''focus''' on the composition
* We can crop an image from either '''left''', '''right''', '''top''' or '''bottom'''

|-
|| Press and hold the '''Alt '''key
|| To '''crop''', press and hold the '''Alt '''key on the '''keyboard.'''
|-
|| Move the cursor a per the narration

Click and drag the mouse as per the narration
|| Move the cursor over the '''small red square '''at the left side of the '''source bounding box.'''

Click and drag the mouse towards the right side.
|-
||

Point towards '''green '''color

|| Notice at the left, the '''bounding box''' turns''' green '''in color.

Which means the '''cropped''' side of the '''bounding box''' is in '''green '''color.
|-
|| Release the mouse button + '''Alt key'''
|| Now release the mouse button and the '''Alt key.'''

This is how we '''crop''' the screen and remove unnecessary footage.
|-
|| Press '''CTRL Z'''
|| Press '''CTRL Z''' to undo the changes.
|-
|| On '''OBS''' >> click '''X''' icon
|| Let’s now close the '''OBS''' interface by clicking on the '''X''' icon.
|-
|| Only narration
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt:

* About the '''OBS''' work''' '''area

We will also learnt to* Use '''Edit '''menu
* Take '''Screenshots'''
* Use '''Filters '''in OBS
* Use '''Transform '''options and
* '''Cropping'''

|-
|| '''Slide''': Assignment

|| As an assignment

* Scale the '''Preview screen''' to the '''maximum '''size.
* Navigate the screen using '''Spacebar'''
* Apply the '''color correction filter'''
* '''Adjust '''the '''settings '''and observe the difference in the colors
* '''Transform '''the screen to '''Rotation 180 '''

|-
|| Slide: About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken tutorial workshops
||
* We conduct workshops using spoken tutorials and give certificates.
* For more details, please contact us.

|-
|| '''Slide''': Answers for THIS Spoken Tutorial
|| Pls post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
|| Spoken Tutorial project is funded by the Ministry of Education (MoE), Govt. of India
|-
| |
| | This is Arvind Pillai along with Nikita Misal from IIT Bombay signing off.

Thank you for joining.
|-
|}

OBS-Studio/C2/Basics-of-working-with-OBS/English

2021-10-25T12:17:47Z

Arvindpillai90: Created page with "Title: Basics of working with OBS Author: Nikita Misal {|border="2" |- || '''Visual Cue''' || '''Narration''' |- || '''Slide''': Title || Welcome to the '''spoken tutorial'..."

Title: Basics of working with OBS

Author: Nikita Misal

{|border="2"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide''': Title
|| Welcome to the '''spoken tutorial''' on '''Basics of working with OBS.'''
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn how to:
* Work with '''sources '''
* '''Rename '''a''' scene'''
* '''Remove '''a''' scene'''
* Switch '''scene's layout'''
* Add a new '''Layer '''and
* Change '''themes'''

|-
|| '''Slide: '''OS and Versions

|| '''OBS Studio '''can '''run''' on any of the following operating systems''':'''

* '''Microsoft Windows 8''' or higher versions
* '''GNU/Linux OS 18.04 '''or higher versions and
* '''Mac OS X 10.13 '''or higher versions

|-
|| '''Slide:''' Prerequisite

|| To practice this tutorial, you should have basic knowledge of computers'''.'''

You should also know how to use a web browser.
|-
|| '''Slide:''' System Requirements
|| This tutorial is recorded using
* '''Windows''' 10 and
* '''OBS''' '''Studio''' version: 27.0.1
* '''Firefox Web''' browser
* We also need a working '''Internet''' connection for the '''installation'''.

You can use any '''web browser''' of your choice.

The steps demonstrated are exactly the same on '''Linux''' and '''Mac OSX'''.
|-
|| Click on '''Start menu>> '''Type '''OBS>> '''Double-click on '''OBS Studio icon'''
|| Let us open '''OBS Studio.'''

For that, click on '''Start menu''' at the bottom left of the screen.

Type '''OBS''' in the '''search bar''' and press '''Enter'''.

Double-click on the '''OBS''' icon to launch it.
|-
|| Only narration

Point towards each component as per the narration
|| The '''OBS work area''' consists of the following components:
* '''Menu bar'''
* '''Canvas preview''' area
* '''Scene management and Control '''options

|-
|| Point to the '''Scenes''' and the associated '''Sources'''
|| We see that the interface reflects all the activities done in the previous tutorial.

We have 2 '''scenes''' and each has a '''source''' associated with it.
|-
|| Only narration
|| '''A source''' inside one '''scene''' can be moved to a different position.
|-
|| Click on '''Scene 002 '''in the '''Scenes '''list
|| Click on '''Scene 002 '''in the '''Scenes '''list'''.'''
|-
|| Move the cursor to the '''Preview '''area
|| Move the cursor to the '''Preview '''area.
|-
|| Click and hold the left mouse button at the center of the '''red rectangle'''

Drag and release
|| Click and hold the left mouse button at the center of the '''red rectangle'''.

Drag it to a new position and release the mouse button.
|-
|| Click on '''Scene 001 '''in the '''Scenes '''list
|| To see the difference, click on '''Scene 001 '''in the '''Scenes '''list.

It is exactly where it was earlier.
|-
|| Click on '''Scene 002 '''in the '''Scenes '''list
|| Now click on '''Scene 002 '''in the '''Scenes '''list.

It has moved to the new location given by us.
|-
|| Only narration
|| In large projects, for better cross-referencing, we may need to rename '''scenes.'''
|-
|| Right-click on '''Scene 001''' in the '''Scenes''' list

Choose '''Rename'''

Type new name as '''Opening-scene-001'''>>'''Enter'''
|| Right-click on the '''scene''' in the '''Scenes''' list which you wish to rename.

I will right-click on '''Scene 001'''.

Choose the '''Rename''' option. '''A blinking''' cursor will appear in the name of the '''scene.'''

I will type the new name as '''Opening-scene-001''' and press '''Enter.'''
|-
||

Right-click on the '''source Screen Capture (XSHM)''' >> '''Rename''' >> '''Screen Capture 001'''

press '''Enter'''
|| Likewise we can also rename the associated '''sources'''.

Right-click on the '''source''', select '''Rename''' option and type '''Screen Capture 001'''.

And press '''Enter'''
|-
|| Right-click on the '''source Screen Capture (XSHM) 2 '''>> '''Rename''' >> '''Screen Capture 002'''
|| Repeat the same action for renaming the '''source''' in '''Scene 002''' as '''Screen Capture 002.'''
|-
|| Only narration
|| Next, let us learn how to remove a '''scene''' in '''OBS.'''
|-
|| Click on '''Scene 002 '''in the '''Scenes '''list.
|| First, click on '''Scene 002 '''in the '''Scenes '''list.
|-
| | Click '''-''' icon on the toolbar of the Scene list
| | To completely remove a '''scene''', click the '''Remove''' icon on the '''toolbar''' of the '''Scene''' list.

This appears as the minus sign at the bottom of the '''Scene '''list.
|-
| | Point to''' Confirm Remove''' dialog box

Point to the '''Yes''' button but don’t click
| | '''Confirm Remove''' dialog box appears.

Clicking on the '''Yes''' button will remove the selected '''scene'''.
|-
| | Click '''No '''button
| | However, we click on the '''No '''button as we need both the '''scenes''' for further demonstration.
|-
|| Point to the '''Scenes '''list arrow icons at the bottom
|| We can move the '''scenes''' up or down using the arrow icons at the bottom.
|-
|| Select '''Scene 002''' and click on the up arrow.
|| Select '''Scene 002''' and click on the up arrow.
|-
| | Click on the down arrow
| | Now click on the down arrow.
|-
| |
|| The '''scene''' moves accordingly.
|-
|| Point to '''Sources''' list arrow icons at the bottom
|| The same actions can be performed in the '''Sources''' list also.

You can try this on your own later for your understanding.
|-
|| Only narration
|| Next, let us learn how to switch a''' Scene’s layout.'''
|-
|| Slide

Point towards list in OBS
|| The '''Scenes '''list pane has two main '''layouts: '''
* '''List'''
* '''Grid'''.

The '''scenes '''in the '''Scenes '''list can be represented as a '''list entry''' or as a '''compact button '''in a grid.

The default '''layout''' is '''list'''.

|-
|| Right-click on '''Scene 002''' in the '''Scenes '''list >> '''context menu''' select '''Grid Mode '''
|| To switch between different '''Scenes layouts, '''right-click on any '''scene '''in the '''Scenes '''list pane.

From the '''context menu, '''select '''Grid Mode.'''
|-
| | Point to the buttons in the grid
|| Observe that the '''scenes''' are now represented as '''buttons''' in a '''grid'''.
|-
|| Right-click on '''Scene 002''' in the '''Scenes '''list >> '''context menu''' select '''List Mode '''
|| Once again right-click on any '''scene '''in the '''Scenes '''list pane.

From the '''context menu, '''select '''List Mode.'''
|-
| | Point to the list of scenes
|| Observe that the '''scenes''' are now one below the other as a list.
|-
|| Only Narration
|| Next, let us learn about '''Layers'''.
|-
|| Slide '''Layers'''
|| What are '''Layers'''* Each '''source''' added to '''OBS''' lies on a different '''layer'''.
* '''OBS''' uses '''layers''' combination to render the output videos.
* These can be either '''streamed''' or recorded.
* '''Layers''' can have different properties: size, transparency, color overlay, etc.

|-
||

Point to Sources Panel>>Click on +

|| Now let us learn how to add a new '''layer''' in '''OBS.'''

We will add a new '''layer''' to '''Scene 002.'''

A new '''layer''' can be added in the '''OBS Sources list''' via the''' Add '''button which is the plus icon.
|-
|| Select '''Audio Input Capture'''
|| On clicking, it shows a list of options for '''recording'''.

We’ll select '''Audio Input Capture.'''
|-
|| Select '''Create New Radio button'''

Select the text “'''Audio Input Capture'''” >> Rename this as “'''Arvind’s external mic'''”.

Click on the''' Ok '''button
|| In the '''Create/Select Source''' dialog box, the '''Create new''' radio button is selected by default.

It shows the text “'''Audio Input Capture'''”.

It is advisable to rename the '''layer''' for easy reference later.

So, I will rename this as “'''Arvind’s external mic'''”.

Click on the '''Ok '''button at the bottom of the dialog box.
|-
|| Point towards '''Audio Input Capture dialog box'''

Click on the dropdown next to the '''Device''' section

Select the '''Microphone''' from your device.
|| '''Properties for Arvind’s external mic’ '''dialog box opens up.

Click on the dropdown next to the '''Device''' section.

Select the '''Microphone''' from your device.

|-
|| Slide
|| If you do not see any option in the drop-down, go to '''System settings.'''

Here check if the '''input sound settings''' are configured properly.

Check if the '''microphone''' is working properly.

If not, you may have to restart the system.
|-
|| Select '''Microphone (Realtek High Definition Audio) '''

Click on the''' Ok '''button
|| In my case, I will select '''Microphone (Realtek High Definition Audio) '''

The options may vary depending on your system and the attached headset you are using.

After selecting, click on the '''Ok '''button at the bottom of the dialog box.
|-
|| Point to '''Arvind’s external mic'''
|| Observe the new '''layer''' named '''Arvind’s external mic '''in the '''Sources '''list.
|-
||

Select '''Audio Input Capture'''
|| Likewise, to delete an existing''' layer,''' first select the '''layer '''you want to delete.

I will select the newly created '''Arvind’s external mic layer.'''
|-
|| Press''' delete '''or minus sign

|| Then press the '''delete''' icon which is the '''minus''' sign at the bottom of the '''Sources''' list.
|-
|| Point to''' Confirm Remove''' dialog box

Click on the '''Yes''' button.
|| '''Confirm Remove''' dialog box appears.

Click on the '''Yes''' button.
|-
|| Press '''Ctrl + Z''' to undo the changes
|| Press '''Ctrl + Z''' to undo this change.
|-
| style="border:0.75pt solid #808080;padding:0.176cm;" | Only Narration
| | Next, we will learn about '''Themes '''in '''OBS.'''

'''OBS Studio''' can use different '''programme themes.'''

The '''Dark theme''' is suitable for evening time streaming, while the '''System theme''' is versatile.
|-
|| '''File >> Settings'''

Point towards '''Settings '''dialog box.
|| Select the '''File '''option on the '''Standard Toolbar.'''

Click on the '''Settings '''option''' '''to open the '''Settings '''dialog box.
|-
|| Point towards the '''General '''tab.

Drop-down besides '''Theme'''

Select '''System'''

Click on the '''Apply '''and '''OK '''button
|| By default, the '''General '''tab is selected.

Under '''General '''options, click on the drop-down besides '''Theme.'''

From the options, select '''System.'''

At the bottom, first click the '''Apply '''button''' '''and then the '''OK '''button to save the changes.

|-
||
|| Observe the '''theme''' changes in the '''OBS''' interface.
|-
|| On '''OBS''' >> click '''X''' icon
|| Let’s now close the '''OBS''' interface by clicking on the '''X''' icon.
|-
| style="border:0.75pt solid #808080;padding:0.176cm;" | Only Narration
| style="border:0.75pt solid #808080;padding:0.176cm;" | This brings us to the end of this tutorial.

Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learned:

* Work with '''sources '''
* '''Rename '''a''' scene'''
* '''Remove '''a''' scene'''
* Switch '''scene's layout'''
* Add a new '''Layer '''and
* Change '''themes'''

|-
|| Slide: About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken tutorial workshops
||
* We conduct workshops using spoken tutorials and give certificates.
* For more details, please contact us.

|-
|| '''Slide''': Answers for THIS Spoken Tutorial
|| Pls post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
|| Spoken Tutorial project is funded by the Ministry of Education (MoE), Govt. of India.
|-
| |
| | This is Arvind Pillai along with Nikita Misal from IIT Bombay signing off.

Thank you for joining.
|-
|}

OBS-Studio/C2/Installation-of-OBS-in-Linux/English

2021-10-11T09:06:10Z

Arvindpillai90: Created page with "Tutorial Name: Installation of OBS in Windows Author: Arvind Pillai Novice reviewer: Nancy Varkey Domain reviewer: Nancy Varkey {| border="2" |- || '''Visual Cue''' || ''..."

Tutorial Name: Installation of OBS in Windows

Author: Arvind Pillai

Novice reviewer: Nancy Varkey

Domain reviewer: Nancy Varkey

{| border="2"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| Slide: Title Slide

|| Welcome to this tutorial on the '''Installation of OBS Studio in Linux OS.'''
|-
|| Slide: Learning Objectives

|| In this tutorial, we will learn to
* Install '''FFmpeg'''
* Install '''v4l2loopback''' driver
* Enable the '''multiverse''' '''repo''' in '''Ubuntu's Software Centre''' and
* Install '''OBS Studio'''in the '''Linux''' Operating System.

|-
|| Slide: Learning Objectives

|| We will also learn about
* '''OBS Studio''' workspace
* '''Scenes''' and '''Sources''' in '''OBS '''and
* How to start and stop a '''recording''' in '''OBS'''

|-
| | '''Slide:''' Prerequisite

| | To practice this tutorial, you should have basic knowledge of '''computers.'''

You should also know how to use a '''web browser'''.
|-
|| Slide: System Requirement

|| This tutorial is recorded using
* '''Ubuntu''' '''Linux''' OS version 18.04 and
* '''OBS''' '''Studio''' version: 27.0.1
* We also need a working '''Internet''' connection for the '''installation'''.

|-
|| Narration only
|| Now, let’s begin to '''install OBS''' in '''Linux OS'''.

The entire process may take some time, depending upon your '''Internet''' speed.
|-
|| '''SLIDE: Installation Steps'''
|| Before '''installing OBS,''' we need to '''install''' a few other components.

First, we will see how to''' install FFmpeg''' in our system.

We will be '''installing''' all the components and '''OBS''' through the '''terminal'''.
|-
|| Press''' Ctrl + Alt + T''' keys together
|| Open the '''terminal''' by pressing''' Ctrl + Alt + T''' keys simultaneously.
|-
|| Point to the Terminal.
|| The '''Terminal''' opens up.
|-
|| Type '''sudo apt install ffmpeg'''

Press''' Enter '''key
|| To install '''FFmpeg''' type '''sudo apt install ffmpeg'''

And press''' Enter'''.
|-
|| Enter System password

Press '''Enter'''
|| Enter the '''system password''' if prompted and then again press '''Enter'''.
|-
|| Type Y
|| If asked whether to continue, type '''Y''' and press '''Enter.'''
|-
|| Point to the '''Terminal'''.
|| '''FFmpeg''' has been installed now. Let’s crosscheck.
|-
|| Type '''ffmpeg -version'''

Scroll up and highlight the '''ffmpeg''' version.

|| On the '''Terminal, '''type '''ffmpeg -version'''

Scroll up, here we can see the version of '''ffmpeg''' installed.

You may see a different version number when you do the installation.

This output indicates that '''FFmpeg''' is successfully '''installed'''.
|-
|| Narration Only
|| If we want '''virtual camera support''', we will need to '''install v4l2loopback-dkms'''

Do this by typing the following '''command.'''
|-
|| Type '''sudo apt install v4l2loopback-dkms'''

>> Press '''Enter'''
|| '''sudo apt install v4l2loopback-dkms'''

Press '''Enter'''
|-
|| Type Y
|| If asked whether to continue, type '''Y''' and press '''Enter.'''
|-
|| Point to the '''Terminal'''.
|| We can see that the '''v4l2loopback driver''' is '''installed'''.
|-
|| Narration Only
|| Now let's''' install OBS '''with the following '''commands'''.

First we will update the '''repositories.'''
|-
|| Type '''sudo apt update'''

Press''' Enter '''Key
|| On the '''Terminal''', type the '''command''' -

'''sudo apt update'''

Press''' Enter'''.
|-
|| Type Y
|| If asked for the '''system password''', type the '''password''' and press '''Enter.'''
|-
|| Narration Only
|| Next let's add '''OBS project repositories'''.
|-
|| Type '''sudo add-apt-repository ppa:obsproject/obs-studio'''

'''>> '''Press''' Enter'''
|| To do so, type this '''command'''

Press''' Enter.'''
|-
|| Press''' Enter '''key again

|| It will '''prompt''' us again to press '''Enter'''.

So press the '''Enter''' key again.
|-
|| Narration Only
|| Now we have '''installed''' and created all components required for '''OBS installation'''

Next, let's install '''OBS''' '''Studio.'''
|-
|| Type '''sudo apt install obs-studio'''

>> Press''' Enter'''
|| Type '''sudo apt install obs-studio'''

Press''' Enter.'''
|-
|| Type Y
|| If asked whether to continue, type '''Y''' and press '''Enter.'''
|-
|| Narration Only
|| '''OBS''' '''Studio''' is installed successfully.

Let's check it by opening the '''OBS''' interface.
|-
|| Click on the '''Show''' '''Applications''' icon

Type '''OBS'''
|| Click on the '''Show''' '''Applications''' icon at the bottom left corner of the screen.

In '''Type to search '''text field at the top, type '''OBS'''.
|-
|| Point to '''OBS''' icon

Click on '''OBS''' icon
|| We can see the '''OBS''' icon in the list.

Click on it.
|-
|| Point to '''OBS''' interface
|| The '''OBS''' '''Studio''' interface opens up.
|-
|| Point to '''Auto''' '''Configuration wizard''' dialog box.

Click on '''Yes''' or '''Next''' button
|| At the start, we can see the '''Auto''' '''Configuration wizard''' dialog box.

Click on the '''Yes '''or '''Next''' button to continue further.
|-
|| Point to '''Usage''' '''information''' section

Point to '''Optimize for streaming, recording is secondary'''

Point to '''Optimize for streaming, I will not be streaming'''

Point to '''I will only be using the virtual camera'''
|| Under '''Usage''' '''information''' section, three options are available
* '''Optimize for streaming, recording is secondary '''and
* '''Optimize just for recording, I will not be streaming.'''
* '''I will only be using the virtual camera'''

|-
||

Select '''Optimize just for recording, I will be not streaming '''radio button

Click on the '''Next''' button
|| As of now, we will be using '''OBS''' only for '''screen recording.'''

So, select the radio button '''Optimize just for recording, I will not be streaming'''.

Then click on the '''Next''' button at the bottom.
|-
|| Point to '''video''' '''settings''' section

Click on the '''Next''' button
|| In the '''Video''' '''settings''' section, keep the default values.

Then click on the '''Next''' button.

We can see the '''Auto''' '''Configuration wizard '''is setting up.
|-
|| Point to '''Final''' '''Results''' section

Click on the '''Apply''' '''settings''' button
|| Now we are at the '''Final''' '''Results''' section.

Click on the '''Apply''' '''settings''' button at the bottom.
|-
|| Narration only
|| '''OBS''' '''Studio''' is installed successfully and ready for screen recording.
|-
| | Narration only
| | An empty profile named "'''Untitled'''" is before us.

First, let us familiarize ourselves with the '''OBS workspace '''or the '''OBS '''window now.
|-
|| Point to '''Menu bar '''at the top and the '''Canvas Preview '''area in the middle

Point to '''Scene management and Control options''' at the bottom
|| We see the '''Menu bar''' at the top and the '''Canvas Preview '''area in the middle.

The '''Scene management and Control options''' are at the bottom.
|-
|| Point to the '''Scene management and Control options'''

Hover the mouse over each tab
|| The''' Scene management and Control''' options have various sub-tabs.

'''Scenes''', '''Sources''', '''Audio Mixer''', '''Scene transitions''' and '''Controls.'''

We will learn how to use each section as the series progresses.
|-
|| SLIDE
|| Let us briefly understand the '''Sources''' and '''Scenes '''tabs.

'''Scenes '''are specific '''layouts''' for how we want our '''sources''' to be displayed.

'''Sources''' are the things/elements shown on our screen.
|-
|| Slide: Sources and Scenes (show image pointing the scene and source)
|| Let us understand this with an example.

Here, the footage is the '''scene''' and the '''camera''' is the '''source'''.
|-
||

Point to Scenes Panel>>Click on +

Point to Scenes Panel>>Right click>>Add option

|| Let’s learn how to create a '''scene''' in '''OBS.'''

To do so, click the '''+''' icon at the bottom left of the '''Scenes''' panel.

Alternatively, '''right-click''' on the empty space of the '''Scenes''' list and choose '''Add''' option.
|-
|| Point towards '''Add Scene''' dialog box

Type Scene 001

Click on the''' Ok '''button
|| The '''Add Scene''' dialog box appears.

It prompts us to enter the name of the '''Scene.'''

I will type the name of the scene as '''Scene 001.'''

Click on the''' Ok '''button at the bottom right of the window.
|-
||

Point to Sources Panel>>Click on +

Select '''Display Capture'''

|| Next, let’s learn to add a '''source''' to the '''scene.'''

To do so, click the '''+''' icon at the bottom left of the '''Sources''' panel.

It shows a list of '''options''' for '''recording'''. We’ll select '''Screen Capture.'''
|-
|| Select '''Create New Radio button'''

Click on the''' Ok '''button
|| In the dialog box, the '''Create New radio button''' is selected by default. If not, please select it.

Then click on the '''Ok '''button at the bottom right of the window.
|-
|| Point towards '''Properties for Display Picture '''dialog box

Click on the''' Ok '''button
|| The '''Properties for Screen Picture '''dialog box pops up.

We will not do anything here.

Click on the '''Ok '''button. at the bottom right of the window.
|-
||

Controls>>Start Recording button

|| In the '''Preview''' section, we see multiple windows showcased.

Under the '''Controls''' panel at the bottom right, click on the '''Start Recording''' option.
|-
|| SLIDE
||
* If you get an error that says-

Failed to open NVENC codec: Unknown error occurred

Please check your video drivers are up to date.
* Then refer to the '''Additional Reading Material''' to fix it.

|-
|| Minimize the '''OBS '''window
|| Minimize the '''OBS '''window and '''record''' any other window of your choice.
|-
|| Open '''Firefox web browser '''>> Narrate a sentence
|| Here, I am '''recording''' my '''Firefox web browser''' screen.
|-
|| Click on the '''Stop Recording '''button
|| After the '''recording''' is done, switch back to the '''OBS''' window and click on the '''Stop Recording '''button.
|-
|| Click on '''File'''

Click on '''Show Recordings'''

|| To view the recorded clip, click on the '''File''' menu on the left of the '''OBS''' interface.

Click on '''Show Recordings.'''

It will automatically take us to the folder where the '''recording''' is saved.
|-
| | Right click on it >> Open with option

Select VLC

| | To view the recording right click on it, from the context menu select '''Open with''' option.

From the sub-menu select any '''Player''' available on your machine.

I will select '''VLC player '''and click the '''Play '''button.

This is what I '''recorded'''.
|-
| | Back to '''OBS''' >> click '''X''' icon
| | Come back to '''OBS''' interface.

Close it by clicking in the '''X''' icon.
|-
| | '''Settings Changed''' dialog box >> Click the '''Save''' button
| | The '''Settings Changed''' dialog box opens.

Click the '''Save''' button to retain the changes made.
|-
| | Narration only
| | With this, we have come to the end of the installation tutorial.

Let us summarize.
|-
| | Slide: Summary
| | In this tutorial, we have learnt to:
* Install '''FFmpeg'''
* Install '''v4l2loopback''' driver
* Enable the '''multiverse''' '''repo''' in '''Ubuntu's Software Centre''' and
* Install '''OBS'''

in the '''Linux''' Operating System.
|-
| | Slide: Summary
| | We also learnt about
* '''OBS Studio''' workspace
* '''Scenes''' and '''Sources''' in '''OBS '''and
* How to start and stop a '''recording''' in '''OBS'''

|-
|| '''Slide''': Assignment

|| As an assignment

* Create a new '''scene''' in '''OBS'''.
* Name it as '''Scene 002'''
* Record your '''Desktop''' screen
* Save and close the file.
* Go to the '''saved '''location and play the recording.

|-
| | '''Slide: '''About Spoken Tutorial Project
| |
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it

|-
| | '''Slide:''' Spoken tutorial workshops
| |
* We conduct workshops using spoken tutorials and give certificates.
* For more details, please write to us.

|-
|| '''Slide''': Answers for THIS Spoken Tutorial
||
* Do you have questions in THIS Spoken Tutorial?
* Please visit this site
* Choose the minute and second where you have the question.
* Explain your question briefly and someone from our team will answer them.
* You will have to register on this website to ask questions.

|-
|| '''Slide''': Forum
||
* The Spoken Tutorial forum is for specific questions on this tutorial.
* Please do not post unrelated and general questions on them.
* This will help reduce the clutter.
* With less clutter, we can use these discussions as instructional material.

|-
| | Slide: Acknowledgement
| | Spoken Tutorial Project is funded by Ministry of Education (MoE), Government of India
|-
| |
| | This is Arvind Pillai from IIT Bombay signing off.

Thank you for joining.
|-
|}

OBS-Studio/C2/Installation-of-OBS-in-Windows/English

2021-10-11T08:31:31Z

Arvindpillai90: Created page with "Title: '''Installation of OBS in Windows''' Author: Nikita Misal Novice reviewer: Domain reviewer: Nancy Varkey Keywords: {|border="2" |- || '''Visual Cue''' || '''..."

Title: '''Installation of OBS in Windows'''

Author: Nikita Misal

Novice reviewer:

Domain reviewer: Nancy Varkey

Keywords:

{|border="2"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide''': Title
|| Welcome to the '''spoken tutorial''' on '''Installation of OBS in Windows'''
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn about:
* Installation of''' OBS Studio'''
* '''OBS Studio''' workspace
* '''Scenes''' and '''Sources''' in '''OBS '''and
* How to start and stop a '''recording''' in '''OBS'''

|-
|| '''Slide:''' Prerequisite

https://spoken-tutorial.org
|| To practice this tutorial, you should have basic knowledge of '''computers.'''

You should also know how to use a '''web browser'''.
|- style="border:0.75pt solid #808080;padding:0.176cm;"
|| Slide: System Requirement

|| This tutorial is recorded using
* '''Windows''' 10 and
* '''OBS''' '''Studio''' version: 27.0.1
* '''Firefox Web''' browser
* We also need a working '''Internet''' connection for the '''installation'''.

|-
||
|| Let us begin with the '''installation''' of '''OBS Studio '''on '''Windows OS.'''
|-
|| Go to '''Firefox web browser'''
|| First, open a''' web browser.'''
|-
|| Type:[https://obsproject.com/download https://obsproject.com/download] >> press '''Enter'''
|| In the '''address bar''', type [https://obsproject.com/download https://obsproject.com/download] and press '''Enter.'''
|-
| | Download page
|| We are immediately redirected to the '''Download''' page of '''OBS Studio'''.
|-
|| Point to the 3 options i.e Windows, Mac, and Linux
|| Here we can see the '''Download options''' for various '''OS'''es.

We can select the one suitable for our machine’s configuration.
|-
|| Click on '''Windows '''icon
|| I have a '''64-bit Windows 10 '''machine, so I will click on the '''Windows '''icon'''.'''
|-
|| Click on the '''Download''' '''Installer '''button
|| Depending on your '''OS''', click on the '''Download Installer '''or''' Build Instructions '''button.

Here we see the '''OBS 27.0''' version.

Newer versions might be available depending on the time of your download.
|-
|| '''Save As '''dialog box opens
|| On clicking, a '''Save As '''dialog box opens.
|-
|| Click on '''Save'''
|| Select the location where you want to download the software.

I will select the '''Downloads '''folder

Click on the '''Save''' button at the bottom of the dialog box

This may take some time, depending upon your '''Internet''' speed.
|-
| | Double click on the package
|| Once downloaded, double-click on the '''package''' from the saved folder on your machine.

I will go to the '''Downloads''' folder on my machine.
|-
| | User Account Control dialog box >> Yes
|| In the '''User Account Control''' dialog box, click on the '''Yes '''button.
|-
| | Click Next
|| In the '''Setup''' dialog box, click the '''Next''' button to continue the '''installation''' process.
|-
| | Click Next
|| When the '''Licence Agreement''' is displayed, select '''Next'''
|-
| | Click Next
|| We'll be asked where we want to '''install OBS. '''

We will keep all the defaults here.

Click on the '''Next '''button at the bottom right side of the Window
|-
|| Select '''Install'''
|| Click on the '''Install '''at the bottom right side of the Window
|-
|| Select '''Finish'''
|| The '''installation''' is now complete.

Uncheck '''Launch OBS Studio'''.

And then click on the '''Finish '''at the bottom right side of the window.
|-
|| Narration Only:
|| Next, let us learn how to open '''OBS Studio.'''
|-
|| Click on “Start menu”>>search bar type '''OBS'''>Click on '''OBS '''icon
|| In '''Windows OS''', click on the '''Start Menu''' icon located at the bottom left corner.

In the '''search bar,''' type '''OBS'''.

From the displayed list, click on the '''OBS '''icon.
|-
|| Point to '''Auto''' '''Configuration wizard''' dialog box.
|| At the start, we can see the '''Auto''' '''Configuration wizard''' dialog box.
|-
|| Point to '''Usage''' '''information''' section

Point to '''Optimize for streaming, recording is secondary'''

Point to '''Optimize for streaming, I will not be streaming'''

Point to '''I will only be using the virtual camera'''
|| Under '''Usage''' '''information''' section, three options are available
* '''Optimize for streaming, recording is secondary '''and
* '''Optimize just for recording, I will not be streaming.'''
* '''I will only be using the virtual camera'''

|-
||

Select '''Optimize just for recording, I will be not streaming '''radio button

Click on the '''Next''' button
|| As of now, we will be using '''OBS''' only for '''screen recording.'''

So, select the radio button '''Optimize just for recording, I will not be streaming'''.

Then click on the '''Next''' button at the bottom.
|-
|| Point to '''video''' '''settings''' section

Click on the '''Next''' button
|| In the '''Video''' '''settings''' section, keep the default values.

Then click on the '''Next''' button.

We can see the '''Auto''' '''Configuration wizard '''is setting up.
|-
|| Point to '''Final''' '''Results''' section

Click on the '''Apply''' '''settings''' button
|| Now we are at the '''Final''' '''Results''' section.

Click on the '''Apply''' '''settings''' button at the bottom.
|-
|| Narration only
|| '''OBS''' '''Studio''' is installed successfully and ready for screen recording.
|-
|| Only Narration:
|| An empty profile named "'''Untitled'''" is before us.

First, let us familiarize ourselves with the '''OBS workspace '''or the '''OBS '''window now.
|-
|| Point to '''Menu bar '''at the top and the '''Canvas Preview '''area in the middle

Point to '''Scene management and Control options''' at the bottom
|| We see the '''Menu bar''' at the top and the '''Canvas Preview '''area in the middle.

The '''Scene management and Control options''' are at the bottom.
|-
|| Point to the '''Scene management and Control options'''

Hover the mouse over each tab
|| The''' Scene management and Control''' options have various sub-tabs.

'''Scenes''', '''Sources''', '''Audio Mixer''', '''Scene transitions''' and '''Controls.'''

We will learn how to use each section as the series progresses.
|-
|| SLIDE
|| Next, let us briefly understand the '''Sources''' and '''Scenes'''.

'''Scenes '''are specific '''layouts''' for how you want your '''sources''' to be displayed.

'''Sources''' are the things/elements shown on your screen.
|-
|| Slide: Sources and Scenes (show image pointing the scene and source)
|| Let us understand this with an example.

Here, the footage is the '''scene''' and the '''camera''' is the '''source'''.
|-
||

Point to Scenes Panel>>Click on +

Point to Scenes Panel>>Right click>>Add option

|| Let’s learn how to create a '''scene''' in '''OBS.'''

To do so, click the '''+''' icon at the bottom of the '''Scenes''' panel

Alternatively, you can '''right-click''' at the

empty space of the '''Scenes''' list and choose '''Add''' option.
|-
|| Point towards '''Add Scene''' dialog box

Type Scene 001

Click on the''' Ok '''button
|| The '''Add Scene''' dialog box appears.

It prompts us to enter the name of the '''Scene.'''

I will type the name of the scene as '''Scene 001.'''

Click on the''' Ok '''button at the bottom right of the window.
|-
||

Point to Sources Panel>>Click on +

Select '''Display Capture'''
|| Next, let’s learn to add a '''source''' to the '''scene.'''

To do so, click the '''+''' icon at the bottom of the '''Sources''' panel.

It shows a list of '''options''' for '''recording'''. We’ll select '''Display Capture.'''
|-
|| Select '''Create New Radio button'''

Click on the''' Ok '''button
|| In the dialog box, the '''Create New radio button''' is selected by default. If not, please select it.

And click on the '''Ok '''button at the bottom right of the window.
|-
|| Point towards '''Properties for Display Picture '''dialog box

Click on the''' Ok '''button
|| The '''Properties for Display Picture '''dialog box pops up.

We will not do anything here.

Click on the '''Ok '''button at the bottom right of the Window
|-
||

Controls>>Start Recording button

|| In the '''Preview''' section, we see multiple windows showcased.

Under the '''Controls''' panel at the bottom right, click on the '''Start Recording''' option.
|-
|| SLIDE
|| * If you get an error that says-

Failed to open NVENC codec: Unknown error occurred

Please check your video drivers are up to date.* Then refer to the Additional Reading Material to fix it.

|-
|| Minimize the '''OBS '''window
|| Minimize the screen and record any other window of your choice.
|-
|| Open '''Firefox web browser '''>> Narrate a sentence
|| Here, I am '''recording''' my '''Firefox web browser''' screen.
|-
|| Click on the '''Stop Recording '''button
|| After the '''recording''' is done, switch back to the '''OBS''' window and click on the '''Stop Recording '''button.
|- style="border:0.75pt solid #808080;padding:0.176cm;"
|| Click on '''File'''

Click on '''Show Recordings'''

|| To view the recorded clip, click on the '''File''' menu on the left of the '''OBS''' interface.

Click on '''Show Recordings.'''

It will automatically take us to where the '''recording''' is saved
|-
|| Right click on it >> Open with option

Select VLC

|| To view the recording right click on it, from the context menu select '''Open with''' option.

From the sub-menu select any '''Player''' available on your machine.

I will select '''VLC player '''and click the '''Play '''button.

This is what I '''recorded'''.
|-
|| Back to '''OBS''' >> click '''X''' icon
|| Come back to the OBS interface.

Close it by clicking in the '''X''' icon.
|-
|| '''Settings Changed''' dialog box >> Click the '''Save''' button
|| The '''Settings Changed''' dialog box opens.

Click the '''Save''' button to retain the changes made.
|- style="border:0.75pt solid #808080;padding:0.176cm;"
|| Only Narration
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt about:
* Installing''' OBS studio'''
* '''OBS Studio''' workspace
* '''Scenes''' and '''Sources''' in '''OBS '''and
* How to start and stop a '''recording''' in '''OBS'''
in '''Windows OS'''
|-
|| '''Slide''': Assignment

|| As an assignment
* Create a new '''scene''' in '''OBS'''.
* Name it as '''Scene 2'''
* Record your '''Desktop''' screen
* Save and close the file.
* Go to the '''saved '''location and play the recording.

|-
|| Slide: About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken tutorial workshops
||
* We conduct workshops using spoken tutorials and give certificates.
* For more details, please contact us.

|-
|| '''Slide''': Answers for THIS Spoken Tutorial
||
* Do you have questions in THIS Spoken Tutorial?
* Please visit this site
* Choose the minute and second where you have the question.
* Explain your question brief someone from our team will answer them.
* You will have to register on this website to ask questions.

|-
|| '''Slide''': Forum
||
* The Spoken Tutorial forum is for specific questions on this tutorial.
* Please do not post unrelated and general questions on them.
* This will help reduce the clutter.
* With less clutter, we can use these discussions as instructional material.

|-
|| '''Slide''': Acknowledgement
|| Spoken Tutorial project is funded by Ministry of Education (MoE), Govt. of India
|-
|| Previous slide
| | This is Arvind Pillai along with Nikita Misal from IIT Bombay signing off.

Thank you for joining.
|-
|}

LibreOffice Suite Impress 6.3

2020-10-21T11:07:38Z

Arvindpillai90: Created page with "=== Introduction === LibreOffice Impress is the presentation component of the LibreOffice Suite. It is the equivalent of Microsoft PowerPoint in Microsoft Suite and has a num..."

=== Introduction ===

LibreOffice Impress is the presentation component of the LibreOffice Suite. It is the equivalent of Microsoft PowerPoint in Microsoft Suite and has a number of unique features, including a system which automatically defines series of graphs, based on information available to the user . It is a free and open source software so it can be copied, re-used and distributed free of cost.

In Impress, creating and editing slides is very versatile thanks to different editing and view modes: Normal (for general editing), Outline (for organizing and outlining your text content), Notes (for viewing and editing the notes attached to a slide), Handout (for producing paper-based material), and Slide Sorter (for a thumbnail sheet view that lets you quickly locate and order your slides). You can create slides that contain many different elements, including text, bulleted and numbered lists, tables, charts, and a wide range of graphic objects such as clipart, drawings and photographs.

__TOC__

=== Basic Level ===

#Introduction to LibreOffice Impress
#*Basic Features
#*Various Toolbars
#*Given Title bar, menu bar, standard toolbar, formatting bar and status bar
#*Adding content to the slide in presentation
#*Saving the presentation
#*Closing the presentation
#*Reopen the presentation which we saved
#*Save as MS PowerPoint and other formats
#*PDF Export
#Creating a presentation in Impress
#*Workspace
#**Normal
#**Outline
#**Notes
#**Slide sorter
#*View Tab Bar
#*Sidebar
#*Inserting Slides
#*Copying Slides
#*Font size and Color, Bold
#*About Fonts
#*Formatting Fonts
#*Text in Bold, Italics and Underlined
#*Deleting Slides
#Viewing a presentation in Impress
#*Views options – Normal, Outline, Master Layout
#*Uses of different view options
#*How to change Slide design
#*Sections under Master Slides
#*Write notes in slides
#*Use the Slide Sorter
#*Use Outline in slide
#*Layout under title content over content
#*How to use Layout
#Inserting Pictures and Tables in Impress
#*Resizing Pictures and Tables
#*Formatting Pictures and Tables
#*Creating a Table within a slide
#*Entering data in the table
#*Table styles
#*Insert picture from insert toolbar
#*Use the hyperlinks
#*Hyperlinking within the presentation
#*Hyperlinking outside the presentation
#*Hyperlinking webpage
#Printing a presentation in Impress
#*Print the slides, handouts, notes and outline
#*Print Preview
#*Use of Previous and Next Page icons
#*Choose the colour for printing document
#*Print Slide name Date, Time, Hidden pages
#*Pages per sheet option
#*Draw a border in slide
#*Select colour in slide
#*Visit file and print
#*Use the page layout
#*Printing slides and Handouts Different Options

=== Intermediate Level ===

#Slide Master and Slide Design in Impress
#*Creating Background for Slides
#*Custom Background for Slides
#*Use of Master Slide
#*Formatting of Master Slides
#*Use the Bitmap as a Background for Slide
#*Use the Font Effects
#*Use the Basic Shapes in Impress
#*Adding Logo to the Slides
#*Applying Different Slide Templates (Layouts)
#Custom Animation in Impress
#*Adding Animation to Textbox
#*How to set the Animation effects
#*List of Animation effect in Impress
#*Automatic Preview of Animation
#*Reorder the animation
#*How to change properties of Animation
#*Use of Effect Option
#*Delay in Animation
#*Use the Text Animation Tab
#*How to play multiple Animations
#Slide Show Creation in Impress
#*Shortcut keys for Slideshow
#*Use of Mouse Pointer as Pen
#*Slideshow from Current Slide
#*Slide Transition
#*Use of Slide Sorter tab
#*Slide Transition Effects
#*Modify Transition Effects
#*Adding Sound to Transition Effects
#*Automatic Slide Shows with fixed time interval
#*Automatic Slide Shows with different time intervals

LibreOffice Suite Calc 6.3

2020-10-21T07:35:11Z

Arvindpillai90:

=== Introduction ===

LibreOffice Calc is the spreadsheet component of the LibreOffice Suite. It is the equivalent of Microsoft Excel in Microsoft Suite and has a number of unique features, including a system which automatically generates graphs, based on information available to the user. It is a free and open source software so it can be copied, re used and distributed free of cost.

Additionally, Calc now supports 1 million rows in a spreadsheet with macro references to each cell. Supports many functions, including those for imaginary numbers, as well as financial and statistical functions. Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets as PDF files. As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows and FreeBSD.
__TOC__

=== Basic Level ===

# Introduction to LibreOffice Calc
#*Various toolbars in Calc window - Title & Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Status Bar and Side Bar
#*Opening new spreadsheet in Calc
#*Opening an existing spreadsheet in Calc
#*Save and close a spreadsheet
#*Workbook in Calc
#*Grid of columns and rows in Calc
#*Cells in Calc
#*Change font size, font style and font name
#*Saving files in different formats dot XLSX and dot HTML
#*Export as PDF
#Working with Cells in Calc
#*Enter numbers in cells
#*Enter text in cells
#*Enter date and time in cells
#*Use the Format Cells dialog-box
#*Navigate between cells
#*Select items in rows
#*Select items in sheet
#*Select columns in sheet
#*Learn how to enter data in cells
#*Select multiple columns
#*Select multiple rows
#Working with Sheets in Calc
#*Insert a single row or a single column
#*Inserting multiple rows
#*Inserting multiple columns
#*Inserting sheets
#*Deleting sheets
#*Renaming Sheets
#*Moving Sheets
#*Deleting single and multiple rows
#*Deleting single and multiple columns
#Formatting Data in Calc
#*Applying border styles from available list
#*Formatting borders of cells as per our preference
#*Adding background colors in cells
#*Formatting multiple lines within a single cell
#*Automatic Wrapping
#*Merging cells
#*Shrinking text to fit the cell
#Basic data manipulation in Calc
#*Introduction to basics of using formula in Calc
#*Basic arithmetic calculations - addition, subtraction, multiplication, division
#*Sorting by columns
#*Basics of filtering data
#*Formula for SUM
#*Formula for AVG
#*Sorting in Descending order
#*Sorting in Ascending order
#*Sort data using the Sort keys feature
#*Working of Auto Filter feature
#Working with Data in Calc
#*Speed up using Fill tools
#*Sharing content between sheets
#*Removing data
#*Replacing data
#*Changing part of a data
#*Different Fill tool
#*Different Fill Series
#Viewing and Printing a Spreadsheet in Calc
#*Viewing in Normal mode
#*Viewing in Page Break mode
#*Viewing in Full Screen mode
#*Setting up Page Style options
#*Setting up the page order
#*Setting up Page Margin, Orientation and Layout
#*How to use Zoom slider
#*Different Zoom & View layout options
#*How to adjust the content to fit page
#*How to use Print Preview option
#*How to print the sheet as a PDF file
#*How to print selected pages
#*How to setup no of print copies
#*How to print selected cells
#*Other printing options

=== Intermediate Level ===

#Using Charts and Graphics in Calc
#*Create, edit and format Charts
#*Resize and move Charts
#*Different Chart formats
#*3D Look in Chart
#*Add a title to the Chart
#*Data Series in Chart
#*Data Ranges in Chart
#*Format Chart Wall
#*Format Chart Area
#*Chart Area Legend ON/OFF
#*Changing the Position and Size of a Chart
#Inserting Images and inbuilt Graphics in Calc
#*Insert an Image file directly
#*Insert an Image file from a graphics program
#*Insert an Image with the help of a clipboard
#*Insert an Image from the gallery
#*Insert an Image using Drag and Drop option
#*Picture toolbar in Calc
#*Graphics mode in Calc
#*Hyperlink an image
#*Crop an image
#*Add filter option to an image
#Advanced Formatting and Protection in Calc
#*Password protect from a spreadsheet
#*Remove Password protect from a spreadsheet
#*Password protect from a single sheet
#*Remove Password protect from a single sheet
#*Define Ranges for a database
#*Validate cells
#*Database range in Calc
#*Use Clone Formatting in Calc
#*Use SUBTOTAL in Calc
#*Use GRANDSUM in Calc
#Formulae and Functions in Calc
#*Usage of Conditional Operator in Calc
#*Usage of If.. Or statement in Calc
#*Rounding off numbers
#*Usage of Function Wizard in Calc
#*Usage of following functions in Calc:
#**SUM()
#**PRODUCT()
#**MIN()
#**MAX()
#**MEDIAN()
#**COUNT()
#**COUNTIF()
#Linking Calc Data
#*Cell Referencing in Calc
#*Inserting a Hyperlink in a spreadsheet
#*Navigate between sheets using Hyperlink
#*Navigate between documents using Hyperlink
#*Hyperlinking to a website
#*Usage of Hyperlink dialog box
#*Setting up a target document
#*Setting up a target sheet
#*Remove the Hyperlink

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

2020-09-10T08:49:20Z

Arvindpillai90: Created page with "Title: Linking Calc Data Author: Arvind Pillai Novice reviewer: Nikita Misal and Pooja Molya Domain reviewer: Praveen S Keywords: LibreOffice,Calc,Ubuntu,Use reference in..."

Title: Linking Calc Data

Author: Arvind Pillai

Novice reviewer: Nikita Misal and Pooja Molya

Domain reviewer: Praveen S

Keywords: LibreOffice,Calc,Ubuntu,Use reference in Calc, Use Hyperlinks in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide: '''Title

|| Welcome to the spoken tutorial on '''Linking Calc Data.'''
|-
|| '''Slide: '''Learning Objectives
|| In this tutorial, we will learn:
* How to '''reference''' other '''sheets''' and
* Insert '''hyperlinks''' in '''Calc'''

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide''':Reference Cells
|| '''LibreOffice Calc '''allows you to '''reference'''
* A '''cell''' from '''sheet''' to a '''cell''' in another '''sheet'''
* A '''cell''' from another '''spreadsheet'''

|-
|| Open''' Personal-Finance-Tracker.ods.'''
|| Let’s open '''Personal-Finance-Tracker.ods.'''
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Please download and extract the file.
* Make its copy and use it for practising.

|-
|| Point to '''Cost''' and '''Spent'''
|| Now, let us find the sum total of the components under '''Spent '''and '''Received'''.
|-
|| Click on cell '''C8'''
|| Click on the '''cell''' '''C8'''.
|-
|| Click on the little '''black box''' at the bottom-right corner of the cell

Drag it till '''cell E8''' and release the mouse button.
|| Click on the little''' black box''' that is visible at the bottom-right corner of the '''cell'''.

Drag it till '''cell E8''' and release the mouse button.
|-
|| Point to the total balance under '''Cost''' and '''Spent'''
|| Now, we will display the total balance under '''Cost''' and '''Spent''' on a different '''sheet'''.

We will do this using '''cell''' '''referencing'''.
|-
|| Click on '''Sheet''' '''3'''
|| Let’s go to '''Sheet''' '''3'''.
|-
|| Click on '''cell A1'''.

Type '''COMPONENT''' inside it.
|| Now click on '''cell A1 '''and type the heading as '''COMPONENT''' inside it.
|-
|| Click on '''cell B1'''

Type '''BALANCE''' inside it.
|| Click on '''cell B1''' and type the heading '''BALANCE''' inside it.
|-
|| Narration Only
|| Now, let’s type the names of the components under this heading.
|-
|| Click on cell '''A3 '''Type '''COSTS''' >> press '''Enter'''
|| Click on the '''cell''' '''A3''' and type '''COST '''and press '''Enter'''.
|-
|| Click on cell '''A4'''

Type '''Spent'''
|| Below '''COST''', let’s type the next component as '''SPENT''' in '''cell''' '''A4'''.
|-
|| Click on cell '''E3'''
|| 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 headings '''COST''' and '''SPENT'''.

It has already been calculated in '''Sheet''' '''1'''.

This will be done by '''referencing'''.
|-
|| Click on '''<nowiki>=</nowiki>''' next to the input line.
|| Let’s make the '''cell''' '''reference''' in '''cell''' '''B3'''.

Click on the '''equal to '''sign named '''Formula''' next to the '''Input''' '''line'''.
|-
|| Click on '''Sheet''' '''1''' tab.
|| Now, on the '''Sheet''' '''tab''' click on '''Sheet''' '''1'''.
|-
|| Click on cell '''C8''' which has the total for '''Cost'''
|| In this '''sheet''', we will click on '''cell''' '''C8''' which contains the total for '''Cost'''.
|-
|| Point to input line
|| Notice that in the '''Input''' '''line,''' the statement '''$Sheet''' '''1''' '''dot''' '''C8''', is displayed.
|-
|| Click on '''Checkmark '''next to the input line.
|| Now click on the check mark named '''Accept''' next to the '''Input''' '''line'''.
|-
|| Point to the cell '''B3''' which appears in the '''Sheet''' '''3'''.
|| Notice that we redirected back to '''Sheet 3.'''

And the grand total in '''Sheet''' '''1''' is automatically filled in '''cell B3''' of '''Sheet''' '''3'''.
|-
|| Show demo of '''Spent''' Sum total '''referencing'''.
|| Similarly,we can enter the grand totals of other components through '''referencing'''.
|-
|| Click on '''Sheet''' '''1''' then back on '''Sheet 3'''
|| '''Referencing''' is very useful to summarise '''data''' if there are many '''sheets'''.
|-
||Only Narration
|| Now, let’s learn how to insert '''Hyperlinks''' in '''Calc''' '''sheets'''.
|-
|| '''Slide: What is a Hyperlink? '''
|| '''Hyperlink''' within '''documents''' are words or '''phrases''' that can be clicked.

On clicking them, we jump to * a new '''document''' or
* a new section within the current '''document''' or
* Even to a webpage.

|-
|| Only Narration

Point to '''Sheet''' '''1''' and then to '''Sheet''' '''3'''.
|| In this file, our main '''data''' is in '''Sheet''' '''1''' and the rest of the content in '''Sheet''' '''3'''.

Let’s say we want to jump from '''Sheet''' '''1''' to '''Sheet''' '''3'''.
|-
|| Click on '''Sheet''' '''1'''
|| First, click on the '''Sheet''' '''1''' tab.
|-
|| Type '''Sheet''' '''3''' in '''B10'''
|| Here let’s click on '''cell''' '''B10''' and type '''Sheet''' '''3.'''
|-
|| Point to '''Input''' '''line'''
|| You see that the name '''Sheet''' '''3''' is displayed on the '''Input line.'''
|-
|| Select text '''Sheet''' '''3''' in the input line.
|| Now select the text '''Sheet''' '''3''' in the '''Input''' '''Line'''.
|-
|| Click on the '''Insert''' '''Hyperlink''' icon on the '''Standard''' '''toolbar'''.
|| After selecting the text, click on the '''Insert''' '''Hyperlink''' icon in the '''Standard''' '''toolbar'''.
|-
|| Point to the '''Hyperlink''' dialog box.
|| The '''Hyperlink''' dialog box appears.
|-
|| Click on '''Document'''
|| On the left side, click on '''Document'''.
|-
|| Point to '''Target in Document'''

|| Under''' Target in Document '''section, click on the circle icon to the right.

The '''Target in Document''' list box opens.
|-
|| Expand '''Sheets''' by clicking on the arrow >> select '''Sheet 3'''

Click on''' Apply''' and '''Close''' button
|| Expand '''Sheets''' by clicking on the arrow and select '''Sheet 3'''.

Click on the '''Apply''' button and then on '''Close''' button.
|-
|| Point to '''Target''' field >> '''Sheet 3'''.
|| In the '''Hyperlink''' dialog box, in the '''Target''' field we see the text '''Sheet 3'''.
|-
|| Point on the '''URL''' field
|| We also see that the '''path''' of '''Sheet 3''' gets inserted in the '''URL''' field.
|-
|| Click on '''Apply''' >> click on '''Close''' button
|| At the bottom, click on the '''Apply''' button first and then on the '''Close''' button.
|-
|| Point to highlighted text '''Sheet''' '''3'''
|| Now the text '''Sheet''' '''3''' is highlighted in the '''cell'''.
|-
|| Click on any random '''cell'''
|| Click anywhere outside to deselect the '''cell'''.
|-
|| Cursor on '''Sheet 3'''

Press Ctrl+left key mouse
|| Keep the cursor on the word '''Sheet 3'''.

And press the '''Ctrl '''key and the left mouse-button together.
|-
|| Highlight with a red box
|| We have been redirected to '''Sheet 3.'''
|-
|| Click on the '''Sheet''' '''1''' tab
|| Let us go back to '''Sheet 1.'''
|-
|| Click on '''B10''' in '''Sheet''' '''1'''
|| To remove the '''hyperlink''', first click on the '''cell B10 '''in''' Sheet 1'''
|-
|| Right click and Point on '''Clear Direct''' '''Formatting'''
|| Right-click on the cell and select '''Clear Direct''' '''Formatting''' from the context menu.

Alternatively, we can click on the '''Clear Direct''' '''Formatting '''icon''' '''in''' '''the''' Standard Toolbar.'''
|-
|| Point to the text which no longer is a hyperlink.
|| The text is no longer '''hyperlinked'''.

It is just like any normal text in the spread'''sheet'''.
|-
|| Only narration
|| Next we will learn how to create a '''hyperlink''' to an external file.
|-
|| Show to '''Contact-Details.ods '''in file browser
|| For this demonstration, I will be using the file '''Contact-Details.ods'''

The same is available in the '''Code''' '''Files''' link.

Pls download and save it in the folder where you have saved '''Personal-Finance-Tracker.ods'''
|-
|| Switch to '''Personal-Finance-Tracker.ods'''
|| Let us go back to '''Personal-Finance-Tracker.ods'''
|-
|| Type '''Contact Details''' in '''B10'''
|| Click on '''cell''' '''B10''' and type '''Contact Details.'''
|-
|| Select text '''Contact Details''' in the input line.
|| Now select the text '''Contact Details''' in the '''Input''' '''Line'''.
|-
|| Click on the '''Insert''' '''Hyperlink''' icon on the '''Standard''' '''toolbar'''.
|| After selecting the text, click on the '''Insert''' '''Hyperlink''' icon in the '''Standard''' '''toolbar'''.
|-
|| Point to the '''Hyperlink''' dialog box.
|| The '''Hyperlink''' dialog box appears.
|-
|| Click on '''Document''' option
|| To create a '''hyperlink''' to another '''spreadsheet '''or '''document''', click on the '''Document''' option.
|-
|| Click on the folder icon on the right of '''Path''' field
|| Click on the '''folder''' icon on the right of the '''Path''' field.
|-
|| Click on Desktop >> Scroll down & locate '''Contact-Details.ods'''
|| Select '''Desktop''' location.

Scroll down and locate the new '''spreadsheet Contact-Details.ods''' which we had saved.
|-
|| Select '''Contact-Details.ods''' and click on '''Open '''button
|| Now, double-click on the “'''Contact-Details.ods”''' file.
|-
|| Point on the '''Path''' field
|| We see that the '''path''' to the file gets inserted in the '''Path''' field.
|-
|| Click on '''Apply''' >> click on '''Close''' button
|| At the bottom, click on the '''Apply''' button first and then on the '''Close''' button.
|-
|| Point to highlighted text '''Contact Details'''
|| Now the text '''Contact Details''' is highlighted in the '''cell'''.
|-
|| Click on any random '''cell'''
|| Click anywhere outside to deselect the '''cell'''.
|-
|| Point to '''Contact Details'''
|| We see that the text "'''Contact Details'''" is blue in color.

Which means the text is now a '''hyperlink'''.
|-
|| Cursor on '''Contact Details'''

Press Ctrl+left key mouse
|| Keep the cursor on the word '''Contact Details'''.

And press the '''Ctrl '''key and the left mouse-button together.
|-
|| Point to '''Contact Details.ods'''
|| We see that the file '''Contact Details.ods''' opens up.
|-
|| Click on X icon
|| Click on the '''X '''icon at the top right corner to close this file.
|-
|| Undo the changes.
|| Let us undo these changes.
|-
|| Only narration.
|| '''Hyperlinking''' to a '''web page '''is similar.
|-
|| Type '''Spoken''' in '''B10'''
|| Click on '''cell''' '''B10''' and type '''Spoken'''
|-
|| Select text '''Spoken''' in the input line.
|| Now select the text '''Spoken''' in the '''Input''' '''Line'''.
|-
|| Click on the '''Insert''' '''Hyperlink''' icon on the '''Standard''' '''toolbar'''.
|| After selecting the text, click on the '''Insert''' '''Hyperlink''' icon in the '''Standard''' '''toolbar'''.
|-
|| Point to the '''Hyperlink''' dialog box.
|| The '''Hyperlink''' dialog box appears.
|-
|| Go to the left pane >> Point to the '''Internet'''.

Go to the '''Hyperlink Type''' >> Point to '''Web'''.
|| In the '''Hyperlink''' dialog box, by default, the '''Internet''' section is selected in the left pane.

In the '''Hyperlink Type '''section, the '''Web''' radio button is also selected.
|-
|| Type '''https://spoken-tutorial.org''' in the '''URL''' field.

Click on the '''Apply''' >> '''Close'''.
|| Now in the '''URL''' field, type '''https://spoken-tutorial.org'''

At the bottom, click on the '''Apply '''button and then on the '''Close '''button'''.'''
|-
|| Click on any random '''cell'''
|| Click anywhere outside to deselect the '''cell'''.
|-
|| Point to '''hyperlinked''' text.
|| Observe that the text '''Spoken '''becomes a '''hyperlinked''' text.
|-
|| Only Narration
|| For the next part of this demonstration, you will need '''internet connectivity'''.

If you don’t have it, then skip this part.
|-
|| Press '''Ctrl''' + click on '''hyperlinked''' text.

Point to website page
|| By holding the '''Ctrl''' key click on the '''hyperlinked''' text.

We will be redirected to the relevant '''URL.'''

<<PAUSE>>
|-
|| Only narration.
|| So, these are the different methods to create '''hyperlinks '''in '''Calc'''.
|-
|| Narration:
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| '''Slide: '''Summary

|| In this tutorial, we learnt to:

* Add '''reference''' to other '''sheets''' and
* Insert '''hyperlinks''' in '''Calc'''.

|-
|| '''Slide:'''Assignment
|| As an assignment* Open '''Spreadsheet-Practice.ods''' file
* Find out the '''sum''' '''total''' of salary in '''Sheet 1.'''
* Use '''sum total '''to display it on a different '''sheet''' using '''cell''' '''referencing'''.
* Use the '''Hyperlink''' icon and link '''LibreOffice''' website '''https://www.libreoffice.org/'''

|-
|| '''Slide: '''About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.y
* Please download and watch it

|-
|| '''Slide:''' Spoken tutorial workshops
||
* We conduct workshops using '''Spoken''' '''Tutorials''' and give certificates.
* For more details, please write to us.

|-
|| '''Slide: '''Forums
|| Pls post your timed queries in this forum.
|-
| | '''Slide: '''Acknowledgement
| | '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C3/Formulae-and-Functions-in-Calc/English

2020-09-10T08:22:23Z

Arvindpillai90: Created page with "Title:Formulae and Functions Author: Arvind Pillai Novice reviewer: Nikita Misal and Pooja Moolya Domain reviewer: Praveen S Keywords: LibreOffice,Calc,Ubuntu,Conditional..."

Title:Formulae and Functions

Author: Arvind Pillai

Novice reviewer: Nikita Misal and Pooja Moolya

Domain reviewer: Praveen S

Keywords: LibreOffice,Calc,Ubuntu,Conditional Operators in Calc,Using IF-OR statements in Calc,Basic Statistical functions in Calc,Rounding off numbers in Calc, Function Wizards in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide:''' Tittle
|| Welcome to the spoken tutorial on '''Formulae and Functions '''in''' Calc'''.
|-
|| '''Slide''': Learning objectives
|| In this tutorial we will learn about:
* '''Conditional Operators'''
* '''If..Or statement'''
* Basic '''statistical''' '''functions '''and
* '''Rounding''' '''off''' numbers

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide''':Conditional Operators.
||
* Earlier in the series, we learnt to use basic '''arithmetic''' '''operators''' and '''average function'''
* Now we shall learn about '''conditional''' '''operators'''.

|-
|| '''Slide''':Conditional Operators.

|| '''Conditional''' '''operators''',
* Check for the '''condition''' applied on the '''data''' by the user and
* Show results in '''boolean: TRUE '''or''' FALSE.'''

|-
|| Open '''Personal-Finance-Tracker.ods'''
|| Let’s open '''Personal-Finance-Tracker.ods.'''
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Please download and extract the file.
* Make its copy and use it for practising.

|-
|| Point to the heading '''Cost'''
|| Here, under the column '''Cost''', we have listed the prices of several items.

Let’s apply '''conditional operators''' on them and analyse the results.
|-
|| Point to '''House''' '''Rent''' and '''6000'''.

Point to '''Electricity''' '''Bill''' and '''800'''.
|| Note that the amount for '''House''' '''Rent''' is rupees '''6''','''000'''.

The cost for '''Electricity''' '''Bill''' is rupees '''800'''.
|-
|| Point to '''6000'''

Then Point to the '''800'''.
|| The amount for '''House''' '''Rent''' is more than the '''Electricity''' '''Bill'''.

We can apply different '''conditions''' on them and check the results.
|-

|| Click on cell '''B10'''.

Point to cell '''B10'''.
|| Click on '''cell B10'''.

The result of the '''condition '''will be applied and displayed in this '''cell'''.
|-

|| Type '''<nowiki>=C3>C4</nowiki>'''

Press '''Enter'''

Point to '''C3''' and then point to '''C4''' Point to '''TRUE''' in cell '''B10'''
|| In this '''cell''', type the first '''condition''' as '''is equal to C3 greater than C4.'''

And then press the '''Enter''' key.

Since the value in '''cell C3''' is greater than the value in '''cell''' '''C4''', the result we get is '''TRUE'''.
|-
|| Edit statement to '''<nowiki>=C3<C4 </nowiki>'''

Press '''Enter'''

Point to '''FALSE'''
|| Now let us change this '''conditional statement''' to '''is equal to C3 lesser than C4'''.

And press '''Enter''' key.

The result we get is '''FALSE '''this time.
|-
|| '''Slide''': Other Conditions

Other conditions to test:
* <nowiki>= Equal to</nowiki>
* <> Not equal to

|| Likewise, we can type some other '''conditions''' and study the results.

These '''statements''' are very useful when dealing with large amounts of '''data'''.
|-
|| '''Slide''': If and Or Condition
||
* We can also use the '''If '''and''' Or''' '''condition''' on our '''data'''
* To print the results according to the '''condition''' that holds '''TRUE'''.

Let’s try this.
|-
|| Click on cell '''B10'''

Type ='''IF(C3>C4, “Positive”,”Negative”)'''
|| Click on '''cell''' '''B10'''.

Type '''is equal to IF and within brackets, C3 greater than C4 comma, within double quotes Positive comma '''and again''' within double quotes Negative.'''
|-
|| Point to '''C3''' then point to '''C4'''
|| The '''if condition''' checks whether the value in '''cell C3''' is greater than the value in '''cell''' '''C4'''.

Accordingly, '''Positive''' or '''Negative''' will be displayed.
|-
|| Press '''Enter'''.
|| Now press the '''Enter''' key.
|-
|| Point to '''Positive'''

Point to '''C3''' then point to '''C4'''
|| Notice that the result is '''Positive''' since rupees '''6000''' is greater than rupees '''800'''.
|-
|| Change statement to '''<nowiki>=IF(C3<C4,”Positive”,”Negative”)</nowiki>'''

Press '''Enter'''.
|| Now, in the '''condition''' '''statement''' let’s change '''greater''' '''than''' to '''less''' '''than'''.

And press the '''Enter''' key.
|-
|| Point to '''Negative'''.
|| We got the output as expected.
|-
|| Narration Only
|| You can also see the change in result, if we change the data in the '''cells''' '''C3''' and '''C4'''.
|-
|| Increase the value in '''C4''' to '''8000'''.

Press '''Enter'''.

Point to '''Positive'''
|| Now, let us increase the value in '''cell''' '''C4''' to '''8000''' and press the '''Enter''' key.

The result automatically changes to '''Positive'''.
|-
|| Decrease the value in '''C4''' to '''800'''.

Press '''Enter'''
|| Again, let’s decrease the value in cell '''C4''' to '''800'''.

and press the '''Enter''' key.
|-
|| Point to '''Negative'''
|| The result again automatically changes to '''Negative'''.
|-
|| Delete the '''Row no. 10'''
|| Now, let us delete the changes made.
|-
|| Narration Only
|| Next, let’s learn a few basic and '''statistical''' '''functions'''.
|-
|| Slide:'''Syntax'''
|| The '''syntax''' to write a '''formula''' with a '''function''' is:

'''Equals to sign = '''

'''Function name (SUM '''for addition)

'''Arguments (cell references)'''
|-
|| '''Slide''': Arithmetic Functions
|| Common basic '''functions''' include-

* '''SUM''' for addition,
* '''PRODUCT''' for multiplication,
* '''QUOTIENT''' for division

|-
|| Narration Only
|| Now let me demonstrate how the '''Sum''', '''Product''' and the '''Quotient functions''' work.
|-
|| Select '''Sheet''' '''3'''.
|| First let’s select '''Sheet''' '''3'''.
|-
|| Type '''50''','''100''' and '''150''' in '''cells B1, B2''' and '''B3''' respectively.
|| Type the numbers '''50''', '''100''' and '''150''' within '''cells''' '''B1''', '''B2''' and '''B3''' respectively.
|-
|| Click on the '''cell A5''' and type '''SUM'''.
|| Click on '''cell''' '''A5''' and type the text '''SUM'''.
|-
|| Click on the '''cell''' '''B5'''
|| Click on '''cell B5'''.

We shall compute the result in this '''cell'''.
|-
|| Type in the cell '''<nowiki>=SUM(B1:B3)</nowiki>'''

Press '''Enter'''
|| If we know the '''function''' and the '''syntax''', we can directly type it in the respective '''cell''' as shown.

Type '''is equal to SUM, and within the braces, B1 colon B3'''.

And press '''Enter''' on the keyboard.
|-
|| Point to the result '''300'''.

Press '''Ctrl''' '''+ Z''' keys
|| Notice the result shows '''300'''.

Undo the change.
|-
|| Only Narration

Click on '''fx''' icon

Point to '''Functions''' section
|| If we don't know the '''function''' name, we can make use of the '''Functions''' section.

Click on the '''fx''' icon in the '''sidebar'''.

The '''Functions Wizard''' opens.

It displays a '''library''' of all '''Calc functions'''.
|-
|| Click on '''Functions''' dropdown >> Select '''Mathematical'''

Scroll down

|| From the '''functions''' drop-down, select '''Mathematical'''.

The list of all '''mathematical functions''' available in '''Calc '''will be displayed below.
|-
|| Double click on >> '''SUM'''
|| Scroll down and double-click on the '''function SUM.'''
|-
|| Point to the Preview
|| At the bottom, we can see information about the selected '''function'''.
|-
|| Point to '''B5'''

|| Notice the '''cell B5'''.

The '''syntax''' for the selected '''function''' is inserted in the '''cell'''.
|-
|| Click on '''Cell''' '''B1''' and drag till '''cell''' '''B3'''
|| Select the '''cells B1''' to '''B3''' as shown, with the '''cursor'''.
|-
|| Point to '''Input Line'''

Press '''Enter'''
|| Look at the '''Input''' '''Line'''.

The '''formula''' is auto-completed.

Now press the '''Enter''' key on the keyboard.
|-
|| Point to the result '''300'''.
|| Once again, the result shows '''300.'''
|-
|| Click on the cell '''A6''' and type '''PRODUCT'''.
|| Next, let’s click on '''cell A6''' and type '''PRODUCT'''.
|-
|| Click on the cell '''B6'''
|| Click on '''cell B6'''.
|-
|| In '''functions''' section, scroll and select '''Product'''
|| From the '''Functions Wizard''', scroll and double-click on the '''function PRODUCT.'''
|-
|| Click on '''cell''' '''B1''' and drag till '''cell''' '''B3'''

Press '''Enter'''
|| Select the '''cells B1''' to '''B3''' as shown, with the '''cursor'''.

And press '''Enter''' on the keyboard.
|-
|| Point to the result '''750000'''.
|| Notice the result shows '''7,50,000.'''
|-
|| Click on '''B6'''

Double click on '''Product''' function

Holding the Ctrl key select '''B1''' and '''B3 '''[Enter]

|| If you wish to select only specific '''cells''', then select those '''cells''' by holding the '''Ctrl''' key.

Double-click on the '''function PRODUCT.'''

Select the '''cells B1''' and '''B3''' as shown, with the '''cursor '''while pressing the '''Ctrl key'''.

And press '''Enter''' on the keyboard.
|-
|| Point to '''B6'''
|| The new result '''7,500 '''is seen.
|-
|| Narration Only
|| Next, let’s see how '''Quotient''' works.
|-
|| Click on the cell '''A7''' and type in that, '''QUOTIENT'''.
|| Click on '''cell''' '''A7''' and type '''QUOTIENT'''.
|-
|| Click on cell '''B7'''.
|| Now click on '''cell B7'''.

We shall use this '''cell''' to compute the result.
|-
|| Type ='''QUOTIENT(B2,B1)'''

Press '''Enter'''.
|| Type '''is equal to QUOTIENT, and within the braces, B2 comma B1.'''

Press '''Enter'''.
|-
|| Point to the result''' 2.'''

Point to the '''100''' and then to '''50'''.
|| We will get the result as '''2''' because '''100''' divided by '''50''' is '''2'''.
|-
|| Change '''100 '''to '''151 '''in '''cell B2'''
|| Let’s change the number in''' cell B2''' to '''151''' now.
|-
|| Point to '''cell B7'''
|| Notice the change in '''cell B7'''. The quotient is '''3''' but the remainder '''1''' is lost.
|-
||

Type ='''MOD(B2,B1)'''

Press '''Enter'''.
|| What if we want to see the remainder?

Click on '''cell B8 '''and type '''is equal to MOD, and within the braces, B2 comma B1.'''

Press '''Enter'''.
|-
|| Point to the '''Functions''' section

Click on the '''X''' icon besides '''Functions'''.
|| Explore the other '''functions''' available in the '''Functions Wizard''' later on your own.

Close the '''Functions Wizard'''.
|-
|| Only narration
|| Next, let’s learn how to implement '''statistical''' '''functions'''.
|-
|| '''Slide''': Statistic Functions
||
* '''Statistical''' '''functions''' are useful for analysis of '''data''' in '''spreadsheets'''.
* For example, '''statistical''' '''functions''' like '''COUNT, MIN, MAX, MEDIAN, MODE'''

|-
|| Click on '''sheet 1.'''
|| Let us go to '''Sheet 1.'''
|-
|| Narration Only
|| Let’s see how to find the '''minimum, maximum''' and the '''median costs'''.

This we will do using '''Calc’s statistical functions'''.
|-
|| Point to the heading '''Cost'''

Point to '''300'''.

Point to '''6000'''.
|| Under the column '''Cost''', we have very few entries.

The minimum cost is rupees '''300'''.

The maximum cost is rupees '''6000'''.
|-
|| Only Narration.
|| These are the results which should be displayed when we use the '''functions'''.
|-
|| Click on cell '''C10'''.
|| Let’s click on the '''cell''' '''C10''' where we will be displaying the result.
|-
|| Click on '''Format as Number '''icon

Point to '''cell C10'''
|| Click on the '''Format as Number''' icon in the '''Formatting toolbar'''

This applies the numbering format to the selected cell.
|-
|| Click on the '''Autosum''' Icon in the '''Formula''' bar

Select '''MIN'''
|| Now go to the '''Formula bar''' and select the '''Autosum''' icon.

From the list select the option '''MIN.'''
|-
|| Click on '''Cell''' '''C3''' >> Hold and drag till '''Cell''' '''C7'''

Press '''Enter'''
|| Select the '''cells C3''' to '''C7''' as shown, with the cursor.

And press '''Enter''' on the keyboard.
|-
|| Point to '''300''' in the result.
|| Now the result is '''300''', which is the minimum value.
|-
|| Click on the '''Autosum''' Icon in the '''Formula''' bar

Select '''MAX'''

Click on '''Cell''' '''C3''' >> Hold and drag till '''Cell''' '''C7 '''[Enter]
|| Likewise do for the '''Maximum function'''.
|-
|| Point to '''6000'''
|| Now the result is '''6000''' which is the maximum value.
|-
|| Replace '''MIN''' with '''MEDIAN'''.

Press '''Enter'''.
|| To find the '''median''' value, in the '''Input Line '''replace the term '''MAX''' with '''MEDIAN'''.

And press the '''Enter''' key.
|-
|| Point to '''800'''
|| The result shows '''800''', which is the '''median cost''' in this '''column'''.
|-
||

Replace '''MEDIAN '''with '''COUNT'''.

Press '''Enter'''.
|| Now, let’s find the count of all entries in this column.

In the '''Input Line '''replace the term '''MEDIAN '''with '''COUNT'''.

And press the '''Enter''' key.
|-
|| Point to '''5'''
|| The result is shown as '''5''' which is the total number of entries in this column.
|-
||

<nowiki>=COUNTIF(C3:C7, ">=1000")</nowiki>

Press '''Enter'''.
|| Now, let’s find the count of all entries in this column which are greater than 1000.

In the '''Input Line '''replace the term '''COUNT '''with '''COUNTIF'''.

After the '''range''' type '''comma space within double quotes greater than 1000.'''

And press the '''Enter''' key.
|-
|| Point to '''Cell C10'''
|| The result is shown as '''2''' which is the total number of entries greater than 1000.
|-
|| Narration Only
|| Explore other '''statistical''' '''functions''' and analyze them on your own later.
|-
|| Delete the changes in this '''cell'''
|| Let us now delete the changes in '''cell C10'''.
|-
|| Narration Only
|| Next, let’s learn how to '''round off''' numbers.

Let us make a few changes under the column '''Cost'''.
|-
|| Change '''6000''' to '''6000'''.'''34'''

Change '''600''' to '''600'''.'''4'''

change '''300''' to '''300'''.'''3'''
|| We shall change: '''6000 '''to''' 6000.34, 600 '''to''' 600.4'''

'''300 '''to''' 300.3.'''
|-
|| Point to '''cell''' '''C8'''
|| Notice that the '''sum''' '''total''' is '''9701'''.'''04'''.

Now suppose we don’t want any decimal places in our result.

The best solution is to '''round''' '''off''' the number to the nearest whole number.
|-
|| Click on cell '''C10'''.

Type '''<nowiki>=ROUND(SUM(C3:C7))</nowiki>'''

Press '''Enter'''
|| Let us click on the '''cell C10.'''

Type '''is equal to ROUND, open bracket SUM '''and again within''' brackets C3 colon C7 '''and '''close''' the''' bracket. '''

Press the '''Enter''' key.
|-
|| Point to '''9701'''
|| You see, that the result is now '''9701'''.

The value '''9701'''.'''04''' is '''rounded''' '''off''' to the nearest whole number.
|-
|| Narration Only
|| '''Rounding''' '''off''', can be done to either the lower whole number or the higher number.
|-
|| Click on '''cell''' '''C10'''.

Edit '''ROUND''' to '''ROUNDUP'''.

Press '''Enter'''.
|| Let’s click on the '''cell''' with the result and edit the term '''ROUND''' to '''ROUNDUP'''.

Now, press the '''Enter''' key.
|-
|| Point to '''9702'''
|| You see that the result is now '''9702''' which is the higher whole number.
|-
|| Click on cell '''C 10'''

Edit ROUNDUP to ROUNDDOWN.

Press '''Enter'''
|| To round off to the lower whole number, change the term '''ROUNDUP''' to '''ROUNDDOWN.'''

And press the '''Enter''' key.
|-
|| Point to '''9701'''
|| This time the result is '''9701''' which is the lower whole number.
|-
|| Narration Only
|| There are many other '''functions''' available in the '''Functions Wizard library''' of '''Calc'''.

Explore and analyze them on your own later.
|-
|| Click on the '''X''' icon and Click on '''Don't''' '''Save'''
|| Let us close the file without saving the changes.
|-
|| Narration:
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt about:

* '''Conditional''' '''Operators'''
* '''If..Or statement'''
* Basic '''statistical''' '''functions '''and
* '''Rounding''' '''off''' numbers

|-
|| '''Slide: '''Assignment
|| As an assignment

* Open '''Spreadsheet-Practice.ods '''file
* With the '''salary data '''try out '''MIN''', '''MAX''' and '''MEDIAN''' functions
* Try '''round off function''' with the same '''salary data'''
* Undo the changes at the end.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
||
* Please post your timed queries in this forum.

|-
|| '''Slide''': Acknowledgement
| |
* Spoken Tutorial project is funded by MHRD, Govt. of India.

|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C3/Advanced-Formatting-and-Protection-in-Calc/English

2020-09-10T07:20:10Z

Arvindpillai90: Created page with "Title: Advanced Formatting and Password Protection Author: Arvind Pillai Novice reviewer: Nikita Misal & Pooja Moolya Domain reviewer: Praveen S and nancy varkeyKeywords: L..."

Title: Advanced Formatting and Password Protection

Author: Arvind Pillai

Novice reviewer: Nikita Misal & Pooja Moolya

Domain reviewer: Praveen S and nancy varkeyKeywords: LibreOffice,Calc,Ubuntu,Password protect Calc file,Password protect a single sheet in Calc,Define ranges for database in Calc,Subtotal option in Calc,Validate cells in Calc

{|border="1"
|-
|| '''VISUAL''' '''CUE'''
|| '''NARRATION'''
|-
|| '''Slide:''' Tittle
|| Welcome to the spoken tutorial on '''Advanced Formatting and Password Protection '''in''' Calc'''.
|-
|| '''Slide''': Learning objectives
|| In this tutorial, we will learn how to:
* Protect a '''spreadsheet '''with a '''password'''
* Protect a single '''sheet''' with a '''password'''
* Define '''Ranges''' for a '''database'''
* Use the '''Subtotal''' option and
* Validate '''cells'''.

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS''' version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open '''Personal-Finance-Tracker.ods'''
|| Let us open our '''Personal-Finance-Tracker.ods '''file'''.'''
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Please download and extract the file.
* Make its copy and use it for practising.

|-
|| Narration Only
|| First let us learn to protect this '''spreadsheet '''with a '''password'''.

This option ensures that only people who know the '''password''' can open this '''spreadsheet'''.
|-
|| Click >> '''Save''' icon >> '''Save''' '''As'''
|| Click on the drop-down besides the '''Save''' icon and select '''Save''' '''As''' option.
|-
|| Point to dialog box.
|| '''Save As''' dialog box opens up.
|-
|| Check the '''Save''' '''with''' '''password''' option.

Click '''Save''' button
|| Next, check the '''Save with password''' checkbox at the bottom left corner.

And then click the '''Save''' button at the top right corner.
|-
|| Point to the file already exists overwrite? dialog box.

Click '''Yes'''.
|| In the '''Save''' '''As''' option, we can either save it as a different file or replace the same file.

For this demonstration, we will replace the file.

Click '''Yes'''.
|-
|| Point to the dialog box.
|| '''Set''' '''Password''' dialog box opens up.
|-
|| Type the password : '''spoken123'''

Retype the password as '''spoken123''' in '''Confirm''' box also

Click '''Ok'''
|| Here in the '''Enter password to open''' field, type a '''password,''' say '''spoken123'''.

In the '''Confirm password''' text field, retype the same '''password '''that is '''spoken123.'''

Then click on the '''OK''' button in the dialog box.
|-
|| Close the file
|| Close the file.
|-
|| Open the file '''Personal-Finance-Tracker.ods'''
|| Now, we’ll try to reopen this file and check what happens.
|-
|| Point to '''Enter Password '''dialog box

Enter the password: '''111 >> '''Click '''OK'''.
|| Immediately the '''Enter Password''' dialog box appears.

Let us type the '''password''' as '''111''' here and click on the '''OK''' button.
|-
|| Point to the error message

Click '''OK'''.
|| We get an error message.

It says '''The password is incorrect.The file cannot be opened'''.

Click on the '''OK''' button.
|-
|| Enter the password: '''123'''

Click '''OK'''.

Point to '''spreadsheet'''
|| This time in the '''Enter''' '''password''' field, type the correct '''password''' as '''spoken123.'''

Click on the '''OK''' button.

The '''Personal-Finance-Tracker.ods '''file opens.
|-
|| Narration only
|| It is possible for us to remove the '''password''' option at a later time, as well.
|-
|| Click dropdown of '''Save''' icon >> '''Save''' '''As''' option
|| To do that, click on the drop-down besides the '''Save''' icon and then on the '''Save''' '''As''' option.
|-
|| Un-check '''Save with Password '''option.

Click >> '''Save'''
|| Now uncheck the '''Save''' '''with''' '''password''' option in the '''Save''' '''As''' dialog box.

Then click the '''Save''' button at the top right corner.
|-
|| Click >> '''Yes '''button
|| Let’s replace the same file by clicking on the '''Yes''' button.
|-
|| Close and open the file.

Narration Only
|| Once again, let us close and open this file.

Notice that, this time we do not require a '''password''' to open the file.
|-
|| Narration Only
|| Next, let’s learn how to '''password'''-protect individual '''sheets''' in the '''spreadsheet'''.
|-
|| Click on '''Tools''' from the menu bar >> Point on '''Protect''' '''Sheet'''

Right click on '''Sheet''' '''1''' tab >> Select '''Protect''' '''Sheet'''
|| Go to the '''Tools''' menu in the '''menu bar''' and click on the '''Protect sheet''' option.

Alternatively, right click on the '''Sheet''' '''1''' tab at the bottom and select '''Protect''' '''Sheet '''option.
|-
|| Point to the '''Protect''' '''Sheet''' dialog box.
|| Either ways, the '''Protect''' '''Sheet''' dialog box opens.
|-
||

Un-check '''Select Protected cells''' and '''Select''' '''Unprotected''' '''cells'''.
|| To protect the '''sheet''', uncheck the following options by clicking on the '''checkbox''' besides it:
* '''Select protected cells '''and''' '''
* '''Select unprotected cells.'''

|-
|| In the '''Password''' type '''spoken123'''.

Re-enter the password '''spoken123''' in the '''Confirm''' field.

Click OK.
|| Now, in the '''Password''' field, let’s type '''spoken123''' as our '''password'''.

In the '''Confirm''' field, retype the same '''password'''.

Then click on the '''OK''' button in the dialog box.
|-
|| Point to '''Sheet''' '''1''' '''lock''' '''Symbol'''.
|| We can see a '''lock''' symbol in the '''Sheet 1''' tab.

This indicates that our '''sheet''' is now '''password-'''protected.
|-
|| Click any '''cell''' and type to show that you cannot enter the '''data'''.
|| To verify, let’s try to add some '''data''' in any '''cell '''on this''' sheet'''.

Notice that we are unable to type anything in any '''cell'''.
|-
|| Warning message >> Click '''Ok''' to exit this box.
|| Also, we see a warning message. Click '''Ok''' to exit this box.
|-
|| Click any '''image''' and try to move.
|| We are also unable to select or move the '''image '''in this '''sheet '''elsewhere.
|-
|| Narration Only

Click on '''Sheet 2'''.
|| But what about the other '''sheets'''?

Let’s click on '''Sheet 2'''.
|-
|| Click on '''E3''' and type '''testing'''.

Point to '''cell''' '''B11'''
|| Here we’ll select '''cell E3 '''and type the word '''testing''' inside the '''cell.'''

'''Calc''' allows us to edit the '''cells''' in other '''sheets'''.
|-
|| Press''' Ctrl + Z'''
|| Let’s undo these changes.
|-
|| Click on''' Sheet 1''' tab
|| Now go back to''' Sheet 1'''.
|-
|| Narration Only
|| Let’s unprotect the '''sheet '''now.
|-
|| Right click on '''Sheet''' '''1''' tab >> Select '''Protect''' '''Sheet'''
|| Right-click on '''Sheet''' '''1''' tab and select '''Protect''' '''sheet''' option.
|-
|| Point to the '''Unprotect''' '''Sheet''' dialog box.

Enter '''spoken123''' as '''password'''
|| The''' Unprotect''' '''Sheet''' dialog box opens up and prompts us for the '''password'''.

Type '''spoken123''' in the '''Password (optional) '''text field.
|-
|| Click '''OK''' button.
|| Click on the '''OK''' button in the dialog box.
|-
|| Point to '''Sheet 1''' tab
|| Notice the lock symbol in '''Sheet 1''' tab has disappeared now.

This indicates that '''Sheet 1''' is no longer '''password'''-protected.
|-
|| Type '''testing''' in '''D10''' and

move '''image 1''' to '''G2'''
|| We are able to edit the '''cells''' again and move the '''images '''as well.
|-
|| Narration Only
|| Next, let’s learn about '''Ranges'''.
|-
|| Slide: '''Ranges'''
||
* We can define a '''range''' of '''cells''' in a '''spreadsheet''' and use it as a '''database'''.
* Each '''row''' in this '''database range''' corresponds to a '''database record'''
* While each '''cell''' in a '''row''' corresponds to a '''database field'''.
* We can '''sort''', '''group''', '''search''' and perform calculations on the '''range''' as we would do in any '''database'''.

|-
|| Narration Only:
|| First, let’s define a '''database''' in our '''Personal-Finance-Tracker.ods '''and then '''sort''' the '''data'''.

So, let’s select the '''items''' which we require in the '''database'''.
|-
|| Select all data under '''SN''' to '''Miscellaneous''' together.

Ignore the '''Sum Total '''row
|| We’ll select all the '''data''' from column '''SN''' to '''Miscellaneous.'''

We’ll Ignore the '''Sum''' '''Total''' row for now.
|-
|| Narration Only
|| Let’s name our '''database'''.
|-
|| Click on '''Data''' menu >> click on '''Define''' '''Range'''
|| Go to the '''Data''' '''menu''' in the '''menu bar''' and select the '''Define''' '''Range''' option.
|-
|| Point to '''Define''' '''Database Range '''dialog box.
|| '''Define''' '''Database Range''' dialog box opens up.
|-
|| In the '''Name''' field, type '''dtbs'''.
|| In the '''Name''' field, type '''dtbs''' which is the short-form of the '''database'''.
|-
|| Click '''OK'''.
|| Click on the '''OK '''button in the dialog box.
|-
|| Click anywhere else in the '''spreadsheet'''
|| Click anywhere else in the '''spreadsheet''' to deselect the '''cells'''.
|-
|| From the Menu bar >> Click on '''Data''' >> click on '''Select''' '''Range'''
|| Again go to the '''Data''' '''menu''' in the '''menu bar''' and click on the '''Select''' '''Range''' option.
|-
|| Point to''' Select Database Range''' dialog box

Point to '''dtbs''' in the dialog box.
|| '''Select Database Range''' dialog box appears.

Notice that in the '''Ranges''' section, the name '''dtbs''' is listed as a '''database'''.
|-
|| Click on '''dtbs''' and Click on '''OK'''
|| Click on '''dtbs''' from the list and then click on the '''OK''' button in the dialog box.
|-
|| Only Narration
|| Now we can sort the '''data''' within this '''database, '''however we want.

Sorting '''data''' was already explained in an earlier tutorial in this series.

So, we’ll skip that demonstration here.
|-
|| Narration Only
|| Next, let’s learn how to use the '''Subtotal''' option in '''Calc'''.
|-
|| '''Slide''': Subtotals
||
* The '''Subtotals''' option calculates the '''sub total''' of '''data''' under different columns.
* For this, we can use any '''mathematical function''' of our choice.

|-
|| Point to the '''cost''' Column
|| Let’s find the '''subtotals''' of the '''data''' in the '''Cost '''column.
|-
|| Delete the entry in row''' '''number''' 8'''.
|| First, let’s delete the entry in '''row number 8''' which is '''SUM''' '''TOTAL'''.
|-
|| Select all '''A1''' to '''F7''' together.
|| Then select all the '''data''' from '''cell A1''' to '''F7''' as shown.
|-
|| Click the '''Data''' menu and '''Subtotals'''.
|| Go to the '''Data''' '''menu''' in the '''menu bar''' and click on the '''Subtotals''' option.
|-
|| Point to the '''Subtotals''' dialog box and the 1st''' Group''' tab.

In the '''Group''' '''by '''>> Click '''SN'''.
|| The '''Subtotals''' dialog box appears.

By default, the '''1st Group''' tab is selected at the top.

Click the '''Group''' '''by''' field drop-down and choose '''SN, '''if not already selected.

This groups the '''data''' by '''SN''' which is the '''Serial''' '''Number'''.
|-
|| In '''Calculate subtotals for''' click on Cost.
|| Next, in the '''Calculate subtotals for''' field, check on the '''Cost''' checkbox.

This will calculate the total of all the entries under it.
|-
|| Under '''Use''' '''function''' choose '''Sum'''

Click '''OK'''.
|| Under the '''Use function '''field, choose '''Sum,''' if not already selected.

And click on the '''OK''' button at the bottom.
|-
|| Point to '''Grand''' '''Sum'''.

Point to '''Subtotals''' and '''SN''' column
|| Notice that the '''Grand''' '''Sum''' of the entries under the column '''Costs''' is displayed on the '''spreadsheet'''.

We also see '''subtotals''' after every row and see the changes in the '''SN''' column.
|-
|| Click on '''cell C14''' >> click on the '''formula bar'''.
|| Click on '''cell C14''' and look at the '''formula bar'''.

We see the syntax of the '''formula, Calc''' has used for the '''SUBTOTAL'''.
|-
|| Point to the syntax
|| It says '''equal to SUBTOTAL''' and within brackets number '''9''' and the '''cell range.'''
|-
|| Point to the blue highlight box in the sheet
|| The same is seen highlighted in the '''spreadsheet''' as well.
|-
|| Slide: '''Subtotal''' '''Function'''
|| Refer to this table for numbers that correspond to '''functions''' within the '''SUBTOTAL formula'''.

9 stands for the '''function SUM''' which is what we had selected in the '''SUBTOTAL '''dialog box.

Other '''function''' numbers are mentioned in this table, for your quick reference.

Use the corresponding numbers in the left column, when you wish to use another '''function'''.
|-
|| Point to '''1,2,3''' on the left hand side.
|| At the top left below the '''Name''' '''Box,''' we can see 3 tiny new tabs '''1, 2 '''and''' 3.'''

These tabs give 3 different views of the '''data'''.
|-
|| Click on '''tab 1.'''

Point to''' Grand sum'''
|| Let’s click on '''tab 1'''.

Notice that only the '''grand''' '''sum''' of the '''data''' under '''Costs''' along with the last '''subtotal'''.
|-
|| Click on '''tab 2.'''

Point to''' Costs and Grand sum'''
|| Click on '''tab 2.'''

The '''data''' under '''Costs''' as well as the '''Grand sum''' is displayed.
|-
|| Click on '''tab 3.'''

Point to''' Sheet'''
|| Now, click on '''tab 3.'''

We get the detailed view of all the '''data''' along with the '''Grand''' '''sum''' of the '''data''' under '''Costs'''.
|-
|| Close the '''file'''.
|| Let’s close this '''file''' without saving the changes.
|-
|| Reopen the '''file''' again.
|| And let’s re-open the '''file'''.
|-
|| '''Slide''':Validity
|| We’ll now learn about the '''Validity''' option in '''Calc'''.

* The '''Validity''' option validates '''data''' in the '''spreadsheet'''.
* This is done by specifying the '''Validation''' '''rules''' for the selected '''cells''' in the '''spreadsheet'''.

|-
|| Narration Only
|| For example, we can specify the mode of payment for the '''items''' bought using '''Validation'''.
|-
|| Type the heading '''MOP''' next to '''Received'''.
|| Let’s add a new column '''Mode of Payment''' as '''MOP''' next to the column '''Received.'''
|-
|| Point to '''M-O-P'''

Point to '''Items''' Column

Point to Items Component
|| Below the heading '''MOP''', the '''cells''' can be used to display the mode of payments.

The '''MOP''' for the '''Items''' in '''Column''' '''B''' can be shown here.

That is, '''Salary, House Rent, Electricity Bill''' and the other components.
|-
|| Click on the cell '''F2''' just below '''MOP'''.

Point to '''Salary'''.
|| Now, let us click on the empty '''cell''' just below the heading '''MOP.'''

This will have the mode of payment for the '''item Salary'''.
|-
|| From the Menu bar >>click on '''Data''' >> click on '''Validity'''
|| Go to the '''Data''' '''menu''' in the '''menu bar''' and select '''Validity''' option.
|-
|| Point to the '''Validity''' dialog box.

Click the '''Criteria''' tab.
|| The '''Validity''' dialog box pops up.

Let’s click the '''Criteria''' tab at the top if not already selected.
|-
|| From the '''Allow''' field drop-down, click '''List'''.
|| From the '''Allow''' field drop-down, select '''List'''.
|-
|| Point to the '''Entries''' box.
|| The '''Entries''' box gets displayed.

Let’s enter the options which will appear on validating the selected '''cell'''.
|-
|| In the '''Entries''' box >> type '''In''' '''Cash''' [Enter]
|| We’ll type''' '''the first mode of payment as '''In''' '''Cash''' and press '''Enter.'''
|-
|| In the '''Entries''' box >>

type '''Cheque '''[Enter]

type '''Online '''[Enter]
|| Next, we’ll type the following entries as shown.
|-
|| Click on '''OK'''.
|| Click on the '''OK''' button at the bottom of the dialog box.
|-
|| Point to the cells.
|| Notice the down arrow displayed alongside '''cell''' '''F2''', which means the '''cell''' is validated.
|-
|| Click the down arrow on the '''cell'''

Point to the three options.

Click the down arrow on the '''cell'''
|| Now, click the down arrow.

We see the options that we entered as '''Mode''' '''of''' '''Payments''' in the '''Entries''' box here.

Click on the down arrow again to collapse the list.
|-
|| Click on '''Clone''' '''Formatting''' icon
|| To validate the '''cells''' below, click on the '''Clone''' '''Formatting''' icon in the '''Standard''' '''toolbar'''.
|-
|| Drag and select 5 '''cells F3 to F7 '''below it.
|| Then, click on the '''cell''' '''F3''' and press the left mouse button.

Drag along the '''cursor''' till '''cell F7''' and release the '''mouse''' button.
|-
|| Select a '''cell''' and show that it has been validated.
|| All selected '''cells''' are validated in one go.
|-
|| Click on the '''cell''' just below '''MOP''' >> click on down arrow

Click on''' Online'''
|| Now click on the '''cell''' just below the heading '''MOP''' and then click on the down arrow alongside.

For''' mode of payment''' let’s select '''Online'''.
|-
|| Narration Only

'''House rent >> Cheque'''

'''Electricity Bill >> Online'''

'''Phone BIll >> Online'''

'''Laundry >> In Cash'''

'''Miscellaneous >> In Cash'''
|| In the same manner, you can select the options in each of the validated '''cells'''.

Select according to the '''mode of payment''' made for each '''Items''' as shown.
|-
|| Narration Only
|| Likewise we can '''format''' and '''validate''' other columns in the '''spreadsheet'''.
|-
|| '''Ctrl + S'''
|| Let’s save all these changes and close the file.
|-
|| Narration Only:
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt to:

* Protect a '''spreadsheet '''with a '''password'''
* Protect a single '''sheet''' with a '''password'''
* Define '''Ranges''' for a '''database'''
* Use the '''Subtotal''' option and
* Validate '''cells'''.

|-
|| '''Slide: '''Assignment
|| As an assignment
* Open '''Spreadsheet-Practice.ods '''file
* Use the '''password''' '''protect''' option to protect the '''sheet''' named '''Department Sheet'''
* Use the '''Subtotals''' option and find the '''grand''' '''sum''' of '''salary''' column
* Close the file without saving the changes.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
||
* Please post your timed queries in this forum.

|-
| | '''Slide''': Acknowledgement
| |
* Spoken Tutorial project is funded by MHRD, Govt. of India.

|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C3/Inserting-Images-and-inbuilt-Graphics-in-Calc/English

2020-09-01T19:24:41Z

Arvindpillai90: Created page with "Title: Images and inbuilt Graphics Author: Arvind PillaiKeywords: LibreOffice, Calc, Ubuntu, Creating charts in Calc, Inserting image in Calc, Inserting image as link in Calc..."

Title: Images and inbuilt Graphics

Author: Arvind PillaiKeywords: LibreOffice, Calc, Ubuntu, Creating charts in Calc, Inserting image in Calc, Inserting image as link in Calc, Delete an image in Calc, Formatting images in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide:''' Title

'''Inserting Images and inbuilt Graphics'''
|| Welcome to the spoken tutorial on '''Inserting Images and inbuilt Graphics in a spreadsheet.'''
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn to:
* Insert an '''image''' into a '''spreadsheet''' and
* Format the '''image'''

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide''': Images
|| '''Images''' can be added into a '''spreadsheet'''
* Directly from a '''graphics''' program or
* With the help of a '''clipboard''' or
* From the '''Calc gallery'''

|-
|| Only Narration
|| We will discuss each one of them in detail.
|-
|| Open '''Personal-Finance-Tracker.ods'''
|| Let us open our '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code Files'''
||
* This file and images have been provided to you in the''' Code files''' link on this tutorial page
* Please download and extract the files to a folder on your '''Desktop'''
* Make its copy and use it for practising

|-
|| Only Narration

Click on '''cell C2'''
|| It is a good practice to select a '''cell''' and then insert an '''image'''.

Let’s click on '''cell C2.'''
|-
|| Point >> '''Insert''' '''Image''' icon
|| Now, click on the '''Insert''' '''Image''' icon in the '''Standard''' '''toolbar'''.
|-
|| Click on '''Insert''' menu

Click on '''Image'''
|| Alternatively, you can click on the '''Insert''' menu in the '''menu''' '''bar.'''

And then click on the '''Image''' option.
|-
|| Point to dialog box
|| Either ways the '''Insert''' '''Image''' dialog box opens.
|-
||

Go to '''Desktop >> '''Click on the '''Images''' folder >> Point to the images

Only Narration

Next click on '''Image1''' file.
|| Now locate the '''image''' that you want to insert on your computer.

I have saved some images on my '''Desktop''' in a folder named '''Images'''.

These images are available in the '''Code files''' link below the player, as mentioned earlier.

I will choose '''Image1 '''from my computer.
|-
|| Click on '''Open''' button
|| Then click on the '''Open''' button at the top right corner.
|-
|| Point to the '''image''' inserted in the '''spreadsheet'''.
|| Observe that the '''image''' is displayed in the '''spreadsheet'''.
|-
|| Narration only
|| But, the '''image''' is covering up some of the '''data'''.

So we have to resize the '''image.'''
|-
|| Point to the '''handles''' on the '''image'''
|| When the '''image '''is selected, we see '''handles''' around it.
|-
|| Click on the corner '''handle''' and increase/decrease the size of the '''image'''
|| Click and drag any of the corner '''handles''' to resize the '''image''' proportionally.

|-
|| Point to the '''image'''
|| Now let’s move the '''image'''.
|-
|| Click on the '''image'''

Click and move the '''image''' to the right of the '''spreadsheet''' >>

Release the mouse button
|| Place the '''cursor''' on any one of the borders till the '''cursor''' turns into a '''hand'''.

Click and move the '''image''' to the desired location and then release the '''mouse''' button.
|-
|| Point to the image
|| Now, we can see our '''data''' and the '''image''' clearly.
|-
|| Point to''' Formatting toolbar'''
|| When the '''image''' is selected, the '''Formatting toolbar''' shows options related to '''image '''only.

We will learn more about these options later in this tutorial.
|-
|| Only Narration
|| To exit the '''Image edit mode''', click anywhere outside the '''image'''.
|-
|| Narration Only

Click on '''Sheet 2''' tab the bottom
|| Let us insert another '''image''' by '''hyperlinking''' it.

For this part of the demonstration, we will work on '''Sheet''' '''2.'''

So, click on the '''Sheet''' '''2''' tab at the bottom.
|-
|| Click on cell '''A2'''

Click on >> '''Insert''' '''Image''' icon
|| In '''Sheet 2''', we will select '''cell A2.'''

Then click on the '''Insert''' '''Image''' icon in the '''Standard toolbar.'''
|-
|| Point to dialog

Click on '''Desktop >>''' '''Images''' folder

Click on '''Image2'''
|| '''Insert''' '''Image '''dialog box opens up.

This time I will choose '''Image2 '''from my computer.

Locate the '''image''' that you want to insert on your computer.
|-
|| Put a check on '''Insert''' '''as''' '''Link''' option
|| To link the '''image''' to the '''spreadsheet''', check the '''Insert''' '''as''' '''Link''' checkbox at the bottom left.
|-
|| Click '''Open'''
|| Then click on the '''Open''' button at the top right corner.
|-
|| Point to the dialog box.
|| The '''Confirm Linked Graphic''' dialog box appears.
|-
|| Point the checkbox
|| Check the option '''Ask when linking the graphic '''if not already checked by default.
|-
|| Click on the '''Keep''' '''Link''' button.
|| Then click on the '''Keep''' '''Link''' button.
|-
|| Point to the '''Image2''' file.
|| The '''image''' is now '''hyperlinked''' to this '''spreadsheet'''.
|-
|| '''Slide''': Linking
|| When we link an '''image''':

* First, it reduces the size of the '''spreadsheet''' as our '''spreadsheet''' does not contain the '''image'''.
* Second, it enables the user to modify both the files separately.
* Changes made to the '''image''' file are reflected in the '''linked image''' in the '''spreadsheet'''.

|-
|| Press '''Ctrl + S''' and close
|| Let's save and close our '''spreadsheet''' now.
|-
|| Go to '''Desktop >>''' '''Images''' folder
|| Go to the folder where all the '''images''' are saved.
|-
|| Rename '''Image2''' >>'''Image2-old''' Rename '''Image3''' >> '''Image2'''
|| Rename '''Image2''' as '''Image2-old''' and rename '''Image3''' file as '''Image2.'''
|-
|| Open '''Personal-Finance-Tracker.ods'''.

Point to '''Image2'''
|| Let us open our '''Personal-Finance-Tracker'''.'''ods '''file once again.

Notice that '''Image2''' in the '''spreadsheet''' has now changed'''.'''
|-
|| '''Slide:''' Disadvantage of linking
|| However, one major disadvantage of '''hyperlinking''' a file is that* Whenever you want to send this '''spreadsheet''' to a different computer or user
* You will have to send both the '''spreadsheet''' as well as the '''image''' file.
* Which means, you have to keep track of the location where you are saving both the files.

|-
|| Only Narration
|| Next, let’s learn another method of inserting '''images''' into a '''spreadsheet.'''

This is done by dragging and dropping the '''image''' from its saved folder location.
|-
|| Go to '''Desktop >>''' '''Images''' folder
|| Go to the folder where all the '''images''' are saved.
|-
|| Drag and drop '''Image2-old''' into the spreadsheet on the '''center'''.
|| Now drag-and-drop '''Image2-old''' directly into the '''spreadsheet''' wherever you want to place it.

I will place it in this empty space.
|-
|| Point to the '''image''' in the '''spreadsheet'''.
|| The '''image''' gets inserted into our '''spreadsheet'''.
|-
|| Press '''CTRL + Z '''keys
|| Let’s undo this change.
|-
|| Narration Only
|| Next let us '''hyperlink''' the same '''image''' using the drag-and-drop method.

This method is easy too!
|-
|| Go to '''Desktop >>''' '''Images''' folder
|| Go to the folder where all '''images''' are saved.
|-
|| Press''' Ctrl + Shift '''keys together >> click on''' Image3'''

Drag and place the '''image''' into the '''spreadsheet'''
|| Hold the '''Control''' and '''Shift''' keys together and then click on '''Image2-old.'''

Now drag the '''image''' onto the '''spreadsheet'''.
|-
|| Point to the '''Image3.'''
|| The '''image''' is now '''hyperlinked''' to this '''spreadsheet'''.
|-
|| Press''' CTRL + S '''keys >> close the '''spreadsheet'''
|| Save and close the '''spreadsheet''' now.
|-
|| Go to '''Desktop >>''' '''Images''' folder

Rename the image '''Image3.jpg''' >> '''Image4.jpg'''
|| Once again go to the folder where all the '''images''' are saved.

Let’s rename the file '''Image2-old''' as '''Image4.'''
|-
|| Open''' Personal Finance Tracker.ods'''
|| Now re-open the '''Personal Finance Tracker.ods '''file

again.
|-
|| Point to the blank area where the '''image''' disappears.

Point to the image path shown
|| The '''hyperlinked image''' is no longer visible in the '''spreadsheet'''.

The '''hyperlinked path''' shows an error!
|-
||

Click on error path
|| So, let’s delete this '''hyperlink'''.

To do so, click on the '''hyperlinked path''' shown as an error.

This will select the missing '''image'''.
|-
|| Press '''Delete''' key on keyboard.

Point to an empty place.
|| Now press the '''Delete''' key on the keyboard.

The missing '''hyperlinked''' '''image''' is deleted.
|-
|| Only Narration.
|| Next we will learn how to insert '''images''' from the '''clipboard'''.
|-
|| Narration Only
|| We can copy '''images''' stored on the '''clipboard''', from one '''spreadsheet''' to another.
|-
|| Open a new '''spreadsheet''' document'''.'''
|| Let's open a new '''spreadsheet''', which will be our '''target file'''.
|-
|| Switch to '''Personal-Finance-Tracker.ods''' file
|| We already have images in '''Personal-Finance-Tracker.ods'''.

This '''spreadsheet''' is our '''source file'''.
|-
|| Select image '''Image2 '''
|| Now select '''Image2''' from the '''source file''' which is to be copied.
|-
|| Press''' Ctrl + C''' keys together
|| Press '''CTRL''' and '''C''' keys together to copy the '''image'''.

The '''image''' is now saved on the '''computer’s clipboard.'''
|-
|| Switch to '''Untitled 1'''.
|| Now switch to the '''target document''', which is '''Untitled 1.'''
|-
|| Select '''B2 '''cell.
|| Select the location where you wish to place the saved '''image''' in '''Untitled 1'''.
|-
|| Press '''Ctrl + V''' keys together
|| Now press '''CTRL''' and '''V''' keys together to insert the '''image''' into the '''spreadsheet'''.
|-
|| Point to the inserted '''image'''.
|| The '''image''' is inserted into our '''target file'''.
|-
|| Close the '''Untitled 1 '''document
|| Close the '''Untitled 1 '''document without saving it.
|-
|| Only Narration
|| Next let us explore the other options available in the '''Picture''' '''toolbar.'''

|-
||

Click on '''Sheet''' '''1'''
|| For this part of the demonstration we will work on '''Sheet''' '''1.'''

Click on the '''Sheet''' '''1''' tab at the bottom.
|-
|| Click on '''Image1'''

Point to the '''Picture''' toolbar
|| Now let’s click on''' Image1.'''

The '''Formatting''' '''toolbar''' changes to the '''Picture''' '''toolbar'''.
|-
|| Hover the cursor on '''icons'''
|| Here, we see various tool icons to edit an '''image'''.
|-
|| Only Narration
|| If you have resized your '''LibreOffice''' window, some of the icons may not be visible.
|-
|| Click on Double arrow '''>>''' icon at the end of the '''toolbar'''
|| In that case, click on the '''double arrow''' icon at the end of the '''toolbar''' to see the hidden icons.
|-
|| Click on the '''Filter''' Option

Click on the Charcoal''' Sketch''' option

Point to '''Image1'''
|| Click on the drop-down of the '''Filter''' option.

From the pop-up menu, let’s click on the '''Charcoal Sketch''' option.

Observe the change in '''Image1.'''
|-
|| Only Narration
|| Next let’s see how to crop this '''image.'''

Make sure that the '''image''' is selected.
|-
|| Click on >> '''Crop''' '''image '''icon
|| Now click on the '''Crop''' '''image''' icon in the '''Picture''' '''toolbar.'''
|-
|| Point to Blue '''Handles'''
|| We see '''blue''' '''colored''' '''handles''' appear around the '''image.'''
|-
|| Click on the corner '''handle''' >> decrease the size of the '''image'''.
|| Click and drag any one of the '''handles, '''as shown.

|-
|| Click on any random cell
|| Then click anywhere outside the '''image '''to exit from the '''Image editing mode'''.
|-
|| Point to the '''Image'''
|| The '''image''' gets cropped as per our selection.
|-
|| Point to the other options.
|| There are other options on the '''Picture''' '''toolbar''' which you can explore on your own later.
|-
|| Narration Only
|| Now we will learn how to insert '''images''' directly from the '''Calc Gallery.'''

'''Gallery '''has '''images''' as well as '''sounds '''which we can insert in our '''spreadsheet'''.

Let’s see how to do this.
|-
|| Click on the '''Insert '''menu in the menu bar.

Go to '''Media''' option and Point to the '''Gallery''' option
|| Click on the '''Insert''' menu in the '''menu bar'''.

From the sub-menu go to the '''Media''' option and click on '''Gallery''' to open it.
|-
|| Click '''gallery''' icon in the sidebar

Point to '''Gallery''' section
|| Alternately, click on the '''Gallery''' icon on the '''Sidebar''' which is at extreme right.

This opens the '''Gallery''' section.
|-
|| Scroll the folders
|| We can see various folders which have '''inbuilt images''' which we can use.
|-
|| Click on Finance Folder.
|| Select the '''Finance''' folder by clicking on it.
|-
|| Drag and drop '''ATM01''' image on a suitable '''cell'''.
|| Then drag-and-drop the '''image ATM01''' into the '''spreadsheet'''.
|-
|| Point to the image inserted.

Narration Only
|| We see that the '''image''' gets inserted into our '''Personal-Finance-Tracker.ods''' file.

Likewise you can insert and format any '''image''' in your '''spreadsheet'''.
|-
|| Delete '''ATM 01 image'''

Click on '''X''' icon Besides '''Gallery'''
|| We don’t need the '''ATM01 image''' anymore, so we will delete it.

Then close the '''Gallery''' section by clicking on the '''X''' icon besides '''Gallery'''.
|-
|| '''Ctrl + S'''
|| Lastly save and close the file.
|-
|| Narration:
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide''': Summary I
|| In this tutorial, we learnt to insert an '''image''' into a '''spreadsheet''' in many different ways like* From a file
* From the '''clipboard''' and
* From the '''Calc gallery'''

|-
|| '''Slide''': Summary II
|| We have also learnt how to:

* Move and resize the '''image'''
* Apply a filter to the '''image''' and
* Crop the '''image'''

|-
|| '''Slide:''' Assignment
|| As an assignment
* Open '''Spreadsheet-Practice.ods '''file
* Insert an '''image''' as a '''link''' in '''Sheet''' '''2'''
* Save and close the file.

|-
|| '''Slide:''' Assignment
||
* Go to the folder where the '''image''' is saved.
* Now rename the '''image'''.
* Open and check if the '''image''' is still visible in the '''spreadsheet'''.
* Now rename the '''image''' back to its original name.
* Check if the '''image''' is visible in the '''spreadsheet.'''

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
|| * The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
|| * Please post your timed queries in this forum.

|-
| | '''Slide''': Acknowledgement
| | * Spoken Tutorial project is funded by MHRD, Govt. of India.

|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C3/Using-Charts-and-Graphics-in-Calc/English

2020-09-01T17:56:10Z

Arvindpillai90: Created page with "Title: Using Charts and Graphs Author: Arvind PillaiKeywords: LibreOffice, Calc, Ubuntu, Creating charts in Calc, Editing charts in Calc, Formatting charts in Calc, Resizing..."

Title: Using Charts and Graphs

Author: Arvind PillaiKeywords: LibreOffice, Calc, Ubuntu, Creating charts in Calc, Editing charts in Calc, Formatting charts in Calc, Resizing charts in Calc, Moving charts in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide:''' Title
|| Welcome to the Spoken Tutorial on '''Using Charts and Graphs''' in '''Spreadsheets'''.
|-
|| '''Slide''': Learning Objectives
|| In this tutorial, we will learn how to:
* Create
* Edit
* Resize
* Format
* Move and
* Delete

'''charts '''in''' LibreOffice Calc'''
|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide: '''Charts
||
* '''Charts''' can powerfully convey information to the reader
* '''LibreOffice Calc''' offers a variety of '''chart formats''' for our data
* Using '''Calc''', we can customize '''charts''' to a considerable extent

|-
|| Open '''Personal-Finance-Tracker.ods'''
|| Let us open our '''Personal-Finance-Tracker.ods '''file'''.'''
|-
|| '''Slide: Code Files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page
* Please download and extract the file
* Make its copy and use it for practising

|-
|| Point to the border
|| Notice that all '''cell''' '''borders''' are incomplete.

Let us sort this out first.
|-
|| Click on cell''' A1 >> '''holding the '''Shift''' key, click on '''cell H8'''
|| Select '''cells A1 '''to''' H8'''.
|-
|| Click on the '''Borders''' icon Dropdown

Click >> Last border option
|| Then go to the '''Formatting''' '''toolbar''' and select the dropdown next to the '''Borders''' icon.

Select the option that will display all borders.
|-
|| Click on any empty cell
|| Click anywhere outside the selected area to deselect the '''cells'''.
|-
|| Only Narration
|| Our chosen '''border style''' is now applied to all the selected '''cells'''.
|-
|| Hold '''Ctrl key''' and click on '''D''' and '''G''' columns

Click on the '''Column''' icon in the '''Standard toolbar''' >> select '''Delete entire''' '''Columns''' option
|| We do not need the '''Days''' and '''Date''' columns anymore.

So, let us delete them as shown.
|-
|| Point to '''Spent '''column''' '''

Click on '''D3''' and type>> '''6500'''

Type '''1000''' in '''D4'''

Type '''625''' in '''D5'''

Type '''310''' in '''D6'''

Type '''2700''' in '''D7'''
|| Let us fill the amount spent for each item listed in the '''Spent column'''.
|-
|| Point to '''Received''' column

Click on '''E3''' and type '''500'''

Type '''200''' in '''E4'''

Type '''75''' in '''E5'''

Type '''10''' in '''E6'''

Type '''700''' in '''E7'''
|| Next, we’ll fill the amounts '''received''' for each item listed in the '''Received '''column.
|-
|| Point to the amounts
|| Let us now format the values in '''Spent''' and '''Received '''columns to '''INR''' '''currency''' format'''.'''
|-
|| Click on '''cell D3 >> '''Press '''Shift '''key >> click on '''Cell E7'''
|| Select the cells '''D3 '''to '''E7, '''by holding the '''Shift''' key and clicking like this.
|-
|| Click on >> '''Format''' '''as''' '''Currency'''

Scroll down and click on '''INR ₹ English India'''
|| On the '''Formatting''' '''toolbar''', select the dropdown of the '''Format''' '''as''' '''Currency '''icon.

Scroll down and select the option''' INR ₹ English India'''.
|-
|| Click on any empty cell
|| Click anywhere outside the selected area to deselect the '''cells'''.
|-
|| Only Narration
|| Now our '''spreadsheet''' has the necessary '''data''' we need to proceed ahead.
|-
|| Only Narration
|| So, let us see how to create a '''chart''' for this '''data'''.
|-
|| Click Cell '''A1'''

Press and hold '''Shift''' key >> Click on cell '''E7'''

Point to the '''Name Box'''
|| To create a '''chart''', first we have to select the '''data''' to be included in the '''chart'''.

Select '''cells A1 '''to '''E7'''.

The selection can be verified in the '''Name Box''' at the top left.
|-
|| Point >> '''Insert''' '''Chart''' icon
|| Now, click on the '''Insert''' '''Chart''' icon in the '''Standard''' '''toolbar'''.
|-
|| Click on '''Insert'''

Click on '''Chart'''
|| Alternatively, we can click on the '''Insert''' '''menu''' in the '''menu bar'''.

And then click on the '''Chart''' option.
|-
|| Point to '''Chart Wizard''' dialog box
|| Either ways, the '''Chart Wizard''' dialog box opens.

It shows several options to select.
|-
|| Click on the '''Finish''' button
|| For now, keep the default settings and click on the '''Finish '''button at the bottom.
|-
|| Point to the '''chart''' in the '''spreadsheet'''
|| A '''chart''' gets inserted in the '''spreadsheet '''based on our '''data'''.
|-
|| Narration only
|| But, the '''chart''' is covering up some of the '''data'''.

So we have to resize the '''Chart.'''
|-
|| Point to the '''handles''' on the '''chart'''
|| When the '''chart '''is selected, we see '''handles''' around it.
|-
|| Click on the corner '''handle''' and increase/decrease the size of the '''chart'''
|| Click and drag any of the corner '''handles''' to resize the '''chart''' proportionally.

|-
|| Point to the '''chart'''
|| Now let’s move the '''chart'''.
|-
|| Click on the '''chart'''

Click and move the chart to the left of the '''spreadsheet''' >>

Release the mouse button
|| Place the '''cursor''' on any one of the borders till the '''cursor''' turns into a '''hand'''.

Click and move the '''chart''' to the desired location and then release the '''mouse''' button.
|-
|| Click outside the '''Chart'''

|| Click anywhere else outside the '''Chart''' to deselect it.

Now, we can see our '''data''' and the '''Chart''' clearly.
|-
|| Double click on the '''Chart'''

Point to''' Formatting toolbar'''
|| To customise the '''Chart, '''double-click on it.

Immediately, the '''Formatting''' '''toolbar''' shows only the options related to the '''Chart'''.
|-
|| Only Narration
|| If you wish to exit the '''Chart edit mode''', click anywhere outside the '''Chart'''.
|-
|| Only Narration
|| First, we will learn to add a '''Title''' to this '''chart'''.
|-
|| Click the '''Titles''' icon
|| Click on the '''Titles''' icon on the '''Formatting toolbar'''.
|-
|| Point to '''Titles''' dialog box
|| The '''Titles''' dialog box opens.
|-
|| Type '''Finance''' '''Tracker'''

Only Narration

Click on '''OK'''
|| In the '''Title''' text field, type '''Finance''' '''Tracker'''.

Leave the rest of the fields as default.

Then click on the '''OK''' button at the bottom.
|-
|| Point to the '''title'''
|| Observe that the title '''Finance''' '''Tracker, '''is displayed at the top center of the '''chart.'''
|-
|| Only Narration
|| Next, let us learn how to change the '''Chart''' '''Type'''.
|-
|| Click the '''Chart Type''' icon
|| Click on the '''Chart Type''' icon on the '''Formatting toolbar'''.
|-
|| Point to '''Chart Type''' dialog box
|| The '''Chart Type''' dialog box opens.
|-
|| Point to '''Chart''' '''Types'''

Point to '''Column'''
|| On the left we can see a list of available '''Chart''' '''Types.'''

'''Column''' '''type''' is selected by default.
|-
|| Point to the preview and hover the mouse on each one to display the tool tips

Point to '''Normal'''
|| On the right side, we can see three sub-types of '''Column''' '''charts'''.

This will vary based on the selected '''Chart type'''.

We will retain the '''Normal '''sub-type''' Column chart'''.
|-
|| Check the''' 3D Look''' option >> point to the spreadsheet in the background also
|| If we check the''' 3D Look''' option, the '''chart''' will get displayed in three dimensions.
|-
|| Point to '''Shape''' option
|| Immediately we see that the '''Shape''' option gets enabled.
|-
|| Select the '''Cylinder''' option >> Subtype as '''Deep'''

Click on '''OK''' button
|| Select the shape as '''Cylinder '''and also select the sub-type as '''Deep'''.

Then click on the '''OK''' button at the bottom.
|-
|| Point to the '''Chart'''
|| Observe the change in the '''chart '''on the '''spreadsheet.'''
|-
|| Only Narration
|| Explore the other combinations on your own later.
|-
|| Only Narration
|| Next, let us learn how to change the '''Data''' '''Range'''.
|-
|| Click the '''Data''' '''Ranges''' icon
|| Click on the '''Data''' '''Ranges''' icon on the '''Formatting toolbar.'''
|-
|| Point to '''Data''' '''Ranges''' dialog box
|| The '''Data''' '''Ranges''' dialog box opens.
|-
|| Point to''' Data range '''text field
|| Using this option, we can manually edit the range of '''data''' we want to represent in the '''chart'''.
|-
|| Point to '''Data series in columns'''
|| The default option for plotting '''data''' is '''Data series in columns.'''
|-
|| Click on '''Data series in rows'''
|| But we can change how we want to plot the '''data'''.

Let’s change this and use '''Data series in rows.'''
|-
|| Only Narration
|| This is useful if we use a '''style''' of '''chart''' such as '''Column''' to display our '''data'''.
|-
|| Point to '''First row as label'''

Check''' First column as label'''
|| Next, we can choose whether to use

* '''First row as label,'''
* or '''First column as label,'''
* or both as labels on the axes of the '''chart'''.

This is my selection.
|-
||

Click on '''Data Range''' text field

Change '''E''' to '''D''' in the '''Data range''' field.
|| Now, suppose we wish to remove the '''data''' under the column '''Received.'''

To do that, first click inside the '''Data range''' field.

Then change the '''range''' from '''$A$1 is to $E$7''' to''' $A$1 is to $D$7.'''
|-
|| Only Narration
|| The '''data''' under the column '''Received''' will no longer be represented when the '''chart '''is ready.
|-
||

Click on '''Data Series'''
|| Next, we’ll see the '''functions''' of the '''Data Series'''.

So, click on the '''Data''' '''Series''' tab.
|-
|| Point to '''Data Series''' list in the middle
|| Notice there are 6 fields representing the '''column''' headings of our '''data'''.
|-
|| Point to the '''Add''' and '''Remove''' buttons
|| The '''Add''' and '''Remove''' buttons will allow us to add or remove rows of '''data''' from the '''chart'''.
|-
|| Click on the '''Up''' button and then on the '''Down''' button
|| We can also sort the '''data''' by using the '''Down''' and '''Up''' buttons.
|-
||

Click on '''OK'''
|| Now we have finished selecting the '''data''' and how to represent the '''data''' in the '''chart'''.

So we will click on the '''OK''' button at the bottom.
|-
|| Point to the '''chart'''
|| Observe all the changes we made in the '''chart'''.
|-
|| Only Narration
|| Next, let us learn how to further customise the '''Chart''' '''area.'''
|-
|| Point on '''Chart Area '''icon
|| Click on the '''Chart''' '''Area '''icon from the '''Formatting toolbar.'''
|-
|| Point to tabs '''Borders''', '''Area''' and '''Transparency'''

Point to '''Borders''' tab
|| There are 3 tabs''' '''at the top - '''Borders''', '''Area''' and '''Transparency'''.

By default, the '''Borders''' tab is selected.
|-
|| Point to the '''Preview''' area
|| There’s a large white box here which is the '''preview''' area.
|-
|| Only Narration
|| Let us change the '''style''' and color of the '''chart's''' border.
|-
|| Click on '''Style''' >> choose '''Continuous'''

Click on '''Color''' >> choose '''Green'''
|| To do so, click on the '''Style''' drop-down and choose '''Continuous'''.

Then in the '''Color''' drop-down, we’ll choose '''Green'''.
|-
|| Point to the '''Preview''' area
|| Notice the changes in the '''preview '''area.
|-
|| Click on '''OK'''
|| Now click on the '''OK''' button at the bottom.
|-
|| Click outside the '''chart'''
|| Click outside the '''chart''' to see all the changes.
|-
|| Point to the '''chart '''border
|| Notice that the '''style''' and color of the '''chart''' border has changed.
|-
|| Only Narration
|| Let us check out a few more '''formatting''' options.
|-
|| Double click on the chart
|| Make sure the '''chart''' is in '''Edit''' '''mode '''only.
|-
|| Point to the 4''' axis '''icons.

Only Narration
|| On the '''Formatting toolbar''', there are 4''' axis '''icons.

These '''axis''' options help to format the lines that create the '''chart'''.
|-
|| Only Narration
|| These also format the font of the text that appears on both the '''X''' and '''Y''' axes.

Let’s check these out.
|-
|| Click on the '''X''' Axis icon >> '''X Axis '''dialog box
|| Click on the '''X''' '''Axis''' icon in the '''Formatting toolbar'''.

The '''X Axis '''dialog box opens.
|-
|| Point to options
|| Here we can see various tabs at the top to customise the '''X Axis'''.
|-
|| Press '''Esc''' Key or Click on '''Cancel''' button
|| Press the '''Esc''' key or click on the '''Cancel''' button at the bottom to exit the dialog box.
|-
|| Point on the '''Y''' '''Axis''' icon

|| Likewise, we can also format the '''Y''' '''Axis''' by clicking on the '''Y''' '''Axis''' icon in the '''Formatting''' '''toolbar'''.
|-
|| Only Narration
|| Explore the other '''axis '''icons on your own later.
|-
|| Only Narration
|| '''Calc''' provides an option for changing the colour of the '''chart''' '''wall'''.
|-
|| Point to the '''chart'''
|| The '''chart''' '''wall''' is the border surrounding the '''chart''' '''graphic''', including the main '''title''' and '''key'''.
|-
|| Point to '''Chart''' '''Wall''' icon

Point to '''Chart Wall '''dialog''' '''box
|| To format, click on the '''Chart''' '''Wall''' icon in the '''Formatting toolbar'''.

The '''Chart''' '''Wall '''dialog box opens up.
|-
|| Point to '''Borders''' tab
|| Go to the '''Borders''' tab if not already selected.
|-
|| Point to '''Continuous'''
|| Under the '''Line''' '''Properties''' option, we can see that the '''Style''' is set to '''Continuous'''.
|-
|| Click on '''Color'''->choose '''Red'''
|| From the '''Color''' drop-down, let’s choose '''Red'''.
|-
|| Click on '''Width''' >> Click + icon '''0.10cm'''
|| Then change the width to '''0.10cm '''by clicking the '''plus''' icon.
|-
|| Click '''OK'''
|| Now click on the '''OK''' button at the bottom.
|-
|| Point to '''chart''' ; Click anywhere in the '''spreadsheet'''
|| We can see the '''style''' and colour of the '''chart''' '''wall''' has now changed.
|-
|| Only Narration

Point to the '''Legend '''in the '''chart'''
|| Next, we will learn how to remove and add the '''Legend'''.

In our chart, this is the '''Legend'''.
|-
|| Click on '''Legend ON\OFF''' icon

Point to the '''legend''' area
|| Click on the''' Legend ON/OFF''' icon in the '''Formatting toolbar.'''

The '''legend''' disappears.
|-
|| Click on '''Legend ON/OFF''' icon >>

Point to the '''legend'''
|| Click again on the '''Legend ON/OFF '''icon and the '''legend''' reappears.
|-
|| Narration only
|| Next we will learn how to resize '''charts''' by using the '''Position''' and '''Size''' dialog box.

Click anywhere outside the '''Chart''' to exit the '''edit mode.'''
|-
|| Right click on the '''chart'''

Choose '''Position''' '''and''' '''Size'''
|| Now right-click on the '''chart'''.

From the context menu, select '''Position''' '''and''' '''Size.'''
|-
|| Point to '''Position''' '''and''' '''Size''' dialog box
|| The '''Position''' '''and''' '''Size''' dialog box appears.
|-
|| Point to '''Position''' '''and''' '''Size''' tab
|| Select the '''Position''' '''and''' '''Size''' tab at the top.
|-
|| Point to the '''X''' and '''Y''' positions

Point to the '''Width''' and '''Height''' fields
|| The '''Position''' section has various fields that can set the '''X''' and '''Y''' positions of the '''chart'''.

We can also adjust the '''width''' and '''height''' of the '''chart'''

under the '''Size''' section.
|-
|| Set '''X''' coordinate to '''1.00'''

Set '''Y''' coordinate to '''0.80'''

Click on '''OK'''
|| Let’s set the '''X''' coordinate to '''1.00''' and '''Y''' coordinate to '''0.80'''.

And click on the '''OK''' button at the bottom.
|-
|| Point to the sample '''chart''' in the '''spreadsheet'''
|| Notice that the position of the '''chart''' has changed according to the assigned values.
|-
||

Click '''Format''' menu

Right click on the '''chart'''
|| Apart from these options available in the '''Formatting toolbar''', we can format the '''chart''' in two other ways.

* Either go to the '''Format''' '''menu''' in the '''menu''' '''bar'''.
* Or right click on the '''chart'''.

To see the '''formatting''' options, make sure that the '''chart''' is in '''edit mode'''.

Explore these options on your own later.
|-
||

Click on the '''Chart''' >>Press '''Delete''' key

Point to the '''spreadsheet'''
|| Lastly let’s learn how to delete a '''chart'''.

Click on the '''chart''' and press the '''Delete''' key on the keyboard.

Notice that the '''chart''' is now deleted from the '''spreadsheet'''.
|-
|| '''Ctrl + S'''
|| Now let’s save and close the file.
|-
|| Narration:
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| '''Slide: '''Summary
|| In this tutorial, we learnt to:* Create '''charts''', resize and move them within the '''spreadsheet'''
* Edit and format the '''charts''' and
* Delete a '''chart'''

|-
|| '''Slide: '''Assignment
|| As an assignment
* Open '''Spreadsheet-Practice.ods '''file
* Insert a '''Pie''' '''chart''' for the '''data'''
* Resize and move the '''chart''' to the bottom right corner of the '''sheet'''

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the spoken tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
||
* Please post your timed queries in this forum.

|-
| | '''Slide''': Acknowledgement
| |
* Spoken Tutorial project is funded by MHRD, Govt. of India.

|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English

2020-07-17T15:08:17Z

Arvindpillai90:

Title: Working with Sheets

Author: Arvind Pillai

Keywords: LibreOffice Calc, Sheets, Insert rows in Calc, Delete rows in Calc, Insert columns in Calc, Delete columns in Calc, Insert sheets in Calc, Delete sheets in Calc, Rename sheets in Calc, Move sheets.

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide:'''Title
|| Welcome to the''' spoken tutorial''' on '''Working''' '''with''' '''Sheets'''.
|-
|| '''Slide''': Learning objectives
|| In this tutorial, we will learn to:
* Insert and Delete
** '''Rows'''
** '''Columns'''
** '''Sheets'''
* Rename '''Sheets'''
* Move '''Sheets'''

|-
|| '''Slide: '''System Requirements

|| This tutorial is recorded using
* '''Ubuntu Linux OS '''version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open''' Personal-Finance-Tracker.ods'''
|| Let us open our '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Pls download and extract the file.
* Make a copy and then use it for practising.

|-
|| Highlight a '''column''' and a '''row'''.
|| Columns and rows can be inserted individually or in bulk.
|-
|| Only Narration
|| First we will learn how to insert a new '''row''' or a new '''column''' in the '''spreadsheet'''.
|-
|| Click on''' C1'''

Point to “'''Cost'''”
|| In our '''Personal-Finance-Tracker.ods''' file, let's click on the '''cell C1.'''

This '''cell''' has “'''Cost'''” written in it.
|-
|| Click on '''Row''' icon in the '''Standard toolbar'''
|| Now click on the '''Row''' icon in the '''Standard toolbar.'''

Many options related to rows are displayed in the '''context menu.'''
|-
|| Highlight '''Insert Rows Above''' and '''Insert Rows Below.'''

Click on '''Insert''' '''Rows Above'''
|| Notice 2 specific options '''Insert Rows Above''' and '''Insert Rows Below.'''

I will click on the option '''Insert Rows Above'''.
|-
|| Point to the new row added
|| A new row gets inserted just above the '''cell C1'''.
|-
|| Click on '''Row''' icon in the '''Standard toolbar'''
|| Now click on the '''Column''' icon in the '''Standard toolbar.'''

Many options related to columns are displayed in the context menu.
|-
|| Highlight '''Insert Rows Before''' and '''Insert Rows After.'''

Click on '''Insert''' '''Rows Before'''
|| Notice 2 specific options '''Insert Columns before''' and '''Insert Columns after.'''

I will click on the option '''Insert Columns Before.'''
|-
|| Point to the new column added
|| A new column gets inserted to the left of the '''cell C1'''.
|-
|| Press '''CTRL''' + '''Z''' twice
|| Let’s undo these changes.
|-
|| Click on '''Sheet >> '''mouse over on '''Insert Rows '''and
'''Insert Columns''' to show their context menu
|| Rows and columns can be inserted by clicking on '''Sheet''' '''menu''' in the '''menu bar''', as well.
|-
|| Point to '''Cell''' '''Reference→''' '''Numbers''' and '''Alphabets'''
|| Another quick way to insert a new row or column is by right-clicking on any '''cell'''.
|-
|| Right-click on '''cell C1'''→click on '''Insert'''
|| Right-click on '''cell C1 '''and click on '''Insert '''option.
|-
|| '''Insert Cells '''dialog box

Highlight '''Entire row '''& '''Entire column '''and '''Ok '''button
|| The '''Insert Cells '''dialog box opens.

Here choose as per your requirement and click on the '''Ok''' button.
|-
||

Click on '''Cancel'''
|| Explore these options on your own for your understanding.

I will skip this and click the '''Cancel '''button to close the dialog box.
|-
|| Only narration
|| Next, we’ll learn to insert multiple '''rows''' and '''columns''' at the same time.
|-
|| Point to '''SN''' i.e '''A1'''
|| Let’s say we want to insert 4 '''columns''' before '''SN''' which is '''cell A1'''.
|-
|| Holding the left mouse key click and drag''' '''from '''cells A1''' to''' D1'''

Point to '''Cells A1 to D1'''
|| So select the '''cells A1''' to '''D1''' by clicking and dragging the left mouse button.

All the '''4 cells''' get selected.
|-
|| Click on '''cell B1'''→''' Insert'''

'''Insert Cells''' dialog box >> click '''Entire''' '''Column'''
|| Right-click anywhere on the selection and select '''Insert'''.

In the '''Insert Cells''' dialog box, click on the option '''Entire Column'''.
|-
|| Click''' Ok'''
|| Then click on the '''OK''' button at the bottom.
|-
|| Point to new '''Columns''' inserted
|| Notice that 4 new columns get added before '''Serial Number.'''
|-
|| Click cell '''D6 '''
|| Now click any random '''cell''' to deselect.
|-
|| Only Narration
|| In a similar manner, we can add multiple '''rows''' as well.

Explore this on your own.
|-
|| Only Narration
|| Next we will learn about how to delete columns individually and in groups.
|-
|| Click on column '''D'''
|| Select any one column by clicking on the alphabet of the column above, as shown.
|-
|| Click '''Column''' icon in the '''Standard toolbar '''>> click '''Delete Columns'''.
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

The selected column gets deleted.
|-
||
|| Suppose we want to delete more than one column at a time.
|-
|| Point to the 3 columns
|| In my case, I want to delete these 3 '''columns''' which we inserted just now.
|-
|| Select columns '''A '''to '''C'''
|| So, select the 3 columns by clicking on the alphabet of the column above, as shown.
|-
|| Point to the '''3''' '''Columns'''
|| All the 3 columns get selected.
|-
|| Click the Column icon in the '''Standard toolbar '''>> click '''Delete Columns'''.
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

The selected columns get deleted.

|-
|| Only Narration
|| In a similar manner, we can delete multiple '''rows''' as well.

Explore this on your own.
|-
|| Narration:

|| We will now learn about how to insert and delete '''sheets''' in '''Calc'''.

There are several ways to insert a new '''sheet''' in '''Calc'''.

We will learn about each one of them one-by-one.
|-
|| Point to '''Sheet 1 '''at the bottom left
|| At the bottom left, we see a tab named '''Sheet 1'''.
|-
|| Highlight all the icons located before that.
|| There are some icons located before that.
|-
|| Point to '''+ icon''' before''' Sheet 1''' >> then click on it
|| When we click on the '''Plus''' icon, a new '''sheet '''named '''Sheet2''' gets added.
|-
|| Point to''' Sheet 2'''
|| This new '''sheet''' gets added to the right of the current one.
|-
|| Point to the empty space besides '''Sheet''' '''2'''
|| We can also add '''sheets''' by clicking on the empty area next to the '''Sheet '''tabs.
|-
|| '''Insert Sheet''' dialog box

Point to '''Position''' options

Point to '''Sheet >> No. of sheets''' option
|| By doing so, the '''Insert Sheet''' dialog box opens up.

Using this dialog box, we can add a sheet before or after the current sheet.

We can also add any no. of '''sheets''' at a time.
|-
|| Select '''Position''' '''>>''' '''Before''' '''Current''' '''Sheet'''

'''Sheet''' >> '''No. of sheets >> 2'''
|| Under '''Position''', I will select '''Before the current sheet.'''

And in '''No. of sheets''', I will specify '''2'''.
|-
|| Click on '''Ok''' button
|| And then click on the '''OK''' button at the bottom.
|-
|| Highlight the sheet tab
|| Notice that '''Sheet 3 '''and '''Sheet 4 '''get added before '''Sheet 2'''.
|-
|| Click on '''Sheet''' >>Click on '''Insert''' '''Sheet'''
|| Another way to insert '''sheets''' is to click on the '''Sheet menu''' in the '''menu bar'''.

Then click on '''Insert Sheet'''.
|-
|| '''Insert''' '''Sheet''' dialog box

Click on '''Cancel''' button
|| On doing so, the '''Insert Sheet''' dialog box opens up.

I will skip this and click on the '''Cancel''' button at the bottom.
|-
|| Narration:
|| Next let us learn how to delete '''sheets'''.

'''Sheets''' can be deleted individually or in groups.
|-
|| Right click on '''Sheet''' '''4''' tab

Select '''Delete''' '''Sheet'''
|| To delete a single '''sheet''', right-click on the tab of the '''sheet''' you wish to delete.

And then, select the '''Delete Sheet''' option.
|-
|| Point to '''confirmation''' dialog box

Click '''Yes'''
|| A '''confirmation''' dialog box pops up.

Click on the '''Yes''' button.
|-
|| Point to '''Sheets '''tab
|| The selected '''sheet '''gets deleted.
|-
||
|| How can we delete multiple '''sheets''' at a time?
|-
|| Point to '''Sheet''' '''2''' and '''Sheet 3'''
|| For example, say we want to delete '''Sheet 2''' and '''Sheet 3'''.
|-
|| Click on '''Sheet''' '''2''' tab
|| First click on the '''Sheet 2''' tab.
|-
|| Hold '''Shift''' key >> click on '''Sheet''' '''3''' tab.
|| Then holding the '''Shift''' key on the keyboard, click on '''Sheet 3 '''tab.
|-
|| Right click >> '''Delete Sheet'''
|| Now right-click on any one of the tabs and click on the '''Delete Sheet''' option.
|-
|| '''Confirmation''' dialog box
|| A '''confirmation''' dialog box pops up.
|-
|| Click '''Yes''' button
|| Click on the '''Yes''' button to delete the '''sheet'''.

Both the '''sheets''' get deleted.
|-
|| Press '''CTRL + Z''' keys once
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| Point to '''Sheet 1, Sheet 2, Sheet 3'''.
|| '''Sheets '''are named by default as '''Sheet 1, Sheet 2, Sheet 3''' and likewise.

'''Calc''' has a provision to rename the '''sheets''' based on our needs.
|-
|| Point to the '''Sheet 2''' tab below.

Double click on '''Sheet 3''' tab.
|| For example, let’s rename '''Sheet 2''' as “'''Dump'''”.

Do this by simply double-clicking on '''Sheet 2''' tab.
|-
|| '''Rename Sheet''' dialog box
|| '''Rename''' '''Sheet''' dialog box opens up.
|-
|| Point to the text box '''Sheet 2'''
|| There is a textbox with '''Sheet''' '''2''' written in it.
|-
|| Delete '''Sheet 2''' written in the text box and write “'''Dump'''”.
|| Delete this and type “'''Dump'''” as the new name.
|-
|| Click on '''OK'''
|| Click on the '''OK''' button.
|-
|| Point to the '''Sheet 2''' tab below.
|| '''Sheet 2''' tab has now been renamed to “'''Dump'''”.
|-
|| Press '''CTRL + Z''' keys once
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| Click '''Sheet 2 '''and bring it to second position on '''Sheets''' tab
|| We can manually rearrange the '''sheets''' by clicking on a '''sheet'''

And dragging it to the desired location.
|-
|| Press '''Ctrl+S''' keys

Press X
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| Narration:
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt to :
* Insert and Delete
** '''Rows'''
** '''Columns'''
** '''Sheets'''
* Renaming '''Sheets'''
* Move '''Sheets'''

|-
|| '''Slide: '''Assignment
|| As an assignment
* Open '''Spreadsheet'''-'''Practice'''.'''ods'''.
* Select and delete the column with the heading '''SN'''.
* Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
* Refer to the '''Code files''' link for details.
* Rename the '''sheet''' as '''Department-Sheet'''.
* Save and close the file.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the spoken tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
| | '''Slide: '''Forum
| | Please post your timed queries in this forum.
|-
| | '''Slide: '''Acknowledgement
| | '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Cells-in-Calc/English

2020-07-17T15:07:04Z

Arvindpillai90:

Title: Working with cells

Author: Arvind Pillai

Novice reviewer: Nikita Misal

Domain reviewer: Praveen S

Keywords: LibreOffice Calc, Enter numbers in Calc spreadsheet, Enter text in Calc spreadsheet, Enter date in Calc spreadsheet, Enter time in Calc spreadsheet, Use Format Cells option in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
| align=center| '''NARRATION'''
|-
|| '''Slide: '''Title
|| Welcome to the '''spoken tutorial '''on''' Working with Cells.'''
|-
|| '''Slide: '''Learning objectives:
|| In this tutorial, we will learn to:
* Enter '''numbers, text, date '''and''' time''' in a '''spreadsheet'''
* Use the '''Format Cells''' dialog box
* Navigate between '''cells '''and
* Select items in '''rows''' and '''columns'''

|-
|| '''Slide: '''System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS''' version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open '''Personal-Finance-Tracker.ods''' file.
|| First we will learn how to enter '''data''' in the '''cells'''.

Let’s open our '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Pls download and extract the file.
* Make a copy and then use it for practising.

|-
|| Click on the '''cell''' C7 >> type the text '''sample''' >> Press '''Enter'''.
|| Now type some text in any empty '''cell''' by clicking on the '''cell''' and typing using the keyboard.

Press '''Enter'''.
|-
|| Point to the cell C7

Point to the '''Alignment''' icons on the '''Formatting''' '''Bar'''.
|| The text is left-aligned, by default.

One can change the alignment by clicking any one of the '''Alignment''' icons on the '''Formatting''' '''Bar'''.
|-
|| Press '''Ctrl+Z''' keys
|| Let's undo what we typed.

Press '''Ctrl+Z''' keys on the keyboard to undo.
|-
|| Scroll the cursor across the headings.
|| In this '''spreadsheet''', we had already typed the '''column''' headings earlier.
|-
||

Click on cell '''A1 '''>>drag the mouse till cell '''G1 >> '''

release the left mouse button

|| In '''Calc''', we can differentiate the headings from other '''data''' by adding a '''style''' to it.

To do that, click on cell '''A1'''.

Then hold the left mouse button and drag the cursor upto cell '''G1.'''

Now release the left mouse button.
|-
|| Highlight this
|| We can see that all the headings got highlighted.
|-
|| Click on '''Styles''' menu >> select '''Accent 2'''

Click on cell '''C4'''
|| Now click on '''Styles''' menu in the '''menu''' '''bar.'''

We can see various '''heading styles'''.

I will select '''Accent 2'''.

Now click randomly on any '''cell''' to unselect the headings.
|-
|| Highlight this
|| Notice that the headings are now highlighted with a grey colour background.
|-
|| Under the '''Items''', type '''Salary''', '''House''' '''rent''',
'''Electricity''' '''bill''', '''Phone''' '''bill''', '''Laundry''' and '''Miscellaneous'''.
|| In the '''Items '''column, we’ll type the names of a few items one below the other.

Type the text as shown here.
|-
|| Click on the '''C7''' cell and type '''123''' >> Press '''Enter'''.
|| In order to enter numbers in the '''cell''', click on the '''cell''' and type the number.

Then press '''Enter'''.
|-
|| Text on screen: Press the '''Enter''' key after every''' data-entry'''.
|| Remember to always press the '''Enter''' key after every''' data-entry'''.
|-
|| Click on '''D7''' cell and type '''-123''' >> Press '''Enter'''.

Click on '''E7''' cell and type '''(123)''' >> Press '''Enter'''.
|| To enter a negative number, either type a '''minus''' '''sign''' before it or enclose it within '''parentheses'''.
|-
|| Point to the two cells one after the other.
|| By default, numbers are right-aligned and negative numbers have a leading '''minus''' '''symbol'''.
|-
|| Select all the '''cells''' to be deleted by holding the '''Shift''' key and clicking each '''cell'''.

Click on the '''Delete '''button.
|| Let us delete these entries.

Select all the '''cells''' to be deleted by holding the '''Shift''' key and clicking each '''cell'''.

Now press the '''Delete '''key on the keyboard.
|-
|| Point to the cell '''A1'''
|| In the '''SN '''column, we want the serial number of each item one below the other.
|-
|| Under '''SN''' type '''1''', '''2''', '''3''' in the cells '''A2''' to '''A4''' one below the other. And press '''Enter'''
|| So click on '''cell A2''' and enter numbers as '''1, 2, 3''' one below the other.

Remember to press '''Enter '''key after typing each number.
|-
|| Click on the '''cell A4'''

|| In order to auto-fill the serial numbers in the subsequent '''cells''', click on the '''cell A4'''.
|-
|| Click on the little '''black box''' at the bottom-right corner of the cell

Drag it till '''cell A7''' and release the mouse button.
|| Click on a little''' black box''' that is visible at the bottom-right corner of the '''cell'''.

Drag it till '''cell A7''' and release the mouse button.
|-
|| Highlight '''A5''', '''A6''' and '''A7'''
|| We see that '''cells A5, A6''' and '''A7''' get auto-populated with the subsequent serial numbers.
|-
|| Point to '''Cost''' column.
|| We will now enter the cost of each item under the heading '''Cost'''.
|-
|| Click on '''C3'''-> type '''Rs.6000'''.'''00'''
|| Click on the '''cell C3''' and type the expense for '''House''' '''rent''' as '''Rupees''' '''6000.00'''
|-
|| Only Narration
|| Now, what if we want the number with the '''Rupee''' symbol?
|-
|| Press '''Ctrl + Z''' keys
|| Clear the value typed in '''cell C3 '''by pressing '''Ctrl '''and '''Z '''keys together.
|-
|| Right-click on '''C3'''-> click on '''Format''' '''Cells'''

|| Right-click on the '''cell C3 '''and select the '''Format Cells''' option.

This will open the '''Format Cells''' dialog box.
|-
|| Point to the '''Format Cells''' dialog box >> '''Numbers '''tab.
|| The first tab is '''Numbers'''. Click on it if not already selected.
|-
|| Point to '''Category'''

Then to '''Number''', '''Percent''', '''Currency''', '''Date''', '''Time'''.

Click on '''Currency'''.
|| Here we can see various options under '''Category'''.

'''Number''', '''Percent''', '''Currency''', '''Date''', '''Time''' and many more.

We will select '''Currency'''.
|-
|| Point to '''INR ₹ English (India) '''under '''Format''' section

Point to the '''drop down arrow'''.
|| Various '''currency''' '''symbols''' from across the world are displayed in the '''Format '''list.

By default, '''INR Rupee English (India)''' is selected in the '''Format''' drop-down.

If not, click on the drop-down and select it from the displayed list.
|-
|| Point to the Format options section

Point to '''-Rs. 1,234'''.'''00'''
|| Below the '''Format''' drop-down, we can see some sample values based on our selection.

We see '''minus Rupee 1234 decimal zero zero''' is selected for '''INR Rupees English India'''.
|-
|| Point to the Preview area (the small white rectangle) on the right.
|| We can see the selected '''format''' in the small preview area on the right.
|-
|| Point to '''Options''' below the category section.
|| Below the '''Category''' section, we have another section named as '''Options'''.
|-
|| Point to '''+ or - buttons '''of '''Decimal''' '''places''' and '''Leading zeroes'''.
|| Using this, we can increase or decrease the number of '''Decimal places''' and '''Leading zeroes'''.
|-
|| Click→ '''+ or - buttons '''of '''Decimal''' '''places''' and '''Leading zeroes'''.

Change it to default values
|| When we do so, we can see the changes in the sample value and in the preview area.

We will retain the default values.
|-
|| Click on '''Thousands''' '''separator'''.

Point to the Preview area.
|| To add a comma between the values, check the '''Thousands separator''' checkbox.

|-
|| Click on '''Font'''.

Point to '''Family''', '''Style''' and '''Size'''.
|| One can also change the '''font style''' by clicking on the '''Font''' tab.

It has various options for '''Family, Style''' and '''Size'''.
|-
|| Slide cursor across '''Font''' '''Effects''' and the other tabs.

Point to '''Alignment''' tab.
|| Explore '''Font Effects''' and other tabs to learn more about them on your own.

We will learn about the options in the '''Alignment''' tab in a later tutorial.
|-
|| Click on the '''OK''' button
|| Let’s click on the '''OK''' button at the bottom right corner.
|-
|| Type '''6000''' in cell '''C3'''.

Point to '''₹6000.00'''.
|| Now type '''6000''' in '''cell C3 '''and press '''Enter'''.

Notice that the number '''6000''' is represented as '''Rupees 6000 '''with '''2 decima'''l places.
|-
|| Select cells '''C4''' to '''C7''' with cursor.

Press '''CTRL''' key and select cell '''G2'''.

Point towards selection
|| Now, let's select '''cells C4''' to '''C7''' by holding the '''Shift''' key and clicking the '''cells'''.

Hold the '''CTRL''' key and select '''cell G2''' also.

Notice all the selected '''cells''' are highlighted.
|-
|| Right-click on cell '''G2→''' click on '''Format''' '''Cells'''

Choose the same options as before

Click on '''OK'''.
|| Right-click on any of the highlighted '''cells''' and select '''Format Cells.'''

Choose the same options as before.

Click on the '''OK''' button at the bottom right corner.
|-
|| Click→ Random Cell
|| Click any '''cell''' in the '''spreadsheet''' to deselect the '''cells'''.
|-
|| Click on '''C4'''-> type '''800''' ['''Enter]'''

Click on '''C5'''-> type '''600''' ['''Enter]'''

Click on '''C5'''-> type '''300''' ['''Enter]'''

Click on '''C7'''-> type '''2000''' ['''Enter]'''
|| Next, we type the amount for all the items one below the other, as shown here.

|-
|| Click on '''G2'''-> type '''30000''' ['''Enter]'''
|| Under the heading '''Account,''' we’ll type the salary for the month as '''30,000'''.
|-
||

Click on cell '''F2'''.
|| Let’s move on to the '''Date '''column.

Click on the '''cell F2'''.
|-
|| Under '''Date''' type '''05/06/20''' in the '''cell F2 [Enter]'''

Point to '''cell F2'''
|| For entering date in '''Calc''', select the '''cell''' and type the '''date, '''as shown.

Here I have used a '''forward slash '''between the date elements.
|-
|| '''Cell F3''' >> type '''05-06-20''' in the cell '''F3''' ['''Enter]'''
|| We can also separate the date elements with a '''hyphen'''.

|-
|| '''Cell F4''' >> type '''05 June 2020''' in the cell '''F4''' ['''Enter]'''
|| Or use text such as '''05 June 2020'''.

'''Calc''' recognizes a variety of date formats.
|-
||

Right-click '''F2''' >> Select '''Format''' '''Cells''' Option
|| We can also customize the date formats according to our requirement.

To do so, right-click on the '''cell''' and select '''Format Cells''' option.
|-
|| Click '''Numbers '''tab >> Under '''Category''' select '''Date'''
|| Click on the '''Numbers''' tab.

Under the '''Category''' section, select '''Date.'''
|-
|| Click on '''31/12/1999''' under Format.
|| Under the''' Format''' section, select the date format based on your requirement.

I will choose '''31/12/1999. '''
|-
|| Point to the Preview area (the small white rectangle) on the right.
|| Notice the display in the preview area.
|-
|| Point '''Format''' '''code''' below.
|| Based on our selection, the '''Format code''' will get updated.

In my case it is '''DD, MM''' and '''YYYY.'''
|-
|| Click on '''OK'''
|| Once we have updated the format, click on the '''OK''' button at the bottom right.
|-
||

Click on a cell '''F8'''

Type '''10:43:20''' and press '''Enter'''.
|| Next, let us try some time options.

Click on any random '''cell'''.

Type the '''time '''as shown.

I have separated the time elements with '''colons'''.
|-
|| Right-click on cell '''F8'''→ Click on '''Format Cells'''.

Click→ '''Numbers tab'''
|| To further customize the time format, right-click on the respective cell and select '''Format Cells'''.

Click on '''Numbers''' tab at the top
|-
|| Click on the option '''Time''' under '''Category'''

Click on '''13:37:46''' under '''Format'''
|| Under '''Category, '''choose '''Time''' and the desired format under '''Format'''.

I will choose '''13:37:46'''.
|-
|| Point to the Preview area

Point to '''Format''' '''code'''
|| Notice the display in the preview area.

Also, the '''Format code''' is displayed below as '''HH:MM:SS'''
|-
|| Point to the Preview area >> '''Format code '''>> edit >>click on '''OK'''.
|| One can change the '''Format code''' directly as well.

Click on '''OK '''button at the bottom right.
|-
|| Select cells and press '''Delete'''
|| Let us delete all the time entries from our '''spreadsheet'''.
|-
|| Click on one '''cell''' and then the next '''cell''' on the same row.
|| We will now learn how to navigate within a '''spreadsheet''' from '''cell''' to '''cell.'''
|-
|| Click on cell '''A3'''.
|| We can access a particular '''cell''' by simply clicking on it with the '''cursor'''.

This changes the focus to the '''new''' '''cell'''.

This method is most useful when the two '''cells''' are far apart.
|-
||
|| Another method of accessing a particular '''cell''' is by using the '''cell''' reference.

|-
||Click on the down arrow to the right of the '''Name Box'''.
||Click on the '''Name Box''' at the top left corner, which is located below the '''Font Name.'''
|-
||Delete→ Existing '''Cell Reference'''
||Erase the existing '''cell reference '''and type the '''cell reference''' of the '''cell''' you want to go.
|-
||Type '''B4''' in the cell reference and press '''Enter'''.

Point to '''B4'''
||I will type '''B4''' and press '''Enter'''.

Observe that '''cell B4''' gets highlighted.
|-
||
|| We can also navigate between '''cells''' using the keyboard.
|-
||Press '''Tab'''.
||Press the '''Tab''' key to go to the next '''cell''' in a row.
|-
||Press '''Shift''' + '''Tab'''.
||'''Shift + Tab''' to go to the previous '''cell''' in a row.

|-
||Press '''Enter'''.
||'''Enter''' to go to the next '''cell''' in a column.

|-
||Press '''Shift''' + '''Enter'''.
||'''Shift''' + '''Enter''' to go to the previous '''cell''' in a column.

|-
||
|| Next, we’ll learn how to select a range of contiguous '''cells''' with the '''cursor'''.

|-
||Click on '''A4''' >> press and hold down the left mouse button.
||First click on a '''cell''' and hold down the '''left mouse button'''.

|-
||Drag the mouse till '''B10'''.

Release left mouse button.
||Drag the '''cursor''' on the '''sheet'''.

Once the desired block of '''cells''' is highlighted, release the left mouse button.
|-
||
||We see that the selected '''cells''' get highlighted.

|-
||
|| Next, we’ll learn how to select multiple '''columns''' or '''rows''' that are not '''contiguous'''.
|-
|| Click on first cell of first row '''Column''' '''A'''
||Click on the first '''column''' or '''row''' that you want to select.
|-
||Hold down the '''Shift''' key >> Drag till '''Column D.'''
||Now hold down the '''Shift''' key and click the last '''column''' or '''row''' that we want to select.

We see that the selected '''cells''' get highlighted.
|-
||

|| Let’s learn to select multiple '''columns''' or '''rows''' that are not contiguous.

|-
||Click on first cell of first row '''Column A'''

Hold down the '''Control''' key
||Click on the first '''column''' or '''row''' that you want to select.

Hold down the '''Control''' key.

|-
||Click→ '''Columns C,D & F '''while holding down the '''Control''' key.

||Now click on all of the subsequent columns or rows that you want to select.

We see that the selected '''cells''' get highlighted.
|-
|| Press '''Ctrl+S''' keys

Press X
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| Only Narration
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide: '''Summary
|| In this tutorial, we learnt to:
* Enter '''numbers, text , date''' and '''time''' in '''Calc'''
* Use the '''Format Cells''' dialog box
* Navigate between '''cells'''
* Select items in '''rows''' and '''columns'''

|-
|| '''Slide:'''Assignment
|| As an assignment
* Open '''Spreadsheet-Practice.ods'''
* Under '''SN''' type the serial number from '''1 '''to''' 5''' one below the other and '''Align''' '''Center'''.
* Add column headings '''Date''' and '''Time '''with the same '''text format'''
* Enter some values in those columns
* Use the''' Format Cells''' dialog box options to format the '''cells'''
* Refer to the '''Code files''' link for the '''data'''.
* Save and close the file

|-
|| '''Slide: '''About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it

|-
|| '''Slide:''' Spoken tutorial workshops
||
* We conduct workshops using '''Spoken''' '''Tutorials''' and give certificates.
* For more details, please write to us.

|-
|| '''Slide: '''Forums
|| Pls post your timed queries in this forum.
|-
|| '''Slide: '''Acknowledgement
| | '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide:''' Thank you

Acknowledgement to DesiCrew
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from '''IIT Bombay '''signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English-timed

2020-07-17T14:52:05Z

Arvindpillai90:

{| border="1"
|-
|| '''TIME'''
|| '''NARRATION'''
|-
|| 00:01
|| Welcome to the''' spoken tutorial''' on '''Working''' '''with''' '''Sheets'''.

|-
|| 00:05
|| In this tutorial, we will learn to:

|-
|| 00:08
|| Insert and Delete

'''Rows''', '''Columns''', '''Sheets'''

|-
|| 00:13
|| Rename '''Sheets''' and

|-
|| 00:15
|| Move '''Sheets'''

|-
||00:18
|| This tutorial is recorded using

'''Ubuntu Linux OS '''version 18.04 and '''LibreOffice Suite''' version 6.3.5

|-
|| 00:32
|| Let us open our '''Personal-Finance-Tracker.ods''' file.

|-
|| 00:37
|| This file has been provided to you in the''' Code files''' link on this tutorial page.

Please download and extract the file.

|-
|| 00:48
|| Make a copy and then use it for practising.

|-
|| 00:52
|| Columns and rows can be inserted individually or in bulk.
|-
|| 00:58
|| First we will learn how to insert a new '''row''' or a new '''column''' in the '''spreadsheet'''.
|-
|| 01:05
|| In our '''Personal-Finance-Tracker.ods''' file, let's click on the '''cell C1.'''

|-
|| 01:12
|| This '''cell''' has “'''Cost'''” written in it.
|-
|| 01:16
|| Now click on the '''Row''' icon in the '''Standard toolbar.'''

|-
|| 01:21
|| Many options related to rows are displayed in the '''context menu.'''
|-
|| 01:27
|| Notice 2 specific options '''Insert Rows Above''' and '''Insert Rows Below.'''

|-
|| 01:35
|| I will click on the option '''Insert Rows Above'''.
|-
|| 01:40
|| A new row gets inserted just above the '''cell C1'''.
|-
|| 01:45
|| Now click on the '''Column''' icon in the '''Standard toolbar.'''

|-
|| 01:50
|| Many options related to columns are displayed in the context menu.
|-
|| 01:56
|| Notice 2 specific options '''Insert Columns before''' and '''Insert Columns after.'''

|-
|| 02:04
|| I will click on the option '''Insert Columns Before.'''
|-
|| 02:09
|| A new column gets inserted to the left of the '''cell C1'''.
|-
||02:14
|| Let’s undo these changes.
|-
|| 02:17
|| Rows and columns can be inserted by clicking on '''Sheet''' '''menu''' in the '''menu bar''', as well.
|-
|| 02:25
|| Another quick way to insert a new row or column is by right-clicking on any '''cell'''.
|-
|| 02:32
|| Right-click on '''cell C1 '''and click on '''Insert '''option.
|-
|| 02:38
|| The '''Insert Cells '''dialog box opens.

|-
|| 02:42
|| Here choose as per your requirement and click on the '''Ok''' button.
|-
|| 02:48
|| Explore these options on your own for your understanding.

|-
|| 02:53
|| I will skip this and click the '''Cancel '''button to close the dialog box.
|-
|| 02:58
|| Next, we’ll learn to insert multiple '''rows''' and '''columns''' at the same time.
|-
|| 03:04
|| Let’s say we want to insert 4 '''columns''' before '''SN''' which is '''cell A1'''.
|-
|| 03:11
|| So select the '''cells A1''' to '''D1''' by clicking and dragging the left mouse button.

All the '''4 cells''' get selected.
|-
|| 03:21
|| Right-click anywhere on the selection and select '''Insert'''.

|-
|| 03:26
|| In the '''Insert Cells''' dialog box, click on the option '''Entire Column'''.
|-
|| 03:32
|| Then click on the '''OK''' button at the bottom.
|-
|| 03:36
|| Notice that 4 new columns get added before '''Serial Number.'''
|-
|| 03:42
|| Now click any random '''cell''' to deselect.
|-
|| 03:46
|| In a similar manner, we can add multiple '''rows''' as well.

Explore this on your own.
|-
|| 03:54
|| Next we will learn about how to delete columns individually and in groups.
|-
|| 04:00
|| Select any one column by clicking on the alphabet of the column above, as shown.
|-
|| 04:07
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

The selected column gets deleted.
|-
|| 04:18
|| Suppose we want to delete more than one column at a time.
|-
||04:23
|| In my case, I want to delete these 3 '''columns''' which we inserted just now.
|-
|| 04:30
|| So, select the 3 columns by clicking on the alphabet of the column above, as shown.
|-
|| 04:38
|| All the 3 columns get selected.
|-
|| 04:41
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

|-
|| 04:49
|| The selected columns get deleted.

|-
|| 04:53
|| In a similar manner, we can delete multiple '''rows''' as well.

Explore this on your own.
|-
|| 05:01
|| We will now learn about how to insert and delete '''sheets''' in '''Calc'''.

|-
|| 05:07
|| There are several ways to insert a new '''sheet''' in '''Calc'''.

|-
|| 05:12
|| We will learn about each one of them one-by-one.
|-
|| 05:17
|| At the bottom left, we see a tab named '''Sheet 1'''.
|-
|| 05:22
|| There are some icons located before that.
|-
|| 05:26
|| When we click on the '''Plus''' icon, a new '''sheet '''named '''Sheet2''' gets added.
|-
|| 05:33
|| This new '''sheet''' gets added to the right of the current one.
|-
|| 05:38
|| We can also add '''sheets''' by clicking on the empty area next to the '''Sheet '''tabs.
|-
|| 05:46
|| By doing so, the '''Insert Sheet''' dialog box opens up.

|-
|| 05:52
|| Using this dialog box, we can add a sheet before or after the current sheet.

|-
|| 05:59
|| We can also add any no. of '''sheets''' at a time.
|-
|| 06:03
|| Under '''Position''', I will select '''Before the current sheet.'''

And in '''No. of sheets''', I will specify '''2'''.
|-
|| 06:12
|| And then click on the '''OK''' button at the bottom.
|-
|| 06:17
|| Notice that '''Sheet 3 '''and '''Sheet 4 '''get added before '''Sheet 2'''.
|-
|| 06:24
|| Another way to insert '''sheets''' is to click on the '''Sheet menu''' in the '''menu bar'''.

Then click on '''Insert Sheet'''.
|-
|| 06:33
|| On doing so, the '''Insert Sheet''' dialog box opens up.

|-
|| 06:39
|| I will skip this and click on the '''Cancel''' button at the bottom.
|-
|| 06:44
|| Next let us learn how to delete '''sheets'''.

|-
|| 06:48
|| '''Sheets''' can be deleted individually or in groups.
|-
|| 06:53
|| To delete a single '''sheet''', right-click on the tab of the '''sheet''' you wish to delete.

|-
|| 06:59
|| And then, select the '''Delete Sheet''' option.
|-
|| 07:03
|| A '''confirmation''' dialog box pops up.

Click on the '''Yes''' button.
|-
|| 07:10
|| The selected '''sheet '''gets deleted.
|-
|| 07:14
|| How can we delete multiple '''sheets''' at a time?
|-
|| 07:18
|| For example, say we want to delete '''Sheet 2''' and '''Sheet 3'''.
|-
|| 07:24
|| First click on the '''Sheet 2''' tab.
|-
|| 07:27
|| Then holding the '''Shift''' key on the keyboard, click on '''Sheet 3 '''tab.
|-
|| 07:33
|| Now right-click on any one of the tabs and click on the '''Delete Sheet''' option.
|-
|| 07:40
|| A '''confirmation''' dialog box pops up.
|-
|| 07:44
|| Click on the '''Yes''' button to delete the '''sheet'''.

Both the '''sheets''' get deleted.
|-
|| 07:51
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| 07:57
|| '''Sheets '''are named by default as '''Sheet 1, Sheet 2, Sheet 3''' and likewise.

|-
|| 08:04
|| '''Calc''' has a provision to rename the '''sheets''' based on our needs.
|-
|| 08:09
|| For example, let’s rename '''Sheet 2''' as “'''Dump'''”.

|-
|| 08:14
|| Do this by simply double-clicking on '''Sheet 2''' tab.
|-
|| 08:19
|| '''Rename''' '''Sheet''' dialog box opens up.
|-
|| 08:23
|| There is a textbox with '''Sheet''' '''2''' written in it.
|-
|| 08:27
|| Delete this and type “'''Dump'''” as the new name.
|-
|| 08:31
|| Click on the '''OK''' button.
|-
|| 08:35
|| '''Sheet 2''' tab has now been renamed to “'''Dump'''”.
|-
|| 08:40
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| 08:46
|| We can manually rearrange the '''sheets''' by clicking on a '''sheet'''

And dragging it to the desired location.
|-
|| 08:54
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

|-
|| 09:01
|| Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| 09:08
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| 09:13
|| In this tutorial, we learnt to :

|-
|| 09:15
|| Insert and Delete

'''Rows''', '''Columns''', '''Sheets'''

|-
|| 09:21
|| Renaming '''Sheets''' and Move '''Sheets'''

|-
|| 09:26
|| As an assignment

Open '''Spreadsheet'''-'''Practice'''.'''ods'''.

|-
|| 09:32
|| Select and delete the column with the heading '''SN'''.

|-
|| 09:37
|| Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns

|-
|| 09:43
|| Refer to the '''Code files''' link for details.

|-
|| 09:46
|| Rename the '''sheet''' as '''Department-Sheet'''.

|-
|| 09:51
|| Save and close the file.

|-
|| 09:54
|| The video at the following link summarizes the spoken tutorial project.

Please download and watch it.

|-
|| 10:02
|| The Spoken Tutorial Project Team conducts workshops and gives certificates.

|-
|| 10:08
|| For more details, please write to us.

|-
|| 10:12
| |Please post your timed queries in this forum.
|-
||10:16
|| '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| 10:23
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Cells-in-Calc/English-timed

2020-07-17T14:48:16Z

Arvindpillai90:

{| border="1"
|-
|| '''TIME'''
|| '''NARRATION'''
|-
|| 00:01
|| Welcome to the '''spoken tutorial '''on''' Working with Cells.'''
|-
|| 00:06
|| In this tutorial, we will learn to:

|-
|| 00:09
|| Enter '''numbers, text, date '''and''' time''' in a '''spreadsheet'''

|-
|| 00:15
|| Use the '''Format Cells''' dialog box

|-
|| 00:19
|| Navigate between '''cells '''and

|-
|| 00:22
|| Select items in '''rows''' and '''columns'''

|-
|| 00:27
|| This tutorial is recorded using

'''Ubuntu Linux OS''' version 18.04 and '''LibreOffice Suite''' version 6.3.5

|-
|| 00:41
|| First we will learn how to enter '''data''' in the '''cells'''.

|-
|| 00:46
|| Let’s open our '''Personal-Finance-Tracker.ods''' file.
|-
|| 00:52
|| This file has been provided to you in the''' Code files''' link on this tutorial page.

|-
|| 00:59
|| Please download and extract the file.

|-
|| 01:03
|| Make a copy and then use it for practising.

|-
|| 01:08
|| Now type some text in any empty '''cell''' by clicking on the '''cell''' and typing using the keyboard.

Press '''Enter'''.
|-
|| 01:18
|| The text is left-aligned, by default.

|-
|| 01:22
|| One can change the alignment by clicking any one of the '''Alignment''' icons on the '''Formatting''' '''Bar'''.
|-
||02:30
|| Let's undo what we typed.

|-
|| 01:33
|| Press '''Ctrl+Z''' keys on the keyboard to undo.
|-
|| 01:39
|| In this '''spreadsheet''', we had already typed the '''column''' headings earlier.
|-
|| 01:45
|| In '''Calc''', we can differentiate the headings from other '''data''' by adding a '''style''' to it.

|-
|| 01:53
|| To do that, click on cell '''A1'''.Then hold the left mouse button and drag the cursor upto cell '''G1.'''

|-
|| 02:04
|| Now release the left mouse button.
|-
|| 02:07
|| We can see that all the headings got highlighted.
|-
|| 02:12
|| Now click on '''Styles''' menu in the '''menu''' '''bar.'''

|-
|| 02:16
|| We can see various '''heading styles'''.

I will select '''Accent 2'''.

|-
|| 02:24
|| Now click randomly on any '''cell''' to unselect the headings.
|-
|| 02:30
|| Notice that the headings are now highlighted with a grey colour background.
|-
|| 02:36
|| In the '''Items '''column, we’ll type the names of a few items one below the other.

Type the text as shown here.
|-
|| 02:47
|| In order to enter numbers in the '''cell''', click on the '''cell''' and type the number.

Then press '''Enter'''.
|-
|| 02:57
|| Remember to always press the '''Enter''' key after every''' data-entry'''.
|-
|| 03:03
|| To enter a negative number, either type a '''minus''' '''sign''' before it or enclose it within '''parentheses'''.
|-
||03:13
|| By default, numbers are right-aligned and negative numbers have a leading '''minus''' '''symbol'''.
|-
|| 03:20
|| Let us delete these entries.

|-
|| 03:23
|| Select all the '''cells''' to be deleted by holding the '''Shift''' key and clicking each '''cell'''.

Now press the '''Delete '''key on the keyboard.
|-
|| 03:36
|| In the '''SN '''column, we want the serial number of each item one below the other.
|-
|| 03:43
|| So click on '''cell A2''' and enter numbers as '''1, 2, 3''' one below the other.

|-
|| 03:53
|| Remember to press '''Enter '''key after typing each number.
|-
|| 03:58
|| In order to auto-fill the serial numbers in the subsequent '''cells''', click on the '''cell A4'''.

|-
|| 04:06
|| Click on a little''' black box''' that is visible at the bottom-right corner of the '''cell'''.

|-
|| 04:13
|| Drag it till '''cell A7''' and release the mouse button.
|-
|| 04:19
|| We see that '''cells A5, A6''' and '''A7''' get auto-populated with the subsequent serial numbers.
|-
|| 04:28
|| We will now enter the cost of each item under the heading '''Cost'''.
|-
||04:35
|| Click on the '''cell C3''' and type the expense for '''House''' '''rent''' as '''Rupees''' '''6000.00'''
|-
|| 04:45
|| Now, what if we want the number with the '''Rupee''' symbol?
|-
|| 04:51
|| Clear the value typed in '''cell C3 '''by pressing '''Ctrl '''and '''Z '''keys together.
|-
|| 04:59
|| Right-click on the '''cell C3 '''and select the '''Format Cells''' option.

|-
|| 05:05
|| This will open the '''Format Cells''' dialog box.
|-
|| 05:09
|| The first tab is '''Numbers'''. Click on it if not already selected.
|-
|| 05:16
|| Here we can see various options under '''Category'''.

|-
|| 05:21
|| '''Number''', '''Percent''', '''Currency''', '''Date''', '''Time''' and many more.

|-
|| 05:29
|| We will select '''Currency'''.
|-
|| 05:31
|| Various '''currency''' '''symbols''' from across the world are displayed in the '''Format '''list.

|-
|| 05:39
|| By default, '''INR Rupee English (India)''' is selected in the '''Format''' drop-down.

|-
|| 05:46
|| If not, click on the drop-down and select it from the displayed list.
|-
|| 05:51
|| Below the '''Format''' drop-down, we can see some sample values based on our selection.

|-
|| 05:58
|| We see '''minus Rupee 1234 decimal zero zero''' is selected for '''INR Rupees English India'''.
|-
|| 06:10
|| We can see the selected '''format''' in the small preview area on the right.
|-
|| 06:16
|| Below the '''Category''' section, we have another section named as '''Options'''.
|-
|| 06:22
|| Using this, we can increase or decrease the number of '''Decimal places''' and '''Leading zeroes'''.
|-
|| 06:30
|| When we do so, we can see the changes in the sample value and in the preview area.

|-
|| 06:37
|| We will retain the default values.
|-
|| 06:41
|| To add a comma between the values, check the '''Thousands separator''' checkbox.

|-
|| 06:48
|| One can also change the '''font style''' by clicking on the '''Font''' tab.

|-
|| 06:54
|| It has various options for '''Family, Style''' and '''Size'''.
|-
|| 06:59
|| Explore '''Font Effects''' and other tabs to learn more about them on your own.

|-
|| 07:07
|| We will learn about the options in the '''Alignment''' tab in a later tutorial.
|-
|| 07:13
|| Let’s click on the '''OK''' button at the bottom right corner.
|-
|| 07:18
|| Now type '''6000''' in '''cell C3 '''and press '''Enter'''.

|-
|| 07:24
|| Notice that the number '''6000''' is represented as '''Rupees 6000 '''with '''2 decima'''l places.
|-
|| 07:34
|| Now, let's select '''cells C4''' to '''C7''' by holding the '''Shift''' key and clicking the '''cells'''.

|-
|| 07:43
|| Hold the '''CTRL''' key and select '''cell G2''' also.

|-
|| 07:48
|| Notice all the selected '''cells''' are highlighted.
|-
||07:52
|| Right-click on any of the highlighted '''cells''' and select '''Format Cells.'''

|-
|| 07:59
|| Choose the same options as before.
|-
|| 08:03
|| Click on the '''OK''' button at the bottom right corner.
|-
|| 08:07
|| Click any '''cell''' in the '''spreadsheet''' to deselect the '''cells'''.
|-
||08:13
|| Next, we type the amount for all the items one below the other, as shown here.

|-
|| 08:22
|| Under the heading '''Account,''' we’ll type the salary for the month as '''30,000'''.
|-
|| 08:29
|| Let’s move on to the '''Date '''column.

Click on the '''cell F2'''.
|-
|| 08:36
|| For entering date in '''Calc''', select the '''cell''' and type the '''date, '''as shown.

|-
|| 08:42
|| Here I have used a '''forward slash '''between the date elements.
|-
|| 08:47
|| We can also separate the date elements with a '''hyphen'''.

|-
|| 08:52
|| Or use text such as '''05 June 2020'''.

|-
|| 08:59
|| '''Calc''' recognizes a variety of date formats.
|-
|| 09:02
|| We can also customize the date formats according to our requirement.

|-
|| 09:09
|| To do so, right-click on the '''cell''' and select '''Format Cells''' option.
|-
|| 09:16
|| Click on the '''Numbers''' tab.

Under the '''Category''' section, select '''Date.'''
|-
|| 09:22
|| Under the''' Format''' section, select the date format based on your requirement.

I will choose '''31/12/1999. '''
|-
|| 09:36
|| Notice the display in the preview area.
|-
|| 09:40
|| Based on our selection, the '''Format code''' will get updated.

In my case it is '''DD, MM''' and '''YYYY.'''
|-
||09:52
|| Once we have updated the format, click on the '''OK''' button at the bottom right.
|-
|| 09:58
|| Next, let us try some time options.

|-
|| 10:02
|| Click on any random '''cell'''.

Type the '''time '''as shown.

|-
|| 10:08
|| I have separated the time elements with '''colons'''.
|-
|| 10:12
|| To further customize the time format, right-click on the respective cell and select '''Format Cells'''.

|-
|| 10:20
|| Click on '''Numbers''' tab at the top
|-
|| 10:23
|| Under '''Category, '''choose '''Time''' and the desired format under '''Format'''.

I will choose '''13:37:46'''.
|-
|| 10:35
|| Notice the display in the preview area.

|-
|| 10:39
|| Also, the '''Format code''' is displayed below as '''HH:MM:SS'''
|-
|| 10:48
|| One can change the '''Format code''' directly as well.

|-
|| 10:51
|| Click on '''OK '''button at the bottom right.
|-
|| 10:56
|| Let us delete all the time entries from our '''spreadsheet'''.
|-
|| 11:01
|| We will now learn how to navigate within a '''spreadsheet''' from '''cell''' to '''cell.'''
|-
|| 11:07
|| We can access a particular '''cell''' by simply clicking on it with the '''cursor'''.
|-
|| 11:13
|| This changes the focus to the '''new''' '''cell'''.

|-
||11:17
|| This method is most useful when the two '''cells''' are far apart.
|-
|| 11:22
|| Another method of accessing a particular '''cell''' is by using the '''cell''' reference.

|-
||11:28
||Click on the '''Name Box''' at the top left corner, which is located below the '''Font Name.'''
|-
||11:35
||Erase the existing '''cell reference '''and type the '''cell reference''' of the '''cell''' you want to go.
|-
||11:42
||I will type '''B4''' and press '''Enter'''.
|-
|| 11:47
|| Observe that '''cell B4''' gets highlighted.
|-
|| 11:52
|| We can also navigate between '''cells''' using the keyboard.
|-
||11:57
||Press the '''Tab''' key to go to the next '''cell''' in a row.
|-
||12:02
||'''Shift + Tab''' to go to the previous '''cell''' in a row.

|-
||12:07
||'''Enter''' to go to the next '''cell''' in a column.

|-
||12:12
||'''Shift''' + '''Enter''' to go to the previous '''cell''' in a column.

|-
|| 12:17
|| Next, we’ll learn how to select a range of contiguous '''cells''' with the '''cursor'''.

|-
||12:24
||First click on a '''cell''' and hold down the '''left mouse button'''.

|-
||12:29
||Drag the '''cursor''' on the '''sheet'''.

|-
|| 12:32
|| Once the desired block of '''cells''' is highlighted, release the left mouse button.
|-
||12:38
||We see that the selected '''cells''' get highlighted.

|-
||12:42
|| Next, we’ll learn how to select multiple '''columns''' or '''rows''' that are not '''contiguous'''.
|-
||12:59
||Click on the first '''column''' or '''row''' that you want to select.
|-
||12:55
||Now hold down the '''Shift''' key and click the last '''column''' or '''row''' that we want to select.

We see that the selected '''cells''' get highlighted.
|-
|| 13:08
|| Let’s learn to select multiple '''columns''' or '''rows''' that are not contiguous.

|-
||13:14
||Click on the first '''column''' or '''row''' that you want to select.

|-
|| 13:19
|| Hold down the '''Control''' key.

|-
||13:21
||Now click on all of the subsequent columns or rows that you want to select.

|-
|| 13:29
|| We see that the selected '''cells''' get highlighted.
|-
|| 13:34
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

|-
|| 13:40
|| Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| 13:46
|| This brings us to the end of this tutorial, let us summarize.
|-
|| 13:52
|| In this tutorial, we learnt to:

Enter '''numbers, text , date''' and '''time''' in '''Calc'''

|-
|| 14:01
|| Use the '''Format Cells''' dialog box

|-
|| 14:05
|| Navigate between '''cells''' and

|-
|| 14:09
|| Select items in '''rows''' and '''columns'''

|-
||14:13
|| As an assignment

Open '''Spreadsheet-Practice.ods'''
|-
|| 14:19
|| Under '''SN''' type the serial number from '''1 '''to''' 5''' one below the other and '''Align''' '''Center'''.

|-
|| 14:27
|| Add column headings '''Date''' and '''Time '''with the same '''text format'''

|-
|| 14:33
|| Enter some values in those columns

|-
|| 14:37
|| Use the''' Format Cells''' dialog box options to format the '''cells'''

|-
|| 14:43
|| Refer to the '''Code files''' link for the '''data'''.

|-
|| 14:47
|| Save and close the file

|-
|| 14:50
|| The video at the following link summarises the Spoken Tutorial project.

Please download and watch it

|-
|| 14:58
|| We conduct workshops using '''Spoken''' '''Tutorials''' and give certificates.

For more details, please write to us.

|-
||15:08
|| Please post your timed queries in this forum.
|-
|| 15:13
|| '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
||15:19
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from '''IIT Bombay '''signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Viewing-and-printing-a-spreadsheet-in-Calc/English

2020-07-12T15:07:54Z

Arvindpillai90:

Title: Viewing and Printing Spreadsheet document

Author: Arvind Pillai

Novice Reviewer: Pooja, Nikita and Manish

Domain Review: Nancy, Praveen

Keywords: libreoffice, Calc, spreadsheet, print, normal view, page break, print spreadsheet, print cells, page format, page layout, page style, zoom factor, print settings, print to file, full screen mode, print ranges, print copies, print as pdf, spoken tutorial, video tutorial

{| border="1"
|-
| align=center| '''Visual Cue'''
| align=center| '''Narration'''
|-
|| '''Slide''': Title Slide
|| Welcome to the''' '''spoken tutorial on '''Viewing and Printing a spreadsheet.'''
|-
|| '''Slide''' : Learning Objectives
|| In this tutorial we will learn to
* View '''spreadsheets''' and
* Print '''spreadsheets''' in '''LibreOffice Calc.'''

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS''' version '''18.04''' and
* '''LibreOffice Suite '''version '''6.3.5'''

|-
|| Only Narration
|| We’ll first learn about the various viewing options in''' LibreOffice Calc.'''
|-
|| '''Slide''' : Viewing options
|| There are basically two widely used viewing options in '''Calc''' - '''Normal''' and '''Page Break.'''
|-
|| '''Slide''': Normal and Page Break
||
* The '''Normal '''option displays how the '''spreadsheet''' will look when printed.
* The '''Page break '''option displays the '''spreadsheet data''' in different pages when the '''data''' is large.
* It helps us to organise and arrange '''data''' to fit within the pages we want to print.

|-
|| Open '''Personal-Finance-Tracker'''.'''ods'''
|| Open the '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Please download and extract the file.
* Make a copy and then use it for practising.

|-
|| Point to Column B >> Point to Miscellaneous
|| Notice that some part of the text is not readable inside column '''B'''.
|-
|| Only Narration
|| If we print as it is, that text will be truncated in the print.

Let us sort this out first.
|-
|| Place cursor on '''B''' column header
|| Place the cursor on the right edge on column header '''B.'''

Notice that the cursor changes into a double-sided arrow.
|-
|| Left click and drag towards left.

Point to the Data
|| Now click and hold the left mouse button.

Drag a little towards the right side as shown to increase the width of column '''B'''.

Now, we can see all the text of column '''B '''clearly.
|-
|| Click on '''View''' >> '''Normal'''
|| To access the '''Normal''' View, click on '''View''' '''menu''' in the '''menu bar '''and then on '''Normal.'''

This is the default view in '''Calc'''
|-
|| Click on '''View''' >> '''Page Break'''
|| To access the '''Page Break''' option, click on the '''View''' '''menu''' in the '''menu bar '''and then on '''Page Break'''.
|-
|| Zoom the interface using zoom slider
|| For the better visibility I'm zooming in.
|-
|| Point to Page 1
|| We can see a watermark named as '''Page''' '''1 '''and''' Page 2''' displayed.
|-
|| Click on '''View '''>> '''Normal'''
|| Let’s go back to the '''Normal''' view on the '''Calc''' window.
|-
|| Point to the dotted lines

(Editing: point with a red arrow)
|| Notice a vertical dotted line passing between '''Date''' and '''Account''' columns.

This indicates the right page margin.
|-
|| Scroll down

Point to the dotted lines

|| Scroll down until you see a horizontal dotted line.

In my case the dotted line is passing between row number 50 and 51.

In your case it may vary.

This indicates the bottom page margin.
|-
|| Only Narration
|| Within these margins, we can see how much '''data''' of our '''spreadsheet''' fits within a single page.
|-
|| Scroll the page upwards.
|| Scroll the page back up to the top.
|-
|| Only Narration
|| Now let's copy our existing '''data''' and paste it below.
|-
|| Click on cell''' A1 >> '''holding the '''Shift''' key on the keyboard, click on '''cell H8'''.
|| First click on '''cell A1'''.

Now holding the '''Shift key''' on the keyboard, click on '''cell H8'''.
|-
|| Point to selection area.

Right Click on the selection area >> Click on '''copy''' option
|| All the '''cells '''have been selected.

Now right-click anywhere on the selected '''cells''' and then click on the '''Copy''' option.
|-
|| Click on cell '''G10'''

Scroll down to''' row no. 51'''
|| Click anywhere outside the selection area to deselect the '''cells'''.

Now I will scroll down to row number 51.

You should scroll down to the row number where your bottom page margin is seen.
|-
|| Right click on cell''' A51 >> '''click on '''Paste''' option.
|| Right-click on '''cell A51''' and then click on the '''Paste''' option.
|-
|| Click anywhere on the page to deselect cells

Scroll up and press '''Esc'''
|| Click anywhere outside the selection area to deselect the '''cells'''.

Scroll up and press the '''Escape''' key to remove the dotted line selection.
|-
|| Click on '''View''' menu >> '''Page''' '''Break'''
|| Now click on the '''View''' menu and the '''Page Break''' option.
|-
|| Click Zoom out
|| Let us zoom out for better visibility.
|-
|| Scroll upwards and downwards.

Point to '''Page 2 '''and''' Page 1'''

Point to '''Page 3 '''and''' Page 4'''
|| Scroll the page down and up to see the page breaks.

We can see a new page with the watermark '''Page''' '''2''' below '''Page''' '''1.'''

We can also see '''Page 4 '''below '''Page''' '''3''' adjacent to these pages.
|-
|| Click on '''View''' '''Menu''' >> '''Normal''' Option
|| Click on '''View''' '''menu''' and go back to the '''Normal''' view again.
|-
|| Only narration
|| Apart from both these options, one can also view a '''spreadsheet''' in '''full screen mode'''.
|-
|| Click on '''View''' >> '''Full screen'''
|| Click on the '''View''' '''menu''' in the '''menu bar''' and then on '''Full Screen''' option.
|-
|| Only Narration
|| The '''Full screen''' mode is useful for editing '''spreadsheets'''.

It’s also useful for projecting them on a projector.
|-
|| Point to '''Full''' '''Screen''' button >> Press '''Esc''' key
|| To exit the '''full screen mode''', press either the '''Full''' '''Screen''' button or the '''Escape''' key.
|-
|| Only Narration
|| We are back to the '''Normal''' view on the '''Calc''' window.
|-
|| Click on '''Format''' '''menu''' >> '''Page'''
|| Click on '''Format''' in the '''menu bar''' and then on '''Page '''option.
|-
|| Point to dialog box
|| The '''Page Style:Default''' dialog box opens.
|-
|| Point to the tabs at top
|| There are various tabs here.
|-
|| Click on '''Page''' tab
|| Click on the '''Page''' tab.
|-
|| Point to >> '''Paper''' '''Format''' >> '''Margins''' >> '''Layout''' '''settings'''.
|| There are various settings here for '''Paper Format, Margins '''and '''Layout settings'''.
|-
|| Point to '''Orientation'''

Point to '''Portrait'''
|| Under '''Paper Format''', notice that the '''Orientation''' field has the '''Portrait''' option pre-selected.
|-
|| Point to the preview area.
|| Look at the preview area to see the page orientation.
|-
|| Click on the '''Landscape''' option.
|| Now, click on the '''Landscape''' option.
|-
|| Point to the preview area.
|| Look at the '''preview area''' to see how the page orientation has changed.
|-
|| Click on the Portrait option.
|| Click on the '''Portrait''' option once again.
|-
|| Click on '''Sheet''' tab
|| Next, click on the '''Sheet''' tab.
|-
|| Point to '''Page''' '''Order'''

Point to '''Top to bottom, then right'''

The red arrows should indicate the И flow of pages
|| Under''' Page Order''', we see that '''Top to bottom, then right''' is selected.

Recall, that’s exactly how our pages are displayed in the '''Page break''' view.

|-
|| Click on '''Left to right, then bottom'''

Click on '''Ok''' button
|| Let’s click on '''Left to right, then bottom''' and click on the '''OK''' button at the bottom right.
|-
|| Click on '''View''' menu >>'''Page''' '''Break'''
|| Click on '''View''' in the '''menu bar''' and then on '''Page break''' option.
|-
|| Point towards the page numbers.
|| Observe the change in the page numbering.
|-
|| Click on '''View '''>> '''Normal'''
|| Let’s go back to the '''Normal''' view.
|-
|| Only Narration
|| Now, let’s learn to use the '''Zoom '''option.
|-
|| Highlight the '''Zoom''' '''slider''' at the bottom right corner

|| The easiest way to zoom or magnify a '''spreadsheet''' is to use the '''Zoom''' slider.

This is located at the bottom right corner of the '''Calc''' window.
|-
|| Click on plus icon

Click on minus icon
|| We can use the '''plus''' and '''minus''' icons on either side of the slider, like this.
|-
|| Drag the '''Zoom head '''to plus side

Drag the '''Zoom head '''to minus side
|| Or we can drag the '''Zoom head''' to increase or decrease the magnification, like this.
|-
|| Only Narration
|| Let's learn another way of zooming.
|-
|| Click on '''View''' >> '''Zoom'''

Point to option

Click on '''Optimal''' '''View'''
|| Click on the '''View menu''' in the '''menu bar''' and click on '''Zoom'''.

A few more options are displayed in the context menu.

Here select '''Optimal''' '''View'''.
|-
|| Point to the spreadsheet.
|| Now, we get the most comfortable magnified view of the '''spreadsheet'''.
|-
|| Click on '''View''' >> '''Zoom'''

Click on '''Zoom'''
|| Again click on '''View''' '''menu''' in the '''menu bar''' and then on the '''Zoom''' option.

This time from the context menu we’ll click on the '''Zoom '''option.
|-
|| Only narration
|| '''Zoom & View Layout''' dialog box opens up.
|-
|| Point to '''Zoom factor''' and '''View layout'''
|| It has 2 headings namely - '''Zoom Factor''' and '''View''' '''Layout'''.
|-
|| Point to '''Zoom factor''' option
|| The '''Zoom Factor''' sets the magnification in which to display the '''spreadsheet'''.
|-
|| Point to options
|| Under '''Zoom Factor''' we see many options.
|-
|| Click on '''Fit width and height '''option >> click on '''Ok'''

Scroll down and up
|| Click on '''Fit width and height''' and then on the''' Ok''' button at the bottom right'''.'''

This view fits the '''spreadsheet''' across the entire width and height of the page.

Scroll down and up, it displays many pages at a time.
|-
|| Click on '''View''' >> '''Zoom>> Zoom & View Layout''' dialog box''' >>'''
|| Open the '''Zoom & View Layout''' dialog box again.
|-
|| Point to '''Fit to Width'''
|| Next option is '''Fit Width'''.

This fits the page to its width.
|-
|| Point on '''100%'''
|| '''100'''% view will display the page in its actual size.
|-
|| Highlight both options with a red box
|| Try out these 2 options on your own.
|-
|| Click on '''Variable''' option
|| Next we have the most important '''zoom''' option called the '''Variable'''.
|-
|| Point to '''Zoom factor'''
|| Here, we can type the''' zoom factor''' at which we want to view the '''spreadsheet'''.
|-
|| Change value field as '''75%''' >> click on '''OK'''
|| For example, let’s type the value as '''75%''' in the '''Variable''' field.

And then click on the '''OK''' button.
|-
|| Point to the texts.

Click on '''View''' >> '''Zoom>>Optimal View'''
|| Observe how the text is '''zoomed'''.

Let's switch back to '''Optimal''' '''View''' for better visibility.
|-
|| Only Narration
|| Next, we will learn about '''Print Preview'''.
|-
|| Click on '''Toggle''' '''Print''' '''Preview''' icon
|| Click on the '''Toggle''' '''Print Preview '''icon in the '''Standard toolbar'''.
|-
|| Show '''print''' '''preview''' mode
|| The '''Print Preview bar''' appears when we view the '''spreadsheet''' in preview mode.
|-
|| Zoom the interface using zoom slider
|| For the better visibility I'm enlarging the view.
|-
|| Only narration
|| It basically shows how the '''spreadsheet''' will look like, when it is printed.
|-
|| Scroll down to see all the pages
|| Scroll down and up to see all the pages in the '''spreadsheet'''.
|-
|| Show '''Page''' '''2''' and '''Page''' '''4'''
|| Notice that the '''Account '''column is going on to the next page.

So now, we will try to fit the '''data''' into one single page.
|-
|| Click on the '''Close''' '''Preview''' button.
|| Click on the''' Close Preview '''button at the top to exit the '''Toggle Print View.'''
|-
|| Select column '''C to H'''
|| Now select the columns '''C '''to''' H''' as shown here.
|-
|| Place cursor on '''H''' column header
|| Place the cursor on the right edge on the column header '''H.'''

Notice that the cursor changes into a double-sided arrow.
|-
|| Left click and drag towards left.

Point to the Data
|| Now click and hold the left mouse button

Drag a little towards the left side as shown to reduce the margins.

On doing so, all the columns from '''C''' to''' H '''get resized proportionally.
|-
|| Point to the hashtags
|| While doing so some '''data''' in the '''cells''' may look like a series of '''hashtags'''.

If so, resize the''' columns''' and '''zoom''' level in such a way that we are able to see the '''data '''again.
|-
|| Point to the dotted lines.
|| The '''data''' in the columns '''A '''to''' H. '''are now within the dotted boundary line of the page.
|-
|| Click on '''Toggle''' '''Print''' '''Preview''' icon
|| Again, click on the '''Toggle''' '''Print Preview '''icon in the '''Standard toolbar'''.
|-
|| Point at the Pages
|| Now the '''data''' fits within two pages.
|-
|| Only narration.
|| In this way we can adjust the '''data''' before printing, so that it looks neat and organised.
|-
|| Point to the '''Print''' icon
|| From this screen, one can proceed to printing the '''spreadsheet''', by clicking the '''Print''' icon.

But I will not do so now.
|-
|| Click '''Close Preview''' button
|| Click on the '''Close Preview''' button to close the preview.
|-
|| Click on '''File >> Print Preview'''

Press '''Esc '''key
|| We can also click on '''File menu''' in the''' menu bar''' and click on '''Print Preview.'''
|-
|| Only narration
|| Next, we will learn how to print our '''LibreOffice Calc spreadsheet.'''
|-
|| Text on screen: Printer connection should be configured correctly on your machine.
|| First, ensure that the printer connection is configured correctly on your machine.
|-
|| Point on '''Print''' icon
|| To directly print the entire '''spreadsheet''', click on the

'''Print''' icon in the '''Standard toolbar'''.

This is known as quick printing.
|-
|| Click '''File''' '''>> Print'''
|| Alternatively, you can click on the '''File menu''' in the''' menu bar '''and then click on '''Print.'''
|-
|| '''Print '''dialog box appears

Highlight the 2 tabs

Highlight the settings below also
|| The '''Print '''dialog box appears on the screen.

There are 2 tabs with different settings in this dialog box.

We can either leave these as default or change the settings as per our printing requirement.
|-
|| Click Printer >>''' Print to File'''
|| Under '''Printer drop-down''', let’s select '''Print to File '''option.

This option is used predominantly to print the '''spreadsheet '''into '''PDF '''file''' '''format.
|-
|| Point and then click on '''Print to File'''
|| The button at the bottom of the dialog box says '''Print to File'''.

Click on it.
|-
|| Choose '''Desktop '''>> type '''sample-file >> '''Click '''Save'''
|| Choose the location to save and type a '''filename''' for the '''pdf'''.

Then click on the '''Save''' button at the top right.
|-
|| Only narration
|| This saves the file in '''PDF''' format.

You can open this file in any '''PDF''' viewer and print it in future.
|-
||

Press '''Ctrl+P '''keys
|| Let’s learn about some more printing features.

Press '''Ctrl+P '''keys on the keyboard.

This is the shortcut to open the '''Print '''dialog box.
|-
|| Select my configured printer’s''' '''name '''(HP LaserJet)'''.
|| Under '''Printer''', we will select our configured printer’s''' '''name.
|-
|| Under '''Range and Copies''' >> '''Pages''' = 2 and
'''Number of copies''' = 3.
|| Under '''Range and Copies''', let’s set the '''Pages''' as 2 and '''Number of copies''' as 3.

So we are printing 3 copies of Page 2 of our '''spreadsheet'''.
|-
|| Click '''Ok'''
|| Click on the '''OK '''button at the bottom right of the dialog box, to start the printing.
|-
|| Only narration
|| If our printer is configured correctly, the pages and copies we mentioned will now get printed.
|-
|| Only narration
|| Now let’s see how to print certain parts of '''data''' by selecting some '''cells'''.
|-
|| Select '''A1''' to '''C8'''
|| Let’s select the '''data''' from '''A1''' to '''C8''' as shown here.
|-
|| Press '''Ctrl+P '''keys
|| Press '''Ctrl+P '''keys on the keyboard.
|-
|| '''From which''' >> Click on dropdown

Select '''Print selected cells'''
|| In the '''Print '''dialog box, click on the dropdown besides '''From''' '''which''' option.

From the available options select''' Print selected cells.'''
|-
|| Point to print preview.
|| Observe that only selected '''cells''' are displayed in the '''Print preview''' section.
|-
|| Click '''Ok'''
|| Now, click on the '''OK '''button at the bottom right to start the printing.
|-
|| Only narration
|| Next, we will see how to access other '''Print '''options.
|-
|| Click on '''Tools'''>>'''options'''
|| Click on the '''Tools menu '''in the '''menu bar''' and then click on '''Options.'''
|-
|| Click on '''Libreoffice'''>>'''Print'''
|| Click on the arrow beside '''LibreOffice '''if not already expanded and then click on '''Print.'''
|-
|| Dialog box appears
|| A dialog box, giving us several options to select from.

Choose these options as per requirements.
|-
|| Click on '''OK''' button
|| I will keep all the default settings and then click on the '''OK '''button at the bottom.
|-
|| Only narration
|| These settings are now valid for all prints from '''LibreOffice Calc''', in the future.
|-
|| Ctrl + S & Close
|| Save and Close the file
|-
|| Only Narration
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| Slide: Summary
|| In this tutorial, we learnt to:

* View '''spreadsheets''' and
* Print '''spreadsheets''' in '''LibreOffice Calc.'''
|-
|| Slide: Assignment
|| As an assignment

* Open “'''Spreadsheet-Practice.ods'''” file.
* Print '''Sheet 1 '''data in '''Landscape''' mode option.
* Choose '''View '''and select '''Full Screen''' option
* Exit '''Full Screen''' option

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
|| Please post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
| | '''Spoken Tutorial '''project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide''': Thank you
| | This is '''Arvind''' from''' IIT Bombay''' signing off. Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Viewing-and-printing-a-spreadsheet-in-Calc/English

2020-07-12T14:39:09Z

Arvindpillai90: Created page with "Title: Viewing and Printing Spreadsheet document Author: Arvind Pillai Novice Reviewer: Pooja, Nikita and Manish Domain Review: Nancy, Praveen Keywords: libreoffice, Calc..."

Title: Viewing and Printing Spreadsheet document

Author: Arvind Pillai

Novice Reviewer: Pooja, Nikita and Manish

Domain Review: Nancy, Praveen

Keywords: libreoffice, Calc, spreadsheet, print, normal view, page break, print spreadsheet, print cells, page format, page layout, page style, zoom factor, print settings, print to file, full screen mode, print ranges, print copies, print as pdf, spoken tutorial, video tutorial

{| border="1"
|-
| align=center| '''Visual Cue'''
| align=center| '''Narration'''
|-
|| '''Slide''': Title Slide
|| Welcome to the''' '''spoken tutorial on '''Viewing and Printing a spreadsheet.'''
|-
|| '''Slide''' : Learning Objectives
|| In this tutorial we will learn to
* View '''spreadsheets''' and
* Print '''spreadsheets''' in '''LibreOffice Calc.'''

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS''' version '''18.04''' and
* '''LibreOffice Suite '''version '''6.3.5'''

|-
|| Only Narration
|| We’ll first learn about the various viewing options in''' LibreOffice Calc.'''
|-
|| '''Slide''' : Viewing options
|| There are basically two widely used viewing options in '''Calc''' - '''Normal''' and '''Page Break.'''
|-
|| '''Slide''': Normal and Page Break
||
* The '''Normal '''option displays how the '''spreadsheet''' will look when printed.
* The '''Page break '''option displays the '''spreadsheet data''' in different pages when the '''data''' is large.
* It helps us to organise and arrange '''data''' to fit within the pages we want to print.

|-
|| Open '''Personal-Finance-Tracker'''.'''ods'''
|| Open the '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Please download and extract the file.
* Make a copy and then use it for practising.

|-
|| Point to Column B>>Point to Miscellaneous

|| Notice that some part of the text is not readable inside column '''B'''.
|-
|| Only Narration
|| If we print as it is, that text will be truncated in the print.

Let us sort this out first.
|-
|| Place cursor on '''B''' column header

|| Place the cursor on the right edge on column header '''B.'''

Notice that the cursor changes into a double-sided arrow.
|-
|| Left click and drag towards left.

Point to the Data
|| Now click and hold the left mouse button.

Drag a little towards the right side as shown to increase the width of column '''B'''.

Now, we can see all the text of column '''B '''clearly.
|-
|| Click on '''View''' >> '''Normal'''
|| To access the '''Normal''' View, click on '''View''' '''menu''' in the '''menu bar '''and then on '''Normal.'''

This is the default view in '''Calc'''
|-
|| Click on '''View''' >> '''Page Break'''
|| To access the '''Page Break''' option, click on the '''View''' '''menu''' in the '''menu bar '''and then on '''Page Break'''.
|-
|| Zoom the interface using zoom slider
|| For the better visibility I'm zooming in.
|-
|| Point to Page 1
|| We can see a watermark named as '''Page''' '''1 '''and''' Page 2''' displayed.
|-
|| Click on '''View '''>> '''Normal'''
|| Let’s go back to the '''Normal''' view on the '''Calc''' window.
|-
|| Point to the dotted lines

(Editing: point with a red arrow)
|| Notice a vertical dotted line passing between '''Date''' and '''Account''' columns.

This indicates the right page margin.
|-
|| Scroll down

Point to the dotted lines

|| Scroll down until you see a horizontal dotted line.

In my case the dotted line is passing between row number 50 and 51.

In your case it may vary.

This indicates the bottom page margin.
|-
|| Only Narration
|| Within these margins, we can see how much '''data''' of our '''spreadsheet''' fits within a single page.
|-
|| Scroll the page upwards.
|| Scroll the page back up to the top.
|-
|| Only Narration
|| Now let's copy our existing '''data''' and paste it below.
|-
|| Click on cell''' A1 >> '''holding the '''Shift''' key on the keyboard, click on '''cell H8'''.
|| First click on '''cell A1'''.

Now holding the '''Shift key''' on the keyboard, click on '''cell H8'''.
|-
|| Point to selection area.

Right Click on the selection area >> Click on '''copy''' option
|| All the '''cells '''have been selected.

Now right-click anywhere on the selected '''cells''' and then click on the '''Copy''' option.
|-
|| Click on cell '''G10'''

Scroll down to''' row no. 51'''
|| Click anywhere outside the selection area to deselect the '''cells'''.

Now I will scroll down to row number 51.

You should scroll down to the row number where your bottom page margin is seen.
|-
|| Right click on cell''' A51 >> '''click on '''Paste''' option.
|| Right-click on '''cell A51''' and then click on the '''Paste''' option.
|-
|| Click anywhere on the page to deselect cells

Scroll up and press '''Esc'''
|| Click anywhere outside the selection area to deselect the '''cells'''.

Scroll up and press the '''Escape''' key to remove the dotted line selection.
|-
|| Click on '''View''' menu >> '''Page''' '''Break'''
|| Now click on the '''View''' menu and the '''Page Break''' option.
|-
|| Click Zoom out
|| Let us zoom out for better visibility.
|-
|| Scroll upwards and downwards.

Point to '''Page 2 '''and''' Page 1'''

Point to '''Page 3 '''and''' Page 4'''
|| Scroll the page down and up to see the page breaks.

We can see a new page with the watermark '''Page''' '''2''' below '''Page''' '''1.'''

We can also see '''Page 4 '''below '''Page''' '''3''' adjacent to these pages.
|-
|| Click on '''View''' '''Menu''' >> '''Normal''' Option
|| Click on '''View''' '''menu''' and go back to the '''Normal''' view again.
|-
|| Only narration
|| Apart from both these options, one can also view a '''spreadsheet''' in '''full screen mode'''.
|-
|| Click on '''View''' >> '''Full screen'''
|| Click on the '''View''' '''menu''' in the '''menu bar''' and then on '''Full Screen''' option.
|-
|| Only Narration
|| The '''Full screen''' mode is useful for editing '''spreadsheets'''.

It’s also useful for projecting them on a projector.
|-
|| Point to '''Full''' '''Screen''' button >> Press '''Esc''' key
|| To exit the '''full screen mode''', press either the '''Full''' '''Screen''' button or the '''Escape''' key.
|-
|| Only Narration
|| We are back to the '''Normal''' view on the '''Calc''' window.
|-
|| Click on '''Format''' '''menu''' >> '''Page'''
|| Click on '''Format''' in the '''menu bar''' and then on '''Page '''option.
|-
|| Point to dialog box
|| The '''Page Style:Default''' dialog box opens.
|-
|| Point to the tabs at top
|| There are various tabs here.
|-
|| Click on '''Page''' tab
|| Click on the '''Page''' tab.
|-
|| Point to >> '''Paper''' '''Format''' >> '''Margins''' >> '''Layout''' '''settings'''.
|| There are various settings here for '''Paper Format, Margins '''and '''Layout settings'''.
|-
|| Point to '''Orientation'''

Point to '''Portrait'''
|| Under '''Paper Format''', notice that the '''Orientation''' field has the '''Portrait''' option pre-selected.
|-
|| Point to the preview area.
|| Look at the preview area to see the page orientation.
|-
|| Click on the '''Landscape''' option.
|| Now, click on the '''Landscape''' option.
|-
|| Point to the preview area.
|| Look at the '''preview area''' to see how the page orientation has changed.
|-
|| Click on the Portrait option.
|| Click on the '''Portrait''' option once again.
|-
|| Click on '''Sheet''' tab
|| Next, click on the '''Sheet''' tab.
|-
|| Point to '''Page''' '''Order'''

Point to '''Top to bottom, then right'''

The red arrows should indicate the И flow of pages
|| Under''' Page Order''', we see that '''Top to bottom, then right''' is selected.

Recall, that’s exactly how our pages are displayed in the '''Page break''' view.
|-
|| Click on '''Left to right, then bottom'''

Click on '''Ok''' button
|| Let’s click on '''Left to right, then bottom''' and click on the '''OK''' button at the bottom right.
|-
|| Click on '''View''' menu >>'''Page''' '''Break'''
|| Click on '''View''' in the '''menu bar''' and then on '''Page break''' option.
|-
|| Point towards the page numbers.
|| Observe the change in the page numbering.
|-
|| Click on '''View '''>> '''Normal'''
|| Let’s go back to the '''Normal''' view.
|-
|| Only Narration
|| Now, let’s learn to use the '''Zoom '''option.
|-
|| Highlight the '''Zoom''' '''slider''' at the bottom right corner
|| The easiest way to zoom or magnify a '''spreadsheet''' is to use the '''Zoom''' slider.

This is located at the bottom right corner of the '''Calc''' window.
|-
|| Click on plus icon

Click on minus icon
|| We can use the '''plus''' and '''minus''' icons on either side of the slider, like this.
|-
|| Drag the '''Zoom head '''to plus side

Drag the '''Zoom head '''to minus side
|| Or we can drag the '''Zoom head''' to increase or decrease the magnification, like this.
|-
|| Only Narration
|| Let's learn another way of zooming.
|-
|| Click on '''View''' >> '''Zoom'''

Point to option

Click on '''Optimal''' '''View'''
|| Click on the '''View menu''' in the '''menu bar''' and click on '''Zoom'''.

A few more options are displayed in the context menu.

Here select '''Optimal''' '''View'''.
|-
|| Point to the spreadsheet.
|| Now, we get the most comfortable magnified view of the '''spreadsheet'''.
|-
|| Click on '''View''' >> '''Zoom'''

Click on '''Zoom'''
|| Again click on '''View''' '''menu''' in the '''menu bar''' and then on the '''Zoom''' option.

This time from the context menu we’ll click on the '''Zoom '''option.
|-
|| Only narration
|| '''Zoom & View Layout''' dialog box opens up.
|-
|| Point to '''Zoom factor''' and '''View layout'''
|| It has 2 headings namely - '''Zoom Factor''' and '''View''' '''Layout'''.
|-
|| Point to '''Zoom factor''' option
|| The '''Zoom Factor''' sets the magnification in which to display the '''spreadsheet'''.
|-
|| Point to options
|| Under '''Zoom Factor''' we see many options.
|-
|| Click on '''Fit width and height '''option >> click on '''Ok'''

Scroll down and up
|| Click on '''Fit width and height''' and then on the''' Ok''' button at the bottom right'''.'''

This view fits the '''spreadsheet''' across the entire width and height of the page.

Scroll down and up, it displays many pages at a time.
|-
|| Click on '''View''' >> '''Zoom>> Zoom & View Layout''' dialog box''' >>'''
|| Open the '''Zoom & View Layout''' dialog box again.
|-
|| Point to '''Fit to Width'''
|| Next option is '''Fit Width'''.

This fits the page to its width.
|-
|| Point on '''100%'''
|| '''100'''% view will display the page in its actual size.
|-
|| Highlight both options with a red box
|| Try out these 2 options on your own.
|-
|| Click on '''Variable''' option
|| Next we have the most important '''zoom''' option called the '''Variable'''.
|-
|| Point to '''Zoom factor'''
|| Here, we can type the''' zoom factor''' at which we want to view the '''spreadsheet'''.
|-
|| Change value field as '''75%''' >> click on '''OK'''
|| For example, let’s type the value as '''75%''' in the '''Variable''' field.

And then click on the '''OK''' button.
|-
|| Point to the texts.

Click on '''View''' >> '''Zoom>>Optimal View'''
|| Observe how the text is '''zoomed'''.

Let's switch back to '''Optimal''' '''View''' for better visibility.
|-
|| Only Narration
|| Next, we will learn about '''Print Preview'''.
|-
|| Click on '''Toggle''' '''Print''' '''Preview''' icon
|| Click on the '''Toggle''' '''Print Preview '''icon in the '''Standard toolbar'''.
|-
|| Show '''print''' '''preview''' mode
|| The '''Print Preview bar''' appears when we view the '''spreadsheet''' in preview mode.
|-
|| Zoom the interface using zoom slider
|| For the better visibility I'm enlarging the view.
|-
|| Only narration
|| It basically shows how the '''spreadsheet''' will look like, when it is printed.
|-
|| Scroll down to see all the pages
|| Scroll down and up to see all the pages in the '''spreadsheet'''.
|-
|| Show '''Page''' '''2''' and '''Page''' '''4'''
|| Notice that the '''Account '''column is going on to the next page.

So now, we will try to fit the '''data''' into one single page.
|-
|| Click on the '''Close''' '''Preview''' button.

|| Click on the''' Close Preview '''button at the top to exit the '''Toggle Print View.'''
|-
|| Select column '''C to H'''
|| Now select the columns '''C '''to''' H''' as shown here.
|-
|| Place cursor on '''H''' column header

|| Place the cursor on the right edge on the column header '''H.'''

Notice that the cursor changes into a double-sided arrow.
|-
|| Left click and drag towards left.

Point to the Data
|| Now click and hold the left mouse button

Drag a little towards the left side as shown to reduce the margins.

On doing so, all the columns from '''C''' to''' H '''get resized proportionally.
|-
|| Point to the hashtags
|| While doing so some '''data''' in the '''cells''' may look like a series of '''hashtags'''.

If so, resize the''' columns''' and '''zoom''' level in such a way that we are able to see the '''data '''again.
|-
|| Point to the dotted lines.
|| The '''data''' in the columns '''A '''to''' H. '''are now within the dotted boundary line of the page.
|-
|| Click on '''Toggle''' '''Print''' '''Preview''' icon
|| Again, click on the '''Toggle''' '''Print Preview '''icon in the '''Standard toolbar'''.
|-
|| Point at the Pages
|| Now the '''data''' fits within two pages.
|-
|| Only narration.
|| In this way we can adjust the '''data''' before printing, so that it looks neat and organised.
|-
|| Point to the '''Print''' icon
|| From this screen, one can proceed to printing the '''spreadsheet''', by clicking the '''Print''' icon.

But I will not do so now.
|-
|| Click '''Close Preview''' button
|| Click on the '''Close Preview''' button to close the preview.
|-
|| Click on '''File >> Print Preview'''

Press '''Esc '''key
|| We can also click on '''File menu''' in the''' menu bar''' and click on '''Print Preview.'''
|-
|| Only narration
|| Next, we will learn how to print our '''LibreOffice Calc spreadsheet.'''
|-
|| Text on screen: Printer connection should be configured correctly on your machine.
|| First, ensure that the printer connection is configured correctly on your machine.
|-
|| Point on '''Print''' icon
|| To directly print the entire '''spreadsheet''', click on the

'''Print''' icon in the '''Standard toolbar'''.

This is known as quick printing.
|-
|| Click '''File''' '''>> Print'''
|| Alternatively, you can click on the '''File menu''' in the''' menu bar '''and then click on '''Print.'''
|-
|| '''Print '''dialog box appears

Highlight the 2 tabs

Highlight the settings below also
|| The '''Print '''dialog box appears on the screen.

There are 2 tabs with different settings in this dialog box.

We can either leave these as default or change the settings as per our printing requirement.
|-
|| Click Printer >>''' Print to File'''
|| Under '''Printer drop-down''', let’s select '''Print to File '''option.

This option is used predominantly to print the '''spreadsheet '''into '''PDF '''file''' '''format.
|-
|| Point and then click on '''Print to File'''
|| The button at the bottom of the dialog box says '''Print to File'''.

Click on it.
|-
|| Choose '''Desktop '''>> type '''sample-file >> '''Click '''Save'''
|| Choose the location to save and type a '''filename''' for the '''pdf'''.

Then click on the '''Save''' button at the top right.
|-
|| Only narration
|| This saves the file in '''PDF''' format.

You can open this file in any '''PDF''' viewer and print it in future.
|-
||

Press '''Ctrl+P '''keys
|| Let’s learn about some more printing features.

Press '''Ctrl+P '''keys on the keyboard.

This is the shortcut to open the '''Print '''dialog box.
|-
|| Select my configured printer’s''' '''name '''(HP LaserJet)'''.
|| Under '''Printer''', we will select our configured printer’s''' '''name.
|-
|| Under '''Range and Copies''' >> '''Pages''' = 2 and
'''Number of copies''' = 3.
|| Under '''Range and Copies''', let’s set the '''Pages''' as 2 and '''Number of copies''' as 3.

So we are printing 3 copies of Page 2 of our '''spreadsheet'''.
|-
|| Click '''Ok'''
|| Click on the '''OK '''button at the bottom right of the dialog box, to start the printing.
|-
|| Only narration
|| If our printer is configured correctly, the pages and copies we mentioned will now get printed.
|-
|| Only narration
|| Now let’s see how to print certain parts of '''data''' by selecting some '''cells'''.
|-
|| Select '''A1''' to '''C8'''
|| Let’s select the '''data''' from '''A1''' to '''C8''' as shown here.
|-
|| Press '''Ctrl+P '''keys
|| Press '''Ctrl+P '''keys on the keyboard.
|-
|| '''From which''' >> Click on dropdown

Select '''Print selected cells'''
|| In the '''Print '''dialog box, click on the dropdown besides '''From''' '''which''' option.

From the available options select''' Print selected cells.'''
|-
|| Point to print preview.
|| Observe that only selected '''cells''' are displayed in the '''Print preview''' section.
|-
|| Click '''Ok'''
|| Now, click on the '''OK '''button at the bottom right to start the printing.
|-
|| Only narration
|| Next, we will see how to access other '''Print '''options.
|-
|| Click on '''Tools'''>>'''options'''
|| Click on the '''Tools menu '''in the '''menu bar''' and then click on '''Options.'''
|-
|| Click\Point on '''Libreoffice'''>>'''Print'''
|| Click on the arrow beside '''LibreOffice '''if not already expanded and then click on '''Print.'''
|-
|| Dialog box appears
|| A dialog box, giving us several options to select from.

Choose these options as per requirements.
|-
|| Click on '''OK''' button
|| I will keep all the default settings and then click on the '''OK '''button at the bottom.
|-
|| Only narration
|| These settings are now valid for all prints from '''LibreOffice Calc''', in the future.
|-
|| Ctrl + S & Close
|| Save and Close the file
|-
|| Only Narration
|| This brings us to the end of this tutorial.

Let us summarize.
|-
|| Slide: Summary
|| In this tutorial, we learnt to:
* View '''spreadsheets''' and
* Print '''spreadsheets''' in '''LibreOffice Calc.'''

|-
|| Slide: Assignment
|| As an assignment
* Open “'''Spreadsheet-Practice.ods'''” file.
* Print '''Sheet 1 '''data in '''Landscape''' mode option.
* Choose '''View '''and select '''Full Screen''' option
* Exit '''Full Screen''' option

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
|| Please post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
| | '''Spoken Tutorial '''project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide''': Thank you
| | This is '''Arvind''' from''' IIT Bombay''' signing off. Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Data-in-Calc/English

2020-07-03T21:26:28Z

Arvindpillai90: Created page with "Title: Working with Data Author: Arvind PillaiKeywords: LibreOffice,Calc,Ubuntu,Using Fill Tools in Calc,Using Selection lists in Calc,Sharing contents between sheets in Calc..."

Title: Working with Data

Author: Arvind PillaiKeywords: LibreOffice,Calc,Ubuntu,Using Fill Tools in Calc,Using Selection lists in Calc,Sharing contents between sheets in Calc,Removing data in Calc,Replacing data in Calc,Changing part of data in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
| align=center| '''NARRATION'''
|-
|| '''Slide''': Title Slide
|| Welcome to the '''spoken tutorial''' on '''Working with data in Calc.'''
|-
|| '''Slide''': Learning objectives

|| In this tutorial, we will learn to:

* Autofill '''data''' using '''Fill''' '''tools'''
* Share the same content on all '''sheets '''of the same '''spreadsheet'''.
* Remove '''data''', replace '''data''', change part of the '''data '''in a '''cell'''.

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide''': Automated Input of Data
||
* Entering '''data''' into a '''spreadsheet''' can be very labor-intensive.
* So '''Calc''' provides several tools for making it considerably easier.
* The most basic ability is to drag and drop the contents of one '''cell''' to another with the mouse.

|-
|| '''Slide''': Automated Input of Data
||
* However '''Calc''' also has other tools for automating input, especially for repetitive '''data'''.
* One such tool is the '''Fill''' '''tool'''.
* This can input '''data''' into multiple '''sheets''' of the same '''spreadsheet '''in one go.

|-
|| Open '''Personal-Finance-Tracker'''.'''ods'''
|| Open the '''Personal-Finance-Tracker.ods''' file.
|-
|| Point to '''Cost''' Column
|| In our file, let's copy the '''data''' under the '''heading Cost''' to the adjacent '''cells'''.
|-
||

Select cells with “'''6000'''” to “'''2000'''” under '''cost'''
|| Click on the '''cell''' which contains the entry '''6000''' under '''cost'''.

Hold the left '''mouse''' button, drag it till the end of the '''cell''' which contains the cost entry '''2000'''.
|-
|| Select the '''cells''' adjacent to the right.
|| Also select the '''cells''' adjacent to the right of the selected '''cells''' along with it.
|-
||
|| In these adjacent '''cells''' we will copy the '''data'''.
|-
|| Release the left mouse after selecting the '''cells'''.
|| Now release the left '''mouse''' button.
|-
|| Click on '''Sheet''' >> click on '''Fill Cells'''

Click on '''Fill''' '''Right'''.
|| Next, click on the '''Sheet''' '''menu''' in the '''menu''' '''bar''' and go to the '''Fill Cells''' submenu.

Click on the '''Fill''' '''Right''' option from the submenu.
|-
|| Click >> '''Column''' Icon

Click >> '''Fill''' '''Right''' Option
|| Alternatively, you can click on the dropdown of the '''Column''' icon in the '''Standard toolbar'''.

And then click '''Fill''' '''Right''' option
|-
|| Point to the copied data

Undo the changes.
|| We see that the '''data''' under the '''heading Cost''' gets copied into the adjacent '''cells'''.

Let us undo the changes.
|-
|| '''Slide: '''Fil Tool
||
* A more complex use of the''' Fill tool''' is used for filling some series as '''data''' in the '''sheets'''
* '''Calc''' provides default lists for the full and abbreviated
** Days of the week and
** The months of the year.
* It also enables the '''users''' to create their own lists.

|-
|| Insert new row besides '''Cost '''and type '''heading''' as '''Days'''

|| Now let’s insert a new heading named '''Days''' in our '''sheet'''.

Under this, we will display the seven days of the week automatically.
|-
|| Select seven consecutive '''cells''' below the '''heading Days'''
|| Select the first seven '''cells''' below the '''heading Days'''.
|-
|| Click on '''Sheet'''>>'''Fill''' '''Cells'''>>'''Fill''' '''Series'''.

|| Now click on the '''Sheet''' '''menu''' in the '''menu''' '''bar''' and then on '''Fill Cells''' submenu.

Select '''Fill''' '''Series''' option from the submenu.
|-
|| Point to '''Fill''' '''Series'''.
|| The '''Fill''' '''Series '''dialog box appears.
|-
|| Under >> Series Type

Click on '''AutoFill'''.
|| Now under '''Series Type''', click on the '''AutoFill''' option.
|-
|| Type '''Sunday''' in the Start '''value''' field.
|| In the '''Start''' '''value''' field, we’ll type the first day of the week, that is '''Sunday'''.
|-
|| Point to '''Increment'''
|| The '''Increment''' field is already set as '''1'''.
|-
|| Click on '''OK'''
|| Now click on the '''OK''' button.
|-
|| Point to the '''Days''' column.
|| We see that all the days are automatically displayed in the '''cells'''.

We can enter only '''weekdays '''and '''months''' by this method as these are pre-defined in '''Calc'''.
|-
|| Only Narration
|| Let me demonstrate another method for auto-filling sequential '''data'''.
|-
|| Type '''Sunday''' in '''cell D11''' >> press '''Enter'''.
|| Type '''Sunday''' in another '''cell''' and press '''Enter'''.

This will shift the focus to the next '''cell''' in the '''column'''.
|-
|| Click on '''cell D11 Sunday'''

Point to the black box on the bottom right of cell '''D11'''.
|| Go back to the '''cell''' where '''Sunday''' was typed.

We see a small '''black''' '''box''' at the bottom-right-hand corner of the '''cell'''.
|-
|| Click on this '''box'''

Drag it downwards till you see '''Saturday'''

Release the mouse button.
|| Click on this '''box''' with the mouse.

Drag downwards till you see '''Saturday''' in the display box on the right.

Release the mouse button.
|-
|| Point to the '''cells'''
|| The '''cells''' get autofilled with the weekdays automatically.

This method works for all '''data '''that are sequential.
|-
|| Press '''Ctrl + Z'''
|| Let's undo these changes.
|-
|| Only Narration

Delete the serial number '''1 to 7 '''below '''SN'''.
|| Next, we’ll create an '''autofill''' series of '''numbers''' by entering the '''start''', '''end''' and '''increment''' values.

We will first delete the serial numbers already entered in the '''cells A2''' to '''A8.'''
|-
|| Click on '''Sheet''' >> '''Fill''' '''Cells''' >> '''Fill''' '''Series'''
|| Now click on the '''Sheet''' in the '''menu bar'''.

Then on the '''Fill''' '''Cells''' and '''Fill''' '''Series''' option.
|-
|| Point to '''Fill''' '''Series''' dialog box >>

Click on '''Linear'''.
|| In the '''Fill''' '''Series''' dialog box, under '''Series''' '''Type '''click on the '''Linear''' option'''.'''
|-
|| Type '''1''' in '''Start''' '''value'''.
|| In the '''Start''' '''value''' field, we will type the first serial number, that is '''1'''.
|-
|| Type '''7''' in '''End''' '''value'''.
|| In the '''End''' '''value''' field, we will type the last value to be entered as '''7.'''
|-
|| Type '''1''' in '''Increment''' value.

Click on '''OK'''
|| Now we’ll set the '''Increment''' value as '''1, '''if it is not already '''1'''.

Then click on the '''OK''' button.
|-
|| Point to the “'''SN'''” column.
|| The '''cells''' get filled automatically with sequential serial numbers between 1 and 7.
|-
|| Slide: Assignment
||
*As an assignment, repeat the above steps with an increment value of 5.

*Observe the changes and then undo them.

|-
|| Only Narration:
|| In all these cases, the '''Fill''' '''tool''' creates only a momentary connection between the '''cells'''.

Once they are filled, the '''cells''' have no further connection with one another.
|-
|| '''Slide: '''Share content between sheets
||
* In '''Calc''' the same '''data''' can be entered in the same '''cell '''location on multiple '''sheets'''.
* This means, there’s no need to enter the same data on each '''sheet''' separately.
* One can enter them in all the '''sheets''' at once.

|-
||
|| Let’s learn how to do this.
|-
|| Point to '''Sheet''' '''1''' where our data is entered.

Point to the '''Sheet''' '''2''' and '''Sheet''' '''3''' tabs at the bottom.
|| In the '''Personal-Finance-Tracker.ods''' file, our entire '''data''' is on '''Sheet''' '''1'''.

Now we want '''Sheet''' '''2''' and '''Sheet''' '''3''' to show the same '''data''' as in '''Sheet''' '''1'''.
|-
|| Click on '''Edit''' >> '''Select'''
|| To do that, click on the '''Edit''' menu in the '''menu bar''' and then click on '''Select'''.
|-
|| Click on '''Select Sheets'''.
|| Now click on '''Select sheets'''.
|-
|| Point to '''Select''' '''Sheets''' dialog box.
|| The '''Select''' '''Sheets''' dialog box appears.
|-
|| Press and hold Shift key and select '''Sheet''' '''1''', '''Sheet''' '''2''', '''Sheet''' '''3'''

Click on '''OK'''.
|| Using the '''Shift''' key, select the options '''Sheet''' '''1''', '''Sheet''' '''2''', and '''Sheet''' '''3'''.

And then click on the '''OK''' button.
|-
|| Point to '''Sheet''' '''1'''
|| This takes us back to '''Sheet''' '''1.'''

Now let's type something in '''Sheet''' '''1'''.
|-
|| Type in a '''cell F12'''.
|| For example, in '''cell F12''' we’ll type “'''This will be displayed on multiple sheets”'''.
|-
|| Click on '''Sheet''' '''2''' and '''Sheet''' '''3''' tab below.
|| Now click on the '''Sheet''' '''2''' and the''' Sheet 3''' tab one after the other.
|-
|| Point to Cell '''F12''' in '''Sheet''' '''2''' and '''Sheet''' '''3'''
|| We see that in each of the '''sheets''', '''cell F12''' displays the exact same '''data'''.
|-
|| Undo the changes.
|| Let us undo these changes.
|-
|| Only Narration:
|| Next we will learn about different ways in which we can delete and edit '''data''' in '''cells'''.
|-
|| Click on cell '''A2''' which contains '''1'''.
|| To delete '''data''' without removing any of the existing '''cell''' formatting, first select the '''cell'''.
|-
|| Point to the '''Input''' '''line'''.

Click on the '''Input''' '''Line'''
|| The '''data''' of the '''cell''' is displayed in the '''Input''' '''line''' field.

Click on the '''Input''' '''line '''once.
|-
|| Press '''backspace''' on the '''Input''' '''line'''.

Point to the '''Input''' '''line'''.
|| Now press the '''Backspace''' key on the keyboard.

The '''data''' gets deleted.
|-
|| Press '''Ctrl+Z '''keys
|| Let us undo these changes.
|-
|| Click on cell '''A2''' which contains '''1''' and type '''23'''.

Click any other '''cell''' on the '''sheet >> '''Point to '''cell A2'''
|| To replace '''data''' in a '''cell''', select the '''cell''' and type over the old '''data'''.

The new '''data''' will retain the '''cell’s '''original formatting.
|-
|| Press '''Ctrl+Z '''keys
|| Let us undo these changes.
|-
|| Only narration
|| We can change part of the '''data''' in a '''cell '''also, without removing all the contents.
|-
|| Double click on cell '''B3'''
|| To do so, just double-click on the '''cell'''.
|-
|| Double click on word '''Rent >> '''Type '''Expenses''' >> press '''Enter'''

Point to cell '''B3'''
|| Then select the word '''Rent '''by double-clicking on it.

Now type '''Expenses '''and press''' Enter.'''
|-
|| Press '''Ctrl+Z '''keys
|| Let us undo these changes.
|-
|| Press '''Ctrl + S '''>> close the file
|| Lastly, save and close the file.
|-
|| Only narration
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt to:
* Autofill '''data''' using '''Fill''' '''tools.'''
* Share the same content on all '''sheets '''of the same file.
* Remove '''data''', replace '''data''', change part of the '''data '''in a '''cell'''.

|-
|| '''Slide: Assignment '''
|| As an assignment
* Open “'''spreadsheet-practice.ods'''” sheet.
* Create a '''Month''' column besides '''Time.'''
* Use the '''Fill''' '''Series''' option to auto-fill till the month of '''May'''.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
|| Please post your timed queries in this forum.
|-
|| '''Slide''': Acknowledgement
| | '''Spoken Tutorial '''project are funded by '''MHRD''', Govt. of India.
|-
|| '''Slide''': Thank you
| | This is '''Arvind''' from''' IIT Bombay''' signing off. Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Basic-Data-manipulation-in-Calc/English

2020-07-03T20:54:17Z

Arvindpillai90: Created page with "Title: Basic Data Manipulation Author: Arvind Pillai Keywords: LibreOffice,Calc,Ubuntu,Addition in Calc, Subtraction in Calc,Sorting columns in Calc,Filtering data in Calc..."

Title: Basic Data Manipulation

Author: Arvind Pillai

Keywords: LibreOffice,Calc,Ubuntu,Addition in Calc, Subtraction in Calc,Sorting columns in Calc,Filtering data in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide''':Title
|| Welcome to the '''spoken tutorial '''on '''Basic Data Manipulation '''in''' Calc.'''
|-
|| '''Slide:'''Learning objectives
|| In this tutorial, we will learn how to:
* Use some basic '''Formula '''in''' Calc'''
* Sort by columns and
* Filter '''data'''

|-
|| '''Slide: '''System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux''' OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide: '''What is a formula?
|| A '''formula''' is an equation that uses '''numbers '''and '''variables '''to get a result.

The '''variables '''are '''cell locations''' that hold the data needed for the '''equation.'''
|-
|| '''Slide: '''Basic''' '''Arithmetic''' '''Operations
|| First, we’ll learn how to perform some basic '''arithmetic''' calculations in '''Calc'''.

That is '''Addition''', '''subtraction''', '''multiplication''' and '''division'''.
|-
|| Open '''Personal-Finance-Tracker'''.'''ods'''
|| Open the '''Personal-Finance-Tracker.ods''' file.
|-
|| Point to '''Cost'''.
|| Let’s sum up the cost of all the expenses mentioned under the '''heading Cost'''.
|-
|| Type '''SUM''' '''TOTAL in the '''cell '''B8 '''under '''Miscellaneous'''.

Click on the cell '''A8''' >> type '''7'''
|| We will type '''Sum Total''' just under '''Miscellaneous'''.

Then click on '''cell A8''' and type the serial number as '''7'''.
|-
|| Click on '''C8'''.
|| Now click on '''cell''' '''C8''' which is where we want to display the sum total of the '''costs'''.
|-
|| Type '''<nowiki>=SUM(C3:C7) </nowiki>'''in''' '''the''' cell C8'''

|| Type '''is equal to SUM''' and within '''braces''' the range of columns to be added.

That is '''C3 colon C7'''.
|-
|| Press '''Enter'''.

Point to the total under '''Cost''' cell '''C8'''
|| Now press '''Enter'''.

Observe that all the amounts under '''Cost''' get added and sum total is displayed in '''cell C8'''.
|-
|| Only Narration
|| Next, let’s learn how to do '''subtraction''' in '''Calc'''.
|-
|| Point to '''House''' '''Rent''' and '''Electricity Bill'''.

Point to '''cell C10'''.
|| Say we want to subtract the cost of the '''House''' '''Rent''' and '''Electricity''' '''Bill'''.

We will display this in '''cell''' '''C10'''.
|-
|| Click '''cell C10'''

Type '''<nowiki>=C3-C4.</nowiki>'''
|| So click on '''cell C10''' and type the following-

'''“is equal to C3 minus C4”.'''
|-
|| Press '''Enter'''.

Point to the '''cell C10'''.

Point to cell '''C3''' and '''C4'''
|| Press '''Enter'''.

Observe the value in the '''cell C10'''.

It shows the subtracted value of '''C3''' and '''C4.'''
|-
|| Only Narration
|| Similarly, one can '''divide''' and '''multiply data''' in different '''cells'''.
|-
|| Click on '''cell C11''' >> type '''<nowiki>=C5*C6</nowiki>''' >> press '''Enter'''.
|| Click on '''cell C11''' and type '''“is equal to C5 asterix C6”''' and press '''Enter'''.

The answer of the '''multiplication''' is shown in '''cell C11'''.
|-
|| Click on '''cell C12''' >> type''' <nowiki>=C3/C6 </nowiki>'''>> press '''Enter'''.
|| Click on '''cell C12''' and type''' “is equal to C3 forward slash C6''' and press '''Enter'''.

The answer of the division is shown in '''cell C12'''.
|-
||

Press '''Ctrl + Z '''thrice
|| Let's undo the changes of '''division, multiplication '''and '''subtraction''' that we made.

To do so, press the '''Ctrl+Z''' key combination thrice.
|-
|| Only Narration
|| Another basic operation in a '''spreadsheet''' is to find the average of numbers.

Let us see how to do that.
|-
|| Type '''Average''' in '''B9'''
|| In '''cell B9, '''let's type the '''heading''' as '''Average'''.

Here we want to display the average of the total cost.
|-
|| Click on cell '''C9'''

Type '''<nowiki>=Average(C3:C7)</nowiki>'''

Press '''Enter'''
|| Next click on '''cell C9.'''

And type i'''s equal to Average''' '''and within braces C3 colon C7'''.

Press '''Enter'''.
|-
|| Point to the average of the '''Cost'''

Press '''CTRL + Z'''
|| We see that the average of the '''Cost''' column gets displayed in the '''cell'''.

Let's undo the changes by pressing '''Ctrl+Z '''keys.
|-
|| Only Narration
|| In the same way, we can find the '''average''' of elements in a horizontal row also.
|-
|| Only Narration
|| We will learn about other '''formulae''' and '''operators''' later in this series.

Now let’s learn how to sort '''data''' in a '''Calc''' '''spreadsheet'''.
|-
|| '''Slide: '''Sorting
||
* Sorting organises rows and columns in a '''spreadsheet''' in a meaningful order.
* Sorting helps us to analyse and visualize '''data''' more effectively.
* It makes it easier to find and retrieve an item from the entire '''sheet. '''
* We can sort '''data''' using upto three criteria, which are then applied one after another.

|-
|| '''Slide: '''Sorting
||
* Sorting can be applied to the entire '''sheet '''or a range of '''cells'''
* '''Data''' is typically sorted based on actual values. For eg: ascending, descending, alphabetic, left to right, oldest to newest, etc.

|-
|| Point to '''Costs'''

Select The cells '''C1''' to '''C7'''

Point to Selection '''C1''' to '''C7'''
|| We will sort the '''data''' under the '''heading Costs''' in ascending order.

Now holding down the left mouse button, select the '''cells C1''' to '''C7.'''

This selects the range of '''cells''' which we want to sort.
|-
|| Cursor on the '''Standard toolbar'''.

Point to the 3 '''sort''' icons
|| Go to the '''Standard toolbar'''.

Here we can see three different '''sorting '''icons.
|-
|| Click '''Sort''' '''Ascending '''icon
|| Click on the '''Sort Ascending '''icon.
|-
|| Point to '''Sort''' '''range''' dialog box

Click '''Current''' '''Selection'''
|| The '''Sort''' '''range''' dialog box appears.

Click on the '''Current selection '''button'''.'''
|-
|| Highlight the selected '''cells'''
|| Observe that the numbers in the selected '''cells''' are now arranged in ascending order.
|-
|| Click on '''Sort Descending '''icon
|| Click on the '''Sort Descending '''icon.
|-
|| Point to '''Sort''' '''range''' dialog box >> click '''Current''' '''Selection'''
|| In the '''Sort''' '''range''' dialog box, click on the '''Current selection '''button'''.'''
|-
|| Highlight the selected '''cells'''
|| Observe that the numbers in the selected '''cells''' are now arranged in descending order.
|-
|| Press '''CTRL + Z '''twice
|| Undo these changes by pressing '''Ctrl+Z '''keys twice.

The numbers are all back in their original '''cells'''.
|-
|| Click '''Sort''' icon
|| To have greater control of sorting '''data''', click on the '''Sort''' icon.
|-
|| Click on '''Data'''

Click on '''Sort'''
|| Alternatively, we can go to the '''menu''' '''bar''' and click on '''Data'''.

Then click on '''Sort''' from the sub-menu.
|-
|| Point to '''Sort''' '''range''' dialog box

Click >> '''Current''' '''Selection'''
|| In the '''Sort Range''' dialog box, once again click on the '''Current selection''' button'''.'''
|-
|| “'''Sort'''” dialog box >> Point to “'''Sort''' '''criteria'''” and “'''Options'''” tabs.
|| This time another '''Sort '''dialog box appears with two tabs named '''Sort''' '''criteria''' and '''Options'''.
|-
|| Point to '''Sort''' '''criteria''' tab
|| '''Sort criteria''' tab is selected by default.

Below, we can see three '''Sort keys'''.
|-
|| Select “'''Cost'''” in the '''Sort''' '''Key''' '''1''' field
|| Under the drop-down in '''Sort key 1,''' select '''Cost.'''
|-
|| Point on '''Ascending'''

Point to '''Descending'''

Click''' Ascending radio '''button
|| Then click on the '''Ascending''' option just next to it.

To sort in the descending order, click on the '''Descending '''option.

I will select the '''Ascending '''option.
|-
|| Click on '''OK'''
|| Now click on the '''OK''' button at the bottom right corner.
|-
|| Point to sorting which is done in ascending order.
|| We see that column '''Cost''' gets sorted in the ascending order.
|-
|| Press '''CTRL + Z'''
|| Let us undo these changes by pressing '''Ctrl+Z '''keys.
|-
|| Only Narration
|| Multiple columns can also be sorted in one go.

To do so, first select multiple columns, and then apply the '''sort''' options.

I’ll demonstrate this for you.
|-
||

Select data under '''SN''' ,'''Items''' and '''Costs''' together.
|| Let’s say, we want to sort '''Serial''' '''numbers, Items''' as well as '''Cost'''.

So first select all the 3 columns '''SN''', '''Items''' and '''Cost''' as shown here.
|-
|| Click on '''Data'''

Click on '''Sort'''
|| Now go to the '''menu''' '''bar''' and click on '''Data'''.

Then from the sub-menu, click on '''Sort'''.
|-
|| '''Sort''' dialog box
|| '''Sort '''dialog box opens up.
|-
|| '''Sort''' '''criteria''' tab >> In '''Sort''' '''Key''' '''1''' select '''Cost'''

In '''Sort''' '''Key''' '''2,''' select '''SN'''

In '''Sort''' '''Key''' '''3,''' select '''Items'''
|| Under '''Sort criteria''' tab, in '''Sort key 1 '''drop-down''',''' select '''Cost.'''

Then in '''Sort key 2''' drop-down, select '''SN.'''

And in '''Sort key 3''' drop-down, select '''Items.'''
|-
|| Click on '''Descending''' in both the options.
|| Click on '''Descending''' in the first two '''sort''' options.

Click on '''Ascending''' in the third '''sort''' option.
|-
|| Click on the '''OK''' button.
|| And then click on the '''OK''' button.
|-
|| Point to the sorted '''data'''.
|| Observe the changes.

We see that all the columns get sorted in the selected''' '''orders.
|-
|| Press '''CTRL + Z'''
|| Let us undo these changes.
|-
|| '''Slide''': Filter Data
|| Next let’s learn how to '''filter''' '''data''' in '''Calc'''.

* A '''filter''' is a list of conditions that each entry has to meet in order to be displayed.

|-
|| Click on the cell '''Items'''.
|| I will demonstrate this feature.

In order to apply a '''filter''', let's click on any '''cell''', for example the''' cell''' named '''Items'''.
|-
|| Click >> '''Auto''' '''Filter''' icon
|| Click on the '''Auto Filter''' icon in the '''Standard toolbar'''.
|-
|| Click on '''Data'''

Click on '''Auto Filter'''
|| Alternatively, you can go to the''' menu bar''' and click on '''Data'''.

Then click on '''Auto Filter''' from the sub-menu.
|-
|| Point '''arrow''' '''marks''' in the '''headings'''.

Click on the '''down''' '''arrow''' on the cell named '''Items'''.
|| We see that a drop-down arrow appears on the '''heading Items'''.

Click on this drop-down arrow.
|-
|| '''Filter''' popup.
|| '''Filter''' pop-up box opens up.
|-
|| Highlight '''Electricity Bill'''.

|| Now suppose we want to display only '''Electricity''' '''Bill data'''.
|-
|| Uncheck the '''Check''' box at the top

Check '''Electricity''' '''bill >> '''Click '''Ok'''
|| So first uncheck the option''' All'''.

Then check the option '''Electricity''' '''Bill''' and click on the '''Ok''' button.
|-
|| Point to '''Electricity''' '''Bill''' in the sheet.

|| Only the '''data''' related to the '''Electricity Bill''' is displayed in the '''sheet'''.

The rest of the items are filtered out.
|-
|| Click the down arrow on the cell heading which contains '''Items'''
|| In order to view all the data again, click on the dropdown arrow on the '''cell''' '''Items.'''
|-
|| Check the option '''All >> '''Click '''Ok'''
|| Check the option''' All'''.

Make sure all the headings are checked and then click on the '''Ok '''button.
|-
|| Show all the data in the spreadsheet.
|| We are now able to view all the '''data''' which we had in the '''sheet'''.
|-
|| Only narration
|| There are other '''filters''' in '''Calc''' which we will learn about in later tutorials of this series.
|-
|| '''Ctrl + S'''
|| Let’s save and close the file.
|-
|| Only narration
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| '''Slide:'''Summary
|| In this tutorial, we learnt to:
* Use a basic '''Formula '''in''' Calc'''
* Sort by columns and
* Filter '''data'''

|-
|| '''Slide''': Assignment
|| As an assignment:
* Open “'''spreadsheet-practice.ods'''” sheet.
* Sort the '''Salary''' column in '''Ascending''' order
* Filter the '''Name''' column and display '''Rahul’s''' data.
* Undo the changes.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
||
* Please post your timed queries in this forum.

|-
|| '''Slide''': Acknowledgement
| | Spoken Tutorial project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide''': Thank you
| | This is '''Arvind''' from''' IIT Bombay''' signing off. Thank you for watching.

|-
|}

LibreOffice-Suite-Calc-6.3/C2/Formatting-Data--in-Calc/English

2020-07-03T16:48:56Z

Arvindpillai90: Created page with "Title: Formatting Data Author: Arvind PillaiKeywords: LibreOffice,Calc,Ubuntu,Format cell borders in Calc,Format cells background colour in Calc,Automatic Wrapping in Calc,Me..."

Title: Formatting Data

Author: Arvind PillaiKeywords: LibreOffice,Calc,Ubuntu,Format cell borders in Calc,Format cells background colour in Calc,Automatic Wrapping in Calc,Merging cells in Calc,Shrinking cell text in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide''': Title
|| Welcome to the '''spoken tutorial''' on '''Formatting Data in Calc.'''
|-
|| '''Slide''': Learning objectives
|| In this tutorial, we will learn to:
* Format '''cell borders '''and '''cell background colors.'''
* Format multiple lines of text using '''Automatic''' '''Wrapping'''.
* Merge '''cells'''.
* Shrink the text to fit inside the '''cell'''.

|-
|| '''Slide''': System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS '''version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open “'''personal finance tracker.ods”''' file.
|| First let us learn about formatting '''cell borders''' in '''Calc'''.

Open our '''Personal-Finance-Tracker.ods''' file.
|-
|| Highlight to “'''SN'''”, “'''Item'''”, “'''Cost'''”, “'''Spent'''”,
“'''Received'''”, “'''Date'''”, “'''Account'''”
|| Formatting of '''borders''' can be done on a particular '''cell''' or a block of '''cells'''.

For example, let us format the '''cells.'''
|-
|| Select >> '''A2''' to '''G2'''

Go to''' Formatting '''toolbar

Select >> '''Borders''' icon
|| Select the cells, '''A2 '''to '''G2''' by holding the left mouse button.

Then go to the '''Formatting toolbar''' and select the '''Borders''' icon.
|-
|| Only Narration
|| If you have resized your '''LibreOffice''' window, some of the icons may not be visible.
|-
|| Click on Double arrow '''>>''' icon at the end of the '''toolbars'''

Click >> '''Borders''' icon
|| In that case, click on the '''double arrow''' icon at the end of the '''toolbars''' to see the hidden icons.

Click on the '''Borders''' icon.
|-
|| Point to '''border''' styles
|| A drop-down box opens up containing several '''border styles.'''
|-
||

Click on the '''last''' '''border''' '''style''' option.
|| Click on any one of the '''styles''' you wish to apply on the '''borders'''.

I will select the last option.
|-
|| Click on any random '''cell'''
|| Now click anywhere on the '''spreadsheet''' to deselect the '''cells.'''
|-
|| Point to the cells '''A1''' to '''G1'''
|| Notice that the '''cell''' '''borders''' are formatted according to the selected '''border style'''.
|-
|| CTRL + Z
|| Let us undo this change by pressing '''Ctrl+Z '''keys.
|-
||

Right-click >> '''Format''' '''Cells'''
|| We can also do the same thing using the '''Format cells''' dialog box.

Right-click on the selected '''cells''' and choose '''Format''' '''Cells''' option.

Or press '''Ctrl+1''' keys on the keyboard.
|-
|| Point to '''Format Cells'''

Click >> '''Borders''' tab.
|| Either way, the '''Format Cells '''dialog box opens up.

Now go to the '''Borders''' tab.
|-
|| Point to '''Line''' '''arrangement''', '''Line,''' '''Padding'''
and '''Shadow''' '''style'''.
|| We see the options for '''Line arrangement''', '''Line''', '''Padding''' and '''Shadow style'''.

One can change any of these as per our preference.
|-
|| Point to '''User-defined''' >> Point to the '''preview''' window.

Click on the third option under '''Presets'''

Point to the '''preview''' window.
|| In the '''Line Arrangement '''section, we can see a small '''preview''' window named: '''User-defined'''.

Under '''Presets''', I will click on the third option.

You can see that it gets reflected in the '''preview''' window.
|-
|| Point to '''Style, Width '''and''' Colo'''r section

Click '''Style''' and select '''dotted lines '''option

Set the '''Width''' as '''2'''.'''00pt >> '''Set the '''color''' as '''red'''
|| I will also change the '''Style''', '''Width''' and '''Color''' from the '''Line''' section, as shown.

From the '''style''' drop-down, I will select the '''dotted''' lines.

I will set the '''width''' as''' 2.00 pt. '''and select the '''color''' as '''Red.'''
|-
|| Point to Preview window
|| Observe the changes in the '''preview''' window.
|-
|| Point to '''Padding''' section
|| Next, go to the '''Padding''' section.

Observe that all the values are the same.
|-
|| Click '''-''' or '''+''' buttons to change values.

Point to '''Synchronize''' option

|| If we try to change the padding value of any one of the sides, all of them get changed.

This is because the '''Synchronize''' option is checked.

If we wish to set different values for each side.

Then the '''Synchronize''' option needs to be unchecked.
|-
|| Uncheck >> '''Synchronize '''option

Under '''Padding''', set '''Top''' and '''bottom''' margins to '''1.5 mm'''

Under '''Padding''', set '''right''' and '''left''' margins to '''1 mm'''
|| Let’s uncheck the '''Synchronize''' option.

I will set the '''padding''' value for '''Top''' and '''Bottom''' margins to '''1.5 mm'''.

And the '''Left''' and '''Right''' margins to '''1 mm.'''
|-
|| Point to '''shadow styles'''
|| You can explore the various '''Shadow styles''' on your own later.
|-
|| Click on '''OK'''.

Click on any random '''cell'''
|| Click on the '''OK''' button at the bottom.

Now click anywhere on the '''spreadsheet''' to deselect the '''cells.'''
|-
|| Point to the '''Headings'''
|| Notice that our chosen '''border''' '''style''' is now applied to all the selected '''cells'''.
|-
|| Point to '''Headings'''

Narration Only
|| In our earlier tutorial, we had set one of the default '''styles''' to the '''headings'''.

Now let us set some other colors to the '''headings''', using the '''Background Color '''option.
|-
|| Select '''A1''' to '''G1'''

Go to the '''Formatting '''toolbar

Select drop-down next to '''Background Color '''icon
|| Now select the '''cells A1''' to '''G1''' by holding the left mouse button.

Then go to the '''Formatting toolbar''' and select the drop-down next to the '''Background Color''' icon.
|-
|| Point to '''Background Color '''popup

Click >> '''Orange'''
|| The '''Background Color '''popup menu opens up.

Select the color you wish to apply as a background to the '''cells'''.

I will click on the color '''Orange'''.
|-
|| Point to '''Headings'''
|| Observe the change.

Now the '''background color''' for the '''headings''' is set to '''Orange'''.
|-
|| '''Slide''': Automatic Wrapping
|| '''Calc''' provides various options for formatting multiple lines of text.

One of them is '''Automatic''' '''Wrapping'''.

It allows a '''user''' to type multiple lines of text into a single '''cell'''. Let us try this.
|-
|| RightClick >> Cell '''B9'''

Select >> '''Format''' '''Cells'''
|| Right-click on '''cell B9''' and select '''Format Cells''' option.

Then go to the '''Alignment''' tab.
|-
|| Check on '''Wrap''' '''text''' '''automatically'''

click on '''OK'''
|| Under the '''Properties''' section, check the '''Wrap text automatically''' option.

Then click on the '''OK''' button at the bottom.
|-
|| In Cell '''B9''' Type >> “This is a personal Finance Tracker. It is very useful”

Press '''Enter'''
|| Now type the following text in '''cell B9.'''

“'''This is a personal Finance Tracker. It is very useful'''”.

And press '''Enter.'''
|-
|| Point to cell '''B9'''
|| We see that the multiple statements get '''wrapped''' into the same '''cell'''.
|-
|| '''Ctrl + Z'''
|| Undo these changes by pressing '''Ctrl+Z '''keys.
|-
|| Only Narration
|| Next we will learn how to merge '''cells''' in '''Calc'''.
|-
|| Click on '''1''' under the heading '''SN'''.

Click and hold '''Shift''' key >> click '''Salary'''

Point to highlighted '''Cells'''
|| First click on the '''cell''' with value '''1''' under the '''heading SN.'''

Now hold down the '''Shift''' key on the keyboard and click on the '''cell''' which has the word '''Salary'''.

The selected '''cells''' get highlighted.
|-
|| Click on the '''Merge and centre cells '''icon
|| Click on the '''Merge and centre cells '''icon in the '''Formatting bar'''.
|-
|| Point to '''Merge Cells''' dialog box
|| '''Merge Cells''' dialog box opens up.
|-
|| Point to '''Merge''' '''cells''' options
|| Here three options for merging the '''cells''' are displayed along with a preview.

We can select any one as per our preference.
|-
||

Select the '''Move the content of hidden hidden cells into the first cell''' radio button.

Click '''Ok'''
|| I want to move the contents of both the '''cells''' into a single '''cell'''.

So, I will select the '''Move the content of hidden hidden cells
into the first cell''' radio button.

Then click on the '''OK''' button at the bottom of the dialog box.
|-
|| Point to cell '''A2'''
|| Observe that the selected '''cells''' and their values are merged together.
|-
|| Go to '''Format''' menu >> '''Merge''' '''Cells''' >> '''Merge''' '''Cells'''
|| Alternatively, we can merge '''cells''' by clicking on the '''Format''' '''menu''' in the '''menu bar'''.

From the sub-menu, go to '''Merge''' '''Cells''' and select any one preferred option'''.'''

Explore these on your own later.
|-
|| Press '''Ctrl + Z'''
|| Undo these changes by pressing '''Ctrl+Z '''keys.
|-
|| Only Narration:
|| Next we will learn how to shrink text to fit into a '''cell'''.

The font size of the data in a '''cell''' can be automatically adjusted to fit the data into the '''cell'''.

Let us learn how to do it.
|-
|| In Cell '''B10''' Type >> “This is for the month of June”

Press '''Enter'''
|| First type the following text in '''cell B10 - '''“'''This is for the month of June'''”.

Then press '''Enter.'''
|-
|| Right click >> '''B10'''

Select >> '''Format''' '''Cells'''
|| In order to shrink the text so that it fits, right-click on '''cell B10'''.

Then select the option '''Format Cells.'''
|-
|| Point to '''Format cells '''dialog''' '''box
|| '''Format cells''' dialog box opens up.
|-
|| Go to the '''Alignment''' tab.

Click on '''Shrink to fit cell size''' check box

Click on '''OK'''.
|| Go to the '''Alignment''' tab.

Under the '''Properties''' section, click on the '''Shrink to fit cell size''' check-box.

Then click on the '''OK''' button at the bottom of the dialog box.
|-
|| Point to Cell >> '''B10'''

|| Observe that, the entire text inside the '''cell '''shrinks and fits within the '''cell'''.

It adjusts itself by decreasing its font size so that the text fits into the '''cell'''.
|-
|| '''CTRL''' + '''Z'''
|| Undo the changes by pressing '''Ctrl+Z '''keys together.
|-
|| '''Ctrl + S '''and''' click on x button at top right corner'''
|| Then save and close the file.
|-
|| Narration:
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt to:
* Format '''cell borders''' and '''cell background colors.'''
* Format multiple lines of text using '''Automatic''' '''Wrapping'''.
* Merge '''cells'''.
* Shrink the text to fit inside the '''cell'''.

|-
|| '''Slide''': Assignment
|| As an assignment:
* Open “'''spreadsheet-practice.ods'''” sheet.
* Select all the '''headings'''.
* Give Grey '''background''' '''color''' to the '''headings'''.
* Using “'''Automatic Wrapping'''” type the text in '''cell A10''' - “'''This is a Department Spreadsheet”.'''
* Shrink this text to fit inside '''cell A11'''.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the Spoken Tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
|| '''Slide''': Forums
||
* Please post your timed queries in this forum.

|-
|| '''Slide''': Acknowledgement
| | Spoken Tutorial projects are funded by '''MHRD''', Govt. of India.
|-
|| '''Slide''': Thank you
| | This is '''Arvind''' from''' IIT Bombay''' signing off. Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Sheets-in-Calc/English

2020-07-03T13:11:22Z

Arvindpillai90: Created page with "Title: Working with Sheets Author: Arvind Pillai Keywords: LibreOffice Calc, Sheets, Insert rows in Calc, Delete rows in Calc, Insert columns in Calc, Delete columns in Calc..."

Title: Working with Sheets

Author: Arvind Pillai

Keywords: LibreOffice Calc, Sheets, Insert rows in Calc, Delete rows in Calc, Insert columns in Calc, Delete columns in Calc, Insert sheets in Calc, Delete sheets in Calc, Rename sheets in Calc, Move sheets.

{| border="1"
|-
|| '''VISUAL CUE'''
|| '''NARRATION'''
|-
|| '''Slide:'''Title
|| Welcome to the''' spoken tutorial''' on '''Working''' '''with''' '''Sheets'''.
|-
|| '''Slide''': Learning objectives
|| In this tutorial, we will learn to:
* Insert and Delete
** '''Rows'''
** '''Columns'''
** '''Sheets'''
* Rename '''Sheets'''
* Move '''Sheets'''

|-
|| '''Slide: '''System Requirements

|| This tutorial is recorded using
* '''Ubuntu Linux OS '''version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open''' Personal-Finance-Tracker.ods'''
|| Let us open our '''Personal-Finance-Tracker.ods''' file that we saved in the earlier tutorial.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Pls download and extract the file.
* Make a copy and then use it for practising.

|-
|| Highlight a '''column''' and a '''row'''.
|| Columns and rows can be inserted individually or in bulk.
|-
|| Only Narration
|| First we will learn how to insert a new '''row''' or a new '''column''' in the '''spreadsheet'''.
|-
|| Click on''' C1'''

Point to “'''Cost'''”
|| In our '''Personal-Finance-Tracker.ods''' file, let's click on the '''cell C1.'''

This '''cell''' has “'''Cost'''” written in it.
|-
|| Click on '''Row''' icon in the '''Standard toolbar'''
|| Now click on the '''Row''' icon in the '''Standard toolbar.'''

Many options related to rows are displayed in the '''context menu.'''
|-
|| Highlight '''Insert Rows Above''' and '''Insert Rows Below.'''

Click on '''Insert''' '''Rows Above'''
|| Notice 2 specific options '''Insert Rows Above''' and '''Insert Rows Below.'''

I will click on the option '''Insert Rows Above'''.
|-
|| Point to the new row added
|| A new row gets inserted just above the '''cell C1'''.
|-
|| Click on '''Row''' icon in the '''Standard toolbar'''
|| Now click on the '''Column''' icon in the '''Standard toolbar.'''

Many options related to columns are displayed in the context menu.
|-
|| Highlight '''Insert Rows Before''' and '''Insert Rows After.'''

Click on '''Insert''' '''Rows Before'''
|| Notice 2 specific options '''Insert Columns before''' and '''Insert Columns after.'''

I will click on the option '''Insert Columns Before.'''
|-
|| Point to the new column added
|| A new column gets inserted to the left of the '''cell C1'''.
|-
|| Press '''CTRL''' + '''Z''' twice
|| Let’s undo these changes.
|-
|| Click on '''Sheet >> '''mouse over on '''Insert Rows '''and
'''Insert Columns''' to show their context menu
|| Rows and columns can be inserted by clicking on '''Sheet''' '''menu''' in the '''menu bar''', as well.
|-
|| Point to '''Cell''' '''Reference→''' '''Numbers''' and '''Alphabets'''
|| Another quick way to insert a new row or column is by right-clicking on any '''cell'''.
|-
|| Right-click on '''cell C1'''→click on '''Insert'''
|| Right-click on '''cell C1 '''and''' '''from''' context menu, '''click on '''Insert '''option.
|-
|| '''Insert Cells '''dialog box

Highlight '''Entire row '''& '''Entire column '''and '''Ok '''button
|| The '''Insert Cells '''dialog box opens.

Here choose as per your requirement and click on the '''Ok''' button.
|-
||

Click on '''Cancel'''
|| Explore these options on your own for your understanding.

I will skip this and click the '''Cancel '''button to close the dialog box.
|-
|| Only narration
|| Next, we’ll learn to insert multiple '''rows''' and '''columns''' at the same time.
|-
|| Point to '''SN''' i.e '''A1'''
|| Let’s say we want to insert 4 '''columns''' before '''SN''' which is '''cell A1'''.
|-
|| Holding the left mouse key click and drag''' '''from '''cells A1''' to''' D1'''

Point to '''Cells A1 to D1'''
|| So select the '''cells A1''' to '''D1''' by clicking and dragging the left mouse button.

All the '''4 cells''' get selected.
|-
|| Click on '''cell B1'''→''' Insert'''

'''Insert Cells''' dialog box >> click '''Entire''' '''Column'''
|| Right-click anywhere on the selection and select '''Insert'''.

In the '''Insert Cells''' dialog box, click on the option '''Entire Column'''.
|-
|| Click''' Ok'''
|| Then click on the '''OK''' button at the bottom.
|-
|| Point to new '''Columns''' inserted
|| Notice that 4 new columns get added before '''SN.'''
|-
|| Click cell '''D6 '''
|| Now click any random cell to deselect.
|-
|| Only Narration
|| In a similar manner, we can add multiple '''rows''' as well.

Explore this on your own.
|-
|| Only Narration
|| Next we will learn about how to delete '''Columns''' individually and in groups.
|-
|| Click on column '''D'''
|| Select any one column by clicking on the alphabet of the column above, as shown.
|-
|| Click '''Column''' icon in the '''Standard toolbar '''>> click '''Delete Columns'''.
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

The selected column gets deleted.
|-
||
|| Suppose we want to delete more than one column at a time.
|-
|| Point to the 3 columns
|| In my case, I want to delete these 3 '''columns''' which we inserted just now.
|-
|| Select columns '''A '''to '''C'''
|| So, select the 3 columns by clicking on the alphabet of the column above, as shown.
|-
|| Point to the '''3''' '''Columns'''
|| All the 3 columns get selected.
|-
|| Click the Column icon in the '''Standard toolbar '''>> click '''Delete Columns'''.
|| Now click on the '''Column''' icon in the '''Standard toolbar '''and then on '''Delete Columns '''option.

The selected columns get deleted.
|-
|| Point to new '''Columns''' inserted
|| Observe that the 3 new columns before '''SN''' gets deleted.
|-
|| Only Narration
|| In a similar manner, we can delete multiple '''rows''' as well.

Explore this on your own.
|-
|| Narration:

|| We will now learn about how to insert and delete '''sheets''' in '''Calc'''.

There are several ways to insert a new '''sheet''' in '''Calc'''.

We will learn about each one of them one-by-one.
|-
|| Point to '''Sheet 1 '''at the bottom left
|| At the bottom left, we see a tab named '''Sheet 1'''.
|-
|| Highlight all the icons located before that.
|| There are some icons located before that.
|-
|| Point to '''+ icon''' before''' Sheet 1''' >> then click on it
|| When we click on the '''Plus''' icon, a new '''sheet '''named '''Sheet2''' gets added.
|-
|| Point to''' Sheet 2'''
|| This new '''sheet''' gets added to the right of the current one.
|-
|| Point to the empty space besides '''Sheet''' '''2'''
|| We can also add '''sheets''' by clicking on the empty area next to the '''sheet '''tabs.
|-
|| '''Insert''' '''Sheet''' dialog box

Point to '''Position''' options

Point to '''Sheet >> No. of sheets''' option
|| By doing so, the '''Insert Sheet''' dialog box opens up.

Using this dialog box, we can add a sheet before or after the current sheet.

We can also add any no. of '''sheets''' at a time.
|-
|| Select '''Position''' '''>>''' '''Before''' '''Current''' '''Sheet'''

'''Sheet''' >> '''No. of sheets >> 2'''
|| Under '''Position''', I will select '''Before the current sheet.'''

And in '''No. of sheets''', I will specify '''2'''.
|-
|| Click on '''Ok''' button
|| And then click on the '''OK''' button at the bottom.
|-
|| Highlight the sheet tab
|| Notice that '''Sheet 3 '''and '''Sheet 4 '''get added before '''Sheet 2'''.
|-
|| Click on '''Sheet''' >>Click on '''Insert''' '''Sheet'''
|| Another way to insert '''sheets''' is to click on the '''Sheet menu''' in the '''menu bar'''.

Then click on '''Insert Sheet'''.
|-
|| '''Insert''' '''Sheet''' dialog box

Click on '''Cancel''' button
|| On doing so, the '''Insert Sheet''' dialog box opens up.

I will skip this and click on the '''Cancel''' button at the bottom.
|-
|| Narration:
|| Next let us learn how to delete '''sheets'''.

'''Sheets''' can be deleted individually or in groups.
|-
|| Right click on '''Sheet''' '''4''' tab

Select '''Delete''' '''Sheet'''
|| To delete a single '''sheet''', right-click on the tab of the '''sheet''' you wish to delete.

And then from the '''context menu''', select the '''Delete''' '''Sheet''' option.
|-
|| Point to '''confirmation''' dialog box

Click '''Yes'''
|| A '''confirmation''' dialog box pops up.

Click on the '''Yes''' button.
|-
|| Point to '''Sheets '''tab
|| The selected '''sheet '''gets deleted.
|-
||
|| How can we delete multiple '''sheets''' at a time?
|-
|| Point to '''Sheet''' '''2''' and '''Sheet 3'''
|| For example, say we want to delete '''Sheet 2''' and '''Sheet 3'''.
|-
|| Click on '''Sheet''' '''2''' tab
|| First click on the '''Sheet 2''' tab.
|-
|| Hold '''Shift''' key >> click on '''Sheet''' '''3''' tab.
|| Then holding the '''Shift''' key on the keyboard, click on '''Sheet 3 '''tab.
|-
|| Right click >> '''Delete Sheet'''
|| Now right-click on any one of the tabs and click on the '''Delete Sheet''' option.
|-
|| '''Confirmation''' dialog box
|| A '''confirmation''' dialog box pops up.
|-
|| Click '''Yes''' button
|| Click on the '''Yes''' button to delete the '''sheet'''.

Both the '''sheets''' get deleted.
|-
|| Press '''CTRL + Z''' keys once
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| Point to '''Sheet 1, Sheet 2, Sheet 3'''.
|| '''Sheets '''are named by default as '''Sheet 1, Sheet 2, Sheet 3''' and likewise.

'''Calc''' has a provision to rename the '''sheets''' based on our needs.
|-
|| Point to the '''Sheet 2''' tab below.

Double click on '''Sheet 3''' tab.
|| For example, let’s rename '''Sheet 2''' as “'''Dump'''”.

Do this by simply double-clicking on '''Sheet 2''' tab.
|-
|| '''Rename Sheet''' dialog box
|| '''Rename''' '''Sheet''' dialog box opens up.
|-
|| Point to the text box '''Sheet 2'''
|| There is a textbox with '''Sheet''' '''2''' written in it.
|-
|| Delete '''Sheet 2''' written in the text box and write “'''Dump'''”.
|| Delete this and type “'''Dump'''” as the new name.
|-
|| Click on '''OK'''
|| Click on the '''OK''' button.
|-
|| Point to the '''Sheet 2''' tab below.
|| '''Sheet 2''' tab has now been renamed to “'''Dump'''”.
|-
|| Press '''CTRL + Z''' keys once
|| Let us undo these changes by pressing '''Ctrl + Z '''keys.
|-
|| Click '''Sheet 2 '''and bring it to second position on '''Sheets''' tab
|| We can manually rearrange the sheets by clicking on a '''sheet'''

And dragging it to the desired location.
|-
|| Press '''Ctrl+S''' keys

Press X
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| Narration:
|| This brings us to the end of this tutorial. Let us summarize.
|-
|| '''Slide''': Summary
|| In this tutorial, we learnt to :* Insert and Delete
** '''Rows'''
** '''Columns'''
** '''Sheets'''
* Rename '''Sheets'''
* Move '''Sheets'''

|-
|| '''Slide: '''Assignment
|| As an assignment
* Open '''Spreadsheet'''-'''Practice'''.'''ods'''.
* Select and delete the column with the heading '''Serial''' '''Number'''.
* Enter relevant data in '''Name''', '''Department''' and '''Salary''' columns
* Refer to the Code file link for details.
* Rename the '''sheet''' as '''Department'''-'''Sheet'''.
* Save and close the file.

|-
|| '''Slide''': About Spoken Tutorial Project
||
* The video at the following link summarizes the spoken tutorial project.
* Please download and watch it.

|-
|| '''Slide''': Spoken Tutorial Workshops
||
* The Spoken Tutorial Project Team conducts workshops and gives certificates.
* For more details, please write to us.

|-
| | '''Slide: '''Forum
| | Please post your timed queries in this forum.
|-
| | '''Slide: '''Acknowledgement
| | '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide: Thank you'''

'''Acknowledgement to DesiCrew'''
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from''' IIT Bombay''' signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Working-with-Cells-in-Calc/English

2020-07-03T11:06:21Z

Arvindpillai90: Created page with "Title: Working with cells Author: Arvind Pillai Novice reviewer: Nikita Misal Domain reviewer: Praveen S Keywords: LibreOffice Calc, Enter numbers in Calc spreadsheet, Ent..."

Title: Working with cells

Author: Arvind Pillai

Novice reviewer: Nikita Misal

Domain reviewer: Praveen S

Keywords: LibreOffice Calc, Enter numbers in Calc spreadsheet, Enter text in Calc spreadsheet, Enter date in Calc spreadsheet, Enter time in Calc spreadsheet, Use Format Cells option in Calc

{| border="1"
|-
|| '''VISUAL CUE'''
| align=center| '''NARRATION'''
|-
|| '''Slide: '''Title
|| Welcome to the '''spoken tutorial '''on''' Working with Cells.'''
|-
|| '''Slide: '''Learning objectives:
|| In this tutorial, we will learn to:
* Enter '''numbers, text, date '''and''' time''' in a '''spreadsheet'''
* Use the '''Format Cells''' dialog box
* Navigate between '''cells '''and
* Select items in '''rows''' and '''columns'''

|-
|| '''Slide: '''System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux OS''' version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| Open '''Personal-Finance-Tracker.ods''' file.
|| First we will learn how to enter '''data''' in the '''cells'''.

Let’s open our '''Personal-Finance-Tracker.ods''' file.
|-
|| '''Slide: Code files'''
||
* This file has been provided to you in the''' Code files''' link on this tutorial page.
* Pls download and extract the file.
* Make a copy and then use it for practising.

|-
|| Click on the '''cell''' C7 >> type the text '''sample''' >> Press '''Enter'''.
|| Now type some text in any empty '''cell''' by clicking on the '''cell''' and typing using the keyboard.

Press '''Enter'''.
|-
|| Point to the cell C7

Point to the '''Alignment''' icons on the '''Formatting''' '''Bar'''.
|| The text is left-aligned, by default.

One can change the alignment by clicking any one of the '''Alignment''' icons on the '''Formatting''' '''Bar'''.
|-
|| Press '''Ctrl+Z''' keys
|| Let's undo what we typed.

Press '''Ctrl+Z''' keys on the keyboard to undo.
|-
|| Scroll the cursor across the headings.
|| In this '''spreadsheet''', we had already typed the '''column''' headings earlier.
|-
||

Click on cell '''A1 '''>>drag the mouse till cell '''G1 >> '''

release the left mouse button

|| In '''Calc''', we can differentiate the headings from other '''data''' by adding a '''style''' to it.

To do that, click on cell '''A1'''.

Then hold the left mouse button and drag the cursor upto cell '''G1.'''

Now release the left mouse button.
|-
|| Highlight this
|| We can see that all the headings got highlighted.
|-
|| Click on '''Styles''' menu >> select '''Accent 2'''

Click on cell '''C4'''
|| Now click on '''Styles''' menu in the '''menu''' '''bar.'''

We can see various '''heading styles'''.

I will select '''Accent 2'''.

Now click randomly on any '''cell''' to unselect the headings.
|-
|| Highlight this
|| Notice that the headings are now highlighted with a grey colour background.
|-
|| Under the '''Items''', type '''Salary''', '''House''' '''rent''',
'''Electricity''' '''bill''', '''Phone''' '''bill''', '''Laundry''' and '''Miscellaneous'''.
|| In the '''Items '''column, we’ll type the names of a few items one below the other.

Type the text as shown here.
|-
|| Click on the '''C7''' cell and type '''123''' >> Press '''Enter'''.
|| In order to enter numbers in the '''cell''', click on the '''cell''' and type the number.

Then press '''Enter'''.
|-
|| Text on screen: Press the '''Enter''' key after every''' data-entry'''.
|| Remember to always press the '''Enter''' key after every''' data-entry'''.
|-
|| Click on '''D7''' cell and type '''-123''' >> Press '''Enter'''.

Click on '''E7''' cell and type '''(123)''' >> Press '''Enter'''.
|| To enter a negative number, either type a '''minus''' '''sign''' before it or enclose it within '''parentheses'''.
|-
|| Point to the two cells one after the other.
|| By default, numbers are right-aligned and negative numbers have a leading '''minus''' '''symbol'''.
|-
|| Select all the '''cells''' to be deleted by holding the '''Shift''' key and clicking each '''cell'''.

Click on the '''Delete '''button.
|| Let us delete these entries.

Select all the '''cells''' to be deleted by holding the '''Shift''' key and clicking each '''cell'''.

Now press the '''Delete '''key on the keyboard.
|-
|| Point to the cell '''A1'''
|| In the '''SN '''column, we want the serial number of each item one below the other.
|-
|| Under '''SN''' type '''1''', '''2''', '''3''' in the cells '''A2''' to '''A4''' one below the other. And press '''Enter'''
|| So click on '''cell A2''' and enter numbers as '''1, 2, 3''' one below the other.

Remember to press '''Enter '''key after typing each number.
|-
|| Click on the '''cell A4'''

|| In order to auto-fill the serial numbers in the subsequent '''cells''', click on the '''cell A4'''.
|-
|| Click on the little '''black box''' at the bottom-right corner of the cell

Drag it till '''cell A7''' and release the mouse button.
|| Click on a little''' black box''' that is visible at the bottom-right corner of the '''cell'''.

Drag it till '''cell A7''' and release the mouse button.
|-
|| Highlight '''A5''', '''A6''' and '''A7'''
|| We see that '''cells A5, A6''' and '''A7''' get auto-populated with the subsequent serial numbers.
|-
|| Point to '''Cost''' column.
|| We will now enter the cost of each item under the heading '''Cost'''.
|-
|| Click on '''C3'''-> type '''Rs.6000'''.'''00'''
|| Click on the '''cell C3''' and type the expense for '''House''' '''rent''' as '''Rupees''' '''6000.00'''
|-
|| Only Narration
|| Now, what if we want the number with the '''Rupee''' symbol?
|-
|| Press '''Ctrl + Z''' keys
|| Clear the value typed in '''cell C3 '''by pressing '''Ctrl '''and '''Z '''keys together.
|-
|| Right-click on '''C3'''-> click on '''Format''' '''Cells'''

|| Right-click on the '''cell C3 '''and from the '''context menu''', select the '''Format''' '''Cells''' option.

This will open the '''Format''' '''Cells''' dialog box.
|-
|| Point to the '''Format''' '''Cells''' dialog box >> '''Numbers '''tab.
|| The first tab is '''Numbers'''. Click on it if not already selected.
|-
|| Point to '''Category'''

Then to '''Number''', '''Percent''', '''Currency''', '''Date''', '''Time'''.

Click on '''Currency'''.
|| Here we can see various options under '''Category'''.

'''Number''', '''Percent''', '''Currency''', '''Date''', '''Time''' and many more.

We will select '''Currency'''.
|-
|| Point to '''INR ₹ English (India) '''under '''Format''' section

Point to the '''drop down arrow'''.
|| Various '''currency''' '''symbols''' from across the world are displayed in the '''Format '''list.

By default, '''INR Rupee English (India)''' is selected in the '''Format''' drop-down.

If not, click on the drop-down and select it from the displayed list.
|-
|| Point to the Format options section

Point to '''-Rs. 1,234'''.'''00'''
|| Below the '''Format''' drop-down, we can see some sample values based on our selection.

We see '''minus Rupee 1234 decimal zero zero''' is selected for '''INR Rupees English India'''.
|-
|| Point to the Preview area (the small white rectangle) on the right.
|| We can see the selected '''format''' in the small preview area on the right.
|-
|| Point to '''Options''' below the category section.
|| Below the '''Category''' section, we have another section named as '''Options'''.
|-
|| Point to '''+ or - buttons '''of '''Decimal''' '''places''' and '''Leading zeroes'''.
|| Using this, we can increase or decrease the number of '''Decimal places''' and '''Leading zeroes'''.
|-
|| Click→ '''+ or - buttons '''of '''Decimal''' '''places''' and '''Leading zeroes'''.

Change it to default values
|| When we do so, we can see the changes in the sample value and in the preview area.

We will retain the default values.
|-
|| Click on '''Thousands''' '''separator'''.

Point to the Preview area.
|| To add a comma between the values, check the '''Thousands separator''' checkbox.

Once again, notice the change in the preview area.
|-
|| Click on '''Font'''.

Point to '''Family''', '''Style''' and '''Size'''.
|| One can also change the '''font style''' by clicking on the '''Font''' tab.

It has various options for '''Font''' '''Family''', '''Style''' and '''Size'''.
|-
|| Slide cursor across '''Font''' '''Effects''' and the other tabs.

Point to '''Alignment''' tab.
|| Explore '''Font Effects''' and other tabs to learn more about them on your own.

We will learn about the options in the '''Alignment''' tab in a later tutorial.
|-
|| Click on the '''OK''' button
|| Let’s click on the '''OK''' button at the bottom right corner.
|-
|| Type '''6000''' in cell '''C3'''.

Point to '''₹6000.00'''.
|| Now type '''6000''' in '''cell C3 '''and press '''Enter'''.

Notice that the number '''6000''' is represented as '''Rupees 6000 '''with '''2 decima'''l places.
|-
|| Select cells '''C4''' to '''C7''' with cursor.

Press '''CTRL''' key and select cell '''G2'''.

Point towards selection
|| Now, let's select '''cells C4''' to '''C7''' by holding the '''Shift''' key and clicking the '''cells'''.

Hold the '''CTRL''' key and select '''cell G2''' also.

Notice all the selected '''cells''' are highlighted.
|-
|| Right-click on cell '''G2→''' click on '''Format''' '''Cells'''

Choose the same options as before

Click on '''OK'''.
|| Right-click on any of the highlighted '''cells''' and select '''Format''' '''Cells.'''

Choose the same options as before.

Click on the '''OK''' button at the bottom right corner.
|-
|| Click→ Random Cell
|| Click any '''cell''' in the '''spreadsheet''' to deselect the '''cells'''.
|-
|| Click on '''C4'''-> type '''800''' ['''Enter]'''

Click on '''C5'''-> type '''600''' ['''Enter]'''

Click on '''C5'''-> type '''300''' ['''Enter]'''

Click on '''C7'''-> type '''2000''' ['''Enter]'''
|| Next, we type the amount for all the items one below the other, as shown here.

|-
|| Click on '''G2'''-> type '''30000''' ['''Enter]'''
|| Under the heading '''Account,''' we’ll type the salary for the month as '''30,000'''.
|-
||

Click on cell '''F2'''.
|| Let’s move on to the '''Date '''column.

Click on the '''cell F2'''.
|-
|| Under '''Date''' type '''05/06/20''' in the cell '''F2''' ['''Enter]'''
|| For entering date in '''Calc''', select the '''cell''' and type the '''date, '''as shown.

Here I have used a '''forward''' '''slash '''between the date elements.
|-
|| '''Cell F3''' >> type '''05-06-20''' in the cell '''F3''' ['''Enter]'''
|| We can also separate the date elements with a '''hyphen'''.

|-
|| '''Cell F4''' >> type '''05 June 2020''' in the cell '''F4''' ['''Enter]'''
|| Or use text such as '''05 June 2020'''.

'''Calc''' recognizes a variety of date formats.
|-
||

Right-click '''F2''' >> Select '''Format''' '''Cells''' Option
|| We can also customize the date formats according to our requirement.

To do so, right-click on the '''cell''' and select '''Format Cells''' option.
|-
|| Click '''Numbers '''tab >> Under '''Category''' select '''Date'''
|| Click on the '''Numbers''' tab.

Under the '''Category''' section, select '''Date.'''
|-
|| Click on '''31/12/1999''' under Format.
|| Under the''' Format''' section, select the date format based on your requirement.

I will choose '''31/12/1999. '''
|-
|| Point to the Preview area (the small white rectangle) on the right.
|| Notice the display in the preview area.
|-
|| Point '''Format''' '''code''' below.
|| Based on our selection, the '''Format code''' will also get updated.

In my case it is '''DD, MM and YYYY.'''
|-
|| Click on '''OK'''
|| Once we have updated the format, click on the '''OK''' button at the bottom right.
|-
||

Click on a cell '''F8'''

Type '''10:43:20''' and press '''Enter'''.
|| Next, let us try some time options.

Click on any random '''cell'''.

Type the '''time '''as shown.

I have separated the time elements with '''colons'''.
|-
|| Right-click on cell '''F8'''→ Click on '''Format''' '''Cells'''.

Click→ '''Numbers''' '''tab'''
|| To further customize the time format, right-click on the respective cell and select '''Format Cells'''.

Click on '''Numbers''' tab''' '''at the top
|-
|| Click on the option '''Time''' under '''Category'''

Click on '''13:37:46''' under '''Format'''
|| Under '''Category, '''choose '''Time''' and the desired format under '''Format'''.

I will choose '''13:37:46'''.
|-
|| Point to the Preview area

Point to '''Format''' '''code'''
|| Notice the display in the preview area.

Also, the '''Format code''' is displayed below as '''HH:MM:SS'''
|-
|| Point to the Preview area >> '''Format code '''>> edit >>click on '''OK'''.
|| One can change the '''Format code''' directly as well.

Click on '''OK '''button at the bottom right.
|-
|| Select cells and press '''Delete'''
|| Let us delete all the time entries from our '''spreadsheet'''.
|-
|| Click on one '''cell''' and then the next '''cell''' on the same row.
|| We will now learn how to navigate within a '''spreadsheet''' from '''cell''' to '''cell.'''
|-
|| Click on cell '''A3'''.
|| We can access a particular '''cell''' by simply clicking on it with the '''cursor'''.

This changes the focus to the '''new''' '''cell'''.

This method is most useful when the two '''cells''' are far apart.
|-
||

Click on the down arrow to the right of the '''Name''' '''Box'''.

Delete→ Existing '''Cell Reference'''

Type '''B4''' in the cell reference and press '''Enter'''.

Point to '''B4'''
|| Another method of accessing a particular '''cell''' is by using the '''cell''' reference.

Click on the '''Name''' '''Box''' at the top left corner, which is located below the '''Font Name.'''

Erase the existing '''cell''' '''reference '''and type the '''cell''' '''reference''' of the '''cell''' you want to go.

I will type '''B4''' and press '''Enter'''.

Observe that '''cell B4''' gets highlighted.
|-
||

Press '''Tab'''. Press '''Shift''' + '''Tab'''.

Press '''Enter'''. Press '''Shift''' + '''Enter'''.
|| We can also navigate between '''cells''' using the keyboard.

Press the '''Tab''' key to go to the next '''cell''' in a row.

'''Shift''' '''+''' '''Tab''' to go to the previous '''cell''' in a row.

'''Enter''' to go to the next '''cell''' in a column.

'''Shift''' + '''Enter''' to go to the previous '''cell''' in a column.
|-
||

Click on '''A4''' >> press and hold down the left mouse button.

Move the mouse till '''B10'''. Release left mouse button.
|| Next, we’ll learn how to select a range of contiguous '''cells''' with the '''cursor'''.

First click on a '''cell''' and hold down the '''left mouse button'''.

Drag the '''cursor''' on the '''sheet'''.

Once the desired block of '''cells''' is highlighted, release the left mouse button.

We see that the selected '''cells''' get highlighted.
|-
|| Click on first cell of first row '''Column''' '''A'''

Hold down the '''Shift''' key.

Drag till '''Column''' '''D.'''
|| Next, we’ll learn how to select multiple '''columns''' or '''rows''' that are '''contiguous'''.

Click on the first '''column''' or '''row''' that you want to select.

Now hold down the '''Shift''' key and click the last '''column''' or '''row''' that we want to select.

We see that the selected '''cells''' get highlighted.
|-
||

Click on first cell of first row '''Column''' '''A'''

Hold down the '''Control''' key

Click→ '''Columns C,D & F '''while holding down the '''Control''' key.
|| Let’s learn to select multiple '''columns''' or '''rows''' that are not contiguous.

Click on the first '''column''' or '''row''' that you want to select.

Hold down the '''Control''' key.

Now click on all of the subsequent columns or rows that you want to select.

We see that the selected '''cells''' get highlighted.
|-
|| Press '''Ctrl+S''' keys

Press X
|| Save the file by pressing '''Ctrl+S''' keys on the keyboard.

Now close the file by clicking the '''X''' icon on the top right corner.
|-
|| Only Narration
|| This brings us to the end of this tutorial, let us summarize.
|-
|| '''Slide: '''Summary
|| In this tutorial, we learnt to:
* Enter '''numbers, text , date''' and '''time''' in '''Calc'''
* Use the '''Format Cells''' dialog box
* Navigate between '''cells'''
* Select items in '''rows''' and '''columns'''

|-
|| '''Slide:'''Assignment
|| As an assignment
* Open '''Spreadsheet-Practice.ods'''
* Under '''Serial Number''' type the serial number from '''1 '''to''' 5''' one below the other and '''Align''' '''Center'''.
* Add column headings '''Date''' and '''Time '''with the same '''text format'''
* Enter some values in those columns
* Use the''' Format Cells''' dialog box options to format the '''cells'''
* Refer to the '''Code files''' link for the '''data'''.
* Save and close the file

|-
|| '''Slide: '''About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it

|-
|| '''Slide:''' Spoken tutorial workshops
||
* We conduct workshops using '''Spoken''' '''Tutorials''' and give certificates.
* For more details, please write to us.

|-
|| '''Slide: '''Forums
|| Pls post your timed queries in this forum.
|-
|| '''Slide: '''Acknowledgement
| | '''Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide:''' Thank you

Acknowledgement to DesiCrew
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from '''IIT Bombay '''signing off.

Thank you for watching.
|-
|}

LibreOffice-Suite-Calc-6.3/C2/Introduction-to-LibreOffice-Calc/English

2020-07-02T14:38:07Z

Arvindpillai90: Created page with "Title: Introduction to LibreOffice Calc Author: Arvind Pillai Novice reviewer: Nikita Misal Domain reviewer: Praveen S Keywords: LibreOffice Calc, Installation of Calc, To..."

Title: Introduction to LibreOffice Calc

Author: Arvind Pillai

Novice reviewer: Nikita Misal

Domain reviewer: Praveen S

Keywords: LibreOffice Calc, Installation of Calc, Toolbars in Calc, Open new spreadsheet in Calc, Open an existing spreadsheet, Save a spreadsheet, Close a spreadsheet, Save Calc file as MS Excel spreadsheet, Export Calc file as a PDF''' '''document

{| border="1"
|-
|| '''Visual Cue'''
|| '''Narration'''
|-
|| '''Slide: '''Title
|| Welcome to the '''spoken tutorial '''on '''Introduction to''' '''LibreOffice Calc'''.
|-
|| '''Slide: '''Learning Objectives
|| In this tutorial, we will learn:
* About '''LibreOffice Calc'''
* Various '''toolbars'''
* How to open a new and existing '''spreadsheet'''.
* How to save and close a '''spreadsheet''' in '''Calc'''
* How to save as '''MS Excel spreadsheet'''
* How to export as a '''PDF '''document

|-
|| '''Slide: '''What is LibreOffice Calc?

|| What is '''LibreOffice Calc'''?
* '''LibreOffice Calc''' is the '''spreadsheet''' component of the '''LibreOffice Suite'''.
* It is the equivalent of '''Microsoft Excel''' in '''Microsoft Office Suite'''.
* It's free and open source software.
* It can be shared, modified and distributed without any restrictions.

|-
|| '''Slide: '''OS and versions
|| '''LibreOffice Calc''' can run on any of the following operating systems:

* '''Microsoft Windows 8''' or higher versions
* '''GNU/Linux OS '''and
* '''Mac OSX'''

|-
|| '''Slide: '''System Requirements
|| This tutorial is recorded using
* '''Ubuntu Linux '''OS version 18.04 and
* '''LibreOffice Suite''' version 6.3.5

|-
|| '''Slide''': LibreOffice Installation
||
* By default the latest '''Ubuntu''' '''Linux OS''' has '''LibreOffice''' pre-installed in it
* To install a specific version, refer to the '''LibreOffice Installation '''series on this website.

|-
|| Narration only
|| Let us learn to open '''LibreOffice''' '''Calc.'''
|-
|| Click on '''Show Application''' >>search bar type '''Calc''' >>
Click on '''LibreOffice Calc''' icon
|| In '''Ubuntu Linux OS''', click on the '''Show Applications''' icon at the bottom left corner.

In the '''search bar''' type '''Calc'''.

From the displayed list, click on the '''Libreoffice Calc''' icon.
|-
|| Click on '''Start menu '''>>search bar type '''Calc''' >>
Click on '''LibreOffice Calc''' icon
|| In '''Windows OS''', click on the '''Start Menu''' icon located at the bottom left corner.

In the '''search bar''' type '''Calc'''.

From the displayed list, click on the '''Libreoffice Calc''' icon.
|-
|| Only Narration:
|| This will open an empty '''spreadsheet''' document in the main '''Calc''' window.

Now let us learn about the main components of the '''Calc''' window.
|-
|| Point to '''title bar, menu bar, standard toolbar,
'''formatting bar, formula bar, status bar '''and''' Sidebar'''
|| The '''Calc''' window has various '''toolbars'''.

'''Title bar, Menu bar, Standard toolbar, Formatting bar, Formula bar, Status bar''' and '''Sidebar'''.

We will learn about these as the series progresses.
|-
|| Narration only
|| The entire '''spreadsheet '''document''' '''in '''Calc''' is called a '''workbook'''.
|-
|| Click on cell '''C6'''.

Highlight a row and a column with the cursor.
|| The work area where the data is to be typed, contains various '''cells''' in the form of a grid.

In other words, the '''cells '''are arranged in '''rows''' and '''columns'''.
|-
|| Highlight cell referenced as '''A1''' with the cursor.

Highlight upward to the column and left-ward to the row.
|| A particular '''cell''' refers to an intersection of a '''row''' and a '''column.'''

It is identified by its relevant '''row number''' and '''column alphabet'''.
|-
|| Point to the highlighted cell referenced as '''A1''' with the cursor.

|| '''Cells''' can hold information like text, numbers, formulae, and many other data elements.

'''Cells''' can be used to display and manipulate the data.
|-
|| Point to '''Sheets''' tab

Point to '''Sheet1'''

|| We can see a '''sheet''' tab at the bottom left corner of the '''spreadsheet'''.

This tab enables access to the '''sheet'''.

By default, we see one '''sheet''' on the interface and it is named as '''Sheet 1.'''
|-
|| Point to the '''Sheets''' tab below.

Text on screen: One million '''rows''' and one thousand '''columns.'''

Text on screen: One billion cells in one sheet
|| Each '''spreadsheet''' can have several '''sheets.'''

Each '''sheet''' can have little more than one million '''rows''' and one thousand '''columns.'''

Which is, more than one billion or hundred crore '''cells''' in a single '''sheet'''.
|-
|| Click on the cell referenced as “'''A1'''”

Highlight column headers and row headers.

|| Each '''row''' is identified by a '''number''' and each '''column''' by an '''English alphabet'''.

There are a series of '''grey boxes''' containing letters at the top of the '''column'''.

Likewise, we see '''grey boxes''' containing numbers at the left end of the '''rows'''.

These are the '''column''' and '''row headers'''.
|-
|| Click on the column starting with “A” and go on to the right.

Click on the row starting with “1”and go down.
|| The '''columns''' start from “'''A'''” and go on to the right.

And the '''rows''' start from “'''1'''” and go down.
|-
||

Point to '''Name''' '''box''' and '''Input''' '''line'''.
|| Along with the '''toolbars''', we have two additional fields also at the top.

'''Name box''' and '''Input line.'''
|-
|| Click on the cell referenced as “'''A1'''”-> Point to “'''Name Box'''” at the top-left.
|| The '''column''' and '''row headers''' form the '''cell references.'''

And these will appear in the''' Name box''' field.
|-
|| Only Narration
|| This was a brief description of the various components in '''Calc'''.

Now let us learn how to open a new '''spreadsheet '''in '''Calc'''.
|-
|| Click on New Icon
|| We can open a new '''spreadsheet''' by clicking on the '''New''' icon in the '''Standard''' '''toolbar.'''
|-
|| Click '''File menu'''

Click '''New''' >> '''Spreadsheet'''

|| Alternatively go to the '''File''' '''menu''' in the '''menu bar.'''

Then click on the sub menu '''New''' and select the option '''Spreadsheet.'''
|-
|| Only Narration

Close the '''spreadsheet '''named''' “Untitled 2”.'''

Click on the '''X''' icon
|| A new '''Calc spreadsheet''' named '''Untitled 2 '''opens up.

Close the newly opened '''spreadsheet '''named''' “Untitled 2”. '''

By clicking the '''X''' icon on the top right corner.
|-
|| Only Narration
|| Now we will learn how to build a “'''Personal Finance Tracker'''” in the '''spreadsheet'''.

We will do this in the '''Untitled 1''' '''spreadsheet.'''
|-
|| Only Narration
|| Let us learn how to input '''data''' in a few '''cells''' in the '''spreadsheet'''.
|-
|| Click on cell '''A1'''

Type “'''SN'''” in cell '''A1'''.
|| Click on the '''cell''' referenced as '''A1''' in the '''spreadsheet'''.

Type the heading as “'''SN'''”.

It denotes the serial''' number''' of items which we will input in the '''spreadsheet'''.
|-
|| Click on cell '''B1''' ->Type “'''Items'''”.

|| Now click on the '''cell''' referenced as '''B1''' and type another heading “'''Items'''”.

All item names which we will use in the '''spreadsheet,''' will be under this heading.
|-
|| Click on cell '''C1-'''>write “'''Cost'''”

Click on cell '''D1-'''>write “'''Spent'''”

Click on cell '''E1-'''>write “'''Received'''”

Click on cell '''F1-'''>write “'''Date'''”

Click on cell '''G1-'''>write “'''Account'''”
|| Similarly, click on the cells '''C1, D1, E1, F1 and G1 '''one after the other.

Type the headings as “'''Cost”, “Spent”, “Received”, “Date” '''and''' “Account'''” respectively.
|-
|| Only narration
|| We’ll add some '''data''' for each of these headings in later tutorials.
|-
|| Only Narration
|| Once done typing our document, we should save it for future use.
|-
|| Click on '''File'''
|| To save the file, click on the '''Save '''icon in the '''Standard toolbar'''.
|-
|| Dialog box

Point to '''Name >>''' type “'''Personal-Finance-Tracker'''”
|| A''' '''dialog box appears on the screen.

It prompts us to enter the name of our file in the '''Name''' field.

I will type the name of the file as''' “Personal-Finance-Tracker”.'''
|-
|| Select '''Desktop''' location
|| On the left side, I’ll select '''Desktop''' as file location to save my file.
|-
|| Point to the '''File type''' drop-down

Click on '''File type''' drop-down
|| Notice, we have a '''File type''' drop-down at the bottom right corner.

Click on this drop-down.
|-
|| Scroll the options

Point to “'''ODF Spreadsheet'''” and then on “'''ods'''”.

|| It shows a list of '''file types''' or '''file extensions''' in which we can save our file.

The default '''file type''' in '''LibreOffice Calc''' is '''ODF''' '''Spreadsheet (.ods)'''.

'''ODF''' stands for '''Open Document Format''' which is an open standard.
|-
|| Click on '''ODF Spreadsheet (.ods)'''.
|| I will click on the '''ODF Spreadsheet''' option to save my file.

Do so likewise on your machine.
|-
|| Click on '''Save''' button.
|| Click on the '''Save''' button at the top right corner of the dialog box.
|-
|| '''Calc '''window
|| We will be redirected back to the '''Calc''' window.
|-
|| Point to “'''Personal-Finance-Tracker.ods'''” in the '''title bar'''.
|| Observe the change in the '''title bar '''now.

It has changed to '''Personal-Finance-Tracker.ods'''
|-
|| Point to '''“Microsoft Excel 97/2003/XP(.xls)” '''

Point to '''“Microsoft Excel 2007 XML(.xlsx)'''
|| Besides saving in '''dot ods''' format, we can also save our file in '''dot xls''' and in '''dot xlsx''' format.

Files with these formats can be opened later in '''MS Excel''' application.
|-
|| Click Save icon dropdown >> '''Save''' '''As'''.
|| Click on the dropdown arrow beside the '''Save''' icon and then on the '''Save As '''option.
|-
||

Click on '''File type''' drop-down

Click on '''Excel 2007-365 (.xlsx)'''
|| In the '''Save As '''dialog box, click on '''File type''' drop-down at the bottom right corner.

Select '''Excel 2007-365 (.xlsx) '''format.
|-
|| Click on the Save button.
|| Click on the '''Save''' button at the top right corner of the dialog box.
|-
|| Point to''' Confirm File Format '''dialog box

Put a check on''' “Ask when not saving in ODF format”'''.
|| If we save the file in any other file format, '''Confirm File Format '''dialog box opens up.

Put a check on “'''Ask when not saving in ODF or default forma'''t” option.
|-
|| Click on '''Use Excel 2007-365 format'''
|| Then click on the '''Use Excel 2007-365 format '''button.
|-
|| '''Calc '''window

Point to the '''Title bar'''
|| We will be redirected back to the '''Calc''' window.

Notice the change in the filename in the '''Title bar'''.
|-
|| Point to '''Export Directly as PDF '''icon.
|| The '''spreadsheet''' can also be exported to '''PDF''' format.

To do so, click on the '''Export Directly as PDF''' icon in the '''Standard toolbar'''.
|-
||

Click on '''File >> >> Export as PDF'''

|| Alternatively, we can do so by clicking on the '''File''' '''menu''' in the '''menu bar'''.

And then on the '''Export as PDF''' option.
|-
|| Point to''' PDF Option '''dialog box

|| '''PDF options''' dialog box opens up.

In this dialog box, we will see various settings to customize the '''PDF''' option.

Keep the default settings as it is and click on the '''Export''' button at the bottom.
|-
|| Click on '''Export '''button

Click on '''Desktop''' >> click on '''Save''' button
|| Choose the location where we wish to save and then click on the '''Save''' button.

A '''pdf '''file will be created in that folder.
|-
|| Click '''File >> Save As.'''

Click on '''File type''' drop-down

Point to “'''Text CSV(.csv)'''”

|| Another popular '''file extension''' which opens in most applications is '''dot csv'''.

This is often used to store '''spreadsheet data''' in a text file format.

This will reduce the file size hugely and is easily portable.
|-
|| Only Narration
|| Additionally, we can save the '''spreadsheet''' in '''dot html''' format, which is a '''web page format'''.

This is done in the same way as explained above.
|-
|| Scroll the '''File type '''drop-down

Click on '''HTML Document (Calc) (.html)'''.
|| In the '''File type''' drop-down, scroll down and select''' HTML Document (Calc)(.html).'''

This option gives the '''dot html''' extension to the '''spreadsheet.'''
|-
|| Choose '''Desktop''' as file location >> Click on '''Save'''.
|| Again choose the same file location to save.

Then click on the '''Save''' button at the top right corner of the dialog box.
|-
|| Point to''' Confirm File Format '''dialog box

Put a check on''' “Ask when not saving in ODF format”'''.
|| The '''Confirm File Format '''dialog box opens up.

Put a check on “'''Ask when not saving in ODF or default forma'''t” option.
|-
|| Click on '''Use HTML Document (Calc) Format'''.
|| Then click on the '''Use HTML Document (Calc) Format''' button.
|-
|| Point to '''title bar.'''
|| We see that the file gets saved with '''dot html''' extension.

This format is used when we want to show our '''spreadsheet''' as a''' web page.'''

It can be opened in any '''web browser'''.
|-
|| Click '''File >> Close'''
|| Let’s close this '''spreadsheet''' by clicking on '''File menu''' in the''' menu bar '''and then '''Close'''.
|-
|| Only Narration
|| Next we will learn how to open an existing '''spreadsheet''' in '''LibreOffice Calc'''.
|-
|| Only Narration
|| Let's open the '''spreadsheet Personal-Finance-Tracker.ods'''
|-
|| Click on '''Open File'''

File browser dialog box opens >> '''Desktop'''
|| Click on the '''Open File''' menu on the left of the '''LibreOffice''' interface.

The file browser dialog box opens up.

Go to the location where our file was saved.
|-
|| Click on '''Personal-Finance-Tracker.ods'''

>> Click on '''Open'''
|| Now in the list of filenames that appears, choose '''Personal-Finance-Tracker.ods'''.

Then click on the '''Open''' button at the top right corner.

The file '''Personal-Finance-Tracker.ods''' opens in the '''Calc''' window.
|-
|| Only Narration
|| Likewise, we can also open files with '''dot xls''' and '''dot xlsx''' extensions in '''Calc.'''
|-
|| Narration Only
|| Next let’s see how to modify a file and save it under the same filename.

So let us modify the file by making the headings '''bold''' and increasing their font size.
|-
|| Click on the cell '''A1'''

Click on the '''B''' icon from the standard '''toolbar'''

Point to '''SN'''
|| To do so, first click on the '''cell''' referenced as '''A1'''.

Now click on the '''Bold''' icon in the '''Standard toolbar. '''

The heading '''SN''' becomes '''bold'''.
|-
||

Click on '''Font Size''' -> Select 14

Point to heading '''SN'''
|| Click on the down-arrow in the '''Font Size''' field in the '''Standard toolbar. '''

In the drop-down, let us select '''14.'''

The font size of the heading '''SN''' increases to '''14'''.
|-
||

Click on '''Font Name''' >> '''Arial'''.
|| Next, let us change the '''font''' we are using.

Click on the down-arrow in the '''Font Name''' field in the '''Standard toolbar.'''

From the drop-down select '''Arial''' as the '''font'''.
|-
|| Repeat the above actions Bold, Font Size and Font name for rest of the headings
|| Likewise, modify the rest of the headings.
|-
|| Click on the '''Save''' icon.
|| Let us now save the changes that we have made.

To do so, click on the '''Save''' icon in the '''Standard toolbar.'''
|-
|| Only Narration
|| Let's close the '''spreadsheet''' now.
|-
|| Click on '''File''' >> '''Close'''
|| Click on the '''File''' menu in the '''menu bar '''and then click on the '''Close''' option.
|-
|| Only Narration
|| This brings us to the end of this spoken tutorial.

Let us summarize.
|-
|| '''Slide:''' Summary
|| In his tutorial, we learnt:
* About '''LibreOffice Calc'''.
* Various '''toolbars''' in '''Calc'''.
* How to open a new and existing '''spreadsheet'''.
* How to save and close a '''spreadsheet'''
* How to save as '''MS Excel spreadsheet'''
* How to export as a '''PDF '''document in '''Calc'''.

|-
|| '''Slide:''' Assignment

|| As an assignment
* Open a new '''spreadsheet''' in '''Calc'''.
* Save it under the name '''Spreadsheet'''-'''Practice'''.'''ods'''
* Type the headings as “'''SN'''”, “'''Name'''”, “'''Department'''” and “'''Salary'''”.
* Underline the headings and '''bold '''them.
* Increase the '''font size''' of the headings to '''12'''.
* Save and close the file.

|-
|| '''Slide: '''About Spoken Tutorial Project
||
* The video at the following link summarises the Spoken Tutorial project.
* Please download and watch it

|-
|| '''Slide:''' Spoken tutorial workshops
||
* We conduct workshops using '''spoken''' '''tutorials''' and give certificates.
* For more details, please write to us.

|-
|| '''Slide:'''Answers for THIS Spoken Tutorial
||
* Do you have questions in THIS Spoken Tutorial?
* Please visit this site
* Choose the minute and second where you have the question
* Explain your question briefly
* The Spoken Tutorial project team will ensure an answer
* You will have to register on this website to ask questions.

|-
|| '''Slide: '''Forum for specific Questions
||
* The Spoken Tutorial forum is for specific questions on this tutorial.
* Please do not post unrelated and general questions on them.
* This will help reduce the clutter.
* With less clutter, we can use these discussions as instructional material.

|-
| | '''Slide: '''Acknowledgement
| | The''' Spoken''' '''Tutorial''' project is funded by '''MHRD''', Govt. of India.
|-
|| '''Slide: '''Thank you

Acknowledgement to DesiCrew
|| This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011

This is Arvind along with Spoken Tutorial team from IIT Bombay signing off.

Thank you for watching.
|-
|}