This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Sunday, August 30, 2015

2015-07-11 MS EXCEL-2013

10:52 AM    No comments

WELCOME TO MY PORT FORLIO




Diploma in Information Literacy and Informatin and Communication Technology 2015-DICT 03016


01 අන්තර්ගතය
MS EXCEL 2013

02 පූර්ව දැනුම
MS EXCEL 2013 සම්බන්ධව දැනුමක් නොවිය

03 නව දැනුම
MS EXCEL 2013 File එකක් විවෘත කරන අයුරු ඉගෙන ගතිමි
Cell adress ,work sheet ,work book ,sheet rename ,sheet delete,hide ,unhide ,sheet password ඉගෙන ගතිමි 
wrap text ,යොදනඅයුරු cell එකක් තුල ඇති text ,copy & move  සිදු කරන අයුරු ඉගෙන ගතිමි
Cell Merge සිදු කරන අයුරු ඉගෙන ගතිමි

INTRODUCTION TO MS-EXCEL Excel is a computer program used to create electronic spreadsheets. Within exc...



THE THREE PARTS RIBBONS OF THE RIBBON ARE ...
WORKING WITH CELLSTO COPY AND PASTE CONTENTS:Select the cell or cells you wish to copy.Click the Copy command in the Clipb...

FORMATTING TEXTTO FORMAT TEXT IN BOLD, TO CHANGE THE FONT STYLE:ITALICS OR UNDERLINE: ...

FORMATTING TEXTTO CHANGE THE FONT SIZE: TO ADD A BORDER:Select the cell or cells you want to Select the ...
FORMATTING TEXTTO CHANGE THE TEXT COLOUR: TO ADD A FILL COLOUR:Select the cell or cells you want to format. Select the c...
CONDITIONAL FORMATTING TO APPLY CONDITIONAL FORMATTING: Select the cells you would like to format. Select the ...
TO INSERT ROWS & COLOUMS NOTE: ...

EDITING- FILL  IN THE LOWER RIGHT HAND CORNER OF THE ACTIVE CELL IS EXCEL’S “FILL HANDLE”.WHEN YOU HOLD YOUR MOUSE...
SORTING TO SORT IN ALPHABETICAL ORDER: Select a cell in the column you want to sort (In this example, we choose a cell in ...

CELL REFERENCING A RELATIVE ...
CELL REFERENCING AN ABSOLUTE ...
CELL REFERENCING A MIXED ...
FUNCTIONS SYNTAX OF DATEDIF =DATEDIF(START_DATE,END...
FUNCTIONS SYNTAX OF SUMIF =SUMIF(RANGE,CRITERIA,SUM_RANGE) RANGE- ...
FUNCTIONS SYNTAX OF IF =IF(LOGICAL TEXT, VALUE IF TRUE, VALUE IF FALSE) ...
COUNT FUNCTIONS SYNTAX OF FUNCTIONS 1. ...

TEXT FUNCTIONS SYNTAX OF FUNCTIONS 1. LOWER FUNC...

TEXT FUNCTIONS SYNTAX OF FUNCTIONS ...
04ඉගෙනුම් ක්‍රමවේදය-හොදයි
05 විස්ථාරණිය අධ්‍යනය-
https://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html

Read More

Friday, August 28, 2015

2015-07-04 MS POWER POINT-2013

3:28 AM    No comments

WELCOME TO MY PORT FORLIO




Diploma in Information Literacy and Informatin and Communication Technology 2015-DICT 03016

01පූර්ව දැණුම-නොවීය

 02නවතම දැණුම-







Template සදහා  desing දැවිම


පින්තුර එකතු කිරිම








Table එකතු කිරිම




















smart Art එකතු කිරිම









Hperlinks එකතු කිරිම


Animation එකතු කිරිම













Video එකතු කිරිම











04ඉගෙණුම් ක්‍රමවේදය-හොදයි
05විස්තාරණිය තොරතුරු ගවේශණය-
https://www.youtube.com/watch?v=_w-TCKVTdSk




Read More

Wednesday, August 26, 2015

2015-06-27 MS WORD

6:18 PM    No comments

WELCOME TO MY PORTFOLIO



Diploma in Information Literacy and Informatin and Communication Technology 2015-DICT 03016
01අන්තර්ගතය-MS WORD
02පූර්ව දැණුම-නොවීය
03නවතම දැණුම-






Read More
Subscribe to: Posts (Atom)