We offer Advanced level Office Application course from Alphabet IT.

At modern days, Microsoft office (Excel, Word, PowerPoint and Access) has become one of the most useful tools at colleges, corporate offices for organizing, handling and presenting data and information. Over 90% of the corporate professionals rely on Microsoft office works and that makes MS Office tools very significant in our regular lives.

We are here for you to boost and strengthen your understanding on advanced Microsoft office tools: Excel, Word, PowerPoint and Outlook. This is an Advanced level MS-OFFICE Training, Which includes:

Advanced level of “Microsoft Word” a word processing program with which you can quickly and efficiently author and format any document.
Advanced level of “Microsoft Excel” a spare sheet program with which you can analyze, communicate and manage information.
Advanced level of “Microsoft PowerPoint” a program with which you can develop and present dynamic, professional-looking slide presentation.
Advanced level of “Microsoft Access” a database program with which you can collect information and output information for reuse in a variety of format.

Course Outline:

Total 30 Classes

Basic Computer Knowledge(1 Class)

MS-Word (7 Classes)

MS-Excel (10 Classes)

MS-Power Point (4 Classes)

MS-Access (4 Classes)

MS-Outlook  (2 Classes)

Trouble Shooting (2 Classes)

Course Fee: 5000 Tk.

 

SL

Name of Modules

Number of Class

Hours

# Basic Computer Knowledge

1

2

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

2

# Word Processing/Microsoft Word

7

14

1
  • Word 2010 interface
  • Ribbon understanding
  • Customizing the quick access tool bar
  • Navigation tool bar, Navigation pane, Status bar
  • Navigation pane, Status bar

 

1

2

2
  • Back stage view
  • Customizing tab
  • Home tab: Font & Paragraph Customization, Style, Find And Replace
  • Short cut key

1

2

3
  • Insert tab: Photo, clip art, table, chart, Header & footer, Smart art, Equation & symbol
  • Table Customization briefly, Hyperlink concept

1

2

4
  • Design tab: Styles, Border & shading
  • Layout tab
  • Reference tab

1

2

5
  • Page layout tab
  • Mailing tab

1

2

6
  • Review tab
  • View tab
  • Typing Procedure

 

 

7
  • Review of Word Processing/Microsoft Word

 

 

# Spread sheet/MS excel

10

20

1
  • What is excel
  • Ribbon bar in excel
  • Ribbon/tab customization in excel

1

2

2
  • Name box, Formula bar
  • Rows, column & cells
  • Selection in excel

1

2

3
  • 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

2

4
  • Multiplying
  • Dividing
  • Update date & time automatically
  • Use template in excel
  • Create original template
  • Header & footer in excel

1

2

5
  • 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

 

1

2

6
  • Use if statement
  • Data validation

1

2

7
  • Chart customization and edit in excel
  • Different kinds of chart on excel
  • Date & time Formatting

1

2

8
  • 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

2

9

 

  • Sort and filter in excel
  • Remove duplicate data in excel
  • Subtotal tool in excel
  • Goal seek tool & PMT function in excel

1

2

10
  • Spread sheet/MS excel class review

1

2

# Presentation / Microsoft PowerPoint

4

8

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.

1

2

2
  • Design tab: Page setup, slide orientation, themes,
  • Back ground style etc.
  • Animation tab: custom animation, Transition customization, advanced slide etc.

1

2

3
  • 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

2

4
  • Review of Presentation / Microsoft PowerPoint

1

2

# Microsoft Access/ Database

4

8

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

1

2

2
  • Creating Database and Simple data:
  • Creating Database from simple table
  • Creating Database from tables manually
  • Customizing rows & columns
  • Creating relationship between tables

 

 

1

2

3
  • 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

2

4
  • Review of Microsoft Access/ Database

1

2

# MS- Outlook

2

4

1
  • Send & receive email messages
  • Store & access contact information

1

2

2
  • Manage scheduling
  • Track task

 

1

2

# Troubleshooting

2

4

29
  • Operating system
  • Basic networking
  • Functions of utility software’s

1

2

30
  • Connecting components of a computer
  • Basic hardware trouble shooting

1`

2

Total Duration (Hours):

30

60