LibreOffice Calc

LibreOffice Calc

• Introduction of Spread Sheet
• Creating of Spread Sheet
• Concept of Cell Address
• Selecting a Cell
• Entering Data in Cell
• Page Setup
• Printing of Sheet
• Saving Spreadsheet
• Opening and Closing
• Manipulation of Cells and Sheet
• Modifying / Editing Cell Content
• Formatting Cell
• Cut, Copy, Paste
• Paste Special
• Changing Cell Height and Width
• Inserting and Deleting Rows
• AutoFill
• Sorting & Filtering
• Freezing panes
• Formulas
• Functions and Charts
• Using Formulas for Numbers
• AutoSum
• Functions
• Advanced Filter
• Database Functions
• What-if Analysis
• Pivot table
• Charts (Bar, Column, Pie, Line)
• Data Validation
• Assessment