E-ACCOUNTING & DATA ANALYTICS - Contents
E-ACCOUNTING & DATA ANALYTICS training in west delhi
Module 1 M.I.S (Management Information System)
E-ACCOUNTING & DATA ANALYTICS training in west delhi
MS - WORD
GET STARTED WITH WORD
- Navigate in Microsoft Word.
- Create and Save Word Documents
- Manage Your Workspace
- Edit Documents
- Preview and Print Documents
- Customize the Word Environment
FORMATTING TEXT & PARAGRAPH
- Control Paragraph Layout
- Align Text Using Tabs
- Display Text in Bulleted or Numbered Lists
- Apply Borders and Shading
WORKING MORE EFFICIENTLY
- Make Repetitive Edits
- Apply Repetitive Formatting
- Use Styles to Streamline Repetitive
- Formatting Tasks
MANAGING LIST
- Sort a List
- Format a List
ADDING TABLES
- Insert a Table
- Modify a Table
- Format a Table
- Convert Text to a Table
INSERTING GRAPHICS OBJECT
- Insert Symbols and Special Characters
- Add Images to a Document
CONTROLLING PAGE APPEARANCE
- Apply a Page Border and Color
- Add Headers and Footers
- Control Page Layout
- Add a Watermark
ADVANCED MAIL MERGE
- Beginning a Mail Merge
- Using Excel for Mail Merge Data
- Previewing Merge Letters
- Selective Merge Records
- Filtering
- IF Then Else Fields
- Include Text Fields
- Mail Merge to Email
PREPARING A PUBLISHED DOCUMENT
- Check Spelling, Grammar, and Readability
- Use Research Tools
- Check Accessibility
- Save a Document to Other Formats
- The Macro Recorder
- Recording Macros
- Testing Macros
- Running Macros
MS - POWERPOINT
CREATING A PRESENTATION
- Blank & Sample Templates
- Adding Text Boxes
- Edit, Copy, Cut & Move Text
- Format Text Boxes
- Add Slides & Change Layouts
- Import or Reuse Slides
- Arranging Slides
- Themes & Backgrounds
- Slide Navigation
- Presentation Views
- Formatting Text
- Formatting Text
- Formatting Paragraphs
ADDING GRAPHICS
- Capture Images & Insert Pictures
- Photo Album
- Drawing Shapes
- Advanced Shapes
- Merge Shapes
- WordArt
- SmartArt Graphics
MODIFY OBJECTS
- Crop, Resize & Style Objects
- Formatting Objects
- Grouping Objects
- Object Ordering & Layering
- Gridlines & Guides
TABLES
- Insert & Formatting Tables
- Insert Table from Word
- Manipulating PowerPoint Tables
- Inserting a Word Table
- Inserting an Excel Spreadsheet
- Adjusting Rows, Columns, Cells
- Table Styles and Borders
CREATE & MODIFY CHARTS
- Inserting a Chart
- Working with Datasheets
- Applying a Chart Type, Style and Layout
- Displaying Chart Analysis
- Picture Charts
- Formatting Chart Background
TEMPLATES , THEMES & LAYOUTS
- Creating a Custom Layout
- Applying a Theme
- Applying a Background Style
- Saving a Custom Theme
- Arranging and Printing Section
CUSTOM DESIGN & TEMPLATES
- Slide Master
- Background Graphics
- Custom Slide Layouts
- Advanced Custom Themes
- Add Headers & Footers
- Modify Notes Master
- Edit Handout Master
- Create Custom Template
EDITING SLIDE MASTERS
- Slide Master, Title Master
- Formatting the Masters
- Adding Header and Footer Information
- Notes and Handout Masters
ANIMATION & TRANSITIONS
- Animation Schemes
- Animating Text and Objects
- Custom Animations and timing
- Inserting Sounds and Video
- Editing Media Clips
SETTING UP THE SLIDESHOW
- Setting Automatic Slide Timings
- Setting Up a Continuous Loop
- Hiding a Slide
- Rehearsing Slide Transition Timings
CUSTOM SHOWS & INTERLINKED SHOWS
- Creating a Custom Show
- Setting Up a Custom Show as the Default
- Creating a Hyperlink
- Using a Hyperlink
- Using an Action Buttons
- Jumping to Another Presentation
PACKAGING PRESENTATION
- Creating a Custom Show
- Embedding the Fonts in a Presentation
- Using the PowerPoint Viewer
- Formatting a Presentation for the Web
- Inspecting the Document
- Annotating a Presentation
- Sending in PDF Format
USING SMARTART
- Inserting a SmartArt Object
- Formatting a SmartArt Object Color
- Resizing/Repositioning a SmartArt Object
- Inserting Text into a SmartArt Object
- Formatting Text Within a SmartArt Object
- Adding Shapes to a SmartArt Object
- Grouping SmartArt Objects
INSERTING A PHOTO ALBUM
- Inserting Pictures from a File
- Adding Captions
- Applying a Theme to your Album
- Customizing the Album Layout
CUSTOMIZING PRESENTATION
- Custom Slide Shows
- Setup Slide Show & Presenter View
- Secure PowerPoint Show
- Hyperlinks
- Action Buttons & Link Actions
- Annotate
- Record Narration
- Rehearse Timings
COLLABORATING
- Merge & Compare
- Insert Comments
- Slide Library
- OneDrive & Coauthoring
SECURE & DISTRIBUTE
- Present Online
- Create Video Files
- Package Presentation
- Publish to PDF or XPS
- Document Properties
- Document Inspector
- Password Protect
- Digital Signature
- Mark as Final
- Screen Recording
- Closed Caption
- Equations & Ink
Prof. MS Access (RDBMS)
SECURE & DISTRIBUTE
- Present Online
- Create Video Files
- Package Presentation
- Publish to PDF or XPS
- Document Properties
- Document Inspector
- Password Protect
- Digital Signature
- Mark as Final
- Screen Recording
- Closed Caption
- Equations & Ink
CREATING TABLES
- Creating a Database
- Creating a Table Using the Wizard
- Creating and Modifying a Table
- Adding Fields to Tables
- Adding and Editing Records
- Printing Tables
- Moving and Deleting Fields
- Deleting Records
WORKING WITH TABLES
- Formatting a Table
- Modifying Field Properties
- Sorting Records in a Table
- Finding Records in a Table
- Using Filters with a Table
- Establishing Relationships Between Tables
- Creating Subdatasheets
- Importing Records From an External Source
DESIGNING A FORM
- Creating a Form Using Auto Form
- Creating a Form Using the Form Wizard
- Adding Controls to a Form
- Modifying Control Properties
- Resizing and Moving Controls
- Entering Records into a Form
- Creating Calculated Controls
DESIGNING A REPORT
- Creating a Report Using Auto Report
- Creating a Report Using Report Wizard
- Adding a Control to a Report
- Formatting a Report
- Resizing and Moving Controls
- Creating Calculated Controls
CREATING & USING QUERIES
- Creating and Running a Query
- Specifying Criteria in a Query
- Using Comparison Operators
- Creating a Calculated Field
- Creating a Multiple-Table Query
- Printing a Query
AUTOMATING TASKS
- Creating an Auto Keys Macro
- Using Controls to Run a Macro
- Assigning a Macro to an Event
- Assigning a Macro to a Condition
- Testing and Debugging a Macro
AUTOMATING TASKS
- Creating an Auto Keys Macro
- Using Controls to Run a Macro
- Assigning a Macro to an Event
- Assigning a Macro to a Condition
- Testing and Debugging a Macro
Professional MS - Excel
AUTOMATING TASKS
- Creating an Auto Keys Macro
- Using Controls to Run a Macro
- Assigning a Macro to an Event
- Assigning a Macro to a Condition
- Testing and Debugging a Macro
Formulas
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Floor
- Round
- Round up
- Round down
- Power
- Count
- CountA
- Count
- Sum if
- Maximum
- Minimum
- Hlookup for single worksheet
- Vlookup for single worksheet
- Hlookup & Vlookup for multiple Sheet
- Index
- Show formula
- Or
- Not
- Iferror
- Lookup
- Rate
- Ppmt
- Ipmt
- Networkdays
- Roundup
- Rounddown
- Mode
- Median
- Received
- Log
- Dollar
- AverageA
- Averageif
- Averageifs
- Mina
- Maxa
- Sumifs
- Large
- Pv
- Fv
- Coupdays
- Coupnum
- Datedif
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
- Now
- Today
- Weekday
- SQRT
- Mod
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Match
- Roman
- Proper
- Pmt
- Concatenate
- IF Function & Nested IF Statements And & Or Functions
- Match and find record by VLOOKUP And HLOOKUP
- ISPMT
- SLN
- Effect
- CUMPRINC
- CUMIPMT
- EoMonth
- EDATE
- WORKDAYS
- DDB
- DB
- Approximate Match with Vlookup
- Exact match with Vlookup
- Nesting Lookup Function
- Choose Function
- Rank & Rank Average
- Rand & Rand Between
- Mod with Conditional Formatting
- Transpose
- Find & mid
- ISERR,
- OFFSET
- IIR
- NPV
- MONTH
- HOURS
- MINUTE
- NETWORKDAYS.INSTL
- Transpose with Vlookup
- ISNUM
- ISERROR
- IFERROR
- SUBSTITUTE
- INDIRECT
- SEARCH
- TRIM
- INDEX WITH SUM,COUNT,AVERAGE
Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
Create Statements According to Function
- Inserting a Hyperlink
- MIS Report
- Profit & Loss a/c statement
- Balance sheet
- Worker contribution statement
- Cash flow statement
- Debtor’s & Creditors statement
- Inventory statement
- BRS Statement
- Fixed Assets & fund statement
- Payroll Report
- P.F & E.S.I Report
WORKING WITH CHARTS
- Creating a Chart with the 2D or 3D
- Create Column Chart, Pie Chart
- Create Pateros Charts
- Create Speed- O-Meter Chart
- Moving a Chart One to another Sheet
- Resizing a Chart, Changing a Chart Type
- Editing Chart Text, Modifying Chart Options
- Formatting Category & Value Axis Data
- Formatting a Data Series
- Changing a Chart’s Source Data
FORMATS , CONDITIONAL FORMATTING & SORTING
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Conditional formatting with formulas
- Conditional formatting with Form Controls.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
FORMATTING NUMBERS
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
DATA MANAGEMENT
- Data Validation and dealing with Invalid Data.
- Group and Outline Data
- Data
- Data Consolidation.
- Data text to column.
- Custom Views
DATA ANALYSIS TOOLS
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
SUMMARIZING DATA
- Adding Subtotals to a List
- Nesting Subtotals
- Applying Advance Filters
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Text to Column
WHAT IF – DATA ANALYSIS
- Using Goal Seek
- Using Data Table
- Creating & Displaying Scenarios
WORKING WITH LISTS
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
WORKGROUP COLLABORATION
- Locking/Unlocking Cells in a worksheet
- Protecting a Worksheet
- Protecting a Workbook
- Creating a Shared Workbook
- Tracking Changes to a Workbook
- Accepting & Rejecting Changes to a Workbook
- Password Protecting a Workbook
- Merging Workbooks
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
CUSTOMIZING EXCEL
- Creating a Macro with Condition
- Running a Macro, Editing a Macro
- Adding a menu to the Menu Bar
- Adding a Commands to a Menu
- Adding Buttons to a Toolbar
PRINT SETTINGS
- Page Break
- Print Area
- Print Titles
- Background
SPECIAL OPERATIONS
- Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
- Find record by drop down list according To condition
- Dash Board
SQL
SQL – OVERVIEW
- What is SQL?
- SQL Process
- SQL Commands
SQL – OPERATORS
- What is an Operator in SQL?
- SQL Arithmetic Operators
- Arithmetic Operators – Examples
- SQL Comparison Operators
- Operators – Examples
- SQL Logical Operators
- Logical Operators – Examples
SQL – Expressions
Boolean Expressions
Numeric Expressions
Date Expressions
SQL – CREATE Database
- SQL ─ DROP or DELETE Database
- SQL ─ SELECT Database, USE Statement
- SQL ─ CREATE Table
- SQL – Creating a Table from an Existing Table
- SQL ─ DROP or DELETE Table
- SQL ─ INSERT Query
- SQL ─ SELECT Query
- SQL ─ WHERE Clause
- SQL ─ AND & OR Conjunctive Operators
- The AND Operator
- The OR Operator
- SQL ─ UPDATE Query
- SQL ─ DELETE Query.
- SQL ─ LIKE Clause.
- SQL ─ TOP, LIMIT or ROWNUM Clause
- SQL ─ ORDER BY Clause
- SQL ─ Group By
- SQL ─ Distinct Keyword
- SQL ─ SORTING Results
SQL CONSTRAINTS
- SQL ─ Constraints
- SQL – NOT NULL Constraint
- SQL – DEFAULT Constraint
- SQL – UNIQUE Constraint
- SQL ─ Primary Key
- SQL ─ Foreign Key
- SQL ─ CHECK Constraint
- SQL ─ INDEX Constraint
- Dropping Constraints
- Integrity Constraints
SQL Using JOINS
- JOIN
- SQL ─ LEFT JOIN
- SQL – RIGHT JOIN
- SQL ─ FULL JOIN
- SQL ─ SELF JOIN
- SQL ─ CARTESIAN or CROSS JOIN
SQL UNION CLAUSE
- The UNION ALL Clause
- SQL ─ INTERSECT Clause
- SQL ─ EXCEPT Clause
SQL ─ NULL Values
SQL ─ Alias Syntax
SQL – Indexes
- The CREATE INDEX Command
- The DROP INDEX Command
- SQL – INDEX Constraint
SQL ─ ALTER TABLE Command
SQL – TRUNCATE TABLE Command
SQL ─ Using Views
- Creating Views
- The WITH CHECK OPTIONSQL ─ Having Clause
VBA
WHAT IS VBA & HOW VBA WORKS WITH EXCEL
- Quick Review of Macros
- Introducing the Visual Basic Editor
- Uses of record Macros
- Understanding and creating modules
PROGRAMMING CONCEPTS
- VBA Sub and Function Procedures
- How to create a message box
- Write a Program to update and retrieve information using Input Box
- Understanding and using Select Case statement
- How do I define a variables and Rules for defining a Variables Name and Type
- Creating And using Variables
- Working with range Objects
- How to save and Protect Modules
OTHER KINDS OF LOOP
- Working with Do While u. Loop Procedure
- Do…… Until Loop and Do…… Loop Until
- Do……While loop and Do…… Loop While
- For each…… Next
- For……Next
Workbook Objects Create or Add Single and Multiple Workbooks
- Workbook Save and Save AS
- Open Single and Multiple Workbooks
- Close Specify and Multiple Workbooks
- Activate From one workbook to another Workbook
- Open Workbook from Specific Path
- Get Workbook Name and Paths
- Hide and Unhide for Single and Multiple Workbooks
- Protect and Unprotect Worksheets
Worksheet Objects insert a single and Multiple Worksheets
- Delete Specific and multiple worksheets
- Get Count of Worksheets
- Select a Specific and all Worksheets
- Get All Worksheets Name
- Hide and Unhide For Single and Multiple Worksheets
- Rename for Single and Multiple Worksheets
- Protect and unprotect worksheets
- Sort and Move worksheets
- Calculate entire worksheet
- Using VBA and worksheet Function
Cell objects insert Single and multiple Row, Column and Cells
- Delete Single and Multiple rows, Column and Cells
- Get Range or Address of Cell and Selection
- Navigate from one Cell to another Cell
- Select specific Range, Cell, Rows and Column
- Types of Selection and Offset method
- Insert Function In cell
Reading and Writing Arrays
- Defining Arrays
- Arrays as Outputs
- Arrays as inputs
- The Arrays as a Collection
- The Array as an Array
Form Controls and User Forms (Create and Design an user Form)
- Working with User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
- How to Create Dynamic Dashboard on User Form with Different Controls
- How to Link Various User Form With Each Other To Create A Complete Interface Between User and System
VBA Programming Functions
- Create a Sum Functions
- Create Multiply Function
- Create Count Function
- Extract Text & Number
- Proper Function
- Vlookup Function
- Square root Function
- Public or Private function
Excel VBA Power Programming for VBA Macros
- Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
- How to Analyze Data On multi Worksheets and Build Summary sheets
- how to Access the Windows File and Folder System to Open and Close Workbooks
- How to protect your code Against Errors
- How to use Excel And VBA to Create Basic Dash Boards
- How to create Your own custom Business Worksheet Function in VBA
- How to create Basic Report Generation Tools Using Excel Vba, Microsoft Word and PowerPoint
- How to use the Excel Visual Basic Macro record Excel Tasks in VBA and then Interpret the code
Connection between Excel VBA & other platforms
- How to Establish Connection Between VBA And Power Presentation to Create Power Point Through VBA
- How to Establish Connection Between Excel Vba And Outlooks Through Vba
- How to Establish Connection Between Excel Vba And MS Word Through Vba
Module 1
E-ACCOUNTING & DATA ANALYTICS
ADVANCED ACCOUNTING
- Accounting terminology
- Activities and user of Accounting Information
- Assumption of Accounting
- Principal of Accounting
- Accounting cycle and source/Accounting document
- Accounting equation Classification of Account
- Types of Expenditure
- Compound Entry
- Subsidiary book and types of book
- Trial balance & Objectives
- Rectification of Error
- Provision & Reserve
- Inventory & cost for Inventory Valuation
- Suspense Account
- Share capital of company
- Kind of Share, forfeiture of share
- Over Subscription & Pro-rata allotment
- Accounting voucher
- Journal, cash book, ledger and trial balance
- Bills of exchange
- Depreciation
- Bank Reconciliation Statement
- Financial Statements
- Ratio Analysis
- Cash Flow Statement
- MIS Report
- Budget & Types of Budget
- Accounting Standard
Module 2
E-ACCOUNTING & DATA ANALYTICS
TAXATION
- Residential Status & Slab rate of Taxes
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit & Gains from Business & Profession
- Income under the Head Capital Gains
- Income under the head Other Sources
- Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
- Agricultural Income, Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of individual
- TDS/TCS-Types of Forms, return filing
- Tax Deduction of Source, Advance Tax,
- Interest, Refund, Penalty,
- Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
- Legal Documentation
- GST (GOODS AND SERVICE TAX)
- Legal Documentation For GST
Module 3
E-ACCOUNTING & DATA ANALYTICS online training in west delhi
BUSY
General Features
- Completely Codeless
- Multi-Company Accounting
- Context-Sensitive On-Line Help
- Flexible Voucher Numbering
- Multiple Voucher Series for each Voucher Type
- Voucher entry while viewing reports and Vice-versa
- User-definable Optional Fields in Masters and Vouchers
- Unlimited level of Grouping of Accounts, Items, Material Centers and Cost Centers
- Option for adding Images & Notes in Account & Item Masters
- Draft Mode Printing for every Report and Document
- Voucher Cancellation
- Powerful Query System
- SQL Query Executor
- Print Preview
- Landscape Mode Printing
- Bird’s Eye View of Account
- ENTERPRISE FEATURES
- Voucher / Master Approval
- Message centre
Financial Accounting
- All books of Accounts & Final Results
- Balance Sheet with various Schedules
- Columnar Account Registers (Configurable)
- Daily / Monthly Summaries of Accounts, Account Groups and Cost Centers
- Bill-wise Outstanding with Ageing Analysis
- Payment Reminder Letters (Configurable)
- Statement of Account (Configurable)
- Handling of Post-dated Cheques
- Broker-wise Reporting
- Royalty Calculation
- Interest Calculation (Multiple Slabs based on Amt. & Days)
- Bank Interest Calculation
- Bank Re-conciliation
- Depreciation Chart (As per Companies Act / IT Act)
- Multi-Currency Accounting
- Cost Centre-wise Reporting
Multi – Location Inventory
- All books of Inventory
- Stock Status (Multi-location)
- Sales / Purchase Challans
- Columnar Inventory Registers (Configurable)
- Stock Valuation on Multiple Methods
- Separate Stock Valuation Method for each Item
- Item Serial No. Tracking
- Stock Ageing Analysis
- Allocation of Expenses to Items
- Daily / Monthly Summaries of Items and Item Groups
- Automatic Round-off in Vouchers
- Primary and Alternate Unit for each Item
- Batch-wise Inventory with Expiry Date
- Provision for Free Qty in Inventory Vouchers
- Provision for entering Sales / Purchase Return in Sales / Purchase Vouchers
- Production / Un-assemble
- BOM / Production Planning
- Critical Level Reporting
- Multiple Price-list for Items
- Multiple Price Structures (Party / Qty / Category-wise)
- Provision to update Item Prices on various Criterion
Sales / Purchase Order Processing
- Pending Sales Orders (Party / Item-wise)
- Pending Purchase Orders (Party / Item-wise)
- Order Cancellation
- Invoice / Challan Generation from Orders
- USER-CONFIGURABLE INVOICING
Fully User-Configurable
- Use Plain / Pre-printed Stationery
- Option for Fonts, Colors& Logos
- Option to Print Outer Box, Horizontal & Vertical Lines
- Multiple-taxes in Single Invoice
- Tax Inclusive / MRP Billing
- Point-of-Sale (POS) Billing
- Mfg. Excise Invoicing
- Trading Excise Invoicing
User-Configurable Documents
- Accounting Vouchers
- Purchase Invoice
- Sales Return / Purchase Return Invoice
- Receipt / Payment Advice
- Debit / Credit Note
- Sales / Purchase Order
- Delivery Note / Goods Receipt Note
- Stock Transfer Memo
Sales & Tax Reports
- Sales Tax Forms Receivables / Issuable
- Sales Tax Forms Reminder Letters
- Forms Received / Issued Register
- Sales Tax / Purchase Tax Summary
- Sales Tax Surcharge
- Sales Tax Registers
GST Reports
- GST Computation / Summary
- GST Invoicing (Tax / Retail)
- GST Returns (State-wise)
- GST Registers (State-wise)
- Columnar GST Registers (Configurable)
- Party-wise / Item-wise GST Summary
- Party-wise / Item-wise GST Summary
- Sales Re-conciliation as per Accounts and GST
- GST R1
- GST R2
- GST 3B
Service Tax
- Input Service Tax Register
- Output Service Tax Register
- Service Tax Summary
- ST-3 (Service Tax Return)
TDS Report
- TDS Calculation
- TDS Warning Alarms
- TDS Challans
- TDS Certificate (Form 16-A)
- TDS Return (Form 26-Q)
- Annexures to Form 26-Q
- e-TDS with TDS 27-A
- TDS Audit Report
- TDS Deduction Details Report
Fringe Benefit Tax
- Mark Expenses as FBT
- Expense-wise Taxable Value
- Option to charge FBT on Account Groups
- Fringe Benefit Tax Report
MIS Report
- Cash Flow / Funds Flow
- Budgets / Targets / Credit Limits
- Ratio Analysis
- Sales / Purchase Analysis on various combinations
- Issue / Receipt Analysis
- Consumption Analysis
- Data Check List
- Profitability Reports (Item / Bill / Party / Batch / MC wise)
- Multi-Company Final Results / Reports
Utilities
- Data Freezing
- Pop-up Calculator
- Notes / Task Manager
- User-definable Access Rights
Module 4
E-ACCOUNTING & DATA ANALYTICS training
TALLY
INTRODUCTION OF TALLY
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
BOOK KEEPING
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
FINANCIAL REPORT
- Balance sheet
- Profit & loss a/c
- Ratio analysis
FUND MANAGEMENT
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
MODE OF INVOICE BILLING
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
INVENTORY MANAGEMENT
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
PURCHASE & SALES ORDER PROCESSING
- Stock group
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
MULTI – GOD CREATION
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
TAS DEDUCTED AT SOURCE (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
TAS COLLECTED AT SOURCE (TDS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
GOODS & SERVICES TAX
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
PAYROLL ACCOUNTING FUNCTION
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
MANUFACTURING VOUCHERS
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
VOUCHERS TYPES & CLASS
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 5 - E-FILLING
E-ACCOUNTING & DATA ANALYTICS training in west delhi
GST FORMS
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
INCOME TAX RETURN FORMS
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
Module 6
E-ACCOUNTING & DATA ANALYTICS
POWER BI
INTRODUCTION OF POWER BI
- Data Visualization
- Reporting
- Business Intelligence (BI)
- Traditional BI, Self-Serviced BI
- Cloud Based BI,
- On Premise BI
- Power BI Products
- Power BI Desktop (Power Query Power Pivot, Power View)
- Flow of Work in Power BI Desktop
- Power BI Report Server, Power BI
Service, Power BI Mobile Flow of Work in Power BI / Power BI Architecture - A Brief History of Power BI
POWER BI
- Data Transformation, Benefits of Data Transformation
- Shape or Transform Data using Power Query
- Overview of Power Query / Query Editor, Query Editor User Interface
- Ribbon (Home, Transform, Add Column, View Tabs)
- The Queries Pane, The Data View / Results Pane, The Query Settings Pane, FormulaBar
- Saving the Work
- Datatypes, Changing the Datatype of a Column Filter
- In Power Query
- Auto Filter / Basic Filtering
- Filter a Column using Text Filters
- Filter a Column using Number Filters
- Filter a Column using Date Filters
- Filter Multiple Columns
- Remove Columns / Remove Other Columns
- Name / Rename a Column
- Reorder Columns or Sort Columns
- Add Column / Custom Column Split
- Columns
- Merge Columns
- PIVOT, UNPIVOT Columns
- Transpose Columns
- Header Row or Use First Row as Headers
- Keep Top Rows, Keep Bottom Rows
- Range of Rows
- Keep Duplicates, Keep Errors
- Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
- Remove Duplicates, Remove Blank Rows, Remove Errors
- Group Rows / Group By
DATA MODELING
- Data Modeling Introduction
- Relationship, Need of Relationship
- Relationship Types / Cardinality in General
- One-to-One, One-to-Many (or Many to-One), Many-to-Many
- AutoDetect the relationship, Create a new relationship, Edit existing relationships
- Make Relationship Active or Inactive
- Delete a relationship
FUNCTIONS
- IF..ELSE Conditions, Transform Column () Types
- Remove Columns (), Split Columns () , Replace Value()
- Table. Distinct Options and GROUP BY Options Table.
- Group (), Table. Sort () with Type Conversions PIVOT
- Operation and Table. Pivot(). List Functions Using
- Parameters.
DAX F UNCTION
- What is DAX, Calculated Column , Measures
- DAX Table and Column Name Syntax
- Creating Calculated Columns, Creating Measures Calculated
- Columns Vs Measures
- DAX Syntax & Operators
❖ DAX Operators
❖ Types of Operators
❖ Arithmetic Operators, Comparison
Operators, Text Concatenation
Operator, Logical Operators
INVENTORY MANAGEMENT
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
PURCHASE & SALES ORDER PROCESSING
- Stock group
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
MULTI – GOD CREATION
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
TAS DEDUCTED AT SOURCE (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
TAS COLLECTED AT SOURCE (TDS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
GOODS & SERVICES TAX
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
PAYROLL ACCOUNTING FUNCTION
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
MANUFACTURING VOUCHERS
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
VOUCHERS TYPES & CLASS
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
