MS OFFICE 365 Total Duration : 24 Hours
MS WORD 365
MS Word 365 5 Hours
Module 1 Paragraph Formatting 1 Hour
• Understanding Paragraph Formatting
• Understanding Text Alignment
• Changing Text Alignments
• Changing Line Spacing
• Changing Paragraph Spacing
• Indenting Paragraphs
• Removing Indents
• Shading Paragraphs
• Applying Borders to Paragraphs
• Using the Paragraph Dialog Box
• The Paragraph Dialog Box Indents and Spacing
• The Paragraph Dialog Box Line and Page Breaks
Module 2 Lists 30 Mins
• Understanding Lists
• Applying Bullets
• Defining a Bullet
• Modifying a Bullet
• Applying Numbering
• Defining a Number Format
• Renumbering a List
• Understanding Multilevel Lists
• Applying a Multilevel List
• Promoting and Demoting List Items
• Defining a Multilevel List
• Modifying a Multilevel List Style
Module 3 Page Layout 30 Mins
• Changing Page Margins
• Setting Custom Margins
• Changing Page Orientation
• Changing Paper Sizing
• Setting Custom Paper Sizes
• Inserting Page Breaks
• Removing Page Breaks
• Inserting Page Numbers
QMS-L3-FR-TS-08
• Formatting Page Numbers
• Removing Page Numbers
Module 4 Spelling and Grammar 30 Mins
• Understanding Spelling and Grammar
• Correcting Spelling Errors
• Correcting Contextual Errors
• Correcting Grammatical Errors
• Understanding Spell Checking Options
• Performing a Spelling and Grammar Check
Module 5 Formatting Techniques 30 Mins
• Applying First Line Indents
• Applying Hanging Indents
• Understanding Pagination
• Controlling Widows and Orphans
• Keeping Paragraphs Together
• Keeping Lines Together
• Inserting a Page Break
• Inserting a Drop Cap
• Revealing Formatting
Module 6 Tables 30 Mins
• Understanding Tables
• Creating a Table
• Adding Data to A Table
• Selecting In Tables
• Selecting Using the Mouse
• Inserting Columns and Rows
• Deleting Columns and Rows
• Changing Column Widths
• Changing Row Heights
• Auto fitting Columns
• Modifying Borders
• Modifying Border Styles
• Choosing a Table Style
Module 7 Table Features 30 Mins
• Creating a Table from Text
• Aligning Data in Cells
• Inserting Formulas into a Table
• Updating Formulas in a Table
QMS-L3-FR-TS-08
• Sorting Table Data
• Merging Table Cells
• Splitting Table Cells
• Displaying Table Gridlines
• Understanding Table Properties
• Aligning Tables
• Changing the Direction Of Text
• Repeating Heading Rows
• Converting a Table To Text
Module 8 Headers and Footers 30 Min
• Understanding Headers and Footers
• Inserting Headers and Footers
• Inserting a Blank Header
• Inserting a Blank Footer
• Switching between Headers and Footers
• Editing Headers and Footers
• Inserting Page Numbering
• Inserting Date Information
• Inserting Document Properties
• Formatting Header and Footer Text
Module 9 Mail Merging 30 Mins
• Understanding Mail Merging
• The Mail Merge Wizard Process
• Selecting the Starting Document
• Selecting a Recipient List
• Inserting Mail Merge Fields
• Previewing the Merged Documents
• Completing the Merge
QMS-L3-FR-TS-08
MS EXCEL 365
MS Excel 365 14 Hours
Module 1 Excel Calculations 1 Hour
• Creating a table and applying formats to it like Borders, Fill Colour, Text
Alignment, Merge and Centre, Wrap Text and Number Formats
• Applying calculations such as Sum(), Average(), Count(), CountA()
Module 2 Sorting and Filtering 1 Hour and 30 Mins
• Data Sort
• Sorting the data on the basis of a single column
• Sorting the data on multiple columns
• Applying the Custom Sort
• Data Filter
• Auto-Filter options
• Advance Filter
• Using Advance Filter to extract unique values from the list
• Remove Duplicates
Module 3 Logical and Lookup Functions 2 Hours
• Logical Functions
• If()
• Nested IF formula
• Using And() and Or() Functions in If()
• Lookup Functions
• VLookup() with IF Error()
Module 4 Paste Special Options 30 Minutes
• Exploring various options of Paste Special
• Using Paste Special to link table on different locations
Module 5 Background Concepts of Functions using Auditing Tools 30 Minutes
• Trace Precedent
• Trace Dependent
• Show Formula
• Evaluate Formula
QMS-L3-FR-TS-08
Module 6 Data Summarization and Analysis 3 Hours
• Using the Quick Analysis Tool
• Formatting the data as a Table
• Data Subtotal
• Data Consolidation
• Creating Pivot Table
• Adding data into the Pivot Table
• Grouping and modifying data in the Pivot Table
• Applying Filters by using Slicers and Timeline
• Connecting multiple pivots through a common slicer
• Applying Conditional Formatting to the data
Module 7 Text and Date Functions 1 Hour
• Text Functions
• Concatenate()
• Upper(), Lower() and Proper()
• Trim()
• Right(), Left() and Mid()
• Date Functions
• Date()
• Today() and Now()
• Datedif()
• Year(), Month(), Day()
Module 8 Statistical Functions 1 Hour
• Countif() and Sumif()
• CountIfs() and Sumifs()
Module 9 Data Validation and Protection of the data 1 Hour
• Applying Data Validation to the cells
• Protection of sheet and workbook
Module 10 Charts 2 Hours
• Creating common chart types like Column chart, Bar chart, line chart, Pie
Chart, Waterfall chart and Histogram
• Pivot table chart options
• 3D Map
QMS-L3-FR-TS-08
Module 11 Print Options 30 Mins
• Set the Print Area
• Print Titles
• Using the Page Break Preview
• Margin Settings
• Setting the orientation
MS POWERPOINT 365
MS PowerPoint 365 5 Hours
Module 1 Tables 30 Mins
• Inserting a Table
• Applying a Table Style
• Inserting Rows and Columns
• Merging and Splitting Cells
• Formatting Table Data
• Applying Borders
• Aligning Table Data
Module 2 Charts 30 Mins
• Inserting a Chart
• Changing the Chart Type
• Applying a Chart Style
• Changing the Chart Layout
• Chart Elements
• Working with Pie Charts
Module 3 Images 30 Mins
• Inserting a Picture
• Resizing an Image
• Inserting Clip Art
• Rotating and Flipping an Image
• Cropping an Image
• Using SmartArt
Module 4 Animation 1 Hour
• Understanding Animation
• Animating Text
• Animating Objects
QMS-L3-FR-TS-08
• Applying Multiple Effects
• Applying Motion Paths
• The Animation Pane
• Setting the Timing
• Applying Slide Transitions
Module 5 Media and Action Buttons 30 Mins
• Inserting a Video Clip
• Inserting an Audio Clip
• Understanding Action Buttons
• Inserting Action Buttons to link to slides in the same presentation
• Inserting a hyperlink to link a slide from a different presentation
Module 6 Design Templates 30 Mins
• Applying Design Themes to the presentations
• Applying Design Ideas according to the content of the slide
Module 7 Slide Masters 30 Mins
• Understanding Slide Masters
• Viewing the Slide Master
• Changing the Master Font
• Modifying Bullets
• Inserting an Image
• Inserting Slide Numbers
Module 8 Setting Up the Show 30 Mins
• About Self-Running Presentations
• Recording the Slide Show
• Setting Up a Self-Running Presentation
Module 9 Saving and Sharing Presentations 30 Mins
• Packaging Presentations for CD
• Saving a presentation as a PowerPoint Show
QMS-L3-FR-TS-08
