Microsoft Word

Course Contents:-

MODULE-I

• Windows Operating System
• Hardware
• Paint
• Notepad 
• WordPad
• Computer Fundamental
• Microsoft Word
• Microsoft Excel
• Microsoft Power Point
• Documents Printing
• Documents Scanning
• Use of USB Pen Drive Internet

About Graphic Designing Course

Graphic design is a creative field that combines art and technology to communicate ideas through visuals. This course is designed to equip you with the essential skills and knowledge required to become a proficient graphic designer. Whether you are a beginner looking to start a career in graphic design or a professional seeking to enhance your skills, this course will provide you with a comprehensive understanding of graphic design principles and tools.

Anyone can easily do this  computer course online sitting at home. You can learn this course in Hindi language

What You Learn in Graphic Designing Course

1. Adobe Photoshop
2. Corel Draw

Advance  Excel course is for all students because in this course Excel has been taught from basic to advanced.

In this course you will learn all these things

Such as :-

1. Advanced Formulas and Functions

This section involves moving beyond simple arithmetic to complex nested and array formulas.

Lookup Functions: Mastering advanced alternatives to VLOOKUP/HLOOKUP, such as INDEX and MATCH (or the newer XLOOKUP), and using INDIRECT and OFFSET for dynamic referencing.

Logical Functions: Utilizing complex nesting of IF, AND, OR, and implementing the IFERROR function for error handling.

Conditional/Statistical Functions: Advanced use of SUMIFS, COUNTIFS, and AVERAGEIFS with multiple criteria.

Text, Date, and Time Functions: Functions like CONCATENATE, TRIM, LEN, EOMONTH, and NETWORKDAYS.

Array Formulas: Understanding and implementing array formulas, often entered using $\text{Ctrl}+\text{Shift}+\text{Enter}$.

2. Data Tools and Validation

Techniques for managing, cleaning, and validating large datasets.

Data Validation: Creating dynamic dependent drop-down lists and using custom formulas for validation rules.

What-If Analysis: Utilizing features like Goal Seek, Scenario Manager, and Data Tables for forecasting and modeling.

Data Cleaning: Using Text to Columns, Remove Duplicates, and advanced filtering techniques.

Data Consolidation: Combining data from multiple worksheets or workbooks.

3. Data Analysis and Visualization

Methods for summarizing and presenting data effectively.

PivotTables and PivotCharts: Creating, modifying, and analyzing data using PivotTables, including calculated fields/items, grouping, and using Slicers and Timelines for interactive filtering.

Advanced Charting: Creating specialized charts like Combo Charts (with Secondary Axes), Waterfall, and Gantt charts, and using Sparklines.

Conditional Formatting: Applying advanced rules and formulas to highlight patterns and trends in data.

Dashboards: Principles and techniques for designing and building interactive analytical dashboards.

Power Tools: Introduction to Power Query (Get & Transform Data) for importing and cleaning data and Power Pivot for creating data models.

4. Automation with VBA Macros

Learning the basics of programming within Excel to automate repetitive tasks.

Macro Recording and Editing: Recording simple macros and editing the underlying VBA (Visual Basic for Applications) code.

VBA Fundamentals: Understanding the VBA Editor, variables, data types, and basic concepts like MsgBox and InputBox.

Control Structures: Implementing simple If/Else statements and Loops (Do/For Loop) for decision-making and repetition in macros.

Ms Office Job Opportunities

Completing a course in Microsoft Office can open up a variety of job opportunities across different industries. Here are some examples of job roles that require proficiency in Microsoft Office

1. Administrative Assistant: Administrative assistants often use Microsoft Office applications such as Word, Excel, and PowerPoint to create documents, manage data, and prepare presentations.
2. Customer Service Representative: Customer service representatives often use Microsoft Outlook to manage email communication with customers and colleagues.
3. Project Coordinator: Project coordinators use Microsoft Project to plan and track projects, manage resources, and create project reports.
4. Financial Analyst: Financial analysts use Microsoft Excel to analyze and manipulate financial data, create financial models, and prepare financial reports.
5. Human Resources Assistant: Human resources assistants use Microsoft Word and Excel to create and manage employee documents, such as resumes, job descriptions, and performance evaluations.
6. Marketing Assistant: Marketing assistants use Microsoft PowerPoint to create presentations for sales meetings and marketing campaigns.

These are just a few examples of the many job opportunities that require proficiency in Microsoft Office applications. By taking a course in MS Office, you can develop the skills necessary to succeed in these roles and many others.

Ms Office Course Syllabus

• Microsoft Word
• Microsoft Excel
• Advance Excel
• Power Point
• Outlook
•  

About Corel Draw

 Corel Draw is a type of Vector and  Graphic Software. It is use for creating a designs, banner, visiting card and all the printing items.

