Course Content
Modules
Status
2
Working with Functions
-
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
- 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
5
Working with Reports
-
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
- 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
9