4.73
(22 Ratings)

Excel Course for Accountant

Categories: Excel

About Course

This Excel course will help the learner to get a complete overview of Excel from basic to advance. The learner will get practical assignments like payroll preparation, GST calculation, TDS calculation, Profit Calculation in Excel. This course is prepared to keep in view the practical approach and use of Excel.

DOWNLOAD ALL RESOURCES & FILES FROM HERE

Specifically, if you are from Finance, Accounts and Taxation background this course is best for you.

Below are the topics covered in the course-

Overview of Excel

  • Ribbon
  • Tabs
  • Groups
  • Formula/Function bar
  • Grids and Cells
  • Workbook
  • Sheet
  • Hyperlink in Excel
  • Hide Show Row/Column in Excel
  • Add a row/Column in Excel
  • Split text
  • Combining Text of two cells
  • Convert Excel to PDF
  • How to remove formula without changing the value
  • Shrink Text in Excel
  • Pivot Table Analysis – Basic
  • Convert number to words
  • Mail Merge and its use

Common Formulas of Excel

  • Sum
  • Sum if
  • Sumifs
  • Count
  • Concatenate
  • If
  • If error
  • Vlookup
  • Xlookup
  • Absolute Value
  • Round
  • Left, Mid, Right

Practical Assignment

Amazon Profit Calculator

  • Using if formula with multiple conditions
  • Calculation Profit per unit
  • How to Lock and Hide cells
  • Protect Excel sheets and cells
  • Use of Data Validation in Excel

Advanced Pivot Table in Excel

  • Practical Learnt to compute GST with the help of Pivot Table
  • Multiple Pivot Table in Excel
  • Classic Pivot Table
  • Design Pivot Table

Salary Calculation in Excel with Payroll Compliance

  • PF Calculation in Excel
  • ESI Calculation in Excel
  • Bonus Calculation in Excel
  • CTC Calculation in Excel
  • In-Hand Salary Calculation
  • Deduction in Salary and its complete calculation in Excel

Fully Automated GST Invoice

  • Use of Data Validation
  • How to use the If error formula
  • How to use data validation in Excel.
  • How to use spell number formula to convert numbers into words.

SAMPLE CERTIFICATE

Show More

What Will You Learn?

  • Microsoft Excel 2019
  • Key Functions and Formulas of Excel
  • Detail Salary Computation in Excel
  • Development of Amazon Profit Calculation in Excel
  • Basic to Advance Pivot Tables in Excel
  • Bulk Invoicing and Mail Merge in Excel
  • GST Calculation in Excel
  • Spell Number Formula with VBA Coding
  • Fully Automated GST invoice in Excel

Course Content

Intro & Basics of Excel

  • Intro to Excel & workbook
    05:31
  • Ribbons, Tabs & Excel
    03:05
  • Cell Name
    02:41
  • Formula Function Bar
    01:33
  • Working Area in Excel
    02:38
  • Use of Save and Save as
    03:55
  • Hyperlink in Excel
    09:26
  • Rows & Column in Excel
    11:01
  • Split Text and Combined Cell
    09:36
  • Lock & Hide Cells
    06:37
  • Print & Export
    03:59
  • Shrink Text
    04:04
  • Spell Number in Excel
    10:31
  • Mail Merge in Excel
    13:25
  • Basic Pivot Table in Excel
    13:53
  • Basic Excel Formula
    38:05

Salary Calculation in Excel

Pivot Table in Excel

Amazon Profit Calculator

Automated GST Invoice in Excel

Course Completion Certificate

Course Completion Certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

4.7
Total 22 Ratings
5
17 Ratings
4
4 Ratings
3
1 Rating
2
0 Rating
1
0 Rating
SV
4 weeks ago
LOVE THE SESSION , I THROUGHLY ENJOYED WHILE WATHCING AND DOING THE WORKING OF AMAZON AND GST INVOICES , THANKS SIR
GK
2 months ago
Basic Excel Course For Accountant
Filled with practical awsomeness.
AD
8 months ago
Excellent very easy to understand but last session of AUTOMATION OF GST INVOICE WAS NOT CLEAR AS NO ZOOM
12 months ago
Excellent Course, This Course is beneficial to me.... thanks a lot sir
SV
1 year ago
Courses is good...but excel tools which are useful for finalization of accounts and auditing are missing sir....
AS
1 year ago
The way of your teaching Skills is Excellent.
AS
2 years ago
Course is vary helpful for jobs oriented people but there is TDS calculation in excel is missing plzz add that video.
KS
2 years ago
Good Excel Course Learning Platform.
Trimmah Mehdi
2 years ago
this course is very educational and interesting
SG
2 years ago
Excellent
VH
2 years ago
This course is very good, please try once, and sir teaches very well,
PY
2 years ago
Overall it was very good
VK
2 years ago
Sir your course is best but you have to increase course content
AC
2 years ago
really awesome
Rohit
2 years ago
good
Manjeet
3 years ago
वीडियो के साथ ही practice sheets attach करने की सख्त जरूरत है।
बोलने और समझाने का तरीका बहुत सरल है
VK
3 years ago
Sir you course is good but you have to increase content for excel
NM
3 years ago
Superb Content
L
3 years ago
It's good for the beginners... ✌️
Thank you...

Want to receive push notifications for all major on-site activities?