Course Includes:
- Duration: 5 Months
- Enrolled: 578 students
- Language: English
- Certificate: Yes
About This Course
Advance Diploma in Computer Applications is a Computer Fundamentals & Accounting Operation Training Program, which consists of training in Computer Operating, Computer Typing, Internet Surfing, MS Office, Advanced Excel, VBA, and Tally ERP 9. This course certification is a "must-learn" for accounting and financial experts. Tally.ERP 9 is a business management software, which provides better management of accounting, sales and purchase, inventory, manufacturing, taxation, payroll, MIS reporting, and much more. This course will also teach you how to manage accounts, inventory, taxation, and payroll in Tally ERP 9 and Tally Prime. VBA will help you create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports.
What You’ll Learn?
- How does Computer work?
- Basics of Computers
- Components of Computer
- Computer Typing
- Basics of Microsoft Office
- Using Microsoft Word to create Documents & PDFs
- Using Microsoft Excel to create Tables, Charts, and Dashboards
- Using Microsoft PowerPoint to create and customize presentations
- Using Microsoft Access to manage Database
- Using Microsoft Outlook for Professional Email
- How to access the Internet?
- How to browse and surf the Website?
- Creating Gmail ID
- Sending Email using Gmail
- Advanced Excel
- Lookup Formulas
- Formula Auditing
- Sharing and Protecting
- Automating Workbook
- Work with Macros
- Working With Charts
- VBA Basics
- Variables & Operators
- Decisions Making & Loops
- Cell Referencing & Input Box
- Events, Arrays, Functions & Procedures
- Tally ERP9
- Company Creation, Setting, and Configurations
- Journal Entries and Bank Entries
- Create and Manage Ledger Accounts
- Handling Purchase and Sales
- Handling Purchase Orders and Sales Orders
- Handling Credit Note and Debit Note
- Handling Errors in Accounting
- Performing Bank Reconciliation
- Generating Profit & Loss A/C
- Generating Balance Sheet
- Generating Funds Flow & Cash Flow Reports
- Implement Tax Entries (GST, TDS & TCS)
- Income Tax Return Filing
Requirements
- No prior knowledge or experience of Computers is required.*
- Prior Knowledge of handling Profit & Loss A/C and Books of Accounts is required.
Target Audience
- Candidates who are going to pursue or already pursuing career in Accounting and Finance.
-
Computer Fundamentals
-
Microsoft Windows
-
Microsoft Office
-
Microsoft Word
-
Microsoft Excel
-
Microsoft PowerPoint
-
Tally ERP 9 (OL, AL & GST)
-
Advance Excel
-
Multiple Worksheets
-
Multiple Workbooks
-
Lookup Formulas
-
Formula Auditing
-
Sharing and Protecting
-
Automating Workbook
-
Work with Macros
-
Creating Sparkline
-
Mapping Data
-
Forecasting Data
-
Working With Charts
-
VBA Basics
-
Variables
-
Operators
-
Decisions Making
-
Loops
-
Cell Referencing
-
Input Box
-
Events
-
Arrays
-
Functions
-
Procedures
Student Feedback
4.80 average rating based on 398 rating
Brijesh Chopra
Oct 28, 2022Advance Diploma in Computer Applications is an excellent program that gives students the skills they need to enter the workforce. The curriculum covers all the basics, including Windows, Excel, and Word. The instructors are friendly and knowledgeable. Students who complete the program will have the skills they need to enter the workforce and get a great job.
Chandan Dubey
Oct 12, 2022Advanced Diploma in Computer Applications is a great course to start if you are looking to further your education in IT. I can't believe how easy it is to learn the basics of computer science through this course.
Darshan Kapoor
Sep 21, 2022This is the perfect program for someone who is interested in pursuing a career in computer application. It is great for those who want a flexible program that can be completed in a few months. I like the easy-to-follow curriculum that includes all the necessary class materials.