• Opening Time : 8:00 AM - 8:00 PM
Free Demo Class
Contact Us
89801 76701

Contact Info

Ahmedabad, Gujarat +91 89801 76701 info@plutomultimediainstitute.in

Advanced Diploma in Finance & Accounting Course

Advanced Diploma in Finance & Accounting

Advanced Diploma in Finance & Accounting Course

Pluto IT Engineering & Multimedia Institute offers an Advanced Diploma in Finance & Accounting Course with expert coaching and training in Ahmedabad. Our finance and accounting classes cover advanced topics like financial analysis, taxation, Tally Prime, GST, payroll management, and corporate accounting to prepare students for high-paying careers. As a top institute in Ahmedabad, we provide hands-on learning with real-world case studies and practical applications, ensuring job-ready skills. If you’re searching for the best advanced finance and accounting course near you, enrol in our professional diploma program and boost your career in the financial sector.

Advanced Diploma in Finance & Accounting Course Module

  1. English Typing
  2. Basic of Computer networks
  3. Concept of Internet
  4. WWW and Web Browsers
  5. Web Browsing Software
  6. Giving the URL address

Word Processing

  1. Opening Word Processing Package
  2. The Menu Bar
  3. Using the Help
  4. Using the Icons below menu bar
  5. Opening Documents and Closing documents
  6. Opening Documents
  7. Save and Save AS
  8. Page Setup
  9. Printing of Documents
  10. Using the Icons below menu bar
  11. Display/Hiding of Paragraph Marks and Inter
  12. Word Space
  13. Moving Around in a Document
  14. Scrolling the Document
  15. Scrolling by line/paragraph
  16. Fast Scrolling and Moving Pages
  17. Text Creation and Manipulation
  18. Paragraph and Tab Setting
  19. Text Selection
  20. Cut, copy and paste
  21. Font and Size selection
  22. Bold, Italic and Underline
  23. Alignment of Text: Center, Left, right and Justify
  24. Formatting the Text
  25. Changing font, Size and Color
  26. Paragraph indenting
  27. Bullets and Numbering
  28. Use of Tab and Tab setting
  29. Changing case
  30. Table Manipulation
  31. Concept of table: Rows Columns and Cells
  32. Draw Table
  33. Changing cell Width and Height
  34. Alignment of Text in Cell
  35. Copying of cell
  36. Delete/insertion of row and columns
  37. Borders for Table

Making Presentations

  1. Difference between presentation and
  2. document
  3. Using Power Point
  4. Opening a Power Point Presentation
  5. Using Wizard for creating a presentation
  6. Creation of Presentation
  7. Text Creation
  8. Fonts and Sizes
  9. Moving to Next Slide
  10. Bullets and indenting
  11. Selection of type of Slides
  12. Using the Slide Show
  13. Printing the Slides and Handouts
  14. Slide sorter
  15. Title sorter
  1. Introduction to excel
  2. How is excel important to business
  3. Understanding the excel interface
  4. Insertion and Deletion in excel
  5. Basic Formatting in excel
  6. Data types in excel

Sort & Filter

  1. Applying the sort Function
  2. Applying the filter Function
  3. Applying the Advanced Filter Function
  4. Uses of Short Function to Analysis the Data

Text Functions

  1. Using The Upper, Lower and Proper Functions
  2. Using The Right, Left And Search Functions
  3. Using the Trim, Concat and Len Functions

Statistical Functions

  1. Using the MIN, MAX, AVERAGE functions
  2. Finding the Standard Deviations
  3. Find the Percentiles of data
  4. Finding the outliers present in data
  5. Array functions

Logical Functions

  1. Using the If Functions
  2. Using the IF ERROR Function
  3. Applying the COUNTIF Function
  4. Applying the SUMIF Function
  5. Applying the AVERAGEIF function

Conditional Formatting

  1. Using Colobars for Formatting
  2. Using Color Scale for Data Formation
  3. Lookup Functions
  4. Applying VLOOKUP Function
  5. Applying HLOOKUP Function
  6. Applying XLOOKUP Function

Index and Match

  1. Why to use index And Match
  2. Applying Index and match

Pivot Tables

  1. Making Pivot tables
  2. Making Pivot Charts
  3. What If Analysis
  4. Goal Seek Analysis
  5. Data Tables Scenario Management

Regression

  1. Understanding Regression
  2. Performing Linear Regression

Macros in Excel

  1. Understanding Excel macros
  2. Activating the Developer tab in excel
  3. Creating your First Macro
  4. File Types and Savings
  5. Running a macro Using keyboard shortcuts
  6. Running macros Using Buttons

Getting Started With VBA

  1. Navigating the Visual Basic Editor
  2. VBA Projects
  3. Excel’s VBA Object Model
  4. Where Do I put my Code?
  5. Understanding Code: Macro Process
  6. Editing & Deleting the Macros

Introduction to Excel Charts & Smart Art Graphics

  1. Training On Charts
  2. Bubble Charts
  3. Pyramid Chart
  4. Surface Chart
  5. Tree map Charts
  6. Donut Charts

How to Create Business Analytics Dashboards

  1. Data Cleaning
  2. Data Sorting
  3. Data Visualization

