မိတဆ
် က်
Yadanar More & More Family Group of Companies Limited ရှိ ဝန်ထမ််းမ ာ်းအာ်း သက်ဆိုင
ှိ ရ
် ာ လိုပ်ငန််းခွင်
ကျွမ််းက င်မှု အရည်အသသွ်းမ ာ်း တှိို်းတက်လာသေရန် Learning & Development Department မှ အစဉ်တစိုက် ကက ြိုးစ ြိုးလျက်
ရှပါသည်။ ကိုမဏ
ပ မ
ီ ှ ချမှတထ
် ြိုးသသ Mission မျ ြိုးမှ သအ က်ပါအတင
ို ြိုး် ဖြစ်ပါသည်။
“တီထင
ွ ဆ
် န််းသစ်မှု၊ ယကုံ ြည်စိတခ
် ျရမှုမျာ်းြိုံ ရတနာချစ်သမ
ူ ျာ်းအာ်း ဦ်းဆဆာင်မိတဆ
် ြ်ဆသာ အဖွွဲ့အစည််းတစ်ရပ်
ဖဖစ်တည်ရန်။”
“စွမ််းဆဆာင်ရည်ဖမငမ
် ာ်းဆသာ ဝန်ထမ််းမျာ်းနှငအ
် တူ တိ်းုံ တြ်ဆအာင်ဖမင်ဆသာ အဖွွဲ့အစည််းတစ်ရပ် ဖဖစ်တည်ရန်။”
ကိုမပဏ၏
ီ Mission နှငအ
် ညီ ေွမ််းသဆာင်ရည်မမငမ
် ာ်းသသာ ဝန်ထမ််းမ ာ်း သပေါ်ထက
ွ ်လ သစရန် Microsoft Office ကို ကျွမ်ြိုးကျင်စွ
အသိုြိုးဖပ နင
ို ဖ် ခင်ြိုး သည် အသရ်းကကီ်းသသာ အခန််းကဏ္ဍပါဝင်သည်။
ရည်ရွယ်ချက်
ဝန်ထမ်ြိုးမျ ြိုး အသနဖြင ် သနစဉ် လိုပ်ငန်ြိုးသ င်တ မျ ြိုးသ င်ရွကရ
် တွင ် နည်ြိုးပည ကို အသြိုးို ဖပ ၍ ပိုမိုကျွမြိုး် ကျင်စွ
သ င်ရွက်နင
ို သ
် စရန်
Microsoft Office ကှိို ကျွမ််းက င်ေွာ အသ်းို မပြု၍ အလိုပ်လိုပ်သဆာင်မှုေွမ်း် ရည် တှိို်းတက်သေရန်နင ် အလိုပ်
လိုပ်သဆာင်မှု မ ာ်းကှိို ပှိိုမလ ွ ်ကူမမန်ဆန်သေရန်
ှိို ယ
Table of Contents
MS WINDOWS, COMPUTER BASICS ................................................................................................................................................ 4
MS WORD Module 1: Text Basics ..................................................................................................................................................... 4
Module 2: Text Formatting and saving file ............................................................................................................................... 4
Module 3: Working with Objects .................................................................................................................................................. 4
Module 4: Header & Footers ......................................................................................................................................................... 5
Module 5: Working with bullets and numbered lists .......................................................................................................... 5
Module 6: Tables ................................................................................................................................................................................ 5
Module 7: Styles and Content ....................................................................................................................................................... 5
Module 8: Merging Documents .................................................................................................................................................... 6
Module 9: Sharing and Maintaining Document .................................................................................................................... 6
Module 10: Proofing the document ............................................................................................................................................ 6
Module 11: Printing ........................................................................................................................................................................... 7
MS EXCEL Module 12: Introduction to Excel ............................................................................................................................... 7
Module 13:Formatting excel work book: ................................................................................................................................... 7
Module 14: Perform Calculations with ....................................................................................................................................... 7
Module 15: Sort and Filter Data with Excel............................................................................................................................... 8
Module 16: Create Effective Charts to Present Data Visually ............................................................................................ 8
Module 17: Analyze Data Using PivotTables and Pivot Charts ......................................................................................... 8
Module 18: Protecting and Sharing the work book .............................................................................................................. 9
Module 19: Use Macros to Automate Tasks ............................................................................................................................ 9
Module 20: Proofing and Printing................................................................................................................................................ 9
MS POWERPOINT Module 21: Setting Up PowerPoint Environment: ............................................................................. 10
Module 22: Creating slides and applying themes............................................................................................................... 10
Module 23: Working with bullets and numbering .............................................................................................................. 10
Module 24: Working with Objects ............................................................................................................................................ 11
Module 25: Hyperlinks and Action Buttons ........................................................................................................................... 11
Module 26: Working With Movies and Sounds ................................................................................................................... 11
Module 27: Using SmartArt and Tables .................................................................................................................................. 11
Module 28: Animation and Slide Transition .......................................................................................................................... 12
Module 29: Using slide Master................................................................................................................................................... 12
Module 30: Slide show option .................................................................................................................................................... 12
Module 31: Proofing and Printing............................................................................................................................................. 12
INTERNET & E-MAIL ........................................................................................................................................................................... 13
Course Content
MS WINDOWS, COMPUTER BASICS
OPERATING COMPUTER USING GUI BASED OPERATING SYSTEM
Introduction
Basics of Operating System
The User Interface
Task Bar
Icons
Menu
Running an Application
Operating System Simple Setting
Changing System Date And Time
Changing Display Properties
To Add Or Remove A Windows Component
File and Directory Management
MS WORD Module 1: Text Basics
Typing the text, Alignment of text
Editing Text: Cut, Copy, Paste, Select All, Clear
Find & Replace
Module 2: Text Formatting and saving file
New, Open, Close, Save, Save As
Formatting Text: Font Size, Font Style
Font Color, Use the Bold, Italic, and Underline
Change the Text Case
Line spacing, Paragraph spacing
Shading text and paragraph
Working with Tabs and Indents
Module 3: Working with Objects
Shapes, Clipart and Picture, Word Art, Smart Art
Columns and Orderings - To Add Columns to a
Document
Change the Order of Objects
Page Number, Date & Time
Inserting Text boxes
Inserting Word art
Inserting symbols
Inserting Chart
Module 4: Header & Footers
Inserting custom Header and Footer
Inserting objects in the header and footer
Add section break to a document
Module 5: Working with bullets and numbered lists
Multilevel numbering and Bulleting
Creating List
Customizing List style
Page bordering
Page background
Module 6: Tables
Working with Tables, Table Formatting
Table Styles
Alignment option
Merge and split option
Module 7: Styles and Content
Using Build- in Styles, Modifying Styles
Creating Styles, Creating a list style
Adding internal references
Table of contents and references
Adding a Footnote
Adding Endnote
Module 8: Merging Documents
Typing new address list
Importing address list from Excel file
Write and insert field
Merging with outlook contact
Preview Result
Merging to envelopes
Merging to label
Setting rules for merges
Finish & Merge options
Module 9: Sharing and Maintaining Document
Changing Word Options
Changing the Proofing Tools
Managing Templates
Restricting Document Access
Using Protected View
Working with Templates
Managing Templates
Understanding building blocks
Module 10: Proofing the document
Check Spelling As You Type.
Mark Grammar Errors As You Type.
Setting AutoCorrect Options
Module 11: Printing
Page Setup, Setting margins
Print Preview, Print
MS EXCEL
Module 12: Introduction to Excel
Introduction to Excel interface
Understanding rows and columns, Naming Cells
Working with excel workbook and sheets
Module 13:Formatting excel work book:
New, Open, Close, Save, Save As
Formatting Text: Font Size, Font Style
Font Color, Use the Bold, Italic, and Underline
Wrap text, Merge and Centre
Currency, Accounting and other formats
Modifying Columns, Rows & Cells
Module 14: Perform Calculations with Functions
Creating Simple Formulas
Setting up your own formula
Date and Time Functions, Financial Functions
Logical Functions, Lookup and Reference
Functions Mathematical Functions
Statistical Functions, Text Functions.
Module 15: Sort and Filter Data with Excel
Sort and filtering data
Using number filter, Text filter
Custom filtering
Removing filters from columns
Conditional formatting
Module 16: Create Effective Charts to Present Data Visually
Inserting Column, Pie chart etc.
Create an effective chart with Chart Tool
Design, Format, and Layout options
Adding chart title
Changing layouts
Chart styles
Editing chart data range
Editing data series
Changing chart
Module 17: Analyze Data Using PivotTables and Pivot Charts
Understand PivotTables, Create a PivotTable
Framework Using the PivotTable and PivotChart
Create Pivot Chart from pivot Table.
Inserting slicer
Creating Calculated fields
Module 18: Protecting and Sharing the work book
Protecting a workbook with a password
Allow user to edit ranges
Track changes
Working with Comments • Insert Excel Objects and Charts in Word Document and Power point
Presentation.
Module 19: Use Macros to Automate Tasks
Creating and Recording Macros
Assigning Macros to the work sheets
Saving Macro enabled workbook
Module 20: Proofing and Printing
Page setup, Setting print area, Print titles
Inserting custom Header and Footer
Inserting objects in the header and footer
Page Setup, Setting margins, Print Preview, Print
Enable back ground error checking
Setting AutoCorrect Options
MS POWERPOINT
Module 21: Setting Up PowerPoint Environment:
New, Open, Close, Save, Save As
Typing the text, Alignment of text
Formatting Text: Font Size, Font Style
Font Color, Use the Bold, Italic, and Underline
Cut, Copy, Paste, Select All, Clear text
Find & Replace
Working with Tabs and Indents
Module 22: Creating slides and applying themes
Inserting new slide
Changing layout of slides
Duplicating slides
Copying and pasting slide
Applying themes to the slide layout
Changing theme color
Slide background
Formatting slide background
Using slide views
Module 23: Working with bullets and numbering
Multilevel numbering and Bulleting
Creating List
Page bordering
Page background
Aligning text
Text directions
Columns option
Module 24: Working with Objects
Shapes, Clipart and Picture, Word Art, Smart Art
Change the Order of Objects
Inserting slide header and footer
Inserting Text boxes
Inserting shapes, using quick styles
Inserting Word art
Inserting symbols
Inserting Chart
Module 25: Hyperlinks and Action Buttons
Inserting Hyperlinks and Action Buttons
Edit Hyperlinks and Action Button
Word Art and Shapes
Module 26: Working With Movies and Sounds
Inserting Movie From a Computer File
Inserting Audio file
Audio Video playback and format options
Video options, Adjust options
Reshaping and bordering Video
Module 27: Using SmartArt and Tables
Working with Tables, Table Formatting
Table Styles
Alignment option
Merge and split option
Converting text to smart art
Module 28: Animation and Slide Transition
Default Animation, Custom Animation
Modify a Default or Custom Animation
Reorder Animation Using Transitions
Apply a Slide Transition, Modifying a Transition, Advancing to the Next Slide
Module 29: Using slide Master
Using slide master
Inserting layout option
Creating custom layout
Inserting place holders
Formatting place holders
Module 30: Slide show option
Start slide show
Start show from the current slide
Rehearse timing
Creating custom slide show
Module 31: Proofing and Printing
Check Spelling As You Type
Setting AutoCorrect Options
Save as video
Save as JPEG files
Save as PowerPoint Show file
Print Preview, Print
INTERNET & E-MAIL
What is Internet?,
Sending Outgoing Messages, Email addressing
Email attachments, Browsing, Search engines
Text chatting, web Searching
Downloading video and Music
Uploading Video or Music, Voice chatting, Webcam Chatting etc.
Introduction to SEO
