Microsoft Office Complete Course
(MICROSOFT WORD, POWERPOINT, EXCEL & ACCESS)

• 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) 

Microsoft Word

• Tute

• Software  

• Microsoft Word Software Shortcut List

• Daily Homework

• Sinhala, Tamil & English Fonts 12000+

• Sinhala Keyboard Layout

Microsoft PowerPoint

• Tute

• Software  

• Microsoft PowerPoint Software Shortcut List

• Daily Homework

• Sinhala, Tamil & English Fonts 12000+

• Sinhala Keyboard Layout

• Presentation Rules (PDF)

• Presentation Skills (PDF)

Microsoft Excel

• Tute

• Software  

• Microsoft Excel Software Shortcut List

• Daily Homework

• Sinhala, Tamil & English Fonts 12000+

• Sinhala Keyboard Layout

Microsoft Access

• Tute

• Software  

• Microsoft Access Software Shortcut List

• Daily Homework

• Sinhala, Tamil & English Fonts 12000+

• Sinhala Keyboard Layout