MS Office

MS Office

 User Interface(Day1)

 Saving and Exporting(Day2)

 Password Protection(Day3)

 Navigating your Document(Day4)

 Selection Skills(Day5)

 Cut, Copy and Paste Special(Day6)

 Find, Replace and GoTo(Day7)

 Text Formatting

 Format Painter

 Text Cases

 Super and Sub Script(Day8)

 Inserting Text Box

 Line and Paragraph

 Text Styles and Presets(Day9)

 Indentation

 Alignment

 Bullets and Numberings(Day10)

 Advance Tabs

 Inserting Picture

 Remove Picture Background(Day11)

 Smart Art for Illustrations

 Inserting Video

 Header, Footer and Page Nos(Day12)

 Page Setup & Page Design

 Hyphenation and Columns

 Working with Tables

 Symbols and Objects(Day13 & Day14)

 Proofing your Document

 Auto Correct Feature

 Compare and Combine(Day15)

 Mail Merge

 Linking and Reference

 Signature and Quick Parts(Day16)

 Screen Shots

 TOC & Macros

 Sharing your Document(Day17)

 PDF Files – Import and Export

 Advanced Excel Training

 Excel User Interface(Day18, Day19)

 Auto Series

 Addition and Subtraction

 Multiply and Divide

 Conditional Formula – IF(Day20)

 Complex Conditional Formula IF

 AND OR Function

 Fix Reference(Day21, Day22)

 Working with Date

 Working with Time

 Cell Formats

 Conditional Formatting(Day23, Day24)

 Paste Special

 Charts and Graphs

 Filter and Sorting

 Pivot Table

 Slicer and Timeline Filters(Day25, Day26)

 Sparklines

 Power View

 Freeze Pane

 Protecting Sheets(Day27)

 Data Validation

 Removing Duplications

 Goal Seek

 Min and Max

 Average Function(Day28)

 Count Function

 Misc. Functions

 Navigation Shortcuts(Day29)

 Powerful Tricks

 Macros in Excel

 MS PowerPoint Training(Day30)

 User Interface

 Slide Design

 Slide Transitions

 Animation to Contents(Day31)

 Slide Master & Slide Notes

 Presenter View

 Presentation Controls

 Creating Corporate Video(Day32)

 Photo Album

 Printing Slide Handouts

 Sharing your Presentation(Day33)