Admission 2023-24
State Level Workshop on Microsoft Excel and Google Sheet
First Aid Training Program(Education Program)
January 30, 2023Budget Symposium
February 7, 2023
State Level Workshop on Microsoft Excel and Google Sheet
by
329 329 people viewed this event.
Event Title |
|
|||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Event category | Workshop |
|||||||||||||
| About Event | The School of Engineering & Computing is going to organize 4 days’ workshop on State Level Workshop on Microsoft Excel & Google Sheet from 20th Feb to 23th Feb 2023. This event will be conducted in Computer Lab Civil block. | |||||||||||||
| AIM of the Events | The objective of a seminar is to get exposure and get trained under the supervision of highly skilled industry experts and look forward to leverage it for mutual benefit for students. | |||||||||||||
| Content of the Events | Workshop on Microsoft Excel & Google Sheet | |||||||||||||
| Highlights of Events | This event is going to describe all about Microsoft Excel and Google Sheet. Students will learn a lot from this event. | |||||||||||||
| Speakers of the Events |
|
|||||||||||||
| Department Name | School of Engineering & Computing, DBUU | |||||||||||||
| Course Name | Open for all students of DBUU | |||||||||||||
| Date Time & Venue of Events: | Computer Lab Civil block DBUU | |||||||||||||
| Organizing Team Members |
|
|||||||||||||
| Registration Desk |
|
|||||||||||||
| Contact Person | Mr. Mukesh Rajput, 9756614554
Mr. Rakesh Arya, 9720274661 |
|||||||||||||
—————————-SYLLABUS—————————–
Day 1
| 9:45 AM – 11:30 AM | Introduction to Excel, Entry & Editing of Cells, Managing Workbook & Worksheets, Formatting of Cells |
| 11:45 AM – 01:15 PM | Math & Trigonometrical Functions |
| 02:15 PM – 04:00 PM | Statistical & Date Functions |
Day 2
| 9:45 AM – 11:30 AM | Text Functions |
| 11:45 AM – 01:15 PM | Lookup & Reference Functions |
| 02:15 PM – 04:00 PM | Logical & Information Functions |
Day 3
| 9:45 AM – 11:30 AM | Flash Fill, Data Validation, Conditional Formatting |
| 11:45 AM – 01:15 PM | Security, Tables, Auto & Advance Filter, Goal Seek, Data table |
| 02:15 PM – 04:00 PM | Pivot Tables, Charts, Power Query & Templates |
Day 4
| 9:45 AM – 11:30 AM | Introduction of Visual Basic Application (Macros) and Providing some important VBA programme |
| 11:45 AM – 01:15 PM | Introduction of Google Sheets. Query, Unique, Sort, Filter and other important functions of Google Sheets |
| 02:15 PM – 04:00 PM | Google Forms, Data Consolidation and Publishing of Google Sheets, Introduction to Google Script. |
