Financial Accounting & Master Excel

Financial Accounting & Master Excel

Diploma in Financial Accounting & Master Excel Fees: Rs. 39,550 2?,550

  • Fees: Rs. 39,550 2?,550
  • Duration: 6 Months Daily / 12 Months Alt Days
  • Work on Projects & Assignments
  • All Inclusive of Books, Certification, and GST
  • Software Covered: TALLY ERP-9, MS Excel
  • Original TALLY Certificate

About Course

Softpro offers professional courses in financial accounting, master excel courses in Mumbai. Diploma in Financial Accounting for Master Excel Course is a short-term certified diploma for the students from accounting, finance, graduates, MBA, other graduates who want to strengthen their understanding in the Business field of Accountancy.

  • Advanced Excel Diploma
  • Corporate Excel Diploma
  • Macros & VBE in Advanced Excel
  • Tally ERP Operations – Diploma
  • GST Executive – Certificate

Course Content

MODULE 1. ADVANCED EXCEL DIPLOMA

  • Sub Total Reports, Auto Filter
  • Sorting Data
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • COUNTIF, SUMIF.
  • What-if-analysis
  • Pivot Tables, Pivot Charts
  • NESTED IF
  • Reporting
  • Character Functions
  • Scenario Manager
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • Logical Functions
  • MACROS Definition & Concepts
  • Record & Run a Macro
  • Store a Macro
  • Intro to VBA Prog (25 Projects)