Advance formulas

  1. Date time function
  2. Draw symbol and insert picture
  3. Emi calculation
  4. Page setup
  5. Array function
  6. Formatting cells and workbooks
  1. Introduction Of Tally Prime
  2. Accounting Assumptions, Concepts and Principles
  3. Accounting Principles
  4. Double Entry System of Accounting
  5. Types of Accounts
  6. The Golden Rules of Accounting
  7. Recording of Business Transactions
  8. The Accounting Equation
  9. Recording of Transactions in Books of Original
  10. Entry/Journal
  11. Use of Debit and Credit
  12. Rules of Debit and Credit
  13. Recording of Business Transactions in Journal
  14. Accounting Vouchers
  15. Receipt Voucher (F6)
  16. Contra Voucher (F4)
  17. Payment Voucher (F5)
  18. Purchase Voucher (F9)
  19. Sales Voucher (F8)
  20. Debit Note Voucher
  21. Credit note Voucher
  1. Introduction To Tally ERP
  2. Getting Started with Prime
  3. Mouse/Keyboard Conventions
  4. Company Creation
  5. Shut a Company
  6. Select a Company
  7. Alter Company Details
  8. Company Features and Configurations
  9. F11: Company Features
  10. Ledger Creation
  11. Altering and Displaying Ledgers
  12. Display of Ledgers
  13. Deletion of Groups and Ledgers
  14. What is Ledger?
  15. Classification of Ledger Accounts
  16. Posting from Journal
  17. Financial Statements
  18. Trading Account
  19. Profit & Loss Account
  20. Balance Sheet
  21. Accounts Payables and Receivables
  22. Maintaining Bill-wise Details
  23. Activation of Maintain Bill-wise Details Feature
  24. New Reference
  25. Against Reference
  26. Advance Reference
  27. On Account Reference
  1. Introduction To Inventory Masters in Tally prime
  2. Creating Inventory Masters
  3. Creation of Stock Group
  4. Creation of Units of Measure
  5. Creation of Stock Item
  6. Creation of Go down
  7. Purchase cycle
  8. Sales cycle
  9. Stock Management In Tally
  1. Godown Management
  2. Activating Godown
  3. Creating A Godown
  4. Recording Of Purchase, Sales And Stock
  5. Transfers With Godown Details
  6. Purchase Of Inventory
  7. Recording Stock Transfer Entry Using Stock
  8. Journal
  9. Sale Of Inventory
  10. Analyzing Godown
  11. Movements Of Goods In Batches
  12. Activating Batch-Wise Details In Tally Prime
  13. Using Batch-Wise Details In Purchase Invoice
  1. Levy and exemption from Tax
  2. Current tax under GST Regime
  3. Overview Of Intra State Purchase & Sales
  4. Overview Of Inter State Purchase & Sales
  5. Overview GST Work Flow
  6. Electronic Commerce
  7. Explain E-Way Bill
  8. Overview E-Way Bill Work Flow
  9. Explain GST Number Code
  10. GST Registration Process
  11. Explain Composition Scheme
  12. How Will I File GST Return?
  13. GST Payments
  14. GSTN Portal Information
  15. Explain Ledger Of GSTN Portal
  16. Explain Input Credit Adjustment
  17. Explain ITC On Closing Stock
  18. Explain Late Fee & Fines & Cancellation Of GST No.
  19. Explain GST Rates
  20. Create Company And Active GST In Company Level
  21. Creating Masters And Set GST Rates
  22. Creating Tax Ledger
  23. Transferring Tax Credit Of VAT, Excise And
  24. Service Tax To GST
  25. Recording GST Sales And Printing Invoice
  26. Recording GST Interstate Sales And Printing Invoice
  27. Recording An Advanced Payment To Supplier
  28. Under GST
  29. Recording GST Local Purchase
  30. Recording GST Interstate Purchase
  31. HSN Code & SAC Codes
  32. Recording Vouchers with TDS
  33. Introduction To TDS
  34. Basic Concepts of TDS
  35. TDS Process
  36. TDS in Tally prime
  37. Activation of TDS Feature in Tally Prime
  38. TDS Statutory Masters
  39. Configuring TDS at Ledger Level
  40. Recording Transactions
  41. Activate of TDS During Voucher Entry
  1. Payroll Accounting in Tally
  2. Payroll with Taxation Features
  3. Back up & Restore
  4. Interest Calculation
  5. Cheque Printing in Tally
  6. TCS – Tax Collected at Source
  7. Cost center and cost category
  8. Cost center with cost center class
  9. Budeget & Control
  10. Integrate Tally Prime with WhatsApp
  11. Integrate Tally Prime with Excel
  12. Integrate Tally Prime with Dashboard
800+ Placement Partners

OUR PLACEMENT PARTNERS

Disclaimer: We Would Like To Clarify That While Our Students Are Placed At The Esteemed Company Mentioned Direct Or indirectly, We Do Not Have A Direct Business Relationship With Them. The Rights To Their Logo Are Solely Retained By The Company Itself. We Utilize Their Logo Purely For The Purpose Of Acknowledging The Successful Placement Of Our Students.

14
13
12
11
10
09
08
07
06
05
04
03
02
01
28
27
26
25
24
23
22
21
20
19
18
17
16
15

Get in Touch