Add on Course Excel/Sheet
Day 1
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
Day 2
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
Day 3
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
Day 4
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
Day 5
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
Day 6
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
Day 7
Exam and Certificate Distribution
Concluding Lecture
Final Test Click Here Just at 10. 00 am
Certificate Distribution Programme
Feedback Click Here