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




Read more

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

Reviews

0
Based on 0 reviews
5 stars
4 stars
3 stars
2 stars
1 stars