Join our Aptech Certified Advanced Excel course.

 

Eligibility: any stream 12th students having 50% marks.

 

Advanced Excel Syllabus:

 

• Work sheet protection, allow user to edit a range

• Templates

• Excel options

• Tab,Ribbon

• Tables

• View options

• Workbook protection and sharing on LAN

• Create table and table styles

• Filtering and sorting

• Page layout

• Flash fill, auto fill, auto complete

• Using formula and functions: (mathematical, financial, lookup, text, statistical,logical,date,time)

• Conditional statements (if,and,or)

• Formula auditing

• What if analysis, using subtotal

• Conditional formatting

• Data Validation

• Pivot table and slicer

• Charts and pivot chart

• Shapes & Smart art

• Power pivot

• Power view using Microsoft silver light

• Simple macro design with buttons

• Scenario manager

• XML synchronization with Excel

​