Corel Draw Course Syllabus

• Intro to Corel Draw
• Use of all tools
• Working on Banners
• Creating Social Media Posts
• Logo Creation
• And Many More...

WordPress Course Syllabus

Introduction CMS And WordPress

• Why CMS
• Advantages and Disadvantages of CMS
• com vs. WordPress.org

WordPress Installation

• Setting up WordPress in Local Server
• Setting up WordPress in Remote Server
• Upgrading WordPress
• Understanding FTP

User Administration

• WordPress Admin
• Creating Users
• User Rights & Roles

WordPress Themes

• Free theme Vs Paid Theme
• Theme Selection Process
• Adding/installing Themes
• Changing Themes
• Preview & Activating Themes

Working with Widgets

• Installing widgets in sidebar
• Installing widgets in footer

Working with Menu for your Website

• Creating menus
• Adding pages, posts, categories to menus
• Creating Sub-menus
• Deleting items from menu

WordPress Plugins

• Installing plugins
• Activating Plugin & managing plugins
• Upgrading plugins
• Recommended Plugins

Working with Content

• Posts Vs Pages
• Adding Hyperlinks
• Playing with Media content
• Previewing and Editing Posts
• Previewing and Editing Pages
• Page Order
• Creating a post
• Adding Media files to content –images and videos
• Using Categories and Tags
• Creating Pages
• Page Hierarchy

WordPress Settings

• General settings
• Reading
• Media
• Writing settings
• Discussion
• Permalinks

WordPress Backup

• Enhancing WordPress Security

Course Contents:- MODULE-I

1. Complete Fundamental of Computer
2. MS Paint, Notepad & WordPad
3. Microsoft Word
4. Microsoft Excel
5. Microsoft Power Point
6. Photoshop
7. Corel Draw
8. Web Designing 
9. Programming Languages
10. Advance Internet
11. Tally Prime
12. Hindi/Punjabi & English Typing

COMPUTER FUNDAMENTALS:

1. Introduction to Computer
2. Computer Hardware and Software
3. Input & Output
4. Computer Memory & Processing
5. Computer Types & Generation
6. Computer Applications

OPERATING SYSTEM (WINDOW) :

1. Memory Management
2. File System
3. Process Management
4. Security

OFFICE APPLICATION (MS Word, MS Excel, MS Power Point) :

1. Microsoft Office Word
2. Microsoft Office Power Point
3. Microsoft Office Excel

INTRODUCTION TO INTERNET, WWW AND WEB BROSWER :

1. Introduction to Internet
2. Internet Basics
3. Introduction to WWW
4. Web Browser

COMMUNICATIONS AND COLLABORATION : 

1. Introduction to Communication 
2. Type of Communications
3. Introduction to Collaboration
4. Teamwork and Professional Communication

TYPING (ENGLISH, PUNJABI/HINDI) :

1. English Typing
2. Punjabi Typing 
3. Hindi Typing

The Diploma in Data Entry Operator course usually covers practical and theoretical subjects focused on typing skills, computer operations, and basic office management. The exact subjects can vary depending on the institute, but generally, they include:

Basic Computer Fundamentals

  Introduction to Computers

  Hardware and Software Basics

  Operating Systems (especially Windows)

Typing Skills

English Typing

Speed and Accuracy Improvement

Touch Typing Techniques

MS Office Applications

MS Word (Document Creation)

MS Excel (Data Entry and Simple Calculations)

MS PowerPoint (Basics of Presentation)

Internet and Email

Using Web Browsers

Email Creation and Management

Online Form Filling

Data Entry Techniques

Numeric and Text Data Entry

Data Formatting

Accuracy and Quality Control

Office Automation

Working with Printers, Scanners, and Photocopiers

File Management

Business Communication

Basic English Grammar and Writing Skills

Professional Email and Letter Writing

Project Work / Internship

Practical assignments

Real-time data entry projects

Financial Accounting – Fundamentals and Significance

1. Understanding the Basics and Importance of Financial Accounting
2. Accounting Principles and Frameworks (GAAP, IFRS)
3. Double-Entry System and Accounting Cycle
4. Classification of Accounts and Nature of Transactions
5. The Accounting Process and Fundamental Equation Rules
6. Preparation of Journals and Ledgers
7. Drafting Profit & Loss Account (Income Statement)
8. Compilation of Balance Sheet with Necessary Adjustments
9. Preparation of the Statement of Cash Flows
10. Formation of Trial Balance
11. Writing Notes to Financial Statements

Cost Accounting – Overview and Applications

