Sales & Support  +94 77 324 1602

 
Basic Computing
• Basic Computer Course (BCC)
           
Office Application
• Master In Microsoft Excel
• Master In Microsoft Power Point
• Master In Microsoft Outlook
Internet Training
Graphic Design
3D Modeling & Animating
• Master In Maya
 
Video Editing
• Master In Adobe Premier
• Master In Adobe After Effects
Photo Editing
• Master In Adobe Photoshop
• Master In GIMP
Web Design & 2D Animation
• Master in Adobe Dreamweaver
• Master in Joomla Web Design
• Master in Web Hosting
• Master in SEO
Master In Adobe FLASH
         
Architectural Design
• Master In Auto CAD-2D
• Master In Auto CAD-3D
Auto CAD BLOCKS
• Master In 3D MAX
• Master In AutoCAD Architecture
Hardware & Networking
• Master In Networking
Programing & Database
• Master in Visual Basic.net
• Master In Microsoft Access
• Master In Microsoft SQL
• Master In Java Programming
   
CUSTOMER CARE
PIXEL ART Co. (PVT) LTD
Production House
219, New Town, Digana, Rajawella
Kandy. Sri Lanka
Sales / Support
081 5626260
Hot line
077 3241602
Master In Microsoft Office 2007-2010-2013 (Word / Excel / PowerPoint)    
Master in Microsoft Office teaches you how to prepare word documents, functions related to Excel, calculations and analysis as well as Power point presentations which are very much important in official activities. This package includes Microsoft Word, Excel & PowerPoint.
  Total Time : 12 hrs
Number of Movies : 210
Number of Discs : 2
Disk Type : CD (Data)
Language : Sinhala (Singlish)
Compatible Versions : Microsoft Office 2007 , 2010 & 2013
       
Price : 990 LKR
       
