Diploma in Financial Accounting with AI

(DFA - AI)

- Diploma in Financial Accounting with AI (DFA - AI)

अब Accounting सीखिए स्मार्ट और आसान तरीके से – AI की मदद से!

- आज के डिजिटल युग में Accounting केवल लेन-देन दर्ज करने तक सीमित नहीं रही। अब वक्त है Smart Accounting का, जहाँ AI यानी आर्टिफिशियल इंटेलिजेंस आपकी सीखने की प्रक्रिया को और भी आसान, तेज़ और प्रभावी बनाता है।

- हमारा DFA - AI कोर्स खासतौर पर उन छात्रों और प्रोफेशनल्स के लिए डिज़ाइन किया गया है जो फाइनेंशियल अकाउंटिंग के साथ-साथ टेक्नोलॉजी की ताक़त को भी समझना और उपयोग करना चाहते हैं।

Semester 1: Office Productivity & Digital Fundamentals

• Fundamental of Computers
• Office Automation
• MS - Office 2021
• RS-CIT
• Typing Skills -
• Hindi Typing
• English Typing
• Project + Assessment

Semester 2: Accounting & ERP

• Tally Prime with GST
• RS-CFA
• Project + Assessment

Semester 3 : Advance Industiral Excel with AI

• Advanced Excel
• Industrial Excel
• Excel with AI
• Project + Assessment 

Semester 4 : Data Skills with AI

• Google AI Tools
• Presentation with AI
• Co Pillot
• Google Sheet
• Google Docs
• Google Slide
• ChatGPT
• Gemini 
• Google Classroom
• Google Drive
• Google Meet
• and many more

Career Opportunities :

• Career Opportunities after DFA-AI Course
• Accounts Executive/Junior Accountant
• Tally Operator/GST Assistant
• Financial Data Analyst (Excel + AI)
• Office Administrator/Computer Operator
• ERP Executive (Marg ERP/Inventory Management)
• Data Entry Operator/Typist (Hindi & English)
• Fast, accurate data entry roles in government & private sectors
• High demand for bilingual typists in Rajasthan & government exams
• AI Tools Specialist/Digital Assistant
• Freelance or assist businesses using AI tools
• Back Office Executive
• Suitable for banks, finance companies, and agencies
• Data maintenance, Excel-based processing, emailing, reports
• Freelancing & Part-Time Income

 Why Choose Anil Computers?

• Government & Industry Recognized Certifications
• Experienced Faculty with Real-World Expertise
• Practical Lab Sessions + Live Projects
• Tie-ups for Placement Support
• 100% Job Guarantee on Successful Completion

Explain Course Details :-

✅ Office Automation

 Bellow is the Syllabus for Office Automation Course:

MS Power Point 2021 or Higher

·        Introduction of Power Point

·        Short Commands of MS Power Point

•   New presentation
•  New slides
•  Changing slides order
•  Themes
•  Photo album
•  Edit Photo album 
•   Slide number
•   Insert video audio
•  Transition
• Animation
• Clock project
• Create a clip image
• Convert PowerPoint file to video

Windows 10 or Higher  

•  Document Scanning
• Hide/Unhide files or folder
• Why computer speed go slow & than what will You do.
• Defragmenter
• Disk Cleanup     
• Fonts Installation
• WinZip

Advanced Internet  

• Theory of Internet
• Searching
• YouTube
• Downloading
• E-mail ID Creation
• Attachments
• Compose Mail
• Create Folder
• Change Profile Photo
• Change Password
• Forgot Password
• Signature Line
• Two step verification
• Delete Gmail ID     
• Google Mobile App
• Google Map
• SSO ID Creation
• Different type of creation
• Update SSO ID
• Using app of SSO requirement portal Govt. Site
• Online Form Filling
• Facebook
• Instagram
• DigiLocker
• Ola Cab     
• Register Railway ID
• Book Ticket
• Cancel Ticket
• Flight Ticket
• Roadways bus booking
• Result Searching
•  
• Other Website link

1. www.123greeting.com
2.  www.online-convert.com
3. www.udai.gov.in (check Aadhar validity)
4. www.wetransfer.com
5. www.fromsmash.com
6. www.speedtest.net
7. www.epaper.patrika.com

• Google Earth
• Video Conferencing
•         Google Meet
•        Zoom Meeting
• Computer Screen Sharing
•         TeamViewer
•         AnyDesk
• Online Mobile Recharge
•        Airtel, Jio, Vodafone, etc.

✅ Tally with GST

 TallyPrime with GST Syllabus :

1.          Accounting Importance

2          Golden Rules

3          Dr Cr Entries

4          Tally Download & Installation

5          Voucher Types

6          Ledger Creation

7          Tally Prime Co. Creation

8          Delete Ledger

9          Same Debtor Creditor

10        Multi Ledger

11        Ledger Group Creation

12        Zero Values Entries

13        Inventory

14        Godown / Location

15        Unused Ledger & Items

16        Backup & Restore

17        Data Transfer from Once Co. To Another Co.

18        Tally Language

19        Bill By Bill Option

20        Letter Reminder, Payment Advice, Confirmation Letter

21        Company Logo

22        Debit Note / Credit Note

23        Multi Address

24        Multi Currency

25        Multi Unit

26        Purchase Order Sales Order

27        Reorder Level

28        Rejection in & Rejection Out Delivery Note & Receipt Note

29        Standard Rate

