Microsoft Office
Class duration : 2 months
Class hours: 1 hrs 30 minutes
Weekly class: 2 days
Course outline
Basic Computer Knowledge
1.Computer Basic
2.Concepts of Information Technology
3.Computer Component- Hardware, Software etc.
4.Uses of input & output devices
5.Concept of memory & storage
6.Using Computer & Managing files
1.Computer Basic
2.Concepts of Information Technology
3.Computer Component- Hardware, Software etc.
4.Uses of input & output devices
5.Concept of memory & storage
6.Using Computer & Managing files
7.Word 2019 interface
8.Customizing the quick access tool bar
9.Navigation tool bar, Navigation pane, Status bar
10.Home tab: Font & Paragraph Customization, Style, Find and Replace
11.Short cut key Insert tab: Photo, clip art, table, chart, Header & footer, Smart art, Equation & symbol
12.Table Customization briefly, Hyperlink concept
13.Design tab: Styles, Border & shading
14.Layout tab
15.Reference tab
16.View tab
17.Review tab
18.Mailing tab
19.Page layout tab
20.Typing Procedure
Spread sheet/MS excel
1.What is excel
2.Ribbon bar in excel
3.Ribbon/tab customization in excel
4.Name box, Formula bar
5.Rows, column & cells
6.What is formula & function
7.Add number manually in excel
8.Add number by auto sum
9.Insert in excel
10.Header & footer in excel
11.Average/min/max/count function in excel
12.Use sum if average if in excel
13.Date & time Formatting
14.Update date & time automatically
15.Custom view and print selection in excel
16.Hide row and column in excel
17.Calculation between worksheet
18.Add multi cell value in one cell in excel
19.Text Formatting
20.Remove duplicate data in excel
21.Subtotal tool in excel
Presentation / Microsoft PowerPoint
1.Work with Slides: Adding & deleting Slides, Adding slides, Slide bar,
2.Insert Photo, Clip art, table, chart
3.3D effect, etc.
4.Design tab: Page setup, slide orientation, themes,
5.Back ground style etc.
6.Animation tab: custom animation, Transition customization, advanced slide etc.
7.Review tab: Spelling check, comment
8.View tab: Presentation views show hide, macros etc.
9.Slide show tab: Starting slide shows, set up tools, monitors
