Spreadsheet for Business

4th January 2022 1 By indiafreenotes
Unit 1 Introduction {Book}  
Introduction to spreadsheets, Office Suite overview VIEW VIEW
Basic Text and cell formatting VIEW
Basic Arithmetic calculation, Special paste, Freeze pane VIEW
Auto completion of Series, Sort and filter, Charts VIEW

 

Unit 2 Summarize data using functions {Book}  
Perform calculations by using the SUM function VIEW
Perform calculations by using MIN and MAX function VIEW
Perform calculations by using the COUNT function VIEW
Perform calculations by using the AVERAGE function VIEW
Perform logical operations by using the IF function VIEW
Perform logical operations by using the SUMIF function VIEW
Perform logical operations by using the AVERAGEIF function VIEW
Perform statistical operations by using the COUNTIF function VIEW

 

Unit 3 Text Functions {Book}  
Data validation VIEW
Text Functions: LEN, TRIM, PROPER, UPPER, LOWER, CONCATENATE VIEW