Advanced Excel.jpg

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