Download the Brochure by filling the form below


Key Highlights

Duration icon
Duration
5 months (125 hours)
Advanced Curriculum
Advanced Curriculum
MS Office, Advanced Excel & Tally Prime.
Office Automation
Office Automation Skills
Efficient document management and data analysis.
Excel Expertise
Excel Expertise
Complex data manipulation, advanced formulas, data visualization, and automation.
Financial Accounting
Financial Accounting
Master Tally Prime for accurate record-keeping and report generation.
Diverse icon
Diverse Career Paths
Office Administrator, Financial Analyst, Accounting Assistant, and more.

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.
The course duration is 125 Hrs. and 5 Months Program
  • Office Administrator
  • Financial Analyst
  • Accounting Assistant
If you are ready to learn and want to light up your future with us. Enroll now in this course.

About the Course

Comprehensive program

A-OAFA empowers with IT skills - MS Office, Advanced Excel & Tally Prime.

office automation

Master document management & data analysis.

Financial expertise

Excel in Tally Prime for accurate record-keeping.

Diverse opportunities

Become Office Administrators, Financial Analysts & more.

Expert guidance

Learn from industry specialists. Practical approach for proficiency.

Transformative journey

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
  • E-mail
  • 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.
    certificate icon
    • 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
    certificate logo

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

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.