Module 1: Introduction to ERP

Need of ERP
Advantages of ERP
Major ERP packages
Introduction to SAP and Why SAP
History of SAP
Roles And Responsibilities of a Consultant
Business Blue Print Creation
Functional Requirement Specification
Creation of Industry Print
Real Time Functionality of SAP R/3, SAP ECC
SAP GUI and SAP Logon/Login,
SAP LandScape,
SAP R/3, SAP ECC, & SAP S/4 Latest version,
SAP ECC Concept.
PIS and Function Specification
Quiz Module 1

Module 2: SAP Projects

Implementation, and implementation methodologies (ASAP & Solution Manager)
Support
Upgrade (ECC to S/4 Latest version)
RollOut (Country-to-country & Plant-to-plant)
Quiz Module 2

Module 3: SAP FI Financial Accounting Basic Settings

Creation and assignment of the company and the company code
Creation of a business area
Defining and assigning the fiscal year variant
Defining and assigning the posting period variant
Defining open and closing posting periods
Defining document type & number ranges
Maintenance and assignment of field status variants
Defining and assigning tolerance groups of employees
Taxes on Sales & Purchases (input & output)
Creation of Chart of Accounts
Defining Accounts Groups
Defining Retained Earnings Account
Defining tolerance groups for G/I accounts
Real-time Issues
Quiz Module 3

Module 4: SAP FI General Ledger Accounting

Creation of General Ledger Master (with and without reference)
Display/Change/Block/Unblock of the general ledger
Master Document Entry
Posting normal postings posting with reference
Display and change documents
Display of GL balances and Line items
Parked documents & hold documents
Creation of the Sample Document and posting
Defining the recurring entry document and posting
Configuration of line layouts for the display of GL line items
Quiz Module 4

Module 5: SAP FI Accounts Payable

Creation of vendor account groups and assignment of number ranges
Creation of a tolerance group for vendors
Creation of vendor master (display/change/block/unblock of vendor master)
Posting of vendor transactions (invoice posting, payment posting, credit memo)
Settings for advance payments to parties (down payment) and clearing of down payment against invoices (special GL transactions)
Procure-to-pay (P2P)
Quiz Module 5

Module 6: SAP FI Accounts receivable

Creation of customer account groups and assignment of number ranges
Creation of a tolerance group for customers
Creation of customer master (display/change/block/unblock of vendor master)
Order-to-Cash (O2C)
Record-to-Report (R2R)
Posting of customer transactions (sales invoice posting, payment posting, debit memo), Settings for advance payment from parties (down payment)
Configuration of settings for dunning
Defining correspondence & party statement of accounts
Real-time issues
Quiz Module 6

Module 7: SAP FI Asset Accounting

Defining the chart of depreciation
Defining account determination, screen layout
Number ranges and asset classes
Integration with General Ledger & Posting rules
Creation of asset master and sub-asset master (change/display/block/unblock)
Defining Depreciation key (base, declining, multilevel, period control methods)
Acquisition or purchase of assets, sale of assets, scrapping of assets, Transfer of assets
Post Capitalization and write up
Depreciation run Line Settle of assets under construction of capital work in progress
Real-time issues
Quiz Module 7

Module 8: SAP FI Reports

Financial statement version GL Reports
Accounts payable reports
Accounts receivable reports Assets
Real-time issues
Quiz Module 8

Module 9: SAP CO CONTROLLING Basic Settings for Controlling

Defining Controlling Area
Defining Number Ranges for Controlling Area
Maintain Planning Versions
Creation of Primary and Secondary Cost Elements
Creation of Cost Element Groups
Primary cost element categories and secondary cost element categories
Real-time issues
Quiz Module 9

Module 10: SAP CO Cost Center Accounting

Defining Cost Center Standard Hierarchy
Creation of Cost Centers and cost center groups
Planning for cost centers, posting to cost centers
Repost of Costs Creation and Execution of Distribution Cycle Creation and execution of assessment cycles Cost Center reports
Real-time Issues
Quiz Module 10

Module 11: SAP CO Internal Orders

Defining order types
Creation of internal orders
Planning of internal orders
Postings to the internal order Report of Variance analysis
Quiz Module 11

Module 12: SAP CO Profit Center Accounting

Basic Settings for Profit Center Accounting
Standard Hierarchy
Creation of Dummy Profit Centers
Maintaining versions of for-profit centers
Creation of profit centers and profit center groups
Creation of revenue cost elements
Automatic Assignment of Revenue elements for Profit Centers Postings to profit centers, planning, and variance reporting
Quiz Module 12

Module 13: SAP CO COPA Reporting

What is COPA
Maintenance of Characteristics
Maintenance of Fields
Configuration etc.
Quiz Module 13

Module 14: SAP Integration

Procurement cycle (P2P) Integration with MM
Sales process integration with SD Integration with asset accounting
Quiz Module 14

Module 15: SAP Taxation

