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