Advanced Microsoft Office Specialist

Advanced Microsoft Office Specialist

At modern days,Microsoft office( Excel,Word,PowerPoint and Access)has become one of the most useful tools at colleges,corporate offices for organization,handling and presenting data and information.

course at a glance

  • Date : 1 Apr - 29 May 2018
  • No. of Classes/ Sessions : 20
  • Total Hours : 60
  • Last Date of Registration : 1 Apr 2018
  • Class Schedule :
    • Sunday - 3:00 pm - 6:00 PM
    • Tuesday - 3:00 pm - 6:00 pm
    • Thursday - 3:00 pm - 6:00 pm
  • venue : Good Luck Center, 151/7 Green Road, 7th Floor, Dhaka 1205

Price: TK. 10,000
(including VAT & TAX)

This Training is jointly organized by BITM & PeopleNTech
Training will be held in PeopleNTech

Course outline :

 

SL

Name of Modules

Number of Class

Hours

#

Basic Computer Knowledge

1

3

1

Ø  Computer Basic

Ø  Concepts of Information Technology

Ø  Computer Component- Hardware, Software etc.

Ø  Uses of input & output devices

Ø  Concept of memory & storage

Ø  Using Computer & Managing files

1

3

#

Word Processing/Microsoft Word

5

15

1

Ø  Word 2010 interface

Ø  Ribbon understanding

Ø  Customizing the quick access tool bar

Ø  Navigation tool bar, Navigation pane, Status bar

Ø  Navigation pane, Status bar

Ø  Back stage view

Ø  Customizing tab

 

1

3

2

Ø  Home tab: Font & Paragraph Customization, Style, Find And Replace

Ø  Short cut key

Ø  Insert tab: Photo, clip art, table, chart, Header & footer, Smart art, Equation & symbol

Ø  Table Customization briefly, Hyperlink concept

1

3

3

Ø  Design tab: Styles, Border & shading

Ø  Layout tab

Ø  Reference tab

Ø  View tab

Ø  Review tab

1

3

4

Ø  Mailing tab

Ø  Page layout tab

Ø  Typing Procedure

1

3

5

Ø  Review of Word Processing/Microsoft Word

1

3

#

Spread sheet/MS excel

8

24

1

Ø  What is excel

Ø  Ribbon bar in excel

Ø  Ribbon/tab customization in excel

Ø  Name box, Formula bar

Ø  Rows, column & cells

Ø  Selection in excel

1

3

2

Ø  What is formula & function

Ø  Add number manually in excel

Ø  Add number by auto sum

Ø  Subtracting

Ø  Conditional formatting in excel

Ø  Customize Conditional formatting

Ø  Style in excel

Ø  Insert in excel

1

3

3

Ø  Multiplying

Ø  Dividing

Ø  Update date & time automatically

Ø  Use template in excel

Ø  Create original template

Ø  Header & footer in excel

1

3

4

Ø  Average/min/max/count function in excel

Ø  Use sum if average if in excel

Ø  Chart customization and edit in excel

Ø  Different kinds of chart on excel

Ø  Chart customization and edit in excel

Ø  Different kinds of chart on excel

Ø  Date & time Formatting

1

3

5

Ø  Use if statement

Ø  Data validation

1

3

6

Ø  Custom view and print selection in excel

Ø  Hide row and column in excel

Ø  Calculation between worksheet

Ø  Add multi cell value in one cell in excel

Ø  Text Formatting

1

3

7

 

Ø  Sort and filter in excel

Ø  Remove duplicate data in excel

Ø  Subtotal tool in excel

Ø  Goal seek tool & PMT function in excel

1

3

8

Ø  Spread sheet/MS excel class review

1

3

#

Presentation / Microsoft PowerPoint

2

6

1

Ø  Work with Slides: Adding & deleting Slides, Adding slides with readymade content, Slide bar, Rearranging Slide bar and sectors,

Ø  Insert tab: Photo, Clip art, table, chart, smart art,

Ø  3D effect, etc.

Ø  Design tab: Page setup, slide orientation, themes,

Ø  Back ground style etc.

1

3

2

Ø  Animation tab: custom animation, Transition customization, advanced slide etc.

Ø  Review  tab: Spelling check, comment, protect presentation, 

Ø  View tab: Presentation views, show hide, macros etc.

Ø  Slide show tab: Starting slide shows, set up tools, monitors

1

3

#

Microsoft Access/ Database

2

6

1

Ø  Explore an Access Database: Exploring tables, Exploring forms, exploring quires, Exploring reports

Ø  Creating Database and Simple data:

Ø  Creating Database from simple table

Ø  Creating Database from tables manually

Ø  Customizing rows & columns

Ø  Creating relationship between tables

1

3

2

Ø  Create Simple forms:

Ø  Creating forms by using form tools

Ø  Changing the look of forms

Ø  Changing the Argument of form

Ø  Display data:

Ø  Sorting information in table

Ø  Filtering information in table & forms

1

3

#

MS- Outlook

1

3

1

Ø  Send & receive email messages

Ø  Store & access contact information

Ø  Manage scheduling

Ø  Track task

1

3

#

Troubleshooting

1

3

1

Ø  Operating system

Ø  Basic networking

Ø  Functions of utility software’s

Ø  Connecting components of a computer

Ø  Basic hardware trouble shooting

1

3

Total Duration (Hours):

20

60


  • Every class will include student practice session for 45 minutes
  • There will be a midterm exam after 10 classes
  • A final exam will be held after 20 classes


Curriculum

Module Advanced Microsoft Office Specialist 60 Hrs

Tentative Class Start

1st April, 2018

Available Seat

10 / 15

who can join

Knowledge of typing,experience using windows and web browser.

Meet the Instructor