Course Duration in Hours
14
14
Advance MS Excel Course Content
COURSE DURATION: 10 DAYS/ 2 Weekends
Advanced Functions
IF Function & Nested IF Statements
And & Or Functions
Lookup Functions (Horizontal And Vertical Lookup)
Index Function
Array Function
Subtotals
Conditional Formatting
3D Ranges
Create & Maintain (Within Worksheets In a Single File & Between External Files)
Consolidate Data (via 3D Ranges & Using The Consolidate Tool)
Pivot Tables
Create Pivot Table
Work With Row/ Column Fields
Data Fields
Customise Table Display
Organising Workbooks
Create Templates
Styles
Protect Ranges & Worksheets
Data
Enter & Select Records Using The Input Form
Sort Data Into Lists
Filter Data - Autofilter, Advanced Filter
DataBase Functions
Validation Rules
Goal Seeking
What-If
Scenarios
Create Scenarios
Create Summary Report
Merge Scenarios
Protect Scenarios
Macros
Create Macros Record
Relative Referencing
Assign To Toolbars/ Keyboard
Make Available To All New Documents/ Current Document Only
Outlines
Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
Display Summary Rows And Summary Styles
Custom Views
Create, Modify, Delete
Include Hidden Rows, Columns, Filter Settings
YATCH INFOTECH
ADDRESS: RZ B1/48, RAGHU NAGAR, PANKHA ROAD,NEAR JANAK CINEMA, NEW DELHI-45
CONTACT NO:9818085925, 8750683409
Email id: admissions@yatchinfotech.in, yatchinfotech@gmail.com
Website: www.yatchinfotech.in
any class
Yatch Infotech, Janakpuri (Delhi),Delhi,IN