9948935656
madhavi@gcstechno.comGCS
institute of computer technologies
an iso & govt . recognized
GCS is an ISO&GOVT recognized institute and no.1institute for practical trainings for 28 plus courses.
from basic working level to advance working levels from past 25 years.
BOTH ONLINE AND OFFLINE
COURSE CONTENT PART 1
CA & MS-OFFICE
BASICS
Computer H/W S/w
-Introduction Of Computers
– Windows Explorer, Accessories
– Ms-dos & Paint
-Wordpad, Notepad, & Calculator Computer Basics
MS WORD
Introduction To Ms-Word
•File Opening,saving, Closing
•Print, Page Setups, Page Layouts
– Page Numbers, Date & Time
– Drawing The Pictures, Shapes
•Bullets & Numbering, Hyperlinks
– Borders & Shading, Themes
– Borders & Shadings, Bg Colors
– Mail Merge, Envelops & Labels
– Creating Tables, Help Menu
MS-EXCEL
Introduction To Excel Sheets
– Functional Formulae
Create Macros, Validation
– Create Payrolls, Tables
– Create Accounts Using Formulae
Graphs, Charts
POWER POINT
– Introduction To Ms-power Point
Create Designing Slides
Create Custom Animations
-Sound Effects & Bg Design
Create Timing Presentation
Slide Shows Presentation
DURATION: 45 DAYS
COURSE CONTENT PART 2
-WITH ADV EXCEL
-ADVANCE EXCEL
-Look Up, V Look Up, H Look Up
– Sum if, Count If Functions
-Index & Match Functions
-Pivot Tables Charts
– Fillers, Adv Filters
-Paste Links, Paste Special
-Import Tables Excel To Word
– Custom List, Data Functions
-Logical Functions,name Define
-Date Functions,text Functions
-Conditional Formatting
-Sub Total Functions
-Goal Seek,pmt Functions
-Protect Book & Sheet
-Scenarios,number Series
-Sheet Breaks,formula Auditing
Hide And Unhide Sheets, Object
•Columns And Rows,print Titles,
Smart Art,watch Windows, Slicers
MS ACCESS
– Introduction To Ms Access
-Table In Design View
Table By Using Wizard
– Data Base, Tables Creations
-Forms, Reports, Queries
INTERNET CONCEPT
-Creating E-mails, Sending E-mail
-Online Job Searching, Interviews
– Online Tickets Booking, Shopping
Downloading Files, Websites