Download the Brochure by filling the form below
Key Highlights
Things To Know
- Aspiring office administrators, accounting professionals, finance executives, and individuals looking to enhance their office automation and financial accounting skills should consider enrolling in this program.
- Office Administrator
- Financial Analyst
- Accounting Assistant
About the Course
A-OAFA empowers with IT skills - MS Office, Advanced Excel & Tally Prime.
Master document management & data analysis.
Excel in Tally Prime for accurate record-keeping.
Become Office Administrators, Financial Analysts & more.
Learn from industry specialists. Practical approach for proficiency.
Graduates emerge as competent professionals in IT & finance
Content
Welcome to A-OAFA - the Advanced Certificate in Office Automation & Financial Accounting! In just 5 months, gain proficiency in MS Office 2019, Advanced Excel, and Tally Prime. Automate office tasks, master data analysis, and excel in financial accounting. Embark on a transformative journey to become an Office Administrator, Financial Analyst, or Accounting Assistant.
- Computer Competency
- System Software
- Windows OS
- Application Software
MS-Office
- MS-Word 2019
- MS-Excel 2019
- MS-PowerPoint 2019
- MS-Outlook 2019
Internet & Web
- Overview Working Of the Internet
- World Wide Web
- Advanced file tasks
- Working with functions and formulas
- Managing tables in Microsoft excel
- Data tools in excel
- Sparkline
- Grouping & outlining and subtotals
- What-if analysis
- Advanced pivot tables & charts
- Advanced excel tasks
- Creating h lookup and v lookup functions
- Advanced conditional formatting
- Advanced lookup functions
- Advanced functions in excel
Tally Prime Basics
- Download Tally Prime Setup
- Installation
- Company Creation, Alteration & Deletion
- Ledger Creation
- Vouchers Creation (Sales, Purchase)
Tally Prime with Accounting
- Bill Wise Entry & Details
- Cost Centre
- Multiple Currencies
- Interest Calculations
Tally Prime with Inventory
- Inventory
- Stock Journal
- Batch wise Inventory in Tally Prime
- Order Processing
- Debit and Credit Note
- Price list
- Bill of material
- Zero Value Entries
- Actual 7 Billed Quantity
TALLY PRIME with Banking
- Cheque Book Configuration
- Activate Cheque Printing
- Printing Cheque
Tally Prime with GST (Goods and Services Tax)
- Activation of GST in Tally Prime
- Accounting of GST Transaction
- Tax Rate Structure
- Voucher with GST
- GST Reports & Payments
- GST Challans & HSN / SAC Codes
- Reverse Mechanism
Data & Security
- Security Control
- Tally Vault
- Data Backup
MIS Reports
- Cash Flow Statement
- Fund Flow Statement
- Ratio Analysis
- Budget & Controls
Generating & Printing Reports
- Financial Statement
- Books & Registers
- Inventory Books & Registers
- Statements of Accounts
- Statement of Inventory
Tally Prime with Payroll
- Payroll in Tally Prime
- Activate Payroll
- Payroll Transaction
- Payroll Transaction
- Statement of Payroll
Account & Taxation Certificate
-
- GJX: The esteemed A-OAFA is awarded upon the successful completion of a comprehensive 5-month program. This certificate represents the mastery of essential IT skills, encompassing MS Office 2019, Advanced Excel, and Tally Prime.
-
- JAIN:The Advanced Certificate in Office Automation & Financial Accounting (A-OAFA) is a prestigious recognition of successful completion of a comprehensive 5-month program. This certificate signifies the mastery of vital IT skills, including MS Office 2019, Advanced Excel, and Tally Prime
Our Affiliations & Associations
We believe people are at the centre of every solution, leading us to the right solution just waiting to be delivered.
Our Students are Working in Following Companies
What Our Students Say
I highly recommend the Web Designing Course at G-TEC JAINx Education for anyone interested in pursuing a career in web design."
The Data Analysis Course at G-TEC JAINx exceeded my expectations. Through practical assignments and real-world case studies, I gained hands-on experience in data analysis techniques and tools.
Taking the Digital Marketing Course at G-TEC JAINx was a game-changer for my career. I am now equipped with the skills to plan and execute successful online marketing campaigns
Keerti Learner Support
Throughout the course,
learners will have access to dedicated support from instructors and course mentors.
They can
ask questions, seek clarification, and receive guidance to enhance their learning
experience.
Additionally, the course provides a collaborative learning environment where
students can
interact with peers, share insights, and learn from each other's experiences.
-
Phone Number +91-90-29341200 -
Email [email protected]