MODULE 2. CORPORATE EXCEL DIPLOMA

  • Performing complex calculations
  • Using various Excel functions
  • Executing in Dynamic projects
  • Organizing & analyzing large volumes of data
  • Creating MIS reports
  • Designing and using templates
  • Managing data from multiple workbooks
  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions
  • (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Advanced Formatting
  • Formatting & customizing Pivot tables
  • Advanced options & Pivot charts
  • Consolidating data from multiple sheets
  • Using external data sources
  • Using data consolidation feature
  • Show Value As ( % of Row, % of Column)
  • Running Total, Compare with Specific Field
  • Viewing Subtotal under Pivot
  • Advanced Date & Time Functions
  • Data Validation in financial functions
  • Advanced Shortcut Keyboard Commands
  • Create Forms
  • Creating Slicers

INSTANT INQUIRY

    MODULE 3. MACROS & VBE ADVANCED EXCEL

    In MACRO’S Course, you will learn to write macros in Excel using programming language Visual Basic Application(VBA). Recorded macro can be edited to customize it & one can directly go for coding to accomplish the required tasks.

    • Creating Functions & Procedures
    • Design & Create reports
    • Understanding Security levels
    • Security levels and its meaning
    • What is Function & Subroutine
    • Writing Functions using VBA Editor
    • Calling Functions in other workbooks
    • Relative & Absolute Macros
    • Recording and running macros storing macro
    • Creating buttons & assigning macros
    • Creating My Menu
    • Editing Macros using VBA Editor
    • Understanding the Project explorer
    • Exploring windows properties
    • Modifying code & debugging code
    • Variables, Data types & Constants
    • Arrays, Object Variables
    • Conditional Structures (If Then, Select Case)
    • Logical Operators / looping Constructs
    • Built-in Functions, Creating Subordinates
    • Creating forms, Forms Events
    • Creating custom menus & Toolbars

    MODULE 4. TALLY ERP OPERATIONS

    a. Inventory

    • Features
    • Stock Groups
    • Stock Items
    • Physical Stock Voucher
    • Creating Units of Measure
    • Rejections In & Out
    • Purchase & Sales Order
    • Multi Currency
    • Invoicing, Bill or Stock Wise
    • Debit / Credit Notes
    • Budgets & Controls
    • Multiple Godowns
    • Rejection Notes
    • Sales Plan / Purchase Plan
    • Sales Order Processing
    • Purchase Order Processing
    • Maintaining Physical Stock
    • Inventory Reports & Statements
    • Interest Calculation
    • Print Preview

    b. Financial Accounting

    • Creating A Company
    • Company Configuration
    • Setting up a New Company
    • Ledger / Creating Groups
    • Account Heads / Voucher Entry
    • Payment / Receipt Voucher
    • Contra Entry
    • Purchase / Sales Register
    • Creating Cost Centres
    • Creating Trial Balance
    • Viewing Statement of Accounts
    • Profit & Loss Account
    • Balance Sheet
    • Bank Reconciliation
    • Interest Calculation
    • Printing of Accounts
    • Bank & Cash Books
    • PAYROLL
    • Company Controlls
    • TDS – Tax Deduction Source
    • GST – Goods and Service Tax
    • Accounting of GST in Tally
    • CGST – Central GST Government
    • SGST – State GST, Integrated GST

    MODULE 5. TALLY EXECUTIVE

    This course includes the Tally Operations along with the Executive level + 2 Volume set of Tally Champs-Level 2 Books, with which you get the Original TALLY Kit.

    • Fundamentals of Accounting and Tally.ERP 9
    • Creating Masters in Tally.ERP 9
    • Voucher Entry and Generation of Reports
    • Tally Vault and Security Controls
    • Export, Import and Splitting of Data
    • Job Costing and Job Order Processing
    • Installing & Activating Tally.ERP 9
    • Connectivity & Printing Reports
    • Advanced Accounting in Tally.ERP 9
    • Inventory in Tally.ERP 9

    MODULE 6. TALLY GST BOOK & CERTIFICATE

    • GST in Tally.ERP 9
    • Company level
    • Stock Group Level
    • Stock Item Level
    • Inter State Sales

    TALLY KIT INCLUDES

    • 2 Volumes of Books + 1 GST Book
    • Tally Training CD
    • 2 Online Exam
    • Original Tally Certification
    • Student Name is Registered on Tally Website

    INSTANT INQUIRY

    CALL: 9833900330 / 9324347326

      Tally Excel Books

      Other Courses

      Tally PRO Executive

      Tally ERP, Tally Champs, GST, Inventory & Accounting

      Advanced Excel Course

      Formulas & functions, financial analysis.

      Financial Accounting & Master Excel

      Excel, Tally ERP, Tally Champs, GST, Inventory & Accounting, Macros

      Corporate Advanced Excel

      Lookup, Pivot Tables, Macro’s, Function, Data Analysis

      INSTANT INQUIRY

      CALL: 9833900330 / 9324347326

        1. Honest Counselling : Choose the Right Course @ Right Price.
        2. Small Batches 7-10 Students leads to Personal Attention.
        3. 100% Practicals with Projects.
        4. Original, Leagal & Official Software from Autodesk, Adobe.
        5. Industry Endrosed Cirriculum.
        6. Highly Trained, Experienced & Certified Faculty.
        7. High Emphasis on Projects & Assignments.
        8. Friendly, Supportive, Patient & Qualified Faculty.
        9. Easy Installment Facility.

        Who Can Do This Course:

        • Graduates, Undergraduates, 10+2
        • Having the minimum knowledge on Bussiness management
        • Commerce Subject Students

        More You Learn Less You Pay
        Professional Training – Take a Free DEMO
        Call 9833900330 / 9930375161

        Fees: Rs. 25,550 1?,550/-

        What do my Tuition Fees include?
        1. Course Book.
        2. GST Included.
        3. Certificate.
        4. Extra Practice/Computer Time.
        5. 100% Placement Assistance.

        Morning Batches : 7:30-9am, 9-10am, 10-11am, 11-12pm
        Afternoon Batches : 12-1pm, 1:30-2:45pm, 3-4pm, 4-5pm
        Evening Batches : 5-6pm, 6-7pm, 7-8pm, 8-9pm.
        Weekend & Fast Track Batches are conducted.
        Please call to confirm the Timings.
        Daily & Alternate Day batches are conducted.

        Job Placement

        We provide 100% job placement support to all our candidates to get achieved a bright career in the Industry.

        Get Certified. Get Hired
        More You Learn Less You Pay - Call 9833900330

        Softpro Student Certificate

        INSTANT INQUIRY

          Other Courses

          Diploma in 3D Animation Course

          Character Modelling, VFX, Visual Effects, Sketching

          Digital Marketing Course

          Advance Digital Marketing Diploma

          Classroom Training, 25 Modules, 80% Practicals, ADMD

          Architecture CAD Diploma Course

          Autocad, Revit, MEP, 2D, 3D, Architecture Course

          Graphic Design Diploma Course

          Create Professional Brochures, Logo, Website Designer

          INSTANT INQUIRY