GLOBAL COMPUTER EDUCATION ADMISSION OPEN FOR BASIC TO ADVANCE EXCEL Discover the Most In-Demand Advanced Course of 2024 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 CONTACT NO.: 7045990990/9022990990