MS Office Training

Module 1: Introduction
to MS Office & Computer Basics

• Overview of Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Access)
• Understanding the Office Interface, Ribbon, and Toolbar
• File Management – Create, Save, Open, and Organize Files
• Keyboard Shortcuts and Productivity Tips
• Introduction to Microsoft 365 / Office 365
• MS Office basics Trichy, computer course for beginners, Microsoft Office intro

Module 2: MS Word –
Document Creation & Formatting

• Creating, Editing, and Formatting Documents
• Page Setup, Margins, Headers & Footers
• Tables, Columns, and Page Borders
• Mail Merge – Letters, Labels, and Envelopes
• Track Changes, Comments, and Document Review Tools
• Templates, Styles, and Themes
• Exporting to PDF and Printing MS
  Word training Trichy, document formatting course, Word for office jobs

Module 3: MS Excel –
Spreadsheets & Data Analysis

• Excel Interface, Workbooks, Worksheets, and Cell References
• Formulas and Functions – SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, COUNT
• Data Sorting, Filtering, and Conditional Formatting
• Pivot Tables and Pivot Charts – MIS Reporting
• Data Validation and Drop-down Lists
• Charts & Graphs – Bar, Line, Pie, Combo Charts
• Excel Macros & Basic VBA Automation
• Advanced Excel – INDEX MATCH, SUMIF, COUNTIF, Dashboard Creation MS Excel training Trichy, advanced Excel course, Excel for
  data analysis Trichy

Module 4: MS PowerPoint
– Presentations & Slides

• Creating and Designing Slides from Scratch
• Using Themes, Layouts, and Slide Masters
• Inserting Images, Charts, Tables, and Shapes
• Transitions, Animations, and Effects
• Slide Show Settings and Presenter View
• Creating Business Presentations and Pitch Decks
• Saving as PDF, Video, and Image Formats
  PowerPoint training Trichy, presentation design course, MS Office PPT

Module 5: MS Outlook –
Email & Calendar Management

• Setting Up Email Accounts in Outlook
• Composing, Sending, and Organizing Emails
• Calendar Management – Meetings and Appointments
• Contacts, Tasks, and Notes
• Folders, Rules, and Auto-Reply (Out of Office)
• Business Email Etiquette MS Outlook training Trichy, email management course, Outlook for professionals

Module 6: MS Access –
Database Management

• Introduction to Databases and MS Access
• Creating Tables, Fields, and Relationships
• Queries – Select, Action, and Parameter Queries
• Forms for Data Entry
• Reports Generation and Printing
• Linking Access with Excel for Data Management MS
  Access training Trichy, database course, Access for office management

Module 7: Advanced
Excel & MIS Reporting (Bonus)

• Dynamic Dashboards with Slicers and Timelines
• Power Query – Import and Transform Data
• Advanced Pivot Tables and Calculated Fields
• Financial Functions – PMT, NPV, IRR
• What-If Analysis – Goal Seek, Scenarios, Data Tables
• Printing and Formatting for Professional Reports
  advanced Excel course Trichy, MIS reporting training, Excel dashboard
  Trichy