1. Fundamentals of Cost Accounting
2. Components and Elements of Cost
3. Various Costing Methods and Techniques
4. Concepts of Marginal and Absorption Costing
5. Essentials of Budgeting and Forecasting
6. Application of Cost Accounting in Decision-Making
7. Adherence to Cost Accounting Standards and Compliance Requirements
8. Techniques of Cost Control and Variance Analysis
9. Key Differences Between Financial Accounting and Cost Accounting
10. Recognizing the Limitations of Cost Accounting

Financial Analysis and Reporting – Principles and Practices

1. Introduction to Financial Reporting
2. Techniques of Financial Statement Analysis (Ratio and Trend Analysis)
3. Fundamentals of Investment Analysis and Decision-Making
4. Conducting Cash Flow and Fund Flow Analyses
5. Corporate Financial Reporting Standards and Frameworks
6. Asset-Based and Revenue/Liability-Based Accounting Standards
7. Disclosure Requirements and Related Accounting Standards

Payroll and Salary Management – Comprehensive Guide

1. Fundamentals of Payroll Management
2. Structure and Key Components of Salary
3. Tax Deducted at Source (TDS) in Payroll Management
4. Payroll Processing Using Accounting Software
5. Payroll Accounting and Regulatory Compliance
6. Managing Provident Fund (PF), Employee State Insurance (ESI), and Professional Tax
7. Income Tax Computation on Salaries
8. Payroll Processing Using Tally and Excel
9. Payroll Budgeting and Cost Optimization

Taxation and GST Accounting – Essentials

1. Core Concepts of Taxation
2. Overview of Direct and Indirect Taxes
3. Goods and Services Tax (GST) – Registration, Filing, and Compliance Procedures
4. Fundamentals of Income Tax, Deductions, and Computation
5. Understanding TDS (Tax Deducted at Source) and TCS (Tax Collected at Source)

Auditing and Internal Control – Framework and Functions

1. Basics of Auditing and Its Importance
2. Auditing Procedures, Types, and Practices
3. Differences Between Internal and External Audits
4. Fraud Detection and Risk Management in Auditing
5. Auditors’ Responsibilities and Audit Reporting
6. Audit Planning and Strategy
7. Principles of Internal Controls and Vouching Procedures
8. Application of Auditing in Cost Accounting

The Advanced Diploma in Computer Teacher Training (ADCTT), typically a 1-year course, is designed to equip individuals with comprehensive technical computer skills combined with the pedagogical methods necessary to teach computer science effectively.

1. Computer Fundamentals and Operating Systems (OS)

Computer Organization: Introduction to hardware, software, memory, and data representation (e.g., number systems).

Operating Systems: In-depth knowledge of Windows and Linux/Unix (file management, system utilities, security).

Networking Basics: Concepts of LAN, WAN, Internet, web servers, and basic troubleshooting.

2. Office and Data Management

MS Office Suite: Advanced proficiency in tools essential for education and administration:

MS Word: Document creation, formatting, mail merge.

MS Excel: Formulas, functions, data analysis, charts, and filtering (often including Advanced Excel concepts).

* **MS PowerPoint:** Creating engaging educational presentations, multimedia integration.
* **MS Access:** Introduction to relational databases and basic querying.

Financial Accounting: Practical training on software like Tally ERP/Tally Prime, covering ledger accounts, GST, payroll, and final financial statements.

3. Programming and Web Technology

Programming Concepts: Introduction to algorithms, flowcharts, and programming logic development.

Core Languages: Hands-on training in procedural languages like C and object-oriented languages like C++ or Java/Python.

Web Design: Fundamentals of website creation using HTML, CSS, and client-side scripting like JavaScript.

4. Graphic Design and Desktop Publishing (DTP)

This section provides skills for creating professional educational materials (posters, notes, presentations).

Image Editing: Practical use of Adobe Photoshop for image manipulation and editing.

Vector Graphics: Training on Corel Draw for creating logos, diagrams, and flyers.

Layout Design: Introduction to tools like PageMaker or Adobe InDesign for designing reports and teaching materials.

5. Soft Skills and Professional Development

Communication Skills: Public speaking, presentation skills, and professional communication (e.g., email etiquette).

Personality Development: Grooming, confidence building, and interview preparation to succeed as a professional instructor.

Project Work: The course typically culminates in a Teaching Practicum or a Capstone Project where the student designs and delivers a comprehensive computer curriculum or a teaching module.

1. Mathematical Foundations 

Math is the language of AI. Without these, machine learning algorithms are black boxes.

Linear Algebra: Vectors, matrices, and operations (essential for handling data in neural networks).

Calculus (Differential & Integral): Used for optimization and understanding how models learn (e.g., gradient descent).

Probability & Statistics: The backbone of making predictions and handling uncertainty in data.

Discrete Mathematics: Logic, set theory, and graph theory, which help in understanding algorithms.

