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
Comments
Post a Comment