SAP Configuration – Tax procedure, Tax condition type, incorporate tax condition type into SD & MM pricing procedure, tax code configuration, account key design for tax posting
Good understanding of Tax Compliance, GST Returns, eInvoicing &eWay Bill, and Tax Reporting.
Experience of testing cross-module (FI-SD, FI-MM) functionality
Experience in developing cross-module reports and programs
Require experience in solving business issues using SAP solutions on an ongoing basis
Ability to work with clients in a consultative way, helping them translate their tax function’s business
objectives into digital strategies
Willingness to build a career within the tax transformation domain
Ability to work under stringent deadlines and demanding client conditions
Strong interpersonal, team, and communication skills, both verbal and written
Teamwork, collaboration, customer centricity, service orientation, and quality focus

Module 16: Advanced Excel Course

Introduction to MS Excel

Advantages of using MS Excel & Various purposes to use Excel
Understanding of Workbook, Worksheet, columns, rows & Cells
Ribbon & Tabs
Quick access bar, Formula bar, Name bar, Status bar
Keyboard Shortcuts & Navigation while using large amounts of data
Different Use of the Mouse
Insert Comment

Working With Tables

Advantages of converting data into tables
Structured formula
Use of Slicers
Dynamic Range

Understanding Cell References

Absolute Reference
Relative Reference
Mixed Reference
3D Reference

Basic Functions of Excel

Text to Column
Flash Fill
Auto Fill

Sorting Data

In Ascending & Descending Order
Sort with Text, Numbers & Date
Sort with formatting (Cell, Color, Font Color)
In Multiple Orders
In Custom Order

Filtering Data

Applying Filters by text, numbers, or date on the Data
Advanced Filter: Setting up Criteria to Filter the data
Applying Complex Criteria
Clearing the existing criteria
Use Wildcard characters in Filter Criteria

Data Consolidation/ Basics of Formula/ Functions

Form multiple Sheets
Form multiple Files
Understanding Syntax, Intellisense, Suggestion box & optional argument
Basic Calculations & BODMAS Rule
Calculate Square, cube & Raise a Number to a Power

If Functions and Test Functions

Simple If
Combination of If with OR, AND & NOT
Nested If Function
LEN, TRIM, LEFT, RIGHT, MID, FIND, SEARCH, CONCATENATE, UPPER, LOWER, PROPER
REPLACE, SUBSTITUTE, SEARCH, FIND

Working With Dates, Countlifs, and Sumlfs

Date & Time Formula
COUNTIF, COUNTIFS, SUMIF, SUMIFS

Lookup and Information Functions

Lookup Functions - VLOOKUP. HLOOKUP. LOOKUP
Disadvantage / Limitations of Vlookup
Reference Functions - MATCH INDEX
Simple XLookup
Exact Match
Approx Match
Nested XLookup
Case Sensitive Xlookup
Multiple Answer column Xlookup
Lookup Repeating Value (Using Filter)

Using Named Ranges

Defining and Using Range Names
Using Named Ranges in Functions

Data Validation

By Numbers, Text Length, Date, List (dropdown)
Input Message and Error Message
Dependent Data Validation
Dynamic Dropdown range with Table

Dynamic Array Formula

Spilled Ranges & use of #
Sort
Sort by
Unique
Filter
Sequence
Ifs

Using Conditional formatting

Applying Conditional Formatting
Applying Multiple Rule Sets
Creating Custom Rule Sets
Viewing and Managing Rules
Clearing Custom Rules

Macros (only Recording, non-VBA)

Displaying the Developer Tab
Review and Purpose of Macros
Where to Save Macros
Absolute and relative record
Running macros: Assigning to Quick Access Toolbar, shapes
Pictures and keyboard shortcuts
Macro recording with charts & sorting Data
Alter the recorded code
User-Defined Function (UDF)
Use prebuilt VBA code

Summarizing Data With Pivot Tables

Creating Pivot Tables
Rearranging Pivot Table Data
Modifying Pivot Table calculations
Drill-Down
Filtering the Pivot data
Summarizing Values by Sum. Count. Average. Max. and Product
Show Values As % of Grand Total, % of Column Total, % of Row Total
Grouping Fields
Creating Calculated Column(s) in Pivot
Creating Calculated Item(s) in Pivot
Showing and Hiding the Grand Totals
Refreshing data in pivot table
Changing the scope of data source

Working With Slicers

Inserting and Using a Slicer
Renaming the Slicer
Changing Slicer Settings
Formatting a Slicer
Clearing the Slicer

Power Pivot / Power Query

Enable PowerPivot
Understand Import Data, Transform data, Data Model to create a report
Use Load, Load to & Transform Data
Use of Power query to record steps for all files from a folder
Add column, Update Column with Text, Numbers, & date

Charts

Selecting data
Formatting your Chart
Understanding Different Types of Charts
Combo Chart
Creating Custom chart types
Use of Secondary Axis
Using Trend Line in Charts

Other Topics

Format Painter
Freeze Pans
Removing Duplicates
Transposing Data
Paste Special
Print Settings
Custom Formatting

