Computech Education Center

Certification IN CMO & TALLYPRIME ( M-021 )

BASIC INFORMATION

Course Fees : 7000.00 8500.00/-
Course Duration : 150 DAYS
Minimum Amount To Pay : Rs.0.00

Admission Now

Course Title: CMO Certification in Microsoft Office

Duration: 90 Days

Course Overview: This comprehensive course is designed to equip learners with essential skills in Microsoft Office applications, focusing on Word, Advanced Excel, Basic MS Access, PowerPoint, Kannada Nudi typing, English typing, and advanced internet skills. By the end of the course, participants will be proficient in utilizing these tools for both personal and professional purposes.

Course Modules

Module 1: Microsoft Word (Days 1-15)

Introduction to MS Word
- Overview of the interface and features
Basic Document Formatting
- Text formatting (font styles, sizes, colors)
- Paragraph formatting (alignment, line spacing, indentation)
Advanced Features
- Styles and themes
- Headers and footers
- Tables and charts
- Mail Merge
Collaboration Tools
- Track changes and comments
Project: Create a professional document (e.g., resume, report)

Module 2: Advanced Excel (Days 16-45)

Excel Basics
- Introduction to spreadsheets and basic functions
Formulas and Functions
- Overview of more than 100 formulas including:
  - Basic arithmetic (SUM, AVERAGE)
  - Logical functions (IF, AND, OR)
  - Lookup functions (VLOOKUP, HLOOKUP)
  - Text functions (CONCATENATE, TEXT)
  - Date and time functions
  - Financial functions (PMT, FV)
  - Array formulas
Data Analysis Tools
- PivotTables and PivotCharts
- Conditional formatting
Data Visualization
- Creating and customizing charts
Project: Data analysis project using real-world datasets

Module 3: Basic MS Access (Days 46-60)

Introduction to MS Access
- Understanding databases and data management
Database Creation
- Designing tables and relationships
Data Entry and Forms
- Creating forms for data input
Queries and Reports
- Basic queries for data retrieval
- Generating reports
Project: Create a simple database for inventory management

Module 4: PowerPoint (Days 61-75)

Introduction to PowerPoint
- Understanding the interface and features
Creating Effective Presentations
- Slide design principles
- Adding text, images, and multimedia
Advanced Features
- Animations and transitions
- Speaker notes and rehearsal tools
Collaboration Tools
- Sharing and collaborating on presentations
Project: Create a professional presentation on a chosen topic

Module 5: Kannada Nudi and English Typing (Days 76-80)

Introduction to Kannada Nudi Typing
- Installation and usage of Kannada Nudi
- Basic typing skills and practice
English Typing Skills
- Touch typing techniques
- Typing practice and speed tests

Module 6: Advanced Internet Skills (Days 81-90)

Navigating the Internet
- Effective searching techniques
Downloading Important Documents
- How to download an Aadhaar card
- How to apply for a passport
- How to apply for a PAN card
Online Safety and Security
- Understanding safe browsing practices
Digital Communication
- Best practices for professional emails and online communication

Assessment and Certification

Continuous Assessment: Quizzes, assignments, and projects throughout the course
Final Assessment: Comprehensive exam covering all modules
Certification: Upon successful completion, participants will receive a CMO Certification in Microsoft Office

Additional Resources

Access to online forums and discussion groups
Recommended reading materials and video tutorials
Weekly Q&A sessions with instructors

1. Introduction to Tally Prime

Overview of Tally Prime
Installation and setup of Tally Prime
Features and benefits of Tally Prime

2. Creating and Configuring a Company

Creating a new company
Company features and configurations
Security controls and user management

3. Inventory Management

Creating inventory masters (Stock groups, Stock items, Units of Measure, etc.)
Stock categories and stock valuation methods
Managing godowns (warehouses)

4. Accounting Features

Chart of Accounts (Creating Ledger and Group Masters)
Voucher entry types (Payment, Receipt, Journal, etc.)
Accounting vouchers configuration
Contra, debit/credit notes

5. Banking Features

Cheque management
Bank reconciliation
Handling post-dated cheques

6. Inventory and Accounting Integration

Purchase and sales entries
Recording of returns (Purchase/Sales)
Inventory reports (Stock summary, Movement analysis)

7. GST (Goods and Services Tax)

Introduction to GST in Tally Prime
GST setup and configuration
Recording GST-compliant transactions
GST returns and reports (GSTR-1, GSTR-3B, etc.)

8. Payroll Management

Employee payroll creation
Pay head types and salary structures
Generating payroll reports and payslips
Statutory compliance for payroll (PF, ESI, TDS)

9. Cost Centre and Cost Category

Cost centre creation and management
Cost categories and allocation
Reporting for cost centres

10. Manufacturing(BOM)

Stock Journal
Inventory Management
Cost Estimation and Control

11. Data Management

Backup and restore
Exporting data to Excel or other formats
Tally ODBC and data synchronization

12. Customization and Automation

Tally Customization (Tally Developer Kit - TDL basics)
Automation of repetitive tasks

The eligibility for learning Tally Prime is quite flexible, making it accessible to a wide range of individuals. Typically, the following groups are well-suited for the course:

Students: Particularly those with a background in commerce, accounting, or finance.
Professionals: Accountants, finance professionals, and small business owners looking to manage their finances more efficiently.
Graduates: Especially those in fields like B.Com, BBA, or MBA.
Business Owners: Entrepreneurs and small business managers who need to handle accounting, inventory, and taxation.
Beginners: Anyone with basic computer knowledge and an interest in accounting can take up the course, as no advanced technical skills are required.