Advance Excel course in 10 days/2 weekends

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, 01124526399
Email id: [email protected], [email protected]
Website: www.yatchinfotech.in