Spreadsheet (Open Office Calc) I.T Skill Course 402

By: Kapil Joshi
I.T Class 2021
I.T Skill 402
Spreadsheet Basics
Spreadsheet Formatting
Calc Basic Calculations
Basic & Compound Formula
Using Formula on text
Calculating Percentage
How to put Grades With if
Using Sorting & Format
Filters in Spreadshteets
Making Salary Statement
Different Cell Reference
Consolidating On Data
Using Subtotals
What If Scenarios
Goal Seek In Calc
Link Data & Worksheet (1)
Referencing Other Sheets
Working with hyperlinks
Types of hyperlinks
Linking To External Data