ADVANCE EXCEL

[vc_row][vc_column width=”1/2″][vc_column_text]Diploma in Excel & Advanced Excel
Fees: Rs.5000 Duration: 4 Weeks
Software Covered:- Advance EXCEL TRAINING

MS-EXCEL
– Electronic Spreadsheet Concept
– Formatting Fonts, Numbers
– Date & Currency Formatting
– Formula charts & Graphs
– 2D/3D Graphs, Pie
– Formatting Charts, Data Values etc…..

(Special Internet Offer)

[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_column_text]ADVANCED EXCEL:
– Sub Total Reports, Auto Filter
– Password Protecting Worksheets
– Linking Multiple Sheets
– Linking Between Word/Excel/Ppt
– Functions:- LOOKUP, VLOOKUP, HLOOKUP,
– COUNTIF, SUMIF. What-if-analysis
– Pivot Tables, NESTED IF
– Reporting
– Character Functions
– Date Functions
– Age Calculations
– Consolidation of Data
– Data Validation
– MACROS (Intro)[/vc_column_text][/vc_column][/vc_row]