Classroom & live online 180 Hours Verifiable certificate Syllabus ↓

Office Automation Professional Course

Learn MS Office in depth with advanced Excel, Access, Outlook, typing and TallyPrime accounting.

Your roadmap — from admission to certificate

  1. Free counselling

    Talk to our counsellor — choose the right course, batch time and mode.

  2. Admission

    Join at a CADD centre near you or online. You get your student login and ID card.

  3. Learn step by step

    180 Hours of hands-on Office Automation Professional classes — in the classroom or live online.

    Computer and Windows EssentialsTyping in English and HindiMS Word: Professional DocumentsMS Word: Long Documents and ReviewMS Excel: Core SkillsMS Excel: Advanced AnalysisMS PowerPoint: PresentationsMS Access: DatabasesMS Outlook and Online CollaborationInternet and Cyber Safety
  4. Practice & project

    Exercises in every class and a final project, checked by your trainer.

  5. Course completion certificate + completion badge

    Finish the course and get your course-completion certificate and a digital completion badge with your name.

    Sample course-completion certificate — Professional Course in Office Automation
    Course-completion certificate (sample) — Professional Course in Office Automation · verifiable online
    Course-completion badge — Professional Course in Office Automation
    Course-completion badge
    Course
    Professional Course in Office Automation
    Issued by
    CADD Training Cetre
    Training
    Classroom or live online
    How to earn
    Complete the course and its project
    With your name and year · its own verify link · “Add to profile” on LinkedIn
  6. Certification exam

    Take the certification exam: a theory test and a practical task — at the centre or online.

  7. Certified certificate + marksheet

    Pass the exam and get the certified certificate with your marksheet. Anyone can check it online with its QR code.

  8. Certified badge

    Your certified badge — add it to LinkedIn and share it anywhere; it opens its own verify page.

    Certified badge — Professional Course in Office Automation
    Certified badge
    Course
    Professional Course in Office Automation
    Issued by
    CADD Training Cetre
    Training
    Classroom or live online
    How to earn
    Pass the certification exam
    You also get
    Certified certificate + marksheet
    With your name and year · its own verify link · “Add to profile” on LinkedIn
  9. Make your CV & apply for jobs

    Make your CV in your student panel (Career → My CV) — your course, certificates and projects are added for you. Send it as a link with a preview picture, and apply to jobs and Hire Me requests from companies.

About the Office Automation Professional course

Objective of the Course

 To provide an in-depth training in use of office automation (word processing, spreadsheet and presentation software tools of Microsoft), internet and internet tools. The course also helps the candidates to students/professionals to enhance their accounting/mathematical skills and increase their productivity.

Learning Outcomes

 After completion of the course, students/professionals would be able to documents, spreadsheets, make small presentations and would be acquainted with internet. The participants are also trained to mastering in Tally ERP 9 and Reach Accountant, financial and use them for accounting, inventory, tax and related modules.

Duration of the Course (in hours)

180 hrs Appr.

Minimum Eligibility Criteria and prerequisites

 if any Knowledge of reading and writing in English

 

Who can enroll?

  • The course is suitable for students and working professionals.
  • Accounting professionals
  • Freshers looking for an entry into accounting field
  • Graduates/graduating students of BCom, BBA, BA, BCS, MCom and MBA
  • Students of BCom, BBA, BA, BCS, MCom and MBA.

You will be able to

  • Prepare professional documents and reports in MS Word with styles and references
  • Analyse data in Excel with lookup functions, PivotTables, charts and data tools
  • Build simple MS Access databases with tables, queries, forms and reports
  • Design and deliver effective presentations in PowerPoint
  • Manage email, calendar and contacts in Outlook
  • Maintain accounts, inventory and GST records in TallyPrime
  • Type in English and Hindi with good speed and accuracy

Who it is for

  • Students and graduates who want strong office and accounts skills
  • Job seekers preparing for computer operator, office executive or accounts roles
  • Working staff who want to improve their productivity in offices
  • Small business owners who want to manage records and accounts

What you need

  • Basic English reading and writing
  • Basic computer familiarity is helpful; beginners are guided from the start
  • A PC or laptop with internet access for live online classes

Courses that include Office Automation Professional

Professional Course in Office AutomationProfessional Course · 180 Hours
Enquire →

Office Automation Professional Syllabus

14 chapters · 64 topics
01 Computer and Windows Essentials 4 topics
  1. Computer hardware, software and networks
  2. Windows desktop, File Explorer and settings
  3. Installing apps and managing printers
  4. Data backup, compression and antivirus
