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!
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