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 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.

Batch Duration

Starting Date : 25th June, 2018

Last Date of Registration :25th June, 2018

Class Schedule : Sun, Tues & Thurs; 3:00 PM- 6:00 PM

Total Hours : 60

Course Curriculum

Basic Computer Knowledge

  • Computer Basic
  • Concepts of Information Technology
  • Computer Component- Hardware, Software etc.
  • Uses of input & output devices
  • Concept of memory & storage
  • Using Computer & Managing files

Word Processing/Microsoft Word

  • 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
  • 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 
  • Design tab: Styles, Border & shading
  • Layout tab
  • Reference tab
  • Page layout tab
  • Mailing tab 
  • Review tab
  • View tab
  • Typing Procedure
  • Review of Word Processing/Microsoft Word

Spread sheet/MS excel

  • What is excel
  • Ribbon bar in excel
  • Ribbon/tab customization in excel
  • Name box, Formula bar
  • Rows, column & cells
  • Selection in excel
  • 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
  • Multiplying
  • Dividing
  • Update date & time automatically
  • Use template in excel
  • Create original template
  • Header & footer in excel
  • 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
  • Use if statement
  • Data validation
  • Chart customization and edit in excel
  • Different kinds of chart on excel
  • Date & time Formatting
  • 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
  • Sort and filter in excel
  • Remove duplicate data in excel
  • Subtotal tool in excel
  • Goal seek tool & PMT function in excel
  • Spread sheet/MS excel class review

Presentation / Microsoft PowerPoint

  • 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.
  • 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
  • Review of Presentation / Microsoft PowerPoint

Microsoft Access/ Database

  • 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
  • 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
  • Review of Microsoft Access/ Database 

MS- Outlook

  • Send & receive email messages
  • Store & access contact information
  • Manage scheduling
  • Track task

Troubleshooting

  • Operating system
  • Basic networking
  • Functions of utility software’s
  • Connecting components of a computer
  • Basic hardware trouble shooting 
Siyam Ahamed

Course Instructor

Siyam Ahamed

Faculty

Admission Open

20% OFF

Course Fee : ৳ 10000
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech