- Courses & Classes
- Institutes, Tutors & Colleges
| View 2 courses from 2 providers |
Location
:- India
Provider Location
|
Active Filters : Category : Office Suites and Tools | Learn : Advanced Excel | Duration : 7 - 30 Days
Course Content: • Payslip of Employee • Format Cell • Pivot Table, Pivot Chart • Function with Condition Sumif, Countif • Vlookup Function • Data Condition • Advance Filter Condition • Conditional formatting • Extra Function a) Goal Seek b) Remove Duplicate Value c) Sorting & Filtering d) Grouping & Ungrouping e) Date Function f) Hyperlink g) Scenario ... Category: Office Suites and Tools | Kutchi I.T.I.India (Maharashtra)  Kutchi I.T.I., was established in the year 1994. In a span of 16 years it has become one of the premiere training Institute in IT Hardware, Networking... |
Course Content: S.No Contents Duration (hour) 1 Naming Ranges 1.5 1.1 Define named ranges 1.2 Use named ranges in formulas 2 VLookUp and HLookUp Functions 1.5 2.1 Using V LookUp 2.2 Using H LookUp 3 Linking Multiple Workbooks 1.5 3.1 Use formulas to link workbooks 3.2 Create a workspace 4 Importing Data 1.5 4.1 Import from external sources 4.2 Using Microsoft Query 5 Pivot Tables and Charts 3 5.1 Creating a Pivot... Category: Office Suites and Tools | Delhi Institute of Computer Education (DICS)India (Delhi)  DICS is the Longest Chain of Doeacc Accreditation Centres In Delhi. One of the fastest growing education groups in Northern India who have not comprom... |
