Call Us

+91 9166303035

Office Automation

Home / Office Automation

Faculty: Tally Certified Trainer (TCT)

Course Overview

Office Automation course equips you with essential skills in Basic Computer Applications, MS Word, MS Excel, and MS PowerPoint, preparing you for modern workplace requirements. Through comprehensive training, learn to create professional documents, manage data, and design effective presentations.  

Practical exercises ensure you gain hands-on experience with the latest Windows 11 and MS Office tools. From understanding computer basics to mastering advanced office applications, develop the fundamental skills that are essential in today’s digital workspace. 

Features

Blended Learning Module

The blended learning module combines text-based materials with interactive video content, providing a comprehensive learning experience.

Interactive Learning Materials

Interactive learning materials includes a variety of resources such as explainer videos, tutorial videos, quizzes, and infographics, ensuring an engaging and effective learning journey.

Grading and Assessment

Grading and assessment consists of various question types including multiple choice questions (MCQs), true or false, match the following, and image-based questions.

Verifiable Certificate

The course is designed in accordance with industry-preferred curriculum standards, known as competency frameworks. Upon completion, learners receive a digital certificate verified by Tally.

What You Will Learn

Chapter 1 - 5
  • An Introduction to Computer 
  • Component of Computer- Hardware & Software 
  • Introduction to Windows 11 
  • Desktop & Its Properties 
  • Mouse & Region Option
  • Practice Exercise 
  • Introduction 
  • File and Folder Management 
  • Uses of Wild Card
  • Recycle Bin 
  • Notepad 
  • Practice Exercise 
  • Introduction 
  • Creating and Setup of New Document
  • Page Setup 
  • Formatting Text 
  • Copy & Paste Using Clipboard
  • Save and Save As 
  • Open Saved File  
  • Practice Exercise 
  • Introduction 
  • Paragraph Formatting Features 
  • Bullets & Numbering 
  • Border and Shading
  • Format Painter 
  • Practice Exercise 
  • Introduction 
  • Understanding Table 
  • Headers and Footers 
  • Comments in Word
  • Bookmark & Hyperlink 
  • Understanding Illustration Group 
  • Practice Exercise 
  • Introduction
    Change Case
    Page Break and Section Break
    Understanding Columns
    Auto Correct
    Find and replace
    Spelling and grammar check
    Tracking Changes
    Watermark
    Protect Document
    Practice Exercise
  • Introduction to MS Excel 
  • Entering Data in Cell 
  • Types of Data 
  • Moving Around a Worksheet 
  • Format Data 
  • Best Fit or Auto Fit 
  • Data Editing 
  • Working with Worksheet 
  • Basic Mathematical Calculation 
  • Saving a Workbook 
  • Opening and Closing Workbooks 
  • Practice Exercise 
  • Introduction
  • Rows and Columns Management 
  • Change the Colour of Text
  • Worksheet Management 
  • Table Style 
  • Custom List 
  • Format Painter 
  • Practice Exercise 
  • Introduction 
  • Relative Cell Reference 
  • Absolute Cell Reference 
  •   Mixed Cell Reference 
  • Circular Cell Reference 
  • Practice Exercise 
  • Introduction 
  • Filling Series 
  • Flash Fill
  • Number Formatting 
  • Conditional Formatting 
  • Name Range 
  • Adding Comments 
  • Practice Exercise 
  • Introduction
  • Basic Concept of Formula 
  • Math and Trigonometry Functions 
  • Statistical Functions 
  •  Date and Time Function 
  • Practice Exercise 
  • Introduction 
  • IF Function 
  • Nested IF 
  • SUMIF 
  • COUNT and COUNTIF 
  • COUNTBLANK 
  • Practice Exercise 
  • Introduction 
  • PMT Function 
  • PPMT Function 
  • IPMT Function 
  • PV Function 
  • Rate 
  • NPER 
  • Practice Exercise 
  • Introduction 
  • VLOOKUP 
  • HLOOKUP 
  • Practice Exercise 
  • Introduction 
  • Charts 
  • Creating Pivot Table 
  • Pivot Table Formatting 
  • Pivot Chart 
  • Practice Exercise 
  • Introduction 
  • Data Filter 
  • Remove Duplicates 
  • Paste Special 
  • Data validation 
  • Splitting Work Sheet 
  • Freeze Pane 
  • Page Setup 
  • Workbook Protection 
  •   Practice Exercise 
  • Introduction 
  • How to Open PowerPoint 
  • Creating a new Presentation 
  • Applying Theme, Effect, Quick Styles, and Transition 
  •  Insert a Blank Slide and Creating Text Box 
  • Custom Animation, Applying Sound, and Speed 
  •   Set Advance Slide and Recording a Narration 
  • Setting up Slide Show 
  • Inserting a Picture, Word Art Text, Content Slide Layout, and Background Style 
  • Save and Reopen PowerPoint Presentation 
  •   Practice Exercise 
  • Introduction 
  • Creating Presentation Using Templates 
  • Slide Master 
  • Inserting Slide Number, Header and Footer 
  • Different Views 
  • Delete Slide, Protecting a Presentation with a Password 

Learning Journey

Shareable Certificate

Frequently Asked Questions (FAQs)

This course is highly recommended for working professionals and students who aspire to build a successful career.

This certification course covers topics on office automation. The content is aligned with current statutory requirements, making it highly preferred in the industry.

You can enroll for the course through our partner network spread across the country and globally. Locate A Partner nearby and enroll today for the course.

The assessment is necessary to complete the course and attain the certificate which will help your career growth and enable you to showcase your key skills.

After successfully completing the course and meeting the stated assessment requirements, you will receive a digital certificate that can be verified on the Tally Education website.

For any issues or queries, you can contact our support team via email at content.support@tallysolutions.com.

Get a Free Quote

Having Trouble Managing Your Finance?

CONTACT US NOW

Other Courses

TDS using Tally

Home / TDS using Tally Faculty: Tally Certified Trainer (TCT) Course Overview A Complete Guide on Tax Deducted at Source (TDS) This is a specialised

Read More »

GST using TallyPrime

Home / GST using TallyPrime Faculty: Tally Certified Trainer (TCT) Course Overview A Complete Guide on Goods and Services Tax (GST) This is a specialised

Read More »

TallyProfessional

Home / TallyProfessional Faculty: Tally Certified Trainer (TCT) Course Overview want to further improve in their careers. TallyProfessional certifies individuals to possess a deeper comprehension

Read More »

TallyEssential

Home / TallyEssential Faculty: Tally Certified Trainer (TCT) Course Overview  A Complete Guide on Business Accounting This entry-level certification helps the learners to be proficient

Read More »

Courses Details

  • Course Duration:
  • 25 Hrs
  • Assessment Duration:
  • 60 Min
  • You will get a Certificate of Merit

Phone

WhatsApp

Unique Computer is an esteemed Tally Institute of Learning, officially authorized by Tally Education Pvt. Ltd., Bangalore—a subsidiary of Tally Solutions Pvt. Ltd.

Facebook Twitter Instagram Youtube

Quick Links

Products

Courses

Information

Phone

+91 9166303035

Email

info@uniquearena.com

Address

3rd Fl, NK Tower, Opp. Kohinoor Cinema, CHB Rd, Jodhpur, RJ

Copyright 2025 © All Right Reserved Design by Unique | Website Developed by Flown Developer