| DAY 1 | Google Form |
| No | Topics |
| 1 | Introduction to Google Forms- (1) How to Create Google Form, Create Form Sections and Logic in Google Forms, (2) Google Forms Alternative with Connected Dropdowns, (3) Check Google Form Responses, Google Form Settings, (4)Share, Data Transfer Google Form to Excel Sheet, Transferring Ownership of Google Form |
| DAY 2 | Google Sheet & MS EXCEL 2016/2013/2010/2007 |
| 2 | MS-Excel Basic Information - (1) Data Entry, Data Editing, and (2) Number Formatting, Working with Cells and Ranges in Excel, (3) Hyperlink, Managing Worksheets, (4) Using Conditional Formatting in Excel Date and Time Formulas in Excel, (5) Auto-fill, Custom Lists, and Flash Fill, (6) COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel, (7) Lookup and Reference Formulas in Excel, (8) Logical Formulas in Excel, (9) Formulas Mix and Match, (10) Data Validation in Excel, (11) Data Sorting and Filtering in Excel, (12) Introduction to Excel Charting, Advanced Excel Charting, Dynamic Charts in Excel, create & customize a pivot table, Page Settings, |
| DAY 3 | Google Sheet & MS EXCEL 2016/2013/2010/2007 |
| 3 | |
| Introduction to Google Sheet- (1) How to Create Google Sheet, Protection in Excel, Protect and Lock Google Sheet, (2) Share, Google Drive Store Data, Formula, Transferring Ownership of Google sheet | |
| DAY 4 | MS WORD 2016/2013/2010/2007 |
| NO | Topics |
| 4 | Introduction to Microsoft Word, (1) Open and Save a Document, Customize The Toolbars, Format Tables, Create Charts |
| 5 | (2) How to insert a page break and a section break in MS Word, How To Insert Header, Footer & Page Number In MS Word , How to set different watermarks on different page in MS Word |
| 6 | (3) How to print multiple letters & envelopes using mail merge with an existing list in Word |
| 7 | (4) How to print address on Envelope with the help of MS Word and how to make a Lable or Sticker |
| 8 | (5)How to use Macro to record any work done |
| DAY 5 | MS POWER POINT 2016/2013/2010/2007 |
| NO | Topics |
| 9 | Introduction to Microsoft Power Point- (1) How to Create Slides, Text And Bullet Editing Options, Clip Art and Tables, Graphic Elements, Charts and Media Clips, Working With SmartArt, Slide Show Design |
| 10 | (2) Using artistic Effects, Compress, Change & reset picture options |
| 11 | (3) What is slider animation & how to animate image like a slider |
| 12 | (4) How to run A slideshow & use Transition in slide |
| 13 | (5)How to create handwriting text animation effect in power point |
| 14 | (6) How to create a master slide in power point ? |
No comments:
Post a Comment