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. Also, access course material for 1 year.
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.
Access to Tally Job Portal
The Tally Job Portal offers a seamless interface that connects Tally-certified learners with employers, streamlining the hiring process and boosting career prospects in accounting, finance, and business.
What You Will Learn
- 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.
Suggested Courses
Our courses include interactive and interesting content, concepts and content delivery to ensure you a delightful learning experience.
Tally Certification with Online Internship
Get hands-on Accounting experience with Tally’s NEP-aligned Online Internship
Tally Certification with GST Simulation
A Dynamic Platform for Practising GST Returns with Tally Certification to Level Up Your Career
Complete Guide to Payroll & Income Tax
Manage payroll & taxes with TallyPrime - process salaries & ensure compliance.
Complete Guide to Inventory Management
Master inventory control with TallyPrime - track, manage & optimize seamlessly.