02 Typing in English and Hindi 4 topics
  1. Touch typing technique
  2. English typing speed practice
  3. Hindi Unicode typing with InScript keyboard
  4. Typing tests and accuracy improvement
03 MS Word: Professional Documents 5 topics
  1. Formatting, styles and themes
  2. Tables, pictures, shapes and SmartArt
  3. Sections, columns and page breaks
  4. Headers, footers and page numbers
  5. Mail Merge
04 MS Word: Long Documents and Review 5 topics
  1. Table of contents and captions
  2. Footnotes, endnotes and references
  3. Track Changes and comments
  4. Protecting documents
  5. Templates and forms
05 MS Excel: Core Skills 5 topics
  1. Formatting, number formats and AutoFill
  2. Relative, absolute and mixed references
  3. Math, text and date functions
  4. Logical functions: IF, AND, OR, IFERROR
  5. Charts and printing
06 MS Excel: Advanced Analysis 6 topics
  1. VLOOKUP, HLOOKUP, XLOOKUP and INDEX-MATCH
  2. Sorting, filtering and Advanced Filter
  3. Data Validation and drop-down lists
  4. Conditional formatting and Excel Tables
  5. PivotTables and PivotCharts
  6. What-If Analysis and Goal Seek
07 MS PowerPoint: Presentations 5 topics
  1. Slide Master and themes
  2. Images, charts, tables and SmartArt
  3. Animations, transitions and timing
  4. Audio, video and hyperlinks
  5. Presenter view and exporting as PDF or video
08 MS Access: Databases 5 topics
  1. Database concepts, tables and fields
  2. Primary keys and relationships
  3. Queries for searching and calculating
  4. Forms for data entry
  5. Reports for printing
09 MS Outlook and Online Collaboration 4 topics
  1. Email accounts, folders and rules
  2. Calendar, meetings and contacts
  3. OneDrive and Google Drive sharing
  4. Online meetings and shared documents
10 Internet and Cyber Safety 4 topics
  1. Web browsing and effective search
  2. Government and banking online services
  3. Digital payments and UPI safety
  4. Phishing, passwords and two-step verification
11 Accounting Basics and TallyPrime 4 topics
  1. Accounting terms and golden rules
  2. Company creation and F11 features
  3. Groups, ledgers and opening balances
  4. Shortcut keys and Gateway of Tally
12 TallyPrime Vouchers, Inventory and GST 5 topics
  1. Contra, payment, receipt and journal vouchers
  2. Sales and purchase with inventory
  3. Stock items, units and godowns
  4. GST setup and GST invoices
  5. Bank reconciliation
13 Tally Reports and Payroll Basics 4 topics
  1. Day Book, ledgers and outstanding reports
  2. Trial Balance, Profit & Loss and Balance Sheet
  3. Payroll basics: employees and pay heads
  4. Backup, restore and security
14 Final Office Project 4 topics
  1. Business report in Word with data from Excel
  2. Excel dashboard with PivotTables
  3. Complete accounts of a trading firm in Tally
  4. Practical test and interview preparation

Ratings & reviews

Students rate the course after they finish it — their ratings appear here.

Office Automation Professional course — FAQ

What is taught in the Office Automation Professional course?

The course covers Windows, English and Hindi typing, MS Word, advanced Excel, PowerPoint, Access and Outlook, internet and cyber safety, and accounting in TallyPrime with GST and basic payroll.

Can a beginner join the Office Automation Professional course?

Yes. The course starts with computer and Windows basics, so beginners can join, although some earlier computer use helps you move faster through the advanced parts.

How long is the Office Automation Professional course?

Office Automation Professional is a 180 Hours programme, giving time for in-depth MS Office practice, typing, Tally and a final office project.

Is this course available online and in the classroom?

Yes, both. Classes run at CADD Training Centre branches and as live online sessions with practice files and assignments.

Will I get a certificate for Office Automation Professional?

Yes. Completing Office Automation Professional earns a CADD Training Centre certificate, which employers can confirm online by scanning the QR code or entering the verification code.

What jobs can I get after this course?

You can apply for computer operator, office executive, MIS assistant, data entry operator, accounts assistant and back office executive roles.

What is the difference between Office Automation Associate and Professional?

The Associate course covers MS Office and internet basics. The Professional course adds advanced Excel, MS Access, Outlook, English and Hindi typing and TallyPrime accounting with GST.

More questions? Ask our counsellor or read the general FAQ.

Office Automation Professional180 Hours
Enquire now