Add on Course Excel/Sheet

Introduction & Basics of Spreadsheet

• Introduction about Google Sheet

• Comparison of Google Sheet and Microsoft Excel

• Creating, Renaming and Sharing Google Sheet

• Formatting

• Freezing Rows and Columns

• Basic Functions

• Data Set 1  Click Here 

• Assignment 1 ( 2 Hour) Click Here 

• Quiz - 1

Manipulating Data

• Data Entry using Data validation, Collaborative way and using Google Form 

• Sorting

• Filters

• Find and Replace

• Revision of History

• Assignment of 3 hours Click Here 

• Data Set   Click Here 

• Quiz  Click Here 

Functions and Formulas

• Google Form, Google Sheet and Certificate Generation using Autocrat add on

• Overview of Formula

• List of Formulas ( Click Here)

• More  Functions: If, Left Right Mid, Search, Concatenate

• Math, Logical and Text Function

• Assignment of 3 hours Click Here 

• Data Set 2  Click Here 

• Quiz  Click Here 

Data Presentation: Charts and Graphs

• Creating various Graphs and chart

• Table

• Pivot Table

• Conditional Formatting

• Assignment of 3 hours Click Here 

• Data Set 2  Click Here 

• Quiz  Click Here 

Data Presentation: Charts and Graphs

• Creating various Graphs and chart

• Table

• Pivot Table

• Conditional Formatting

• Assignment of 3 hours Click Here 

• Data Set 2  Click Here 

• Quiz  Click Here 

Solve real life problems that you daily face

• Preparing Various Registers

• Preparing Routine and Calendar

• Students and Staff Data Management

• Assignment of 3 hours Click Here 

• Data Set 2  Click Here 

• Quiz  Click Here 

Exam and Certificate Distribution

• Concluding Lecture

• Final Test  Click Here  Just at 10. 00 am

• Certificate Distribution Programme

• Feedback Click Here