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)

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

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) 

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)

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) 

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) 

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

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) 

Create a Simple Notice

Create a Professional Poster (Poster Design)

Create a Standard CV 

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

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

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) 

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) 

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) 

Presentation Guidelines

Presentation Rules 

Create a Professional Microsoft Presentation

Presentation Skills 

Create a Animation Video

Create a Short Advertisement  

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) 

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) 

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) 

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) 

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) 

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) 

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) 

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 

Primary Key

What is Relationship

Create a relationship (10 Steps)

What are the Queries

Create a Query (4 Steps) 

Create a Query in Query Wizard 

What is the Form

Create a Form (5 Steps)

Creative Form Design 

What is the Report

Create a Report (7 Steps)

Print the Report

What is the Macro

Create a Macro (4 Steps)