- Word,Excel & Power Point
COURSE FEATURES
Course Instructor : Experience Teachers
Category : Office Productivity
Exam : Online
Certificate :Government Approved
COURSE DETAILS
Microsoft Office Class Room Training Course covers in-depth training for Microsoft Office including Word, Advanced Excel and PowerPoint Tutorial with Practical Examples and Live Documents. After completing this course, you will be able to work faster and smarter with MS Office 2013 – 2016 and will improve your overall Office Productivity
Syllabus for Microsoft Office Offline Training Course
Module 01 : Microsoft Word Training
User Interface - Saving and Exporting
- Password Protection
- Navigating your Document
- Selection Skills
- Cut, Copy and Paste Special
- Find, Replace and Go To
- Text Formatting
- Format Painter
- Text Cases
- Super and Sub Script
- Inserting Text Box
- Line and Paragraph
- Text Styles and Presets
- Indentation
- Alignment
- Bullets and Numbering
- Advance Tabs
- Inserting Picture
- Remove Picture Background
- Smart Art for Illustrations
- Inserting Video
- Header, Footer and Page Nos
- Page Setup & Page Design
- Hyphenation and Columns
- Working with Tables
- Symbols and Objects
- Proofing your Document
- Auto Correct Feature
- Compare and Combine
- Mail Merge
- Linking and Reference
- Signature and Quick Parts
- Screen Shots
- TOC & Macros
- Sharing your Document
- PDF Files – Import and Export
-
- Module 02 : Microsoft Excel Training
-
- Excel User Interface
- Auto Series
- Addition and Subtraction
- Multiply and Divide
- Conditional Formula – IF
- Complex Conditional Formula IF
- AND OR Function
- Fix Reference
- Working with Date
- Working with Time
- Cell Formats
- Conditional Formatting
- Paste Special
- Charts and Graphs
- Filter and Sorting
- Pivot Table
- Slicer and Timeline Filters
- Spark lines
- Power View
- Freeze Pane
- Protecting Sheets
- Data Validation
- Removing Duplication
- V and H Lookup
- Importing Data
- Navigating
- Working with Sheets
- Excel Contingency Table
- Printing Sheets
- Page Break
- Flash Fill
- Loan EMI’s (PMT)
- Fixed Deposits (FV)
- Recurring Deposits (FV)
- Investment (PV)
- Interest Rate
- Goal Seek
- Min and Max
- Average Function
- Count Function
- Misc. Functions
- Navigation Shortcuts
- Powerful Tricks
- Macros in Excel
-
- Module 03 : Microsoft Power Point Training
-
- User Interface
- Slide Design
- Slide Transitions
- Animation to Contents
- Slide Master & Slide Notes
- Presenter View
- Presentation Controls
- Creating Corporate Video
- Photo Album
- Printing Slide Handouts
- Sharing your Presentation
- Online Presentation
-