Excel | GST | Accounting | Tally - Beginners to Advanced Level For Students & Professional
Description
Excel | GST | Accounting | Tally - Beginners to Advanced Level For Students & Professional
Learn basic & advance accountancy rules with our complete Bookkeeping & Accounting course. Book Keeping involves the recording of financial transactions in various accounting books whereas the accounting process involves recording, interpreting, classifying, analyzing, reporting and summarizing financial data. Recording financial transactions is the first part of the foundation of the accounting process. Here we will understand the fundamentals of accounting and the entire process of accounting for various types of business organizations that includes Sole Proprietor, Partnership Firm, Not for Profit concerns, Company etc. who wants to get their accounting done.
- What will you learn?
I. All the basic fundamentals of accounting
II. Detailed process of preparing financial statement of a sole proprietor.
III. Entire Partnership Accounting
IV. Accounting For Non-Profit Organisations
V. Accounting For Incomplete Records (Single Entry System)
VI. Accounting of Negotiable Instrument - Bill of Exchange
VII. Accounting of Companies
This Accountancy Course for beginners consists of simple and logical explanatory videos on each of the mentioned topics along with some problem-solving sessions and fun quiz videos that will test your knowledge on the subject. It also includes summary on the topic along with practice questions and solutions.
- Who can take this course?
- -- Every Individual
- -- Professionals or businessman
- -- Students
- -- Any student who have an interest in finance
- -- 11th & 12th Students
- Benefits of taking this Course:
-- Explanatory videos ensure complete concept understanding.
-- Problem-solving sessions & Downloadable resources in PDF format help in applying your knowledge to solve various problems.
-- Quiz video helps in testing your knowledge.
-- MCQ along with the solution.
On completion of the course, your foundation of accounts will be stronger, also one will understand the accounting of different types of business organizations. This course will prove beneficial in learning any other higher level accounting chapter as well because the basics always remain the same.
In short, it is an interesting course fulfilling all the student's needs.
Our MS Excel course is designed under the expert knowledge of CA Santosh Apraj, with the use of the latest Office 365 and updated MS Excel software program on windows. In this course you will acquire the complete knowledge about Excel Fundamentals and all the necessary formulae and functions. We have included many tricks and shortcuts that will help you to easily use Excel and save your time while dealing with huge data and bring efficiency in your day-to-day tasks.
We have especially designed our course keeping in mind working professionals, job aspirants and students, so that this course can be beneficial to each and every-one opting for it.
Our course is specially designed with ease of explanation and putting down difficult formulae with easy explanation and how helpful it will be in your daily life. We have also included some questions & answers after each section so that you can test your knowledge and skills.
This course will teach you thoroughly on how to use and apply the important tools & shortcuts in Excel and how to apply various functions that can help save your time.
So what are you waiting for?
Enroll now and enjoy this complete course on Excel.
What you will learn from this Course?
At the end of the course you will be able to deal with a large amount of data and also will be able to apply text, number, math, lookup function, statistical functions & reference functions very easily without any hesitation. You will find it easy to manage organizing tools in Excel like charts, pivot table, etc.
Who should Enroll?
This course is designed for Individuals seeking jobs, college students, working professionals, data analysts and anyone who is willing to gain knowledge about Excel applications.
For whom is this Course designed:
· Job Aspirants
· Working Professionals
· Marketing, Finance, Sales department Professionals
· Any Graduates who want to learn Excel.
· Students who want to aspire their Career into the field of Data Science, Data mining & Data MIS.
Goods and Service Tax (GST) is an indirect tax that came into effect on 1st July 2017 which has replaced many indirect taxes in India. GST is levied on the supply of goods and services and the main advantage is that it has removed the cascading effect on the sale of goods and services.
Also, GST is mainly technologically driven. All the activities like GST registration, return filing, application for refund needs to be done online on GST portal.
So, get the basic knowledge on GST and learn about the practical aspects of GST with this course.
What will you learn?
Basic understanding of GST - Introduction, Classification (CGST, SGST, IGST) and Categorizing of GST(Input & Output)
GST online registration
Letter of Undertaking (LUT) registration
E Way Bill introduction and procedure to generate E Way bill online
GSTR 2A/2B data preparation and reconciliation
GSTR 1 data preparation and online return filing
GSTR 3B data preparation and online return filing
ITC 04: Job Work return filing
Who can take this course?
Business owners
Accounting Professionals
Graduates looking for Job
Any individual having interest in learning GST and its practical aspects
Benefits of taking up this course:
Learn basics of GST.
Get complete understanding of GST registration process and return filing steps & procedure.
Learn how to extract data from Tally for the various return filing.
Business owners can do registration and file their GST return by their own.
Explanation of how to rectify some common errors encountered while filing the GST returns will assist the accountants in their job role.
Increases the job opportunities for newly passed out graduates and also for all others with the knowledge of practical aspects of GST.
On completion of this course, you will get good understanding of theoretical as well as practical angle of GST and you will be GST ready for coming future.
So hurry up and enroll now!!!
If you have any queries, call / whatsapp us on +91 7506363600 or Mail us on Info@letstute.co.in
Lessons
- lessons
- 30 hr 17mins
Introduction to Accounting
Introduction to Accounting
Basic Accounting Terms
Accounting Principle 1
Accounting Principle 2
Accounting Principle 3
Accounting Principle 4
Accounting Principle 5
Accounting Principle 6
Accounting Conventions
Quiz Session - Accounting Principle & Conventions
Quiz Session - Accounting Principle & Conventions
Fundamentals of Double Entry Book-Keeping
Fundamentals of Double Entry Book-Keeping
Quiz Session - Classification of Accounts
Debit & Credit
Accounting Equation
Source Documents Required for Accounting
Source Document Part 1
Source Document Part 2
Journal
Journal Part 1
Journal Part 2
Quiz Session - Journal
Mistakes to Avoid in Journal Entries
Subsidiary Books
Introduction to Subsidiary Books
Types of Subsidiary books - Purchase, Sales, Purchase Return, Sales Return
Cash Book & Types
Petty Cash Book
Bank Reconciliation Statement
What is Bank Reconciliation Statement
Quiz Session - BRS
Quiz Session - BRS
Quiz Session - BRS
Trial Balance
How to Prepare Trial Balance?
Errors & Their Rectification
What are Errors & Rectification?
Quiz Session - Errors & Rectification
Depreciation , Provision & Reserves
Introduction to Depreciation
Accounting Treatment of Depreciation
Quiz Session - Depreciation
Provisions & Reserves
Adjustment in final Account
Adjustment in final Account
Bad Debts Recovery Concept
Closing Stock - Adjustment
Income & Expenses - Adjustment
Quiz Session - Adjustments Income & Expenses
Financial Statements of Proprietary Concern
Financial Statement Part 1
Financial Statement Part 2
Quiz Session - Financial Statements
Quiz Session - Financial Statements
Analysis of Financial Statements
How to read financial statements?
How to Compare Financial Statements?
How to Prepare Financial Statement?
How to Complete Financial Statement?
How to Derive Bank Summary?
Types of organisation
Types of organisation
Introduction to partnership firm & it's final Accounts
Introduction to partnership firm
Problem Solving - 1
Problem Solving - 2
Mistakes to Avoid in partnership final Accounts
Reconstitution of Partnership - Admission
Admission of Partner - Introduction
Admission Problem Solving 1
Reconstitution of Partnership - Retirement
Reconstitution of Partnership
Retirement of a partner Problem Solving 1
Retirement of a Partner Problem Solving 2
Partnership Accounting Adjustments
Partnership Accounting Adjustments
Quiz Session - Profit Sharing Ratio
Valuation of Goodwill
Accounting Treatment of Goodwill
Quiz Session - Accounting Treatment of Goodwill
Dissolution of Partnership
Dissolution of partnership Firm
Not For Profit Concern Problem Solving 1
Accounts for 'Not For Profit' Concern
Accounting for Not for Profit Concern
Not For Profit Concern Problem Solving 1
Bills of Exchange
Bills of Exchange
Bills of Exchange Accounting Entries 2
Bills of Exchange - Tips & Tricks
Bills of Exchange - Accounting Entries 1
Single Entry System
Single Entry System - Introduction
Single Entry System - Conversion Method
Undervaluation & Overvaluation Concept
Single Entry System Problem Solving 1
Company Accounting
Introduction to Joint Stock Company
Sources of Funds
Issue of Shares Part 1
Issue of Shares Part 2
Issue of Shares Problem Solving 1
Issue of Shares Problem Solving 2
Issue of Shares Problem Solving 3
Forfeiture and Reissue
Forfeiture and Reissue - Problem Solving 1
Introduction to Debentures
Debenture Accounting Entries
Debenture Problem Solving
Redemption of Debentures
Redemption of Debentures Problem Solving
Issue of Shares & Debentures Consideration other than cash problem solving
What is GST?
Classification of GST
Accountancy Tips & tricks
Accounts Paper Presentation Tips
How to Manage Time During Exams
How To Study Accounts
Introduction to MS Excel
1. Launching Excel: Startup Screen and User Interface, Different versions of Excel
2. Microsoft Excel Startup Screen
3. Introduction to Excel Interface, basic shortcuts, etc
4. Customising the quick access toolbar
5. More information of the Excel interface
6. Understanding the structure of Excel
7. Saving an excel document
8. Opening an Existing Excel file
9. Common Shortcut keys use in Excel
10. Excel worksheet with Ctrl Shortcuts
11. How to save time with Function Shortcuts
12. Accessing Tools with Alt Keys
Entering Data and Editing Formulas
13. Entering Text to Create Spreadsheet Titles
14. Working with Numeric Data in Excel
15. Creating Drop-Down Menus with Data Validation
16. Entering Date Value in Excel
17. Working with Cell Reference
18.Creating Basic Formulas in Excel
19. Relative vs Absolute Cell References in Formulas
20.Understanding the Order of Operations
21.Writing Efficient formula with Fixed or Relative References
Modifying an Excel Worksheet
22. Moving and Copying Data in an Excel Worksheet
23. Inserting and Deleting Rows and Columns
24. Changing the Width and Height of Cells
25. Hiding and Unhiding Excel Rows and Columns
26. Renaming and Deleting an Excel Worksheet
27. Moving and Copying an Excel Worksheet
Printing an Excel Worksheet
28. Viewing your Document in Print Preview
29. Changing the Margins, Scaling and Orientation
30. Working with Page Layout View
31. Adding Header and Footer Content
32. Printing a Specific Range of Cells
Formula and References in Excel
33. How to enter text and edit formulas
34. Common Types of Errors in Excel formulas
35. Absolute Reference
36. Relative Reference
37. Mixed Reference
38. Use of Functions
How to Insert Shapes and Images into Excel Worksheet
39. Inserting Images
40. Inserting Excel Shapes
41. Formatting Excel Shapes
42. Working with Excel Smart Art
Creating Charts & Graphs in Excel
43. Visually representing Data
44. Creating Excel Column Chart
45. Working with Excel Chart Ribbon
46. Formatting Charts
47. Scatter Charts
48. Combo Charts
49. Pivot Chart
50. Pie Charts: How to use and Application
51. Adding and Modifying a Data on Excel Chart
Working with Basic Excel Functions
52. Structure of Excel Function
53. Working with SUM()
54. Working with MIN() MAX() Functions
55. Working with AVG()
56. Working with COUNT()
57. Cell Errors in Excel Calculations
58. How to use Autosum Command & Shortcut key
59. Using Autofill Command to copy Formulas
Excel Functions for Professionals
60. Introduction to Advance Functions in Excel
61. Payment Functions & Loans
62. Future Value Function & Pensions
63. VLOOKUP Function & GradeBooks
64. IF, Concatenate, & Evaluation
65. Conditional Formatting
66. IFERROR Function & Dynamic Amortization Tables
67. Calculating A Grade Example
68. How to Collect Data by Google Forms?
Statistical Functions Commonly used in Excel
69. Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
70. Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
71. Randomization with RAND() & RANDBETWEEN
72. Row-Level Calculation with SUMPRODUCT
73. How to Calculate Shipping Cost with SUMPRODUCT?
74. Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
75. Building a Basic Dashboard with COUNTIFS & SUMIFS
76. Counting Duplicates with COUNTIF & SUMPRODUCT
77. Data Profiling with COUNT & SUMPRODUCT
GST Introduction and Registration
GST - Online Registration
Letter of Undertaking (LUT)
E Way Bill - Introduction
E Way Bill - Preparing on Eway Bill Portal
GSTR 2A/2B - Introduction & Data Preparation
GSTR 2A/2B - Reconciliation
GSTR 1 - Introduction
GSTR 1 - Data Preparation
GSTR 1 - Filing on GST Portal
GSTR 3B - Data Preparation
GSTR 3B - Filing on GST Portal
ITC 04 - Introduction
ITC 04 - Filing on GST Portal