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

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

Below are the topics covered in 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

• Covert 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 it’s 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 sheet and cells

• Use of Data Validation in Excel

Advance 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 Iferror formula

• How to use data validation in Excel.

• How to use spell number formula to convert number in words.