Course contain - Microsoft WORD   Course contain - Microsoft EXCEL
  • Look Around 
    • Opening Ms Word
    • Ms Word Interface 
    • Using the Document Views 
  • Getting Start 
    • Creating a New Document Sample Movie
    • Using Page setup Sample Movie
    • Insert, Edit & Text Navigation / Deleting text
    • Selecting Options Sample Movie
    • Redo & Undo / Repeat
    • Cut, Copy, Move Text
    • Rule, Grid lines & Document map
    • Zooming Options
    • Switching Windows
    • Use Find and Replace 
    • Close a Document & Exit word
  • Save and Printing Documents 
    • Save & Save as a Word Document / File Extensions
    • Open & Open Recent Document 
    • Print preview a Document 
    • Print set up & print a Document 
    • Save Document as a Template 
  • Text & Paragraph formatting
    • Changing the Font, Formatting Font & Styles 
    • Apply Indents and Spacing 
    • Set Tabs & Modify Tabs 
    • Paragraph Aligning
    • Paragraph Borders & Paragraph Shading 
    • Insert Bullets & Numbers
    • Creating multilevel list
    • Apply, Change & Create Styles 
  • Combine Graphics and Text 
    • Insert a Screen Capture 
    • Insert a Word Art 
    • Insert a Photo & Clip Art 
    • Insert a Smart Art 
    • Insert a Shape & Format a Shape 
    • Arranging & Aligning Objects
    • Use a Drop Cap 
    • Add a Symbol 
    • Use a Theme 
    • Add a Page Border 
    • Text Wrapping
    • Insert a Watermark 
  • Using Long Documents  
    • Insert a Page Number  Sample Movie
    • Insert a Hyperlink 
    • Working with Headers & Footers 
    • Work with Columns 
    • Insert a Section Break 
    • Line Numbering 
    • Add a Cover Page 
    • Create a Bookmark 
  • Table & Charts
    • Insert a Table & Design ribbon
    • Working with Tables
    • Perform Table Calculations
    • Insert a Chart 
  • Letters & Mails
    • Create Envelopes
    • Mail Merge for Letters
    • Mail Merge for Envelopes
    • Letter & Mail Tools
  • Review Documents 
    • Correct Your Spelling & Grammar
    • Getting a Word Count 
    • Add a Comment 
    • Use Auto Correct to Reduce Mistakes & Save Time 
    • Use Smart Tags 
    • Use the Thesaurus 
    • Translate a document
    • Customize the Dictionary 
    • Auto Recover 
    • Track Changes 
    • Accept or Reject Changes 
    • Mark Document as Final 
    • Inspect a Document 
    • Compare Documents Side by Side 
    • Combine Documents 
    • Print Changes 
    • Hide Text
  • Introduction to Ms Excel
    • Opening Ms Excel
    • Ms Excel Interface 
    • Using Ms Excel Help 
  • Working with Worksheets & Workbooks 
    • Creating a New Workbook  Sample Movie
    • Adding & Deleting Data  Sample Movie
    • Naming & Saving a Workbook 
    • Working with Multiple Worksheets 
    • Closing Workbook & Exiting excel
    • Opening a Workbook
    • Importing Data into Excel 
    • Protecting a work sheet & a Work book
    • Password protection
  • Editing Techniques 
    • Selecting Cells, Rows & Columns 
    • Cut, Copy & Paste
    • Copy & Paste Special 
    • Editing or Replacing Content in a Cell 
    • Undo & Redo
    • Adjusting Row, Column Height & Width 
    • Inserting and Deleting Rows, Columns & Cells 
    • Merging & Splitting Cells 
    • Clearing a Cell 
    • Finding and Replacing Data 
    • Using Auto Fill 
  • Customizing Excel
    • Freezing and Locking Cells 
    • Hiding and Showing Rows / Columns / Sheets 
    • Using Different Views 
    • Displaying Grid lines and Headings 
    • Using Excel Options
  • Changing the Appearance of a Worksheet 
    • Formatting fonts
    • Using alignments & Wrap Text 
    • Using numbering
    • Using 1000 separator for valves
    • Table boarder & Fill styles
    • Using Conditional formatting & styles
    • Using Document Themes 
    • Setting Page Layout Options 
    • Adding Headers & Footers 
    • Setting Page Breaks 
  • Working with Formulas 
    • Introduction to Formulas
    • Creating simple Formulas with Cell References
    • Using Operators 
    • Calculating Totals with Auto Sum 
    • Creating Formulas with Functions 
    • Common Functions 
  • Working with Functions 
    • Average Sample Movie
    • int
    • Round
    • Sqrt
    • Max
    • Min
    • Mod
    • Count
    • Count blank
    • Sin
    • Cos
    • Tan
    • Pi
    • Odd
    • Even
    • Factorial
    • Permute
    • Combine
    • If 1
    • If 2
    • If 3
    • Creating Names & Creating Formulas with Names 
    • Error Checking & Common Errors
  • Working with Data 
    • Sorting an Excel Table 
    • Filtering an Excel Table 
    • Validating Data 
    • Removing validations
    • Linking Data between Worksheets 
    • Using text to columns
    • Removing duplicate rows
    • Using Macros
  • Working with Tables
    • Creating & Formatting Excel Table Data 
    • Working with Excel Table Rows & Columns 
    • Calculating Table Data Totals 
    • Reset a Table
  • Charts and Graphics 
    • Chart Types & Creating a Chart
    • Formatting a Chart – Design tab
    • Formatting a Chart – Layout tab
    • Formatting a Chart – Format tab
    • Moving and Deleting a Chart 
    • Importing Graphics into Excel & Modifying
  • Printing & Work with Other Applications
    • Saving Files in Other Formats 
    • Publishing an Excel Worksheet 
    • Printing
             
  Course contain - Microsoft POWERPOINT
  • Getting Start Power Point
    • Starting Power Point
    • Power Point Interface 
    • Starting with a Blank Presentation 
    • Inserting a New Slide & Slide Layout Sample Movie
    • Page setup Sample Movie
    • Reset & Delete slides
    • Saving a Presentation 
    • Open & Open a resent Presentation 
    • Redo, Undo & Repeat
    • Cut, Copy, Move & Delete 
    • Ruler, Grid lines & Document map
    • Zooming Options
    • Using the Document Views  Sample Movie
    • Closing Presentation & exiting Power Point
  • Working with Text 
    • Entering Text, Managing, Resizing, Rotating Text
    • Formatting text
    • Entering paragraph Text & Formatting
    • Working with Bullets and Numbering 
    • Text Direction & Line spacing
    • Using Spell Checkers
    • Using Find & Replace
  • Working with Shapes & Graphics 
    • Drawing shapes & using styles
    • Working with Objects
    • Drawing a Curve & formatting
    • Working with Smart Art Graphics 
    • Working with Word Art 
    • Inserting a Photo, Resizing & Rotating & Formatting
    • Working with Clip Art & Formatting Clip Art 
  • Working with Tables and Charts 
    • Inserting a Table  
    • Formatting Tables 
    • Inserting a Chart 
  • Using Themes & Quick Styles 
    • Using Theme for slides, Modifying Theme Color, Fonts & effects
    • Work with Slide Background 
    • Applying & Editing Quick Styles 
  • Working with Multimedia & Links
    • Inserting Movies & work with options
    • Inserting Audio Clips & work with options
    • Record a sound
    • Working with Hyperlinks 
    • Working with Action buttons
    • Inserting Date, Time & Slide numbers
  • Applying Animations & Transitions
    • Understanding & Applying Transitions
    • Understanding & Applying Animations
    • Creating Custom Animation for Objects
    • Creating Custom Animation for Text
    • Path Animations 
  • Preparing Final Presentation
    • Sorting Slides 
    • Using Hidden Slides
    • Setup slide show & Setup monitors
    • Creating Custom Shows 
    • Viewing & Publishing the Presentation
    • Creating Speaker Notes & Hand outs
    • Keyboard Shortcuts for Moving Between Slides 
 
..........................................................
..........................................................
 
|Self Learning CDs | Educational CDs | Computer Software Tutorials | Computer Courses | Sinhala Medium Training CDs |Computer Clases |Learning Programs |