Certified Training on Microsoft Office Specialist

Certified Training on Microsoft Office Specialist

Microsoft Office is a suite of desktop applications and services such as Microsoft Word, Excel, Access, PowerPoint, and Outlook, designed for Microsoft Windows and Mac OS X operating systems.

course at a glance

  • Date : 15 Jul - 9 Sep 2024
  • No. of Classes/ Sessions : 15
  • Total Hours : 30
  • Last Date of Registration : 13 Jul 2024
  • Class Schedule :
    • Sunday - 7:00 PM - 9:00 PM
    • Wednesday - 7:00 PM - 9:00 PM
  • venue : BASIS Institute of Technology & Management Limited BDBL Bhaban (3rd Floor - East), 12 Kawran Bazar, Dhaka -1215. Contact Number: 01989408040

Price: TK. 10,000
(including VAT & TAX)
One time full payment: BDT 8,000

This Training is organized by BITM & Training will be held in BITM Lab

Course Outline:

MS WORD:

  • Creating a new blank document using a Keyboard shortcut
  • Save As
  • Select, then format, Selecting text
  • Inserting, deleting, undo and redo
  • Copying text within a document
  • Moving (cutting) text within a document
  • What is text formatting?
  • Font: type, size, increase, decrease, bold, italic, underline, subscript, superscript
  • Case changing, Highlighting
  • Font color
  • Copying text formatting, removing formatting
  • Using zoom
  • Inserting special characters and symbols
  • What is paragraph formatting
  • Techniques for aligning and indenting text
  • Appling paragraph spacing (single, double, above, below)
  • Using paragraph spacing rather than using the return key
  • Applying bullets to a list, number to alist
  • Modifying and removing bullet and numbering formatting
  • Adding and modifying borders
  • Adding and modifying shading
  • Applying borders to selected text
  • Know about style and apply it
  • Applying design them and it color
  • Apply a customized font
  • What is page formatting?
  • Page orientation, page size and page margin
  • Insert and delete page breaks
  • Creating, editing header footer
  • Inserting page number
  • Cover pages
  • Applying automatic hyphenation
  • Inserting a table
  • Navigating within a table
  • Selecting and editing text within a table
  • Selecting cells, rows, columns or the entire table
  • Inserting and deleting rows and columns
  • Modifying column width or row height
  • Modifying the table width
  • Modifying table styles
  • Inserting pictures, Online pictures, Shapes, SmartArt,
  • Chart, Modifying the Chart type, Chart style, Chart data
  • Inserting a screenshot
  • Selecting, resizing and deleting graphics
  • Copying or moving graphics
  • Using find and replace find
  • What is mail merging?
  • Starting the mail merge wizard, six steps of mail merge wizard
  • Creating a mailing list to be used within a mail merge
  • Create PDF
  • File ZIP & UNZIP
  • MS Word Equation
  • Documents Printing · Single Page Printing, Both page Printing, page setup
  • MS Excel:
  • Basic Discussion
  • Interface of Excel
  • Quick Access Toolbar
  • Customize Ribbon
  • How to add Developer Tab
  • Search Button
  • Name Box
  • Formula Bar
  • Workbook Background
  • Worksheet Format and Manage Workbook
  • Row Height & Column Width
  • Add Borders
  • Apply Colors and Patterns
  • Format Painter
  • Merge Cells, Rotate Text
  • Advance Tab of Headers & Footers
  • Inserting Objects
  • Organogram
  • Format Numbers & Values
  • Insert & Delete Worksheet
  • Duplicate Removal
  • Hide Columns, Rows and
  • Protect Sheet
  • Protect a Workbook
  • Split and Freeze a Window
  • Enter Date Values and using
  • Auto-complete
  • Custom List
  • Insert Cell Comments & Note
  • All About Data Entry Tricks
  • Paste Options
  • Cell Reference
  • Relative, Absolute & Mixed
  • Cell References
  • Dynamic Name Range
  • Sort
  • Advance Sort Options
  • Filter
  • Data Validation
  • Data Validation with Any value, Whole Number, Text Length etc.
  • Drop Down List
  • Create Custom Data Validation Messages
  • Workbook, Worksheet and Individual Protection
  • Formula & Functions
  • Difference between Formula & Function
  • Functions Basic Arithmetic Operations
  • Edit & Copy Formulas
  • Cell References practical example
  • Formula Audit
  • Text Function
  • Sum, Max, Min, Average, Count, Count A, Count Blank
  • If Function, Nested If, Logical OR,AND Function
  • Sumif, Sumifs, Average If,Average Ifs, CountIf, CountIfs,
  • Vlook-up
  • SubTotal
  • Project:
  • Salary Sheet with various Condition
  • Salary Sheet with Daily Attendance
  • Result Sheet with various Condition.
  • Conditional Formatting
  • Highlight Cell As Per Various Rules
  • Top/ Bottom Rules
  • Data Bars, Color Scale, Icons Set
  • Task Reminder using Conditional Formatting
  • Excel Charts
  • Create Charts
  • Move and resize & change Chart
  • Format and Edit Objects in a Chart
  • Change Chart Source Data
  • All About Add Chart Element and Quick Layout
  • Change Chart Type and work with Column Chart, Bar Chart, Pie Chart etc.
  • Pivot Table
  • Pivot Table
  • Slicer & Slicer settings
  • Timeline in Pivot
  • Custom Grouping
  • Pivot Table Options/Setting
  • Show value as
  • Calculated Field
  • Filter & filter reports Page
  • Pivot Chart
  • Pivot Table Chart & Slicer
  • Table & Bar Chart
  • Service level chart
  • Project:
  • Dashboard Design
  • Excel Print
  • How to print large worksheet properly in A4 size page
  • Adjust Page Margins and Orientation
  • Add Print Titles and Grid-lines,
  • rows to repeat at top of each page
  • Print with column & Row Header
  • MS Powerpoint:
  • Starting PowerPoint ,Creating a blank presentation.
  • Creating a new presentation
  • Inserting new slide into a presentation
  • Techniques of creating slide contents
  • Undo and Repeat
  • Saving a presentation and Saving it in different file type.
  • Inserting slides within a particle slide layout and modifying slide layout
  • Changing the background color on an active slide and on all slides within the presentation
  • Applying a them to the presentation
  • Modifying the theme color
  • Editing, Resizing & Moving the text boxes
  • Selecting text
  • Moving and Copying text within a slide
  • Moving and Copying text between the sides of a presentation or between presentation
  • Changing font type, size, case and color
  • Use of bold, italic, underline formatting
  • Strikethrough and Shadow effect
  • Character spacing
  • Clearing all text formatting
  • Text alignment
  • Modifying bullet point formatting
  • Using number list
  • Changing the list level
  • Identifying bulleted list
  • Use of line spacing and paragraph spacing
  • Using outline view
  • Use of presenter note
  • Text autofit, Text direction
  • Text direction within a text box
  • Table selection techniques: Column selection, Row selection, Entire Table selection
  • Hyperlink
  • Creating a table
  • Applying a style to a table
  • Adding cell background and shading
  • Applying table effects
  • Adding quick styles to selected text
  • Applying borders to cells
  • Inserting and Deleting column & rows
  • Modifying column width and row height
  • Distributing rows and columns
  • Selecting illustrations
  • Moving, Copying, Inserting, Deleting, Resizing and Stretching Illustration
  • Inserting shapes, text into a shape
  • Text box and Smart art
  • Aligning graphics relative to each other or relative to the slide
  • Aligning shape relative to the left, right, top, bottom and Centre of a slide
  • Grouping and ungrouping objects
  • Moving slides within presentation or between presentations
  • Copying slides within presentation or between presentation
  • Understanding a slide master
  • Inserting and removing picture into master slide
  • Running a slide show
  • Adding and removing slide show transition effects
  • Adding, Modifying and Removing slide show animation effects
  • Converting a PowerPoint presentation into a video
  • Spell checking a presentation
  • Using portrait and landscape slide orientation
  • Switching between standard and widescreen formats
  • Printing options
  • Setting the number of copies to print
  • Setting a different number
  • Printing selected slides per page to be printed
  • Single or both sided printing
  • Project:
  • Responsibilities of a Team Leader
  • Internet Browsing
  • Using a web browser
  • Bookmarks and history
  • Downloading files, Saving images
  • Mailing,CC/BCC
  • Using Search Engines
  • Google Sheet
  • Zoom Meeting
  • Teams Meeting · Password Save & Delete
  • Google Meeting

Curriculum

Module Certified Training on Microsoft Office Specialist 30 Hrs

Tentative Class Start

15th July, 2024

Available Seat

10 / 20

who can join

The prerequisites for this course are nothing more than basic computer skills.

Meet the Instructor