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
