Menu Close

ICIT

ICIT (International Certificate in Information Technology) is the preferred course for beginners. This course covers the most basic concepts of the classification of computers, software classification, and the essentials of the windows operating system. One of the most commonly used software for the millions and billions of people across the globe, MS Office. This course is annexures with the Internet concepts and commonly used PC utilities to manage your computer.
MS Office, one of the most popular software in every machine with MS Windows operating system. Microsoft Office is a suite of desktop productivity applications that is designed specifically to be used for office or business use. It is a proprietary product of Microsoft Corporation and was first released in 1990. Microsoft Office is available in 35 different languages and is supported by Windows, Mac and most Linux variants. It mainly consists of Word, Excel, PowerPoint, Access, OneNote, Outlook and Publisher applications. Besides desktop applications, Microsoft Office is available to use online or from cloud under a lighter (Office Web Apps) and full (Office 365) version.

This course suits everyone who learns the basics of computer operation and word processing, to carry on routine daily operations and help them land employment or advance an existing career.

  • Computer Operator
  • Office Assistant
  • Admin Assistant

Every individual who wants to create documents, statements, graphs, presentations, manage e-mails, etc. with one software.

INTRODUCTION TO COMPUTERS
• Computer Definition
• Data, Characters, Information
• ANSI, ASCII
• Advantages, Disadvantages
• Computer Architecture
• Memory, Types of memories
• Storage devices, Hardware
• Software, Classification
WINDOWS
• GUI Environment
• Keyboard shortcut keys
• Desktop features- Window, Icon
• Folder, Taskbar, Start Menu
• Calculator, MS Paint
• Notepad, Wordpad, Clipboard
• Date/Time properties
• Display properties, Screen Saver
• Mouse, RecycleBin
MS OFFICE
MS WORD
• Introduction to Word
• File – Open, Save, Close
• Backstage view, Ribbon
• Quick Access toolbar
• Create a document
• Page Setup, Page Layout
• Print Setup, Page break
• Count no. of words in a document
• Formatting text, paragraphs
• Add a heading, Clear formatting
• Add or remove text effects
• Line spacing, Paragraph spacing
• Set the default font
• Apply themes to documents
• Read documents in Word
• Show or hide formatting marks
• Proofreading a document
• Check spelling and grammar
• Find & Replace
• Look up words in the thesaurus
• Look up words in the dictionary
• Make text superscript or subscript
• Adding Pictures/WordArt
• Paragraph/Character Styles
• Bullets & Numbering
• Borders & Shading
• Footnotes and Endnotes
• Headers and Footers
• Page numbers, Date & Time
• Text Box, Screen shot
• Pictures & ClipArt
• WordArt, SmartArt graphics
• Create an organization chart
• Rotate text in a SmartArt graphic
• Add alternative text to any shape
• Add or delete a table
• Mail merge – Letters, Labels
• Compare documents
• Macros – Recording, Execution
• Tables – Drawing, Formatting
• Review tracked changes & comments
• Hyperlink, OLE
• Preview & Print Documents
• List of recently used files
• Keyboard Shortcuts
MS POWERPOINT
• Introduction to Powerpoint
• Design Slides, Create Presentation
• Working with Text, Tables, Shapes
• Working with Charts, Pictures
• Custom Animation, Custom Transition
• Organizing & Formatting Slides
• Rehearse timings
• Adding Graphics, Media Clips
(eg. video, audio)
• Using Slide Master, T ypes of Views
• Review Slide Show
• Delivering the Presentation
• Distributing the Presentation
MS ACCESS
• Introduction to MS Access
• Database, DBMS, RDBMS
• Create Database
• Manage Database
• Create Tables
– Design View
– Table Wizard
– Datasheet View
• Add Records to Table
• Update data using queries
• Create Queries
• Types of Queries
– Select, Crosstab, Maketable
– Append, Update, Delete
• Create Forms with UI controls
• Form Wizard
• Fine-tune Form
• Sort Data
• Filter Data
• Generate Reports
• Report Wizard
• Custom Reports
INTERNET
• World Wide Web, Web Server
• Webpage, Website
• Send E-mail
• Add attachments
• Browsing (information searching)
• Sending SMS
• Using Job portals
• Online Ticket booking
• Online Shopping
• Downloading files
PC UTILITIES
• CD writing
• Virus detection & removal
• Printing documents
• Managing Audio
• Backup data
MS EXCEL
• Introduction to Excel
• Introduction to Worksheets
• Introduction to Workbooks
• Cell, Column, Row, Range
• Entering / Editing data
• Copying / Moving data
• Reposition the data in cell
• Wrap text in a cell, Merge cells
• Move or copy cells / cell contents
• Copy specific cell contents
• Cell borders, Cell shading
• Text color, Text Formatting
• Gridlines, Sheet Background
• Selecting the cells
• Navigation in the worksheet
• Organizing the sheets
• Entering & Formatting Titles
• Worksheet calculations
• Formatting Rows/Columns
• Hiding Columns/Rows/Sheets
• Lock Cell
• Cell Alignment, Font styles
• Cell Formatting, Cell Styles
• Cell Referencing
• Row Height, Column Width
• Find, Replace, Goto
• Conditional Formatting
• Format as Table
• Number Series, Fill Handle
• Adding Formulas
• Formula bar, Status bar
• Math Functions
• Text Functions
• Date& Time Functions
• Logical functions
• IF function
• Add Pictures/Shapes
• W ordArt
• Smart Art graphic
• Screenshot
• Create Table
• Sort Data i n Table
• Filter Data i n Table
• Page Layout
• Themes, Colors, Effects
• Margins, Size, Orientation
• Page breaks, Page scaling
• Page background
• Print setup
• Print area, Print titles
• Gridlines, Headings
• Creating Graphs/Charts
• Types of Charts
• Insert Text Box
• Header & Footer
• Insert Object
• Insert Symbol
• Data Sort
• Data Filter
• Data Validation
• Macros – Record, Execute
• Add Header & Footer
• Workbook Views – types
• Freeze /Unfreeze panes
• Create Payrolls/Tables
• Keyboard shortcuts
ADVANCED EXCEL
• Add Smart Art objects
• Align objects, Themes
• Objects – Align / Group / Arrange
• Absolute Cell Referencing
• Calculation options
• Insert Page breaks
• Paste Links, Paste Special
• Working with Comments
• Lookup & Reference functions
• VLookup, HLookup
– Sheet to Sheet
– Sheet to Workbook
– Workbook to Workbook
• SumIF, CountIF, CountBlank
• Index, Match, Transpose
• Find, Search
• Replace, Substitute
• Naming Range
• Name box, Name Manager
• Enhancing Chart Titles
• Changing colors of Data bars
• Rotating Charts
• Sparklines • Slicer
• Signature Line
• Filter data
– Text, Number, Date, Color
• Advanced filter
• Custom List
• Custom Sort
• Get External Data
– from Access, Notepad
• Text to Columns
• Remove Duplicates
• Data Consolidation
• Pivot table
– Sort data, Filter data
– Refresh Pivot table data
• Pivot chart
• Data Subtotal
• What-if Analysis
• Scenarios, Scenario Manager
• Goal Seek,
• Data Table
• Formula Auditing
• Protect Workbook/Sheet
• Share Workbook
• Save Workspace
• Export Excel tables to Word
• Excel Options
• Reporting using Excel
– Financial statements
– Sales / Purchase Report
– Product Report
– Summary Report
– Business Reports
– Academic Reports
OTHER USES OF EXCEL
– Calendar
– Gantt Chart
– Meeting Agenda
– Invoices