LibreOffice Suite Calc
From Script | Spoken-Tutorial
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 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.
Basic Level
- Promo of LibreOffice Suite
- LibreOffice promo
- Features of LibreOffice
- Uses of LibreOffice
- LibreOffice formats
- LibreOffice tutorials in Spoken Tutorial
- Applications of LibreOffice
- LibreOffice tutorials in various languages
- Introduction to LibreOffice Calc
- What is Calc,Who should use Calc,What can be done using Calc.
- About spreadsheets,sheets and cells.
- Basic features – parts of main Calc window - Title & Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Status Bar
- What is a cell, row, column, Create new document, enter data in one cell, save in Calc( CSV and other formats),opening/closing document.
- Save as ods, csv, xls, xlsx and export to PDF
- Working with Cells
- How to enter numbers,text,numbers as text,date and time in Calc.
- How to use the Format Cells dialog box.
- How to Navigate between cells and in between sheets.
- How to select items in rows,columns and sheets.
- Working with Sheets
- Inserting and Deleting rows and columns Calc.
- Inserting and Deleting Sheets in Calc.
- Renaming Sheets.
- 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 breaks
- Merging cells, rows and columns, issues with using merge cells.
- Shrinking text to fit the cell
- 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
- Different kinds of functions available in spreadsheet
- Sorting by Columns
- Filtering Data - Basics
- Working with data
- Speed up using Fill tools and Selection lists.
- Sharing content between sheets
- Remove data,Replace data,Change part of a data.
- Viewing and printing a document
- Views options – Zoom option,Freezing and Splitting of screen, Page break view
- Printing options and settings, header, footer
- Print Margin
Intermediate Level
- Using Charts and graphs in Calc
- Creating,Editing and Formatting Charts
- Types of charts
- Resizing and moving of charts
- Images and graphics in Calc
- Inserting images in Calc
- Modifying images
- Advanced Formatting and Protection
- Cell Protection
- Ranges
- Validity
- Formulas and Functions
- Creating formulas,operator types and referencing
- Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function
- Rounding off numbers
- If..else
- Important string functions (left, right, middle, concatenate)
- Linking Calc Data
- Referencing other sheets and documents
- Working with Hyperlinks
Advanced Level
- Auto-formatting cells and sheets
- How auto-formatting is done
- Defining a new auto-format
- Using themes and Conditional formatting
- Hiding and showing data
- Sharing and Reviewing
- Recording Changes
- Adding comments to changes
- Accepting/Rejecting changes
- Header and footer
- Macro in Calc
- Using macro recorder
- Writing own functions in macro
- Editing a macro,playing a macro, deleting a macro
- Working with Styles
- Types of Styles
- Modifying Styles
- Creating new styles
- Data manipulation
- Convert text to columns
- Convert columns to txt
- Data Analysis
- Creating scenarios
- Changing scenarios
- Working with scenarios using navigator
- Multiple operations in rows and columns
- Data Pilot
- Data source
- Data pilot dialog
- Working with the results of data pilot.
- Filters
