Microsoft Office Complete Course
(MICROSOFT WORD, POWERPOINT, EXCEL & ACCESS)
මයික්රෝසොෆ්ට් ඔෆිස් සහතිකපත්ර සම්පූර්ණ පාඨමාලාව
මයික්රෝසොෆ්ට් ඔෆිස් සහතිකපත්ර සම්පූර්ණ පාඨමාලාව
MICROSOFT OFFICE COMPLETE COURSE
(MICROSOFT WORD, POWERPOINT, EXCEL & ACCESS)
මයික්රෝසොෆ්ට් ඔෆිස් පිළිබද සහතිකපත්ර සම්පූර්ණ පාඨමාලාව
Duration - Four Months
Course Fee - Rs. 4,000/=
Only Rs. 3,000/= (25% Discount)
පාඨමාලාව සදහා ලියාපදිංචි වීම සදහා පහත Take This Course මගින් ගොස් ලියාපදිංචි වන්න.
Lesson 01
About the Academy of Indelible Design
About the Course
About the Microsoft Office
About the Microsoft Word
History of Microsoft Word
Microsoft Office Software Pack Download
Microsoft Word Interface
Open a New Document
File Tab (Home | New | Open | Get Add - ins | Info | Save / Save as / History | Print | Share | Export | Transform | Close | Account | Feedback | Options)
Lesson 02
Typing
Sinhala Typing
Select Text
Home Tab
Clipboard - (Cut / Copy / Past / Format Painter) |
Font - (Fonts / Font Size / Increase Font Size / Decrease Font Size / Change Case / Clear All Formatting / Bold / Italic / Underline / Strikethrough / Subscript / Superscript / Text Effect and Typography / Text Highlight Color / Font Color)
Undo / Redo
Font Pack
Lesson 03
Home Tab
Paragraph - (Bullets / Numbering / Multilevel List / Decrease Indent / Increase Indent / Sort / Show & Hide / Alignments / Line and Paragraph Spacing / Shading / Borders) |
Style
Editing - (Find / Replace / Select)
Insert Tab
Pages - (Cover Page / Blank Page / Page Break)
Tables - (Table)
Table Design Tab
Table Style Options
Table Styles - (Shading)
Table Borders - (Borders Style / Line Style / Line Weight / Pen Color / Borders / Border Painting)
Table Layout Tab
Table - (Selects / View Gridlines / Properties)
Draw - (Draw Table / Eraser)
Rows & Columns - (Insert)
Merge - (Merge Cells / Split Cells / Split Table)
Cell Size - (AutoFit / Height ? Width / Distribute Rows / Distribute Columns)
Lesson 04
Table Layout Tab
Alignment - (Text Direction / Cell Margins)
Data - (Sort / Repeat Header Rows / Convert to Text / Formula)
Insert Tab
Illustrations - (Pictures)
Picture Format Tab
Adjust - ( Remove Background / Corrections / Color / Artistic Effects / Compress Pictures / Reset Picture)
Picture Styles - (Picture Border / Picture Effects / Picture Layout)
Accessibility - (Alt Text)
Arrange - (Position / Warp Text / Bring Forward / Send Backward / Selection Pane / Align / Group / Rotate)
Size - (Crop / Height / Width)
Insert Tab
Illustrations - (Shapes)
Shape Format Tab
Insert Shapes - (Edit Shape / Draw Text Box)
Shape Style - (Fill / Outline / Effects)
WordArt Style - (Fill / Outline / Effects)
Text - (Text Direction / Alight Text / Create Link)
Insert Tab
Illustrations - (Icons / 3D Models / SmartArt)
Lesson 05
Insert Tab
Illustrations - (SmartArt)
SmartArt Design Tab
Create Graphic - (Add Shape / Add Bullate / Text Pane)
Layouts
SmartArt Styles - (Change Colors)
Reset - (Reset Graphic)
Shape Format Tab
Shapes - (Edit in 2-D / Change Shape / Larger / Smaller)
Insert Tab
Illustrations - (Chart)
Chart Design Tab
Chart Layouts - (Add Chart Element / Quick Layout)
Chart Style - (Change Color)
Data - (Switch Row & Column / Select Data / Edit Data / Refresh Data)
Type - (Change Chart Type)
Insert Tab
Illustrations - (Screenshot)
Add ins - (Get Add ins / My Add ins / Wikipedia)
Media
Links - (Link / Bookmark / Cross Reference)
Comments
Header & Footer - ( Header / Footer / Page Number)
Text - (Text Box / Quick Parts / WordArt / Drop Cap / Signature Line / Date & Time / Object)
Symbols - (Equation / Symbol)
Lesson 06
Draw Tab
Tools - (Select / Draw with Touch / Eraser)
Pens
Convert - (Ink to Shape / Ink to Math)
Insert - (Drawing Canvas)
Design Tab
Document Formatting - (Color / Font / Paragraph Spacing / Effects / Set as Default)
Page Background - (Watermark / Page Color / Page Borders)
Layout Tab
Page Setup - (Margins / Orientation / Size / Columns / Breaks / Line Numbers / Hyphenation)
Paragraph
Arrange - (Position / Warp Text / Bring Forward / Send Backward / Selection Pane / Align / Group / Rotate)
View Tab
View - (Read Mode / Print Layout / Web Layout / Outline / Draft)
Immersive - (Immersive Reader)
Page Movement - (Vertical / Side to Side)
Shaw - (Ruler / Gridline / Navigation Pane)
Zoom - (Zoom / 100% / One Page / Multiple Pages / Page Width)
Window - (New Window / Arrange All / Split / View Side by Side / Synchronous Scrolling / Reset Window Position / Switch Window)
Macros - (Macros)
Share Point - (Properties)
Help Tab
Help - (Help / Contact Support / Feedback / Show Training)
Lesson 07
References Tab
Table of Contents - (Table of Contents / Add Text / Update Table)
Footnote - (Insert Footnote / Insert Endnote / Next Footnote / Show Notes)
Research - (Search)
Citations & Bibliography
Captions - (Insert Caption / Insert Table of Figures / Update Table / Cross Reference)
Index - (Mark Entry / Insert Index / Update Index)
Table of Authorities - (Mark Citation / Insert Table of Authorities / Update Table)
What is a Footnote
What is the Reference & Citation
Put the Citation
Put the References
Lesson 08
Create a Professional Letter
Mail Merge
What is Mail Marge
Mailing Tab
Create - (Envelopes / Labels)
Start Mail Merge - (Start Mail Merge / Select Recipients / Edit Recipient List)
Write & Insert Field - (Highlight Merge Field / Address Block / Greeting Line / Insert Field)
Preview Results - (Preview Results / Find Recipient / Check for Errors)
Finish - (Finish & Merge)
Review Tab
Proofing - (Spelling & Grammar / Thesaurus / Word Count)
Speech - (Read Aloud)
Accessibility - (check Accessibility)
Language - (Translate / Language)
Comments - (New Comments / Delete / Preview / Next / Show comment / ink Comment / Pen / Eraser)
Tracking - (Track Changes / All Markup / Shaw Markup / Reviewing Pane)
Changes - (Accept / Reject / Preview / Next)
Compare
Protect - (Block Authors / Restrict Editing)
Ink - (Hide Ink)
Lesson 09
Create a Simple Notice
Create a Professional Poster (Poster Design)
Create a Standard CV
Lesson 10
What is Microsoft PowerPoint
History of Microsoft PowerPoint
Microsoft PowerPoint Interface
Create a New PowerPoint Presentation
File Tab - (Home | New | Open | Get Add - ins | Info | Save / Save as / History | Print | Share | Export | Transform | Close | Account | Feedback | Options)
Open Presentation
Lesson 11
Typing
Create a Text Box
Home Tab
Clipboard - (Paste / Cut / Copy / Format Painter)
Slide - (New Slide / Layout / Reset / Section)
Font - (Font / Font Size / Increase Font Size / Decrease font Size / Clear All Formatting / Bold / Italic / Underline / Text Shadow / Strikethrough / Character Spacing / Change case / Text Highlight Color / Font Color)
Paragraph - (Bullets / Numbering / Decrease List Level / Increase List level / Line Spacing / Alignments / Add or Remove Columns / Text Direction / Align Text / Convert to SmartArt)
Drawing - (Arrange / Quick Styles / Shape Fill / Shape Outline / Shape Effects)
Editing - (Find / Replace / Select)
Insert Tab
Sliders - (New Slide)
Tables - (Table)
Table Design Tab
Table Style Options
Table Style - (Shading / Borders / Effects)
WordArt Style
Draw Borders - (Pen Style / Pen Weight / Pen Color / Draw Table / Eraser Table)
Table Layout Tab
Table - (Select / View Gridlines)
Rows & Columns - (Delete / Insert Above / Insert Below / Insert Right)
Merge - (Merge Cells / Split Cells)
Cell Size - (Height / Width / Distribute Rows / Distribute Columns)
Alignment - ( Text Direction / Cell Margins)
Table Size - (Height / Width / Lock Aspect Ration)
Arrange - (bring Backward / Send Forward / Selection Pane / Align / Group / Rotate)
Undo / Redo
Lesson 12
Import Image
Insert Tab
Images - (Pictures)
Picture Format Tab
Adjust - (Remove Background / Corrections / Color / Artistic Effects / Compress Pictures / Change Picture / Reset Picture)
Picture Styles - (Picture Border / Picture Effects / Picture Layout)
Accessibility - (Alt Text)
Arrange - (Bring Forward / Send Backward / Selection Pane / Align / Group / Rotate)
Size - (Crop / Height / Width)
Insert Tab
Images - (Screenshot | Photo Album)
Illustrations - (Shapes)
Shape Format Tab
Insert Shapes - (Edit Shape / Text Box / Merge Shapes)
Shape Style - (Shape Fill / Shape Outline / Shape Effects)
WordArt Style - (Text Fill / Text Outline / Text Effects)
Accessibility - (Alt Text)
Arrange - (Bring Forward / Send Backward / Selection Pane / Align / Group / Rotate)
Size - (Height / Width)
Insert Tab
Illustrations - (Icon | 3D Models | SmartArt)
SmartArt Design Tab
Create Graphic
Layouts
SmartArt Style - (Change Colors)
Reset - (Reset Graphic / Convert)
SmartArt Format Tab
SmartArt Shapes
Insert Tab
Illustrations - (Chart)
Chart Design Tab
Chart Layout - (Add Chart Element / Quick Element)
Chart Style
Data - (Switch Rows & Switch Columns / Select Data / Edit Data / Refresh Data)
Type - (Change Chart Type)
Chart Design Format Tab
Current Selection
Insert Tab
Add ins - (Get Add ins / My Add ins)
Link - (Zoom / Link / Action)
Comment
Text - (Text Box / Header & Footer / WordArt / Date & Time / Slide Number / Object)
Symbols - (Equation / Symbol)
Media - ( Video / Audio / Screen Recording)
Lesson 13
Draw Tab
Tools - (Select / Draw / Eraser / Lasso Select)
Pens - (Add Pens)
Stencils - (Ruler)
Convert - (Ink to Shape / Ink to Math)
Design Tab
Themes
Variants
Customize - (Slide Size / Format Background)
SD / HD
Review Tab
Proofing - (Spelling / Thesaurus)
Accessibility - (Check Accessibility)
Insights - (Search)
Language - (Translate / Language)
Comment - (New Comment / Delete / Previous / Next / Show Comment)
Compare - (Compare / Accept / Reject / Previous / Next / Reviewing / End Review)
Ink - (Hide Ink)
View Tab
Presentation Views - (Normal / Outline View / Slide Sorter / Notes Page / Reading View)
Master Views - (Slide Master / Handout Master / Notes Master)
Shaw
Zoom - (Zoom / Fit to Window)
Color/Grayscale - (Color / Grayscale / Black & White)
Window - ( New Window / Arrange All / Cascade / Move Split / Switch Window)
Macros
Help Tab
Help - (Help / Contact Support / Feedback / Shaw Training)
Lesson 14
What is the Transitions
How to Use Transitions
Transitions Tab
Preview
Transition to This Slide - (Effect options)
Timing - (Sound / Duration / Apply to All / On Mouse Click / After)
What is the Animations
How to Use Animations
Animation Tab
Preview
Animation - (Effect options)
Advanced Animation - (Add Animation / Animation Pane / Trigger / Animation Painter)
Timing - (Start / Duration / Delay / Recorder Animation)
Slide Show Tab
Start Slide Show - (From Beginning / From Current Slide / Custom Slid Show)
Set Up - (Set Up Slid Show / Hide Slide / Rehearse Timing / Record)
Monitors - (Monitor / Use Presenter View)
Record Tab
Record
Content - (Screenshot)
Auto Play Media - (Screen Recording / Video / Audio)
Save - (Save as Show / Export to Video)
Lesson 15
Presentation Guidelines
Presentation Rules
Lesson 16
Create a Professional Microsoft Presentation
Presentation Skills
Create a Animation Video
Create a Short Advertisement
Lesson 17
What is Microsoft Excel
History of Microsoft Excel
Microsoft Excel Interface
Create a new Workbook
File Tab - (Home | New | Open | Get Add - ins | Info | Save / Save as / History | Print | Share | Export | Transform | Close | Account | Feedback | Options)
Typing
Work in Cells
Create a Table
Home Tab
Clipboard - (Paste / Cut / Copy / Format Painter)
Font - ( Font / Font Size / Increase Font Size / Decrease Font Size / Bold / Italic / Underline / Bottom Border / Fill Color / Font Color)
Alignment - (Alignment / Orientation / Decrease Indent / Increase Indent / Wrap Text / Merge & Center)
Lesson 18
Home Tab
Number - (Number Format / Accounting Number Format / Percent Style / Comma Style / Increase Decimal / Decrease Decimal)
Styles - (Conditional Formatting / Format as Table / Cell Style)
Cell - (Insert / Delete / Format)
Editing - (AutoSum / Fill / Clear / Sort & Filter / Find & Select)
Add ins
Insert Tab
Table - (Pivot Table / Recommended Pivot Table / Table)
Illustrations - (Picture | Shapes | Icons | 3D Model | SmartArt | Screenshot)
Add ins - (Get Add ins / My Add ink)
Charts - (Recommended Chart / Maps / Picot Chart)
Tours - (3D Map)
Spark lines - (Line / Column / Win & Loss)
Filters - (Slicer / Timeline)
Link
Text - (Text Box / Header & Footer / WordArt / Signature line / Object)
Symbols - (Equation / Symbol)
Lesson 19
Draw Tab
Tools - (Select / Draw with Touch / Eraser / Lasso Select)
Pens
Convert - (Ink to Shape / Ink to Math)
Page Layout Tab
Themes - (Themes / Colors / Fonts / Effects)
Page Setup - (Margins / Orientation / Size / Print Area / Breaks / Background / Print Titles)
Scale to Fit - (Width / Height / Scale)
Sheet Options
Arrange - (bring Forward / Send Backward / Selection Pane / Align / Group / Rotate)
Review Tab
Proofing - (Spelling / Thesaurus / Workbook Statistics)
Accessibility
Insights
Language - (Translate)
Comments - (New Comments / Delete / Preview / next)
Protect - (Protect Sheet / Protect Workbook / Allow Edit Ranges / Unshare Workbook)
Ink
View Tab
Workbook View - (Normal / Page Break Preview / Page Layout / Custom Views)
Shaw
Zoom - (Zoom / 100% / Zoom to Selection)
Window - (New Window / Arrange All / Freeze Panes / Split / Hide / Unhide / View Side by Side / Synchronous Scrolling / Reset Window Position / Switch Windows)
Macros
Help Tab
Help - (Help / Contact Support / Feedback / Show Training)
Community - (Community / Excel Blog)
Lesson 20
Data Entry
How to Work in Microsoft Excel
Formula & Function
Functions -
SUM
AVERAGE
AVERAGEA
MIN
MAX
MINA
MAXA
RANK
LEN
COUNT
COUNTA
UPPER
LOWER
RROPER
IF (Pass & Fail)
IF (Grade)
Lesson 21
Functions -
AND
OR
MEDIAN
MODE
PRODUCT
COUNTIF
SUMIF
AVERAGEIF
ROUND
EVEN
ODD
SQRT
POWER
LOG
LOG10
SIN
COS
TAN
FACT
MOD
ROMAN
Formula Tab
Function Library - (Insert Function / AutoSum / Recently Used / Financial / Logical / Text / Date & Time / Lookup & Reference / Math & Trig / More Functions)
Defined Name - (Name Manage / Define Name / Use in Formula / Create from Selection)
Formula Auditing - (Trace Precedents / Trace Dependents / Remove Arrows / Show Formulas / Error Checking / Evaluate Formula / Watch Window)
Calculation - (Calculation Option / Calculate Now / Calculate Sheet)
Lesson 22
Data Tab
Get & Transform Data - (Get Data / From Text & CSV / From Table & Range / Recent Sources / Existing Connections)
Queries & Connections - (Refresh All / Queries & Connections / Properties / Workbook Links)
Sort & Filter - (Sort / Filter / Clear / Reapply / Advances)
Data Tools - (Text to Columns / Flash Fill / Remove Duplicates / Data Validation / Consolidate / Relationships / Manage Data Model)
Forecast - (What if Analysis / Forecast Sheet)
Outline - (Group / Ungroup / Subtotal)
Developer Tab
Code - (Visual Basic / Macros / Record Macro / Use Relative References / Macro Security)
Visual Basic Application and Macro
What is the Visual Basic Application
Make a Code
Create a Button
Developer Tab
Add Ins - (Add ins / Excel Add ins / COM Add ins)
Controls - (Insert / Design Mode / Properties / View Code / Run Dialog)
Lesson 23
What is the Microsoft Access
History of Microsoft Access
Microsoft Access Interface
Open the Database
Create a New Database
File Tab - (Home | New | Open | Get Add - ins | Info | Save / Save as / History | Print | Share | Export | Transform | Close | Account | Feedback | Options)
Home Tab
Views - (View)
Clipboard - (Paste / Cut / Copy / Format Painter)
Sort & Filter - (Filter / Ascending / Descending / Remove Sort / Selection / Advanced / Toggle Filter)
Records - (Refresh All / New / Save / Delete / Totals / Spelling / more)
Find - (Find / Replace / Go To / Select)
Text Formatting - (Font / Font Size / Bullets / Numbering / Increase List Level Decrease List Level / Left to Right text Direction / Bold / Italic / Underline / Font Color / Text Highlight Color / Background Color / Alignment / Gridlines / Alternate Row & Column)
Lesson 24
Create a Database (7 Steps)
Data Type - (Short Text / Long text / Number / Large Number / Date & Time / Date & Time Extended / Currency / Auto Number / Yes or No / OLE Object / Hyperlink / Attachment / Calculated / Lookup Wizard)
Field Properties
Data Entry
Lesson 25
Primary Key
What is Relationship
Create a relationship (10 Steps)
Lesson 26
What are the Queries
Create a Query (4 Steps)
Create a Query in Query Wizard
Lesson 27
What is the Form
Create a Form (5 Steps)
Creative Form Design
Lesson 28
What is the Report
Create a Report (7 Steps)
Print the Report
What is the Macro
Create a Macro (4 Steps)
Tute
Software
Microsoft Word Software Shortcut List
Daily Homework
Sinhala, Tamil & English Fonts 12000+
Sinhala Keyboard Layout
Tute
Software
Microsoft PowerPoint Software Shortcut List
Daily Homework
Sinhala, Tamil & English Fonts 12000+
Sinhala Keyboard Layout
Presentation Rules (PDF)
Presentation Skills (PDF)
Tute
Software
Microsoft Excel Software Shortcut List
Daily Homework
Sinhala, Tamil & English Fonts 12000+
Sinhala Keyboard Layout
Tute
Software
Microsoft Access Software Shortcut List
Daily Homework
Sinhala, Tamil & English Fonts 12000+
Sinhala Keyboard Layout