30        Batch wise Details

31        Stock Categories

32        Costing Method

33        Scheme Entries

34        Voucher Numbering

35        Split, Fin. Year, Group of Cos.

36        A5 Paper Print & Printing Settings

37        Export in Excel

38        Security System

39        Additional Accounting Entries

40        Cost Tracking

41        Integrated Accounts with Inventory

42        Income & Expenses Report

43        Bill of Material Part 1 & 2

44        Cost Center

45        Cost Category

46        Budget & Control

47        Bar Code Reader

48        POS

49        Interest Calculation

50        Tally Remote User

51        Banking

52        Post Dated Entries

53        Scenario Management

54        Payroll

55        TDS

56        TCS

57        GST Theory

58        GST Practical

59        Material in & Material Out

✅ Advanced Industrial Excel

with AI

Advance Excel  

·         Absolute Cell Reference

·         Char Function

·         Clear Function

·         Code Function

·         Dollar Function

·         Left And Right Function

·         Right Function

·         Mid Function

·         Replace Function

·         Rept Function

·         Search Function

·         Trim Function

·         ABS Function

·         INT Function

·         Roman Function

·         Round, Roundup Or Rounddown Function

·         PMT Function

·         Rate Function

·         NPEr Function

·         Future Value Function

·         Due And Advance Amount

·         Scenario Manager

·         Data Table

·         Remove If Zero

·         Pivot Table

·         Subtotal

·         Attendance Sheet

·         Insert a New Tab

·         Paste Special

·         Age Calculates

·         Concatenate

·         Spark Line

·         Text To Column

·         Format Is Table

·         Fill Blank Cell In Excel

·         Count If

·         Vlookup

·         Hookup

·         Pass Or Fail Formula

·         Goal Seek

·         Excel Error

·         Find Formula

·         Rand And Rand Between

·         Substitute

·         Mix Cell Reference

·         Marksheet

·         Nested If

·         Cube Root

·         Exact

·         Istext And Isnontext

·         Comma Style

·         Sumif Formula

Industrial Excel

·         MIS Report

·         Indirect Function

·         Index With Match

·         Sum Product

·         Array

·         Create New Templates

·         Forecast Formula

·         Simple Interest

·         Pivot Chart

·         Index Function

·         Data Validation

·         Dget Formula

·         E Date

·         Lookup Formula

·         Small Formula

·         Consolidate Multiple Sheet

·         How To Use Even Or Odd With If Formula

·         Is Even Or Odd Formula

·         Macros

·         DB Formula (Depreciation)

·         Frequency Formula

·         Large Formula

·         Formula Auditing

·         GCD Formula

·         LCM Formula

·         Calculation Option

·         Conditional Formatting

·         Condition Formatting Part 2

·         Conditional Formatting Part 3

·         Dmax And Dmin

·         Average If 

·         Daverage

·         Dcount

·         Floor And Ceiling

·         If Error

·         How To Convert Number To Word

·         How To Split Name Or Surname

·         Full Screen

·         Best Tricks In Excel From Subtotal

·         Excel Master Tricks

·         Excel Magic Tricks

·         Important Setting Part 1

·         Important Setting Part 2

·         Important Setting Part 3

·         How To Create Bill Format

·         Create Salary Slip

✅ AI Tools 

Module 1: Productivity with AI

• Google Workspace Suite:
  • Creating visually appealing presentations
  • Using AI-powered design suggestions
  • Data organization and analysis
  • Leveraging AI-assisted formulas and charts
  • Efficient writing and editing
  • Utilizing AI for grammar, style, and suggestions
  • Task management and note-taking
  • Using AI for reminders and smart organization
  • Language translation and understanding
  • AI-powered accurate and context-aware translations
• Google Slides:
• Google Sheets:
• Google Docs:
• Google Keep:
• Google Translate:
• Google Calendar
• Zoom Meeting
• Google Meet
• Google Earth
  
  
• Google Drive:
• File storage and organization
• AI-enhanced search and retrieval of files

• Module 2: Creativity and Practical Applications with AI

• AI-Powered Content Creation:
• CoPilot
• Gamma
  • Creating dynamic and professional presentations
  • Using AI-driven templates and themes
  • Tailoring resumes and cover letters to specific job roles
  • Utilizing AI for content suggestions and formatting
  • Generating story ideas and writing prompts
  • Using AI for language generation and style improvement
• Presentation Design:
• Resume and Cover Letter Writing:
• Creative Writing:

Module 3: Research and Communication with AI

• Conversational AI:
  • Understanding and utilizing conversational AI for various tasks
  • Asking questions, seeking information, and generating creative text
  • Translating websites and documents
  • Using AI for accurate and context-aware translations
  • Developing interactive Q&A sessions
  • Using AI to generate questions and answers
• ChatGPT and Gemini:
• Language Translation:
• Q&A Creation:

Module 4: Advanced AI Applications

• AI-Driven Problem-Solving:
  • Solving complex formulas and automating tasks
  • Using AI-powered formula suggestions
  • Planning, executing, and presenting projects
  • Utilizing AI for task prioritization and time management
• Excel Formulas:
• Project Management:
• Real-world Application:
• Integrating learned AI skills into a practical project
• Demonstrating proficiency in using AI tools and techniques

Module 5: Additional Tools to Consider:

• CoPilot: AI-powered code completion and generation
• Google Classroom: AI-enhanced learning management system
• Using AI with Gmail