Customs:
OBJECTIVE:
Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools
Advanced Excel
Lookup & Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Management:- Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart, Graph & Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Filter, Validation & Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.
Lesson: Introducing SAP HANA and SAP S/4HANA
Lesson: Introducing SAP Fiori
Lesson: Managing Organizational Units in Financial Accounting (FI)
Exercise 1: Create a Company Code
Exercise 2: Create a Company ID for Your Company Code and assign it to Your Company Code
Exercise 3: Check the Assignment of a Company Code to a controlling Area
Lesson: Checking the Basic Settings in General Ledger (G/L) accounting
Exercise 4: Check the Basic Settings in G/L Accounting
Lesson: Outlining the Variant Principle
Lesson: Managing Fiscal Year Variants
Exercise 5: Create and Maintain Fiscal Year Variants
Lesson: Identifying the Basic Functionality of Currency Keys andexchange Rate Types
Lesson: Managing Currency Types
Lesson: Maintaining General Ledger (G/L) Accounts
Exercise 6: Create Account Groups for G/L Accounts
Lesson: Creating Profit Centers and Segments
Exercise 7: Create Profit Centers, Cost Centers, and Segments
Lesson: Managing Business Partners
Exercise 8: Create Account Groups and Maintain Customer or vendor Accounts
Exercise 9: Maintain Field-Status Configuration
Exercise 10: Define Sensitive Fields
Lesson: Configuring the Header and Line Items of Financial Accounting (FI) Documents
Exercise 11: Create a Number Range and Document Type
Exercise 12: Classify the Document Type for Document Splitting
Exercise 13: Create a Field Status Group and Assign It to a G/L Account
Lesson: Managing Posting Periods
Exercise 14: Create and Maintain Posting Period Variants
Lesson: Managing Posting Authorizations
Exercise 15: Create a Tolerance Group and Assign It to a User
Lesson: Creating Simple Documents in FI
Exercise 16: Post FI Documents
Lesson: Analyzing Document Splitting
Exercise 17: Post a Document with Document Splitting
Lesson: Maintaining Default Values
Exercise 18:Maintain Default Values
Lesson: Configuring Change Control
Exercise 19: Maintain the Change Control for a Field
Lesson: Configuring Document Reversal
Exercise 20: Post a Document Reversal
Lesson: Configuring Payment Terms and Cash Discounts
Exercise 21: Maintain Terms of Payment
Lesson: Maintaining Taxes and Tax Codes
Exercise 22: Create a Tax Code and Post a Customer Invoice
Lesson: Posting Cross-Company Code Transactions
Exercise 23: Configure Cross-Company Code Transactions
Exercise 24: Post and Display Cross-Company Code Transactions
Lesson: Performing Open Item Clearing
Exercise 25: Clear an Account
Exercise 26: Post with Clearing
Lesson: Managing Payment Differences
Exercise 27: Manage Payment Differences
Lesson:Managing Exchange Rate Differences
Lesson: Executing an Automatic Payment Run
Lesson: Using Bank Accounts
Exercise 28: Define a House Bank
Lesson: Modifying Master Records and Financial Accounting documents
Exercise 29: Modify Vendor Master Records
Exercise 30: Enter Invoices for Payments
Lesson: Managing the Application View for Special General Ledger Transactions
Exercise 31: Enter a Guarantee Made
Exercise 32: Post a Down Payment Request, a Received Down Payment, and a Customer Invoice, and Perform Clearing
Exercise 33: Post a Customer Invoice and Enter an Individual value Adjustment
Lesson: Maintaining Special General Ledger Transactions
Exercise 34: Configure Special G/L Transactions
Lesson: Understanding Purchasing (MM Integration)
Exercise 35: Perform an Integrated Down Payment Process
Lesson: Understanding Sales and Distribution Integration
Lesson: Managing Document Parking Basics and Document Holding
Exercise 36: Hold and Park Documents
Lesson: Processing Parked Documents
Exercise 37: Process Parked Documents
Lesson: Managing Document Parking and Workflow
Exercise 38: Enter a Financial Document Using Parking and Workflow
Lesson: Creating Balance Confirmations
Exercise 39: Create a Balance Confirmation
Lesson: Managing the Foreign Currency Valuation
Exercise 40: Manage the Foreign Currency Valuation of Open Items
Lesson: Managing Value Adjustments
Exercise 41: Execute a Flat-Rate Individual Value Adjustment
Lesson: Regrouping Receivables and Payables
Exercise 42: Regroup Receivables According to Their Remaining Life
Lesson: Posting Accruals and Deferrals
Exercise 43: Post Accruals
Unit 6: Technical, Organizational, and Documentary Closing Activities
Lesson: Managing Technical Steps During the Period-End Closing Activties
Lesson: Executing the Balance Audit Trail
Exercise 44: Execute the Balance Audit Reports
Lesson: Explaining the Purpose of Document Splitting in General Ledger Accounting
Lesson: Posting Ledger Group-Specific FI Documents
Exercise 45: Post to a Ledger Group
Lesson: Managing Financial Statements
Exercise 46: Create Financial Statements
Lesson: Executing Drilldown Reports
Exercise 47: Execute Drilldown Reports
Unit 3: Fixed and Current Assets
Lesson: Executing Closing Activities Within Asset Accounting
Exercise 48: Execute and Analyze the Depreciation Run
Lesson: Managing Closing Activities in Materials Management
Exercise 49: Execute Closing Activities in Materials Management
Lesson: Assigning a Chart of Accounts and a Chart of Depreciation to a Company Code
Exercise 50: Assign a Chart of Depreciation to a Company Code
Lesson: Assigning Management Accounting Objects to Fixed Assets
Lesson: Defining How Depreciation Areas Post to the General Ledger
Exercise 51: Define Depreciation Areas and the Update of the General Ledger
Lesson: Understanding the Importance of Asset Classes in Fixed Assets
Lesson: Explaining the Components of an Asset Class
Exercise 52: Use Number Assignment for FI-AA
Exercise 53: Use Account Determination
Exercise 54: Maintain the Screen Layout of Asset Master Data
Exercise 55: Maintain the Screen Layout of Asset Depreciation Areas
Exercise 56: Copy Asset Classes from Reference
Exercise 57: Display Asset Class 4000
Exercise 58: Manage Asset Classes for Low-Value Assignments
Lesson: Creating and Changing Master Data in Asset Accounting
Exercise 59: Create Asset Master Records
Exercise 60: Maintain Time-Dependent Data
Lesson: Carrying Out Mass Changes to Asset Master Data Using a Worklist
Exercise 61: Define the User Fields and Mass Changes of Asset Master Records
Lesson: Processing Acquisitions
Exercise 62: Post an Integrated Asset Acquisition and Analyze the Asset Value in the Asset Explorer
Lesson: Posting Non-Integrated Asset Acquisitions and understanding the Integration with Materials Management (MM)
Exercise 63: Make Various Non-Integrated Asset Acquisition Postings
Exercise 64: Make Postings Integrated with Materials Management
Lesson: Posting Integrated and Non-Integrated Asset Retirements
Exercise 65: Post Integrated Asset Retirements with Accounts Receivable (AR)
Lesson: Performing Transfers Within Company Code and Intercompany Asset Transfers
Exercise 66: Transfer Assets Within Company Code
Exercise 67: Post Intercompany Asset Transfer (Across Company Boundaries)
Exercise 68: Post Intercompany Asset Transactions (Within One company)
Lesson: Representing, Distributing, and Settling Assets Under Construction
Exercise 69: Create and Post to an Asset Under Construction (AUC) and Settle It to Completed Assets
Lesson: Entering and Analyzing Unplanned Depreciation
Exercise 70: Post Unplanned Depreciation
Lesson: Defining Depreciation Areas, Keys, Calculation, and Posting
Exercise 71: Analyze Depreciation Areas
Exercise 72: Understand and Maintain Depreciation Keys
Exercise 73: Maintain Time-Dependent Depreciation parameters
Exercise 74: Analyze Cost-Accounting Depreciation Area
Exercise 75: Execute and Analyze the Depreciation Run
Lesson: Executing Programs for Fiscal Year Change and Year-End Closing in Asset Accounting
Exercise 76: Execute Year-End Closing in Asset Accounting
Lesson: Using the Accounts Approach for Parallel Accounting in Asset Accounting
Exercise 77: Manage Parallel Accounting in FI-AA
Exercise 78: Manage Unilateral Asset Postings
Advanced Excel
Lookup & Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Management:- Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart, Graph & Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Filter, Validation & Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.
Advanced Dashboard & VBA / Macros Programming Objective
Introduction to Programming Introduction to logical thinking flowcharts & algorithms:
Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…etc.)
Excel VBA Power Programming For VBA Macros
Overview of Using User forms To Create Business Wizards
Connection between Excel VBA & other platforms
Testing and Debugging Your Code
Effective Error Handling
Automation Development Reports & Live Projects
Financial Modeling
Equity Research
Discounted Cash Flows
Relative Valuations
Report writing
GST is a consumption depends on tax applied to on sale, manufacture, and usage on goods & services on a nationwide level. This tax will be substituted for all indirect tax levied by state as well as central government. Exports and direct tax such as income tax, business tax, and capital gain tax will not be influenced by GST. GST would be appropriate for all products other than crude petroleum, aviation turbine fuel, motor spirit, diesel, and natural gas. It would be relevant to all services, excepting a few to be particular. With the boost of worldwide trade in services, GST has turned a global standard.
These days, e-commerce industry is paying lots of taxes, which include VAT, CST, Service Tax, Excise, and TDS, with numerous taxes applicable on any known deal. The complexities of logistics and reverse logistics, advertising and endorsement services, music, software, products, and eBooks turns it difficult to differentiate between goods as well as services in each transaction. It is important for the sellers to be complied with registration requirements and announce their turnover to tax departments of several states.
Yes, SLA offers short Term course or Weekends course For GST. We are one of the highly popular training center. We are known as the Best E-Accounts, E-Taxation Training Institute who proficiency in offering business accountancy and taxation job leaning professional accountancy training to the starters to experienced in a quite short term of time. Professional 3-4 Chartered Accountant will offer sensible training on weekdays/weekends.
With e-accounting, SLA can create accounts of more than one business from any place of the globe. With e-accounting, we can share accounting details with others from any position of the world. With e-accounting, we can perform live work of accounting. It implies one accounting, project can be absolute more than one individual from different places.
With e-accounting, SLA can create accounts of more than one business from any place of the globe. With e-accounting, we can share accounting details with others from any position of the world. With e-accounting, we can perform live work of accounting. It implies one accounting, project can be absolute more than one individual from different places.
Yes, you can start own tax consulting. The first and leading thing that you should do if you will set up a tax consulting firm is to study the taxation and tax consulting process. There are several institutions providing taxation’s degree and Master’s degree programs, not just for the tax consulting, managing but also for the growth of the taxation systems in the varied government and private agencies. The plan generally aims for a student to have a methodical understanding of the tax system and tax law among others.
It has been a good experience for me to take a professional training from SLA. I have taken the GST classes. If I talk about it’s placement, it is also good. The package depends on your academic performance and your interview.
I Joined SLA Consultants India for learning GST & ITR training and my experience was very good with the institute and also they helped me to get better placement and now I am working as Accounts Executive.
SLA Consultants India is the one of the best place of knowledge and obtain training. I’ve completed my tally, TDS & GST Classes from the best teachers available with the institution.
All trainers and staff are too good especially want to say thanks to placement team, who always Co-operates with me.
Well, I take the practical training in Accounts, & GST is going. Guys, if you want to learn and enhance your skills, so it is a good institute for build or making your resume well versed in the global market.
I joined MIS/VBA training at SLA Consultants India. This type of practical oriented classroom training is very helpful for everybody and who will follows classes given by expert trainers with practical orientation approach regularly. Finally in my words “SLA Consultants India” is the best for learning professional or job oriented classroom programs.
There are a lot of fake training institutes in Delhi but SLA Consultants is not one of them. SLA Consultants India is a reliable institute that has a great team and awesome trainers who helped me settle in life by allowing me to work for the reputed Taj Group.
SLA Consultants has excellent trainers who are not just concentrated on finishing a class. They really helped me learn new things and were patient when I made mistakes. Thanks to the trainers I have got a job I love and I am good at it too.
SLA Consultants is a boon to all the freshers who are not getting any good jobs. They trained me as an Accounts Executive by using interesting and innovative teaching methodologies. They also helped me get a job when I was in the last leg of the course which was really a pleasant surprise for me.
The team of trainers working with SLA is amazing. The support staff is always there to help and Arbind Sir was a great guide. I will never forget my time at SLA and I thank them for the job they helped me get after I completed my course.
I want to tell you all that SLA Consultants had made my life. I was just a graduate with not so good marks when I came to them. They trained me, helped me learn and now I am a successful Accounts Executive. I hope you enjoy the Accounting Course as much as I did.
SLA Consultants is a name every new student or eager professional should trust. They helped me make a career switch and helped me land a job while I was about to complete the course. Their placement team is really efficient.
After I completed my schooling, I had no idea about what should I do. Then a friend told me about SLA and that was that. They helped me become a number wizard and taught me everything about Accounting which helped me get a good job at a place near my house and has made my life.
My career path seemed to be stuck at the same place for months. So when I approached SLA Consultants. They trained me so well in Accounts that I got a senior position I always wished for and the bonus is that I love my job because I am so good at it.
I did not have any idea what I will do in life. SLA Consultants gave direction to my life by recognizing my skills with numbers and training me as an Accounts Executive. I have a stable job now thanks to teaming SLA and I am getting better at my job every day due to the amazing training they provided me.
None of my batch mates had a good job and I was worried sick over my career. SLA Consultants came as a ray of hope for me. They honed my accounting knowledge and helped me get a good job. I was the first among my batch mates to get a job and I am very happy with SLA team.
SLA Consultants is a great place for young students who want a job without spending a lot of money. I have learnt a lot there and they helped me get a stable job in a company of my choice. I will forever be thankful to them for guiding me towards a great career path and helping me make a good life for myself.