COUSE CONTENT IN WORD

• Word Introduction (Interface)
• Text Formatting (Font and Font size, Text color, Bold, Italic, Underline, Superscript, Subscript and Strikethrough)
• Clear Formatting
• Changing Case – Sentences Case, Lower Case, Upper Case and Toggle Case
• Highlighting and shading
• Introduction of International Paper sizes and Colors
• Text effects: outline, Shadow, Reflection, Glow, and number styles
• Word Options (Essential Setting of Words)
• Save, Save As
• Cut, Copy, Paste and Past Option
• Format Painter
• Bullets, Numbering, and multilevel list
• Indent and Special indent
• Tab Setting
• Paragraph Setting – Alignment, Line and Paragraph spacing
• Text Styles
• Find and Replace
• Select Option
• Cover Page, Blank page and Page Break
• Insert Tables – Table Style and Style Option, Shading and Borders, Delete & Insert Table, Raw and Columns, Merge and Adjustment.
• Illustrations (Insert Picture, Shapes, Icons, 3D Models, SmartArt, Chart, Screenshot)
  • Insert Picture – Remove Background, Adjustment, Picture Styles, Position, Wrap text and other Arrangement, Crop
  • Insert Shape – Different type of shape insert, Edit Shape, Shape Styles, WordArt Styles, Text on Shape, Position, Wrap text and other arrangements.
• Insert Online Videos
• Insert Hyperlink
• Insert Comment and manage
• Insert Header, Footer and Page Number
• Text Box
• WordArt
• Drop Cap
• Watermark
• Page Color
• Border and Page Borders
• Margin, Orientation, Page Sizes and Columns
• Table of Contents
• Citations
• References
• Footnote and Endnote
• Mail Merge
• Document Views options
• Document Protection
• Printing
• Spelling & Grammar
• Translate

 

COURSE CONTENT IN EXCEL

• BASIC EXCE
• Introduction Excel
• Page setup
• Data entry
• Data formatting
• Fill handle
• Format painter
• Cell styles
• Find and replace data
• Converting data type
• Sort and filters
• Charts
• Link
• Selection pane
• Insert picture, shapes, Icons, 3D models and Smart Art
• Table and format as table
• Protect sheet and workbook
• Workbook views
• Freeze panes
• Printing
• barcode creating

 

BASIC FORMULAS/ FUNCTIONS

• SUM
• COUNT
• AVERAGE
• MAX
• DATE FUNCTIONS
• MIN
• MODE
• MEDIAN
• SQRT
• ROUND
• ADD
• MINUS
• MULTIPLY
• DIVIDE
• RAND
• RANDBETWEEN

 

ADVANCED EXCEL

• Conditional formatting
• Paste options
• Pivot table
  • Creating
  • Short and filter
  • Calculate columns
  • Grouping
  • Formatting
  • Report filter pages
  • Value field setting
  • Pivoting slicers
  • Pivoting charts and Automated Dashboard
  • Update and refresh
• Cell referencing
• Named ranges
  • Introducing and working
  • Define names
  • Name manager
• Formula Auditing
• Data validation
• Macros
• Text to columns
• Remove duplicates
• Consolidate
• Goal seeks
• Insert Table on web
• Flash Fill
• Data from Picture
• Sparklines

 

 

ADVANCED FORMULAS

• IF
• IFS
• PMT
• SWITCH
• CHOOSE
• IFERROR
• LOOKUP
• VLOOKUP
• HLOOKUP
• IF LOOKUP
• NESTED IF
• AND, IF AND
• OR, IF OR
• SUMPRODUCT
• SUMIF AND SUMIFS
• AVERAGEIF AND AVERAGE IFS
• TRIM
• + More functions

 

COURSE CONTENT IN POWEPOINT AND ACCESS

POWEPOINT 2019

• PowerPoint Introduction
• New Slide, Layout, Section
• Format Background
• Screen Recording
• Design
• Transitions
• Animations
• Slide Show
• Record
• Save as Show
• Export to Video
• Presentation View
• Master View
• Print

 

ACCESS 2019

 

• Access Introduction
• Table Design
• Query Wizard
• Views
• Form
• Report
• Print

 

INTERNET AND EMAIL

• Introduction of Internet
• WWW
• Types of viruses
• How to protect from virus
• Most used website for educations and job environment
• Email Account Creating
• Verify phone number
• Writing emails
• Signature and more setting
• Two factors protection and recovery option

 

INTRODUCTION OF COMPUTER AND SYSTEM

• Hardware, Software and Information Technology
• Type of Computers
• Main Part of a Personal Computer
• Type of Hard Drives
• Input, Output and Peripheral Devices
• Memory and memory measurement
• Type of Software
• Networking
• Internet, Intranet and Extranet
• IP Address
• Windows 10 and 11

 

GOOGLE

• Google Sheet, Docs and Slide
• Google Drives
• Google Form
• Google Alert and Trends
• Google Gemini

 

OTHERS

• Sinhala Typing
• ChatGPT
• QR Code and Barcode
• PDF
• File transfer

 

OUR OTHER PROGRAM

DEGREE

• LLM (HONS) – Master of International & Commercial Low
• LLB (HONS) – Bachelor of Laws
• BA (HONS) – Business Management
• BSc (HONS) – IT
  • BSc (HONS) COMPUTING – CYBER SECURUTY
  • BSc (HONS) COMPUTING – INFORMATION SYSTEM
  • BSc (HONS) COMPUTING – NETWORK SYSTEMS

 

HIGHER NATIONAL DIPLOMA

• HND in Information Technology
• HND in Business Management

DIPLOMA

• Diploma in IT
• Diploma in Digital Marketing

 

ADVANCED CERTIFICATE

• Advanced Certificate in Computer Literacy

CERTIFICATE

• Certificate in Entrepreneurship and Business Start Up
• Certificate in Digital Marketing
• Certificate in Web Designing
• Certificate in English
• Certificate in Japanese
• Certificate in Korean
• Certificate in Tamil
• Certificate in IT