Now showing items 1-10 of 34
LibreOffice Calc - Basic Data Manipulation
(Spoken Tutorial IIT Bombay, 2014-10-10)
Outline: Basic Data Manipulation: Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table; Introduction to Formulas – Sum, Average, basic formula (=a*b+c); Subtotal; ...
LibreOffice Calc - Formulas and Functions
(Spoken Tutorial IIT Bombay, 2014-10-17)
Outline: Formulas and Functions: Creating formulas, operator types and referencing; Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function; Rounding off numbers; ...
LibreOffice Calc - Formatting Data
(Spoken Tutorial IIT Bombay, 2014-10-09)
Outline: Formatting Data: Borders, Color, Formatting Text, Increasing Cell Size; Formatting multiple lines of text, numbers, fonts, cell borders, cell background; Automatic Wrapping and Using manual ...
LibreOffice Calc - Working with Data
(Spoken Tutorial IIT Bombay, 2014-10-13)
Outline: Working with data: Speed up using Fill tools and Selection lists; Sharing content between sheets; Remove data, Replace data, Change part of a data. Pre-requisite: LibreOffice Calc - Basic ...
LibreOffice Calc - Working with Cells
(Spoken Tutorial IIT Bombay, 2014-10-07)
Outline: Working with Cells: How to enter numbers, text, numbers as text, date and time in Calc; How to Navigate between cells and in between sheets; How to select items in rows, columns and sheets. ...
LibreOffice Calc - Using Charts and Graphs
(Spoken Tutorial IIT Bombay, 2014-10-14)
Outline: Using Charts and graphs in Calc: Creating,Editing and Formatting Charts; Types of charts; Resizing and moving of charts. Pre-requisite: LibreOffice Calc - Working with Data
LibreOffice Calc - Linking Calc Data
(Spoken Tutorial IIT Bombay, 2014-10-20)
Outline: Linking Calc Data: Referencing other sheets and documents; Working with Hyperlinks. Pre-requisite: LibreOffice Calc - Formulas and Functions
LibreOffice Calc - Working with Sheets
(Spoken Tutorial IIT Bombay, 2014-10-08)
Outline: Working with Sheets: Inserting and Deleting rows and columns Calc; Inserting and Deleting Sheets in Calc; Renaming Sheets. Pre-requisite: LibreOffice Calc - Working with Cells
LibreOffice Impress - Introduction
(Spoken Tutorial IIT Bombay, 2014-10-21)
LibreOffice Impress is the spreadsheet component of the LibreOffice Suite. It is the equivalent of Microsoft PPT in Microsoft Suite and has a number of unique features that make it a versatile tool for creating presentations. ...
LibreOffice Impress - Inserting Pictures and Objects
(Spoken Tutorial IIT Bombay, 2014-10-27)
Outline: Inserting Pictures and Other Objects in a Document: Insert Pictures/Hyperlinks (Within/Across Documents, from Web); Creating Tables. Pre-requisite: LibreOffice Impress - Viewing a Presentation Document