Excel Dashboard

Objective to Create Dashboard
Create Pivot Table & Charts
Design Dashboard
Use Macro to Automatically Refresh all when row data is changed or new data is added

Protecting and Security

Password Protect workbook (file) for open & modify
Password Protect Sheet
Password protect workbook structure (Review - protect Sheet)
Allow Edit Range with password

Mail Merge

Understand Mail Merge

Module 17: Basics of Finance & Accounts (Self-Paced)

Management of Money

Management of Money
Basic Understanding of Financial Concepts
Assets – Meaning and Examples
Liabilities – Meaning and Examples
Income and Expenditure Concepts

Financial Concepts

Difference between Assets, Liabilities, Income & Expenditure
Practical Examples for Conceptual Understanding

Time Value of Money, Risk & Return

Concept of Time Value of Money
Investment Policies
Today’s Investment as Future Asset
Types of Risk in Investment
Return on Investment Concepts

Cash Flow and Fund Flow

Meaning of Cash Flow
Meaning of Fund Flow
Difference between Cash Flow and Fund Flow
Industrial Usage with Examples
Tracking Inflow and Outflow of Money in a Company

Asset Allocation & Diversification

Concept of Asset Allocation
Allocating Assets as per Requirements
Diversification of Asset Classes
Examples of Asset Classes (Real Estate, Shares, etc.)

Net Worth Calculation

Concept of Net Worth (Assets − Liabilities)
Net Worth Formula Explanation
Types of Assets (Land, Building, Plant & Machinery, etc.)
Types of Liabilities (Mortgage, Credit Card Debt, Company Debts)
Practical Net Worth Calculation Examples

Interest Calculation

Concept of Interest
Simple Interest Calculation
Compound Interest Calculation
Practical Examples and Applications

Inflation

Meaning of Inflation
Consumer Price Index (CPI)
Retail Inflation
Decrease in Purchasing Power
Purchasing Power Parity (PPP)
Broad Price Increase Concept
Measurement of Inflation

Financial Planning & Budgeting

Financial Planning Fundamentals
Money Management Techniques
Short-Term Financial Goals
Long-Term Financial Goals
Financial Position Analysis
Income, Expenditure, Assets & Liabilities Evaluation

Budget & Its Impact on Society

Basics of Budget
Role of the Budget in the Economy
Income Tax Basics
GST Overview
Withholding Tax Concepts
Societal Impact of the Budget

Fundamentals of Accounting Types

Financial Accounting (External Reporting)
Management Accounting (Internal Decision Making)
Cost Accounting (Cost-Based Planning)
Auditing (Independent Review)
Tax Accounting (Compliance Handling)
Accounting Information System (AIS)

Accounting Standards

GAAP (Generally Accepted Accounting Principles)
IFRS (International Financial Reporting Standards)
Indian Accounting Standards
Adoption of Accounting Standards Across Countries

Accounting Systems & Financial Statements

Concept of Tally
Single Entry System
Double Entry System
Trading Account Basics
Profit & Loss Account
Balance Sheet Understanding
Importance in Tax, Accounting & Compliance

Credit & Lending Concepts

Concept of Credit
Mortgage Basics
Installment Credit
Home Equity Loans
Credit Risk Monitoring & Management
Bank Mortgage & Loan Against Property
Consumer Credit Management

Career Preparation & Assessmen

Interview Preparation
ATS-Friendly Resume Preparation
MCQ Exam Preparation
Group Discussion (GD) Preparation
Career Guidance & Evaluation

Module 18: CA Crash Course (Self-Paced)

Fundamentals of Accounting Revision

Accounting Principles and Concepts
Journal Entries and Ledger Posting
Trial Balance Preparation
Rectification of Errors
Depreciation Accounting
Financial Statements Preparation

Financial Reporting and Accounting Standards

Overview of Key Accounting Standards
Recognition and Measurement Principles
Presentation of Financial Statements
Consolidated Financial Statements Basics
Practical Case Studies and Applications

Cost and Management Accounting

Cost Concepts and Cost Classification
Material, Labour, and Overhead Costing
Marginal Costing and Break-Even Analysis
Standard Costing and Variance Analysis
Budgeting and Budgetary Control

Direct Taxation

Basics of Income Tax Law
Heads of Income
Deductions and Exemptions
Computation of Total Income
Advance Tax and TDS
Practical Problems and Case Studies

Indirect Taxation (GST)

Fundamentals of GST
Levy and Collection of GST
Input Tax Credit Mechanism
GST Returns and Compliance
GST Case Studies and Practical Problems

Corporate and Business Laws

Companies Act Key Provisions
Company Incorporation and Management
Corporate Governance
Contract Law and Business Regulations
Important Case Laws for Exams

Auditing and Assurance

Fundamentals of Auditing
Audit Planning and Documentation
Internal Control and Internal Audit
Audit Reports and Standards on Auditing
Professional Ethics in Auditing