Mastering Microsoft Office to Enhance Productivity

Training Schedule:

Date: January 5 & 6, 2024.
Time: 6.00 PM

MS Word: 1^st day (01 Hr.)

• Working with the Microsoft Word Ribbon
• Editing Text in Your Word Document
• Creating Bulleted and Numbered Lists in Word
• Formatting Paragraphs in a Word Document
• Creating Custom Microsoft Word Styles
• Working with Word Document Margins
• Adding Columns to a Word Document
• Working with Page Breaks
• Page Breaks and Columns Together
• Changing the Orientation of a Page
• Inserting Headers and Footers
• Working with the Page Background
• Converting to A PDF of MS Word File
• Formatting Word Tabs
• Formatting Word Tables
• Working with pictures
• The Mail Merge Data Source
• Working with the caption:
  • Adding Citation Sources
  • Creating the Bibliography
  • Managing Large Documents with Captions
  • Inserting a dynamic Table of Content

MS PowerPoint: 1^st day: (2 Hrs.)

1. Basic of PowerPoint
2. Insert slides from MS Word
3. Reuse slides to save your time.
4. Uses of various shapes
5. Create Logos and designs with various shapes on PowerPoint
6. Design with SmartArt: to prepare corporate presentation slides
7. Animation and transition on slides & design
8. How to create a Professional infographic design

MS Excel: 2nd day (3 hrs.)

1. Basic Excel & Formatting
2. Number and value formatting & comparative analysis of data
3. Conditional formatting to find & sort required data
4. Data validation: checking the integrity, accuracy, and structure of data
5. Practical uses of various Excel formulas to solve real-life business problems
6. How to create a dynamic invoice
7. Dashboarding, Data analysis, and reporting with pivot tables