ADVANCE EXCEL
This course is certified by Yashwantrao Chavan Maharashtra Open University (YCMOU). 

Formulas Function
Data Customization
Data Formatting
Function (Sum, Average, Min, Max, Small, Large, Count, Concatenate, Countblank, Upper, Lower, Sumif, Countif,Round)
Lookup Function
IF lookup
H Lookup
V Lookup
Nested Lookup
Lookup
Lookup Calculation

Advance Formula
If, and, or Conditions
Financial Function
Advance date & time Function
What-If analysis tools
Goal Seek
Macros/PPMT, IPMT,

Bill Invoice Creation
Bill Making
Bill Printout in Excel
GST Bill Calculation
Preparing GST bill
Page Layout- margin setting

MIS Report
Insert List & Custom List
Sorting & Custom Sorting
Filter & Advance Filter
Pivote Table & Pivot Charts
Developer Tab
Consolidation
Course Detail
Duration:- 1 Month
Fees:-  5000/-