Office Automation
Course category : Certification Course
Course Duration: 25 Hours
Assessment Duration: 60 Min
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.
what you will learn
Chapter 1: Introduction to Computer Application
1.1 Introduction 1.2 Components of Computer-Hardware & Software 1.2.1 Hardware 1.2.2 Software 1.3 Introduction to Windows 11 1.4 Desktop and its Properties 1.4.1 Mouse Properties & Region Option Shortcut Keys Practice Exercises
Chapter 2: Application of Windows 11
2.1 Introduction 2.2 Files and Folder Management 2.3 Wild Cards Concept in Windows 11 2.4 Recycle Bin 2.5 Notepad Practice Exercises
Chapter 3: Microsoft Word for Accounting Documentation
3.1 Introduction 3.1.1 Creating and Setup of New Documents 3.2 Paragraph Formatting 3.3 Working with Insert Tab 3.4 Different Functions in Word Practice Exercises
Chapter 4: Microsoft Excel for Accounting
4.1 Introduction 4.1.1 Overview of the Worksheet 4.2 Inserting and Basic Formatting of Data 4.3 Working with Cell Referencing 4.4 Number and Conditional Formatting 4.5 Working with Formulas 4.6 Logical Functions 4.7 Basics of Financial Function 4.8 Working with Lookup Function 4.9 Goal Seek 4.10 Working with Charts and Pivot Table 4.11 Different Functions in MS Excel Conclusion Practice Exercises
Chapter 5: Microsoft PowerPoint for Financial Presentations
5.1 Getting Started with PowerPoint 5.1.1 How to Open PowerPoint 5.2 Creation & Finalisation of Presentation 5.2.1 Creating Presentation Using Templates Conclusion Practice Exercises
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.
Tally Tutor (AI Learning Assistant)
Tally Tutor is an AI-powered learning assistant that instantly answers course-related queries, links learners to relevant chapters, and explains real-world Tally examples, making learning smarter, faster, and more engaging.
Advanced Features
GST Compliance through Simulation
This practical and interactive training tool replicates GST processes and calculations, including GST returns, generating e-Way bills, and e-Invoicing, providing learners with hands-on experience in GST compliance.
Online Internships
Tally’s online internships offer learners practical, hands-on experiences aligned with the National Education Policy (NEP), emphasizing experiential learning over rote memorization to enhance understanding and application of concepts.