Event brochure in Word
Design a brochure with a schedule, speakers and venue using text boxes, images and styles.
MS Office / Office Automation Course Online from India
Type, format, calculate, present and email like a confident office professional – from your first document to Excel macros. Live trainer-led classes for learners worldwide, with hybrid and 100% offline options in India.
Live online5 levels24–128 hYour time zone
01About the course
What you will learn in MS Office / Office Automation
Microsoft Office is the set of desktop programs from Microsoft used in nearly every workplace: Word for letters and reports, Excel for calculations and data, PowerPoint for presentations, Access for small databases and Outlook for email and calendars. Office automation means using these tools well enough that routine office work – typing, formatting, mail merge, tables, charts, reports and scheduling – is done quickly and correctly, with less manual effort.
This page is for learners outside Vellore, Katpadi and Ranipet – NRIs, professionals in the Gulf and other countries, and students elsewhere in India who want MS Office / Office Automation taught live by a trainer.
No prior experience is needed for the 24-hour levels beyond basic use of a keyboard and mouse. The longer levels move faster, so regular practice between classes helps.
At a glance
- 5 programme levels: 24–128 h
- Live online, hybrid or offline in India
- Projects assessed before certification
- Certificate from the SynergySBS network
- Batches fixed around your time zone
02Outcomes
Skills you will be able to show
- Create, format, proof and print professional Word documents
- Use styles, tables, headers, citations and mail merge for letters and reports
- Enter, format and chart data in Excel and use everyday formulas
- Sort, filter and validate data and use pivot tables for summaries
- Build clear PowerPoint presentations with tables, SmartArt, media and animations
- Design Access tables, forms, queries and reports (Course on Office Automation)
03Syllabus
MS Office / Office Automation syllabus by level
Every module and topic taught in the classroom batch is covered online. Open a level to see its modules.
Foundation level
Certificate in Office Automation
Students and first-time computer users who want a certified 24-hour course in Word, Excel and PowerPoint.
24 hours6 modules · 58 topicsCertificate: SynergySBS network
01MS Word: Basics of a Document8 topics
Starting a New DocumentHome Tab: Cut, Copy, Paste and Format PainterFind and ReplaceFormatting TextFill ColourApplying StylesUsing PicturesUsing SmartArt
02MS Word: Editing, Formatting and Finalising14 topics
Using Text BoxesOffice Add-ins (My Apps and Store)Header and FooterAdding SignaturesGrouping Multiple ObjectsWrapping TextPage Setup: Size, Columns, Breaks, Indents and SpacingHyphenationReferencesCitation and BibliographyMail MergeReviewing the Document and CommentsViewing the DocumentPrinting, Saving and Closing the Document
03MS Excel: Creating and Formatting a Workbook8 topics
Introduction to MS OfficeEntering Data in CellsInserting Rows and ColumnsInserting and Deleting WorksheetsNumber FormatInsert Tab: Tables, Pictures, Slicer, Hyperlink, Header and FooterColumn Charts (2D and 3D)Bar, Pie, Scatter, Combo and Line Charts
04MS Excel: Data, Formulas and Saving10 topics
Data TabSort and FilterFlash FillData ValidationRemoving DuplicatesPage LayoutFormulasReview: Spelling, Research, Thesaurus and CommentsView Options and Freeze PanesSaving, Recovering an Unsaved Workbook and Closing
05MS PowerPoint: Creating and Editing a Presentation11 topics
Introduction to PowerPointQuick Access ToolbarOpening an Existing PresentationWorking with SlidesFormatting TextInserting Tables and TextAdding Rows and Columns and Designing TablesPictures on SlidesSmartArt and WordArtHyperlinks and ActionsAdding Video and Audio
06MS PowerPoint: Design, Slide Show and Sharing7 topics
Formatting and Designing the PresentationAdding and Removing TransitionsAnimationsSlide Show Settings: Advancing Slides and Multiple MonitorsReview ToolsSlide Master, Handout Master and Notes MasterSaving, Sharing, Printing and Closing the Presentation
Foundation level
Essential in Office Automation
Beginners who need a quick, 24-hour start in Word, Excel and PowerPoint for study or office work.
24 hours6 modules · 58 topicsCertificate: CADD Centre network
01MS Word: Basics of a Document8 topics
Starting a New DocumentHome Tab: Cut, Copy, Paste and Format PainterFind and ReplaceFormatting TextFill ColourApplying StylesUsing PicturesUsing SmartArt
02MS Word: Editing, Formatting and Finalising14 topics
Using Text BoxesOffice Add-ins (My Apps and Store)Header and FooterAdding SignaturesGrouping Multiple ObjectsWrapping TextPage Setup: Size, Columns, Breaks, Indents and SpacingHyphenationReferencesCitation and BibliographyMail MergeReviewing the Document and CommentsViewing the DocumentPrinting, Saving and Closing the Document
03MS Excel: Creating and Formatting a Workbook8 topics
Introduction to MS OfficeEntering Data in CellsInserting Rows and ColumnsInserting and Deleting WorksheetsNumber FormatInsert Tab: Tables, Pictures, Slicer, Hyperlink, Header and FooterColumn Charts (2D and 3D)Bar, Pie, Scatter, Combo and Line Charts
04MS Excel: Data, Formulas and Saving10 topics
Data TabSort and FilterFlash FillData ValidationRemoving DuplicatesPage LayoutFormulasReview: Spelling, Research, Thesaurus and CommentsView Options and Freeze PanesSaving, Recovering an Unsaved Workbook and Closing
05MS PowerPoint: Creating and Editing a Presentation11 topics
Introduction to PowerPointQuick Access ToolbarOpening an Existing PresentationWorking with SlidesFormatting TextInserting Tables and TextAdding Rows and Columns and Designing TablesPictures on SlidesSmartArt and WordArtHyperlinks and ActionsAdding Video and Audio
06MS PowerPoint: Design, Slide Show and Sharing7 topics
Formatting and Designing the PresentationAdding and Removing TransitionsAnimationsSlide Show Settings: Advancing Slides and Multiple MonitorsReview ToolsSlide Master, Handout Master and Notes MasterSaving, Sharing, Printing and Closing the Presentation
Foundation level
Certificate in Office Automation using MS Office
Learners who want the core Office trio plus 24 hours of Advanced Excel with macros and VBA, in 40 hours.
40 hours6 modules · 90 topicsCertificate: SynergySBS network
01MS Word22 topics
Starting a New DocumentHome Tab: Cut, Copy, Paste and Format PainterFind and ReplaceFormatting TextFill ColourApplying StylesUsing PicturesUsing SmartArtUsing Text BoxesOffice Add-ins (My Apps and Store)Header and FooterAdding SignaturesGrouping Multiple ObjectsWrapping TextPage Setup: Size, Columns, Breaks, Indents and SpacingHyphenationReferencesCitation and BibliographyMail MergeReviewing the Document and CommentsViewing the DocumentPrinting, Saving and Closing the Document
02MS Excel18 topics
Introduction to MS OfficeEntering Data in CellsInserting Rows and ColumnsInserting and Deleting WorksheetsNumber FormatInsert Tab: Tables, Pictures, Slicer, Hyperlink, Header and FooterColumn Charts (2D and 3D)Bar, Pie, Scatter, Combo and Line ChartsData TabSort and FilterFlash FillData ValidationRemoving DuplicatesPage LayoutFormulasReview: Spelling, Research, Thesaurus and CommentsView Options and Freeze PanesSaving, Recovering an Unsaved Workbook and Closing
03MS PowerPoint18 topics
Introduction to PowerPointQuick Access ToolbarOpening an Existing PresentationWorking with SlidesFormatting TextInserting Tables and TextAdding Rows and Columns and Designing TablesPictures on SlidesSmartArt and WordArtHyperlinks and ActionsAdding Video and AudioFormatting and Designing the PresentationAdding and Removing TransitionsAnimationsSlide Show Settings: Advancing Slides and Multiple MonitorsReview ToolsSlide Master, Handout Master and Notes MasterSaving, Sharing, Printing and Closing the Presentation
04Advanced Excel: Formats, Validation, Names, Tables and Arrays10 topics
Conditional Formatting: Colour Scales, Icon Sets, New Rule, Manage and Clear RulesValid Range and Value RulesCustom Validation Using a FormulaPreventing Duplicate EntriesCreating, Using and Deleting Range NamesAdvanced Range OptionsExcel Tables: Naming, Style, Total Row, Calculated ColumnFiltering and Removing Duplicates in a TableArray Formulas with Ctrl+Shift+EnterOne- and Two-Dimensional, Single- and Multi-Cell Arrays
05Advanced Excel: Functions, Charts and Pivot Tables11 topics
Text FunctionsLogical FunctionsDate and Time FunctionsMath and Trigonometry FunctionsStatistical FunctionsLookup and Reference FunctionsCreating and Formatting Charts, Labels, Chart Type and Data SourceCreating Pivot Tables and Report FieldsRefreshing and Changing Summary FunctionsReport Filter Pages, Subtotals and Multi-Level SubtotalsFormatting, Advanced Options and Pivot Charts
06Advanced Excel: Protection, What-If, Import/Export, Macros and VBA11 topics
Worksheet, Range and Workbook ProtectionSharing and Editing a Shared WorkbookGoal Seek, Data Tables and Scenario ManagerImporting and Exporting Text and CSV FilesChanging Delimiters and SeparatorsDeveloper Tab and Macro SecurityRecording, Running and Deleting MacrosVBA Basics: Message Box, InputBox and CommentsSub Procedures, Functions, Constants and VariablesOperators, Loops and DecisionsUser Forms in VBA
Foundation level
Course on Office Automation
Learners who want the full Microsoft Office 2021 suite in 64 hours – Word, Excel, PowerPoint, Access and Outlook – with hands-on projects.
64 hours9 modules · 97 topicsCertificate: Livewire network
01Word 2021: Documents and Styling10 topics
Word Interface and Primary ToolsCreating, Structuring and Saving DocumentsGetting Started: Templates, Opening PDFs and Non-Native Files, Save As and ExportNavigation Pane, Go To, Find & Replace, Hyperlinks, Bookmarks and Cross-ReferencesPage Setup, Themes, Style Sets, Watermarks, Page Numbers, Colours and BordersHeaders and FootersAdding, Editing and Moving TextHeading and Paragraph StylesImages, Shapes and Artistic EffectsTable Creation and Formatting
02Word 2021: Publishing, Long Documents and Automation8 topics
Desktop Publishing with WordLong Document ManagementMail MergeProofing and Editing ToolsTrack Changes and Collaborative RevisionsUsing Preset TemplatesPassword Protection and Backward CompatibilityAutomating with Macros
03Excel 2021: Workbooks, Formulas and Charts11 topics
Workbooks and Worksheets: Creating, Naming and ManagingEditing and Formatting Cells, Rows and ColumnsEntering and Manipulating DataTables for Organised DataBasic Formulas, Functions, Operators and Cell ReferencesConditional Functions and IF StatementsDate/Time and Text FunctionsImages, Illustrations and GraphicsCharts and DiagramsSorting, Filtering and Conditional FormattingData Lists and Forms
04Excel 2021: Analysis and Automation11 topics
Pivot Tables for Summarising DataCalculated Fields, Timelines and SlicersPivot ChartsWhat-If AnalysisGoal Seek and SolverAnalysis ToolPakData Validation TechniquesGet & Transform (Power Query) for Importing and Cleaning DataFormula Auditing and Error TroubleshootingRecording and Running MacrosIntroduction to VBA
05PowerPoint 202114 topics
Structure of a Good PresentationThemes and LayoutsText TechniquesCombining Text with Images, Graphs and ChartsViews, Layouts and ProofingSpeaker NotesImages and ShapesDesigning TablesChartsSmartArtSound and VideoTransitions and AnimationsSlide MasterPrint, Share and Export
06Access 2021: Databases, Tables and Forms9 topics
Introduction to Access and Its UsesSystem Requirements and SetupFoundations of DatabasesDatabase ObjectsNavigating the Access InterfaceBuilding Your First Database and TablesObject ViewsDesigning FormsForm Controls and Styling
07Access 2021: Queries, Relationships and Reports12 topics
Select QueriesCriteria, Operators and WildcardsParameter QueriesCreating and Managing RelationshipsDatabase NormalisationCalculated ExpressionsAggregate QueriesGenerating ReportsAdvanced Report Design, Grouping and SortingPrinting and Exporting ReportsImporting and Exporting DataLatest Access Features
08Outlook 202111 topics
Outlook Interface and ConfigurationCreating, Formatting and Sending EmailUnderstanding Email HeadersOrganising the InboxAddress Books and ContactsAutomatic RepliesEmail Styling and SignaturesEmail RulesCalendar and SchedulingTasks and RemindersShared Calendars, Collaboration and Alerts
09Projects11 topics
Word: Event BrochureWord: Research Paper with Table of Contents and CitationsPowerPoint: Interactive Training ModulePowerPoint: Project Status DashboardExcel: Dynamic Dashboard with PivotTables and SlicersExcel: Personal Finance TrackerOutlook: Email Organisation SystemOutlook: Task Management SystemAccess: CRM DatabaseAccess: Project Tracking DatabaseAccess: Library Management System
Master level
Advanced Certificate in Office Automation
Job seekers who want one 128-hour programme covering Word, Excel, PowerPoint, Advanced Excel with VBA and TallyPrime accounting.
128 hours8 modules · 116 topicsCertificate: SynergySBS network
01MS Word22 topics
Starting a New DocumentHome Tab: Cut, Copy, Paste and Format PainterFind and ReplaceFormatting TextFill ColourApplying StylesUsing PicturesUsing SmartArtUsing Text BoxesOffice Add-ins (My Apps and Store)Header and FooterAdding SignaturesGrouping Multiple ObjectsWrapping TextPage Setup: Size, Columns, Breaks, Indents and SpacingHyphenationReferencesCitation and BibliographyMail MergeReviewing the Document and CommentsViewing the DocumentPrinting, Saving and Closing the Document
02MS Excel18 topics
Introduction to MS OfficeEntering Data in CellsInserting Rows and ColumnsInserting and Deleting WorksheetsNumber FormatInsert Tab: Tables, Pictures, Slicer, Hyperlink, Header and FooterColumn Charts (2D and 3D)Bar, Pie, Scatter, Combo and Line ChartsData TabSort and FilterFlash FillData ValidationRemoving DuplicatesPage LayoutFormulasReview: Spelling, Research, Thesaurus and CommentsView Options and Freeze PanesSaving, Recovering an Unsaved Workbook and Closing
03MS PowerPoint18 topics
Introduction to PowerPointQuick Access ToolbarOpening an Existing PresentationWorking with SlidesFormatting TextInserting Tables and TextAdding Rows and Columns and Designing TablesPictures on SlidesSmartArt and WordArtHyperlinks and ActionsAdding Video and AudioFormatting and Designing the PresentationAdding and Removing TransitionsAnimationsSlide Show Settings: Advancing Slides and Multiple MonitorsReview ToolsSlide Master, Handout Master and Notes MasterSaving, Sharing, Printing and Closing the Presentation
04Advanced Excel: Formats, Validation, Names, Tables and Arrays10 topics
Conditional Formatting: Colour Scales, Icon Sets, New Rule, Manage and Clear RulesValid Range and Value RulesCustom Validation Using a FormulaPreventing Duplicate EntriesCreating, Using and Deleting Range NamesAdvanced Range OptionsExcel Tables: Naming, Style, Total Row, Calculated ColumnFiltering and Removing Duplicates in a TableArray Formulas with Ctrl+Shift+EnterOne- and Two-Dimensional, Single- and Multi-Cell Arrays
05Advanced Excel: Functions, Charts and Pivot Tables11 topics
Text FunctionsLogical FunctionsDate and Time FunctionsMath and Trigonometry FunctionsStatistical FunctionsLookup and Reference FunctionsCreating and Formatting Charts, Labels, Chart Type and Data SourceCreating Pivot Tables and Report FieldsRefreshing and Changing Summary FunctionsReport Filter Pages, Subtotals and Multi-Level SubtotalsFormatting, Advanced Options and Pivot Charts
06Advanced Excel: Protection, What-If, Import/Export, Macros and VBA11 topics
Worksheet, Range and Workbook ProtectionSharing and Editing a Shared WorkbookGoal Seek, Data Tables and Scenario ManagerImporting and Exporting Text and CSV FilesChanging Delimiters and SeparatorsDeveloper Tab and Macro SecurityRecording, Running and Deleting MacrosVBA Basics: Message Box, InputBox and CommentsSub Procedures, Functions, Constants and VariablesOperators, Loops and DecisionsUser Forms in VBA
07TallyPrime Foundation12 topics
Fundamentals of Accounting: Terms, Concepts and PrinciplesDouble Entry and Golden Rules of AccountingSource DocumentsInstalling TallyPrime and Creating a CompanyCompany Features and ConfigurationMigrating Tally.ERP 9 DataChart of Accounts: Ledgers and GroupsInventory Masters: Stock Groups, Units, Items, Godowns and CategoriesAccounting and Inventory VouchersInvoicing and Bill-wise DetailsTrading, Profit and Loss, Balance Sheet and Cash FlowAccounting and Inventory Books, Exception Reports
08TallyPrime Advanced14 topics
Cost Centres and Cost CategoriesMultiple CurrenciesInterest CalculationsBudgets, Controls and Scenario ManagementBank ReconciliationPurchase and Sales Order ProcessingReorder Levels, Batch-wise Details and Bill of MaterialsActual vs Billed Quantities, Zero-Valued Entries and Additional CostsPoint of Sale (POS)GST: Configuration, Masters, Transactions, Payments and ReportsTDS: Configuration, Masters, Rates, Transactions, Challan 281 and ReportsPayroll: Masters, Salary Structure, PF, ESI, Processing and ReportsTallyVault, Security, Backup, Restore and Split Company DataStatutory Reports, Trial Balance, Day Book, Stock Summary and Outstandings
04Tools covered
Software and tools you will use
Microsoft WordMicrosoft ExcelMicrosoft PowerPointMicrosoft AccessMicrosoft OutlookMail MergePivot Tables and ChartsGet & Transform (Power Query)Macros and VBATallyPrime (Advanced Certificate)
We provide training and instruction only. Software and licences are not included; use your own licence, or an educational or trial licence where the software maker offers one. See our Software & Licensing Policy. Certificates are skill-training certificates, not degrees or professional licences.
05Projects
Practice projects
Formatted research report
Set up a report with headings, a table of contents, headers, footers and citations.
Excel dashboard
Summarise sales or marks with pivot tables, charts and slicers.
Mail merge letters
Send personalised letters or certificates to a list of names from Excel.
06How online works
How the MS Office / Office Automation course runs online
Pick the mode that matches where you are and what you can travel for.
Live online
Trainer-led sessions on your own computer. Same syllabus, project and certificate as classroom batches. Evening, early-morning or weekend slots in your time zone.
Hybrid
Part online, part in the lab. Take lab sessions at Vellore, Katpadi or Ranipet when you visit India, and the rest online. Depends on trainer and lab availability.
100% offline in India
Learn at our centres on any date that suits you and the trainer. Fast-track schedules possible. Partner-centre options in other cities are explored case by case.
07Class timings
Find your class time
Example slots for popular regions. Your exact timing is fixed with the trainer on WhatsApp.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| Dubai · Abu Dhabi | Weekday evening | 7:00 PM–9:00 PM | 8:30 PM–10:30 PM |
| Dubai · Abu Dhabi | Weekday early morning | 6:00 AM–8:00 AM | 7:30 AM–9:30 AM |
| Dubai · Abu Dhabi | Weekend morning | 9:00 AM–11:00 AM | 10:30 AM–12:30 PM |
Slots marked “late night in India” need the trainer’s confirmation. Final timings are fixed on WhatsApp based on trainer and student availability; any date and time can be arranged where a trainer is available.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| London · Manchester · Birmingham | Weekday evening | 7:00 PM–9:00 PM | 12:30 AM–2:30 AM (next day) late night in Indiawinter · summer: 11:30 PM–1:30 AM late night in India |
| London · Manchester · Birmingham | Weekday early morning | 6:00 AM–8:00 AM | 11:30 AM–1:30 PMwinter · summer: 10:30 AM–12:30 PM |
| London · Manchester · Birmingham | Weekend morning | 9:00 AM–11:00 AM | 2:30 PM–4:30 PMwinter · summer: 1:30 PM–3:30 PM |
Slots marked “late night in India” need the trainer’s confirmation. Final timings are fixed on WhatsApp based on trainer and student availability; any date and time can be arranged where a trainer is available.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| Singapore | Weekday evening | 7:00 PM–9:00 PM | 4:30 PM–6:30 PM |
| Singapore | Weekday early morning | 6:00 AM–8:00 AM | 3:30 AM–5:30 AM late night in India |
| Singapore | Weekend morning | 9:00 AM–11:00 AM | 6:30 AM–8:30 AM |
Slots marked “late night in India” need the trainer’s confirmation. Final timings are fixed on WhatsApp based on trainer and student availability; any date and time can be arranged where a trainer is available.
08Pair it with
Related online courses
Office Automation
Advanced Excel Course
Work faster in Excel with lookups, pivot tables, validation, what-if tools and macros that take the repetition out of reports.
1 level24 h
Online details Business Accounting and Taxation
Tally Prime Course
Keep books, raise GST invoices, track stock, process payroll and close the year in TallyPrime – the way real offices do it.
3 levels80–110 h
Online details Business Accounting and Taxation
Power BI Course
Turn raw Excel sheets and database tables into clean, interactive Power BI dashboards that managers actually use.
3 levels30–60 h
Online details Special Programs
Employability Skills Course
Speak clearly, write professional emails, handle group discussions and face interviews with confidence – through practice, not just theory.
2 levels4–40 h
Online details 09FAQ
MS Office / Office Automation online – FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppCan I learn MS Office / Office Automation online from outside India?
Yes. MS Office / Office Automation is taught live online by a trainer, with the same syllabus, hours and project as the classroom batch. Batches are planned around your time zone, subject to trainer availability.
How many hours is the MS Office / Office Automation course?
MS Office / Office Automation is offered at 5 levels (24–128 h): Certificate in Office Automation – 24 hours; Essential in Office Automation – 24 hours; Certificate in Office Automation using MS Office – 40 hours; Course on Office Automation – 64 hours; Advanced Certificate in Office Automation – 128 hours.
Do I need to buy the software?
We teach; we do not supply software. Use your own licence or an educational or trial licence where the maker offers one. Our Software & Licensing Policy explains the rules.
Can I attend some classes in person in India?
Yes. Hybrid and fully offline options are available at our Vellore, Katpadi and Ranipet centres on dates agreed in advance, depending on trainer and lab availability.
What does it cost?
Fees depend on the level and mode. Message +91 8111 029 125 on WhatsApp for the current fee and payment options for your country.
Will I get a certificate?
On completing the course and its project you receive the SynergySBS network certificate. It is a skill-training certificate, not a degree or a professional licence.
Start from anywhere
Get the MS Office / Office Automation syllabus, fee and next batch
Tell us your country and preferred time. We reply on WhatsApp with the syllabus, fee and the next available batch.
- Live online, hybrid or 100% offline in India
- Batches in your time zone, based on trainer availability
- Free counselling and a syllabus on WhatsApp
- One number for everything: +91 8111 029 125