2. Core Computing & Programming 

You need to learn how to talk to the machine before you can teach it to think.

Introduction to Programming: usually Python (the standard language of AI) or C++.

Data Structures & Algorithms (DSA): How to organize data efficiently and solve computational problems.

Object-Oriented Programming (OOP): Building modular and reusable code.

Database Management Systems (DBMS): Basics of SQL and handling large datasets.

3. Introductory AI Concepts 

Some curriculums introduce specific AI topics late in the first year.

Introduction to Artificial Intelligence: History of AI, agents, and basic search algorithms.

Python Libraries for AI: Intro to NumPy, Pandas, and Matplotlib for data manipulation.

1. Core Machine Learning (The Foundation) 

This is where you learn how to teach computers to learn from data without being explicitly programmed.

Supervised Learning: Teaching the machine with labeled data (e.g., linear regression, decision trees).

Unsupervised Learning: Finding patterns in unlabelled data (e.g., clustering customers by behavior).

Reinforcement Learning: Learning through trial and error (like teaching a robot to walk).

Model Evaluation: How to measure if your AI is actually "smart" (accuracy, precision, recall).

2. Deep Learning (The Advanced "Brain") 

Once you know the basics, you study Neural Networks, which mimic the human brain.

Artificial Neural Networks (ANN): The basics of deep learning.

Convolutional Neural Networks (CNN): Used for Computer Vision (recognizing faces, medical images).

Recurrent Neural Networks (RNN) & Transformers: Used for Natural Language Processing (like ChatGPT or Google Translate).

3. AI Electives & Applications 

In the final stages, you apply these skills to specific fields.

Natural Language Processing (NLP): Text and speech analysis.

Computer Vision: Image and video processing.

Robotics: integrating AI with hardware.

Ethics in AI: Bias, fairness, and safety.

BASIC COMPUTER FUNDAMENTAL:

1. Introduction to Computer
2. Computer Hardware and Software
3. Input and Output
4. Types & Generation of Computer

INTRODUCATION OF FINANCIAL ACCOUNTING:

1. Meaning & Need of Financial Accounting
2. Types of Accounts
3. Branches of Accounting

COMPANY & ACCOUNT MASTER CREATION & MAINTAINING BOOKS:

1. Introduction to Company
2. Companies Act, 2013 Rules & Regulations
3. Maintaining Books (Journal, Trading A/c, Profit & Loss A/c, Balance Sheet)

TAXATION & BANKING SYSTEM:

1. Introduction to Taxation & Banking System
2. Introduction to VAT (Value Added Tax)
3. Introduction to GST (Goods Service Tax)

COMPUTERZIED ACCOUNTING:

1. Introduction to E- Accounting
2. Tally ERP9
3. Tally Prime with GST

MANUAL ACCOUNTS, DOUBLE ENTRY SYSTEM & SUBSIDAIRY BOOKS:

1. Meaning & Concepts of Double Entry System
2. Introduction to Subsidiary Books
3. Types of Subsidiary Books

1. Introduction to Financial Accounting:

Basic accounting principles and concepts
2. Financial Accounting Basics:

Understanding financial transactions and records
Company creation and accounts configuration in Tally.ERP 9
3. Voucher Types and Accounts Vouchers:

Voucher entry and transactions in Tally
Advanced financial accounting and final accounts preparation
4. Inventory Management:

Introduction to inventory management
Stock groups, categories, items, and units of measure
Inventory voucher entry and management
5. Business Management:

MIS reports
Budget management and scenario management
Document printing and configuration
6. Import & Export of Data:

Data import and export in Tally.ERP 9
7. Security and TDS:

Security settings in Tally
Introduction to Tax Deducted at Source (TDS)
8. VAT – Value Added Tax:

Introduction to VAT
VAT computation and usage in Tally.ERP 9
9. Service Tax:

Introduction to Service Tax
Using Service Tax in Tally.ERP 9
10. Introduction to Payroll: - Payroll management in Tally.ERP 9

11. Excise for Manufacturers and Dealers: -

 Introduction to Excise for Manufacturers and Dealers - Types of Excise Duty and usage in Tally.ERP 9

12. Introduction of Tally.NET: - Introduction to Tally.NET and remote user management

13. GST (Goods and Services Tax): - Overview of GST and its implementation - Liability of the taxpayer and GST Council - Levy, composition scheme, and remission of tax/duty - Registration, amendments, and cancellation - Meaning and scope of supply, valuation in GST - Payment of GST, TDS & TCS, and electronic commerce - Input tax credit, input service distributors, and IGST Act - Place of supply of goods and services

14. Finalization & Reporting:- Balance Sheet, Trial Balance & Cash Flow