Mastering LibreOffice: Essential Skills Workshop
Learn how to use LibreOffice for word processing, spreadsheets, presentations, and more. Explore its features, operations, file types, and formatting options. Enhance your productivity with LibreOffice!
Mastering LibreOffice: Essential Skills Workshop
E N D
Presentation Transcript
A Workshop on LibreOffice Er. Arvind Kumar AssistantProfessor, Department of ComputerScience & Engineering www.kharwal.com
Powered By: Arvind Introduction • LibreOffice is the most actively developed free and open source office suite, a project of The Document Foundation.
Powered By: Arvind • The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae.
Powered By: Arvind Liberofficewriter = MS word Extensions
Powered By: Arvind LiberOffice Calc Spreadsheet= MS Excel
Powered By: Arvind LiberOffice Impress Presentation= MS PowerPoint
Powered By: Arvind LiberOffice Base Database= MS Access
Powered By: Arvind Math Formula | Draw Drawing
Powered By: Arvind • Download • www.libreoffice.org • It is available for • Windows • Macintosh • Linux
Powered By: Arvind LiberOffice Writer
Powered By: Arvind Introduction • Title Bar • Menu Bar • Tool bar • Status bar
Powered By: Arvind • Operations • Creation of file • Opening of file • Saving of file • Font family & size
Powered By: Arvind File type extensions • Odt- open document format • Ott- open text document template • *You can also save document with doc or docx and rtf extensions. • * You can also save document with html extension for web.
Powered By: Arvind PDF Support • You can also export odt / doc files to pdf file.
Powered By: Arvind Typing Text & Basic Formatting • Aligning Text • Bullets & Numbering • Cut Copy Paste • Bold Underline & Italic • Font name, size & color
Powered By: Arvind Inserting Pictures & Objects • Inserting an Image file into a document • Inserting table • Inserting Hyperlink
Powered By: Arvind Viewing & Printing • There are two widely used viewing options. • Print Layout • How the document will look when printed. • Web Layout • This is useful when we want to create html documents.
Powered By: Arvind Search Replace Auto correct • Search • Replace • Spellcheck: looks for spelling mistakes in words & give you the option of adding an unknown words to a user dictionary. • Autocorrect
Powered By: Arvind To Install Local language • Install scim • Keyboard input method scim-immodule in language setting. • In tools-options-language-CTL-> hindi etc
Powered By: Arvind Track Changes • Go to Edit- Track changes • Benefits • Reviewer make comments • Add text • Delete or modify existing text
Powered By: Arvind Header & Footer • Insert- header • Insert- footer • Header-Footer properties: Double click on Header or Footer
Powered By: Arvind LiberOffice Calc Spreadsheet
Powered By: Arvind • Libreofficecalc is • The spreadsheet component of Libreoffice suit. • Said to be a software for the language of numbers. • Is free and open source software • Can be copied, reused and distributed free of cost.
Powered By: Arvind • Operations • Creation of file • Opening of file • Saving of file
Powered By: Arvind File type extensions • Ods- open document Spreadsheet • Ots- open spreadsheet template • You can also save your file in xlsx, csv, xml and html file format.
Powered By: Arvind PDF Support • You can also export ods files to pdf file.
Powered By: Arvind Working with cells • Enter Numbers • Text • Number as a text • Date & time • Currency
Powered By: Arvind Working With sheets • Inserting Rows • Inserting Column • Deleting Rows • Deleting Column • Inserting Sheet • Deleting Sheet • Renaming Sheet
Powered By: Arvind Formatting Data • Formatting Borders • Background Colors • Merging Cells • Formatting multiple lines of text using automatic wrapping • Shrinking text to fit the cell
Powered By: Arvind Basic Data Manipulation • Sum of cells value • Average of cells value etc.
Powered By: Arvind Charts & Graph
Powered By: Arvind Images & Graphics • Inserting an image
Powered By: Arvind Protection • Put a password on file • Put a password on a spreadsheet
Powered By: Arvind LiberOffice Impress Presentation
Powered By: Arvind Introduction • Impress is a presentation manager of LibreOffice suite. • It is used to create powerful presentation. • Equivalent of MS Office Powerpoint
Powered By: Arvind Operations • Create a new presentation • Save as MS Power Point • Open an MS Power Point • Export to Pdf
Powered By: Arvind File type extensions • Odp- open document Presentation • Otp- open Presentation template • You can also save your file in ppt,pptx and html file format.
Powered By: Arvind PDF Support • You can also export odp files to pdf file.
Powered By: Arvind Inserting Pictures & Objects
Powered By: Arvind Printing a Presentation • Slides • Handouts • Outline • Notes
Powered By: Arvind Master Slide • You can create template from this option. • View-master slide