Excel Overview & Basic calculation.
Understanding Workbook and worksheets.
DB, SYL, SYD, IPMT, PMT, NPER, PV & RATE
IF, AND, OR, IFERROR & NOT.
UPPER, LOWER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, CONCATENATE, FIND, & SEARCH.
Date & time Functions
DAY, MONTH, YEAR, EOMONTH, EDATE, NETWORKDAYS, TODAY, WEEKDAY, WEEKNUM, WORKDAY, DAYS360 & DATEDIF.
Lookup & Reference Functions
VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET, HYPERLINK, CHOOSE, COLUMN & ROW.
SUM, SUMIF, SUMIFS, ABS, CEILING, FLOOR, COMBIN, ROUND, MOD, QUOTIENT, PRODUCT, SUMPRODUCT & ABS.
COUNT, COUNTA, COUNT BLANK, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MAXA , LARGE, MIN, SMALL & MEDIAN
CELL, ISERROR, ISNONTEXT, ISNA, ISNUMBER, ISBLANK, ISODD & ISEVEN.
DSUM, DMAX, DMIN, DAVERAGE, DCOUNT, DCOUNTA & DGET
USEFUL RIBBON COMMANDS
Pivot Table, Dynamic Chart,
What if Analysis (Data table, Goal Seek, Scenario Manger).
Creating User Form Function using Macro.
Advance Filter & Sorting
Group & Ungroup,
PROFESSIONAL REPORT CREATION
Dashboard introduction & tips sample of productivity report.
Employee schedule & time report using advance restrictions.
Employees Attendance Performance report.
Sales & Stock reports.
Shrinkage report sample of sales dashboard.
ESI ACT- 1948 & PF ACT-1952
Contribution from both employee & employer
Filling (monthly & half yearly)
Filling the form
GRATUITY ACT-1972 & BONUS ACT-1965
Coverage & eligibility
Tax exemptions limits
MODULE-1-STATUTORY & LEGAL COMPLIANCE
MODULE-2-COMPENSATION AND BENEFITS
The pay structure
HRA, DA, conveyance, medical allowance, lunch allowance etc.
ESL, PF calculations
Calculation of gross, net salary & CTC
Preparation of breakup salary, designing CTC and salary breakup and discussion on compensation and benefits.
TAX PLANNING FOR SALARIED EMP
PT- slab process
TDS- (salaried people)
Slab process of TDS
Calculation of TDS for men, women, senior citizens.
Routine tax planning
Tax exemptions under deferent sections.
PF report in excel sheet
ESI report in excel sheet
Profession tax report