Work with advanced formulas, lookup functions. Learn data validation; how to import/ export data. Work with PivotTables and PivotCharts. Use analytical features -Goal Seek and Analysis tool, run and record macros. Students pursuing the Microsoft Office Specialist Certification must take MS Excel I, II and II.
MS Excel-Level II or equivalent experience.