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
"eLearning support, Live Sessions available across Mumbai and Navi Mumbai"
Contact Us
Our Office Address
CHEMBUR
14, Neelkanth Commercial Complex,N G Acharya Marg, Chembur East 400071

GOVANDI
5, Arjun Centre, Opp. Patwardhan Colony, Govandi Station Road East 400088

CHEMBUR NAKA
1-A,First Floor, Above CCD, Swami Vivekanand Road,Sindhi Society 400071

NERUL
105, First Floor, Chandrai Arcade, Sect-20, Opp. Nerul Railway Station, Nerul West 
General Enquiries
md@anubhavcomputer.com
Call Us
Chembur: 9167243835
Govandi: 9167243836
Chembur Naka: 9167243833
Nerul: 9167243838
Our Timing
Mon - Sun : 10:00 AM - 07:00 PM
Submit