Course Content - Basic to Adv. MS Office Course

 

Basic to Advanced MS Office Applications Certificate Course

පාඨමාලා අන්තර්ගතයන් -

Microsoft Word Basic to Advanced Course Contents

• ·         MS Word Introduction
• ·         How to Open/New/Save documents
• ·         Basic Texting (Sinhala / English Typing)
• ·         Text Formatting
• ·         Paragraphs Formatting
• ·         Indents and Tabs
• ·         Tabs for creating table of contents
• ·         Find and Replace option
• ·         Bullets and Numbering
• ·         Page Layouts
• ·         Header Footer
• ·         Page Numbering
• ·         Picture Text Wrapping
• ·         Picture Formatting
• ·         Inserting Shapes
• ·         Inserting Tables
• ·         Inserting Charts
• ·         Smart Art Graphics
• ·         Inserting Text Box
• ·         Inserting Hyperlinks
• ·         Inserting Equations in MS Word
• ·         Align/ Arrange/ Group
• ·         Column Break and Page Break
• ·         Spelling Checker
• ·         Styles for Docs
• ·         Mail Merge
• ·         References tab ( Citation, Table of content, Table of figures)
• ·         Creating Professional Reports (Eg: Management Reports, University reports..)
• ·         Creating cover pages
• ·         Creating templates for 
• Calendars
• Business letter
• Resumes (CV) and cover letters
• Newsletter
• Reports
• Invoices and bills
• Certificates
• ·         Word for artistic designing ( Eg: Birthday Card, Invitation cards…)
• ·         Word for Creative Designing (Eg: Brochures and flyers)
• ·         Creating layouts for books and Magazines
• ·         Macros in MS Word

 

 

Microsoft Excel Basic to Advanced Course Contents

• ·         Introduction to MS Excel
• ·         Basics of Cells
• ·         Modifying Columns Rows and Cells
• ·         Cell Formatting
• ·         Number Formats
• ·         Basics of Data Storing
• ·         Basics of Data Organizing
• ·         Start to Formulas
• ·         Complex Formulas
• ·         Relative and Absolute Reference
• ·         Excel Functions
• ·         Freezing Panes
• ·         Sorting Data
• ·         Filtering Data
• ·         Excel Tables
• ·         Excel Charts
• ·         Conditional Formatting
• ·         Pivot Tables
• ·         Sub Total
• ·         Range Names
• ·         Lookup Functions
• ·         The INDEX Function
• ·         The MATCH Function
• ·         Text Functions
• ·         Date Functions
• ·         Excel Financial Functions
• ·         Depreciation Functions
• ·         IF Analysis
• ·         The COUNTIF, COUNTIFS, COUNT,COUNTA, and COUNTBLANK Functions
• ·         The SUMIF, AVERAGEIF, SUMIFS and AVERAGEIFS Functions
• ·         Pivot Tables and Slicers to Describe Data
• ·         Data Validation
• ·         Summarizing Data
• ·         Consolidating Data
• ·         Reporting and Visualization of analyzed data
• ·         Macro Recorder
• ·         Creating Accounting models
• ·         Creating Dynamic Dashboards

 

Microsoft PowerPoint Basic to Advanced Course Contents

• ·         MS PowerPoint Introduction 
• -     Introduction to Presentations
• ·         Basics of Slides
• ·         Text Formatting
• ·         Paragraph Formatting
• ·         Designing Backgrounds
• ·         Designing customized themes for Slides
• ·         Slide Transitions
• ·         Slide Animations
• ·         Action Buttons and hyperlinks
• ·         Inserting Audio Files
• ·         Inserting Video Files
• ·         Inserting Tables
• ·         Inserting Charts
• ·         Inserting Smart Arts
• ·         Inserting Objects ( Eg: MS Excel Sheets, MS Word..)
• ·         Slide Show techniques
• ·         Recording and Rehearsing Slide Shows
• ·         Creating Lecture notes, Tutorials and Handouts
• ·         Creating Animation Videos for Advertising
• ·         Creating Templates for Professional presentations
• ·         Macros in PowerPoint
• ·         Protecting and Printing the Slide show

 

 

Microsoft Access Basic to Advanced Course Contents

• ·         Introduction to MS Access
• ·         Introduction to Databases
• ·         Databases and Objects
• ·         Work with Tables
• ·         Work with Forms
• ·         Database Tools
• ·         Database Designing
• ·         Importing data from external sources
• ·         Sorting and filtering data
• ·         Creating a Simple Query
• ·         Creating a Multi Table Query
• ·         Creating Relationships among tables
• ·         Primary key and Foreign key theory
• ·         More Query Design Options
• ·         Creating Simple Reports
• ·         Creating  Advanced Reports
• ·         Advanced Report Options
• ·         Macros in Database Management
• ·       Creating a fully functioning database model 

• Internet and E-Mail Basic to Advanced Course Contents

•  Introduction to Internet  
• Internet Operations
• Internet Services
• URL
• IP Addresses
• Domain Name Server (DNS)
• Protocol
• E Mail
• Social Networks/ Social Media
• Multimedia
• Artificial Intelligence for MS Office