Advanced Excel Course - Samyak Computer Classes

Course Content

Expand All

Overview of the Basics 1 Topic

Expand

Module Content

0% Complete 0/1 Steps

Quick Basic Recap

Working with Functions 8 Topics

Expand

Module Content

0% Complete 0/8 Steps

Writing conditional expressions (using IF)

Using logical functions (AND, OR, NOT)

Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

VlookUP with Exact Match, Approximate Match

Nested VlookUP with Exact Match

VlookUP with Tables, Dynamic Ranges

Nested VlookUP with Exact Match

Using VLookUP to consolidate Data from Multiple Sheets

Data Validations 3 Topics

Expand

Module Content

0% Complete 0/3 Steps

Specifying a valid range of values for a cell

Specifying a list of valid values for a cell

Specifying custom validations based on formula for a cell

Sorting and Filtering Data 2 Topics

Expand

Module Content

0% Complete 0/2 Steps

Sorting tables, Using multiple-level sorting, Using custom sorting

Filtering data for selected view (AutoFilter), Using advanced filter options

Working with Reports 8 Topics

Expand

Module Content

0% Complete 0/8 Steps

Creating subtotals, Multiple-level subtotals

Creating Pivot tables, Formatting and customizing Pivot tables

Pivot charts

Consolidating data from multiple sheets and files using Pivot tables

Using external data sources

Using data consolidation feature to consolidate data

Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)

Viewing Subtotal under Pivot

25+ Branches Worldwide | +91 977.227.1081

25+ Branches Worldwide | +91 977.227.1081

25+ Branches Worldwide | +91 977.227.1081

Course Content

Request Call Back

25+ Branches

Why Samyak

How May We Help You Today ?