Complete Accounting & Excel Course For Professionals and Students - Combo

Description

Complete Accounting & Excel Course For Professionals and Students - Combo 


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.


Accounting

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.

So hurry up and enroll now!

If You Have Any Queries you can Call / Whatsapp Us on  +917506363600 Or Mail us on Info@letstute.co.in


Read more

Lessons

  • lessons
  • 25 hr 10mins
  • Introduction to accounting - Quiz
  • Basic Terminologies
  • Introduction to Accounting Study Material
  • Accounting Principal 1 Quiz
  • Accounting Principles 2
  • Accounting Principal 2 Quiz
  • Accounting Principles 3
  • Accounting principal 3 Quiz
  • Accounting Principles 4
  • Accounting Principal 4 Quiz
  • Accounting Principles 5
  • Accounting Principal 5 Quiz
  • Accounting Principles 6
  • Accounting Principal 6 Quiz
  • Accounting Convention
  • Quiz Session - Principles & Accounting
  • Quiz Session - Principles & Accounting
  • Accounting Principal & convention - Study Material
  • Introduction to Accounting
  • Basic Accounting Terminologies
  • Accounting principle 1
  • Classification of Accounts
  • Classification of Accounts Quiz
  • Quiz Session- Classification of Accounts
  • Classification of Accounts - Study Material
  • Debit & Credit
  • Debit Credit - Study Material
  • Accounting Equation
  • Accounting Equation - Study Material
  • What is Accounting Cycle?
  • Accounting Cycle Quiz
  • Source Documents Part 1
  • Source Docs Quiz
  • Source Documents Part 2
  • Source Doc 2 Quiz
  • Source Document
  • Source Documents - Study Material
  • Journal Part 1
  • Introduction to Journal Quiz
  • Journal Part 2
  • Journal 2 Quiz
  • Quiz Session - Journal Entries
  • Mistakes to Avoid in journal entries
  • Journal - Study Material
  • Introduction to subsidiary Book
  • Subsidiary Books Quiz
  • Cash Book
  • Cash Book Quiz
  • Petty Cash Book
  • Petty Cash Book Quiz
  • Subsidiary Books - Study Material
  • How to post in Ledger From Journal
  • Ledger Quiz
  • Ledger - Study Material
  • Bank Reconciliation Statement
  • BRS Quiz
  • Quiz Session 1 - BRS
  • Quiz Session 2 - BRS
  • Quiz Session 3 - BRS
  • Bank Reconciliation statement - Study Material
  • Trial Balance
  • Trial Balance Quiz
  • Trail Balance - Study Material
  • Errors and Their Rectification
  • Error & Rectification Quiz
  • Quiz Session - Error and Rectification
  • Rectification of Errors - Study Material
  • Introduction to Depreciation
  • Depreciation Quiz
  • Accounting Treatment of Depreciation
  • Quiz Session - Depreciation
  • Depreciation - Study Material
  • Provisions & Reserves
  • Provision & Reserves Quiz
  • Provision & Reserves - Study Material
  • Adjustment - Closing Stock
  • Closing Stock Quiz
  • Closing Stock - Study Material
  • Adjustment - Bad Debts
  • Bad Debts Quiz
  • Bad Debts - Study Material
  • Adjustments in Accounting - Prepaid/Outstanding
  • Quiz Session - Adjustment in Accounting
  • Financial Statement Part 1
  • Financial statement Quiz
  • Financial Statement Part 2
  • Quiz Session 1 - Financial statement
  • Quiz Session 2 - Financial Statement
  • Financial Statement - Study Material
  • Revise Whole Accounting Cycle
  • Reading Financial Statements
  • Scanning Financial Statements
  • Completing Financial Statement
  • Deirving Missing financial statement
  • Deriving Bank Summary From Financial Statements
  • Types of Business organizations
  • Introduction to partnership
  • Introduction to Partnership Quiz
  • Introduction to partnership - Study Material
  • Partnership Problem Solving 1
  • Partnership problem Solving 2
  • Mistakes to Avoid in partnership final Accounts
  • Admission of Partner - Introduction
  • Admission of Partner Quiz
  • Admission Problem Solving 1
  • Admission Problem Solving 2
  • Admission of a Partner - Study Material
  • Retirement of partner - Introduction
  • Retirement of Partner Quiz
  • Retirement of a partner Problem Solving 1
  • Retirement of a Partner Problem Solving 2
  • Retirement of a Partner - Study Material
  • Profit sharing Ratio
  • Profit Sharing Ratio Quiz
  • Profit sharing Ratio - Study Material
  • Quiz Session - Profit Sharing Ratio
  • Valuation of Goodwill
  • Valuation of Goodwill Quiz
  • Quiz Session - Valuation of Goodwill
  • Valuation of Goodwill - Study Material
  • Accounting Treatment of Goodwill
  • Accounting of Goodwill Quiz
  • Quiz Session - Goodwill treatment
  • Accounting Treatment for Goodwill - Study Material
  • Death of Partner Problem Solving 1
  • Death of a Partner Problem Solving 2
  • Dissolution of partnership Firm
  • Dissolution of Partnership Quiz
  • Dissolution of Partnership Problem Solving 1
  • Dissolution of Partnership Problem Solving 2
  • Dissolution of Partnership Problem Solving 3
  • Dissolution of Partnership Problem Solving 4
  • Accounting for Not for Profit Concern
  • Non Profit organization Quiz
  • Not For Profit Concern Problem Solving 1
  • Non Profit Organisations - Study Material
  • Introduction to Bills of Exchange
  • Bills of Exchange Quiz
  • Quiz Session - Bills of Exchange
  • Accounting Entries Part 1
  • Accounting Entries part 2
  • Types of Expenditures
  • Not for Profit Concern Problem Solving 2
  • Not for Profit Concern Problem Solving 3
  • NPO - Tips & Tricks
  • Single Entry System - Introduction
  • Single Entry System Problem Solving 1
  • Single Entry System Problem Solving 2
  • Single entry system - Study Material
  • Single Entry System - Conversion Method
  • Undervaluation & Overvaluation Concept
  • Single Entry System Problem Solving 3
  • Company Account Introduction
  • Sources of Funds
  • Issue of Shares - Introduction
  • Issue of Shares Part 2
  • Issue of shares Problem Solving 1
  • Issue of Shares Problem Solving 2
  • Issue of Shares Problem Solving 3
  • Forfeture Re-Issue
  • Introduction to Debenture
  • Accounting Entries of Debenture
  • Issue of Debentures problem solving
  • Redemption of Debenture
  • Redemption of Debentures Problem Solving
  • Issue of shares Debentures for Consideration other than cash Problem solving 1
  • Forfeiture & Reissue - Problem Solving 1
  • Forfeiture & Reissue - Problem Solving 2
  • Forfeiture & Reissue - Problem Solving 3
  • Issue of shares Debentures for Consideration other than cash Problem solving 2
  • What Is GST
  • Classification of GST
  • Accounting Paper presentation tips for student
  • How to manage Time during Exams tips
  • Mistakes you should never make in Accountancy Board Exam
  • How to study Accounts
  • Bookkeeping and Accounting - Level 1
  • Bookkeeping and Accounting - Level 2
  • Accounting Test Paper
  • Accounting Test - 1 Solution
  • Accounting Test - 2
  • Accounting Test Paper 2 - Solution
  • Accounting Test Paper 3
  • Accounting Test Paper 3 - Solution
  • Accounting Test Paper 4
  • Launching Excel: Startup Screen and User Interface, Different versions of Excel
  • Microsoft Excel Startup Screen
  • Introduction to Excel Interface, basic shortcuts, etc
  • Customising the quick access toolbar
  • More information of the Excel interface
  • Understanding the Structure of Excel workbook
  • Saving an excel document
  • Opening an Existing Excel file
  • Common Shortcut keys use in Excel
  • Excel worksheet with Ctrl Shortcuts
  • How to save time with Function Shortcuts
  • How to save time with Function Shortcuts
  • Accessing Tools with Alt Keys
  • Accessing Tools with Alt Keys
  • Entering Text to Create Spreadsheet Titles
  • Working with Numeric Data in Excel
  • Creating Drop-Down Menus with Data Validation
  • Entering Date Value in Excel
  • Working with Cell Reference
  • Creating Basic Formulas in Excel
  • Relative vs Absolute Cell References in Formulas
  • Understanding the Order of Operations
  • Writing Efficient formula with Fixed or Relative References
  • Moving and Copying Data in an Excel Worksheet
  • Inserting and Deleting Rows and Columns
  • Changing the Width and Height of Cells
  • Hiding and Unhiding Excel Rows and Columns
  • Renaming and Deleting an Excel Worksheet
  • Moving and Copying an Excel Worksheet
  • Viewing your Document in Print Preview
  • Changing the Margins, Scaling and Orientation
  • Working with Page Layout View
  • Adding Header and Footer Content
  • Printing a Specific Range of Cells
  • How to enter text and edit formulas
  • Common Types of Errors in Excel formulas
  • Absolute Reference
  • Relative Reference
  • Mixed Reference
  • Use of Functions
  • Inserting Images
  • Inserting Excel Shapes
  • Formatting Excel Shapes
  • Working with Excel Smart Art
  • Visually representing Data
  • Creating Excel Column Chart
  • Working with Excel Chart Ribbon
  • Formatting Charts
  • Scatter Charts
  • Combo Charts
  • Pivot Charts
  • Pie Charts: How to use and Application
  • Adding and Modifying a Data on Excel Chart
  • Structure of Excel Function
  • Working with SUM()
  • Working with MIN() MAX() Functions
  • Working with AVG()
  • Working with COUNT()
  • Cell Errors in Excel Calculations
  • How to use Autosum Command & Shortcut key
  • Using Autofill Command to copy Formulas
  • Introduction to Advance Functions in Excel
  • Payment Functions & Loans
  • Future Value Function & Pensions
  • VLOOKUP Function & GradeBooks
  • IF, Concatenate, & Evaluation
  • Conditional Formatting
  • IFERROR Function & Dynamic Amortization Tables
  • Calculating A Grade Example
  • How to Collect Data by Google Forms?
  • Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
  • Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
  • Randomization with RAND() & RANDBETWEEN
  • Row-Level Calculation with SUMPRODUCT
  • How to Calculate Shipping Cost with SUMPRODUCT?
  • Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
  • Building a Basic Dashboard with COUNTIFS & SUMIFS
  • Counting Duplicates with COUNTIF & SUMPRODUCT
  • Data Profiling with COUNT & SUMPRODUCT
  • Introduction to Tally: Uses, Advantages & automation, etc.
  • How to download and Install Tally
  • Company Creation in Tally
  • Understanding Gateway of Tally Screen
  • Create/Alter and Display Ledgers in Tally
  • Posting Opening balances in Tally.ERP 9
  • Create Stock Item and Stock Group in Tally
  • Recording Sales and Purchase Transaction with Stock
  • Recording Receipt and Payment Transaction
  • Recording Contra Entries and Journal Entries
  • Entering Opening Business Stock in Tally.ERP9 and Other Stock Reports Analysis
  • Overview of GST and how to create GST Ledgers
  • Recording Sales and Purchase Transaction with GST
  • Concept of Change in Tax Rate
  • Concept of E-Way Bill and its effects
  • Create and Maintain Price List in Tally
  • Shortcut Keys in Tally
  • What is Tally Prime and how it is Different from Tally ERP 9
  • Create/Alter and Display Groups in Tally
  • GST Reports - GSTR - 1,2,3B
  • Bank Reconciliation
  • Basic Understanding of Payroll in Tally
  • Manual and Auto Back, Manual and auto restore

Reviews

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