Data Table - Example 1 | AmazingExcel

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Advanced Level Course

Part 1

Applying SUMIF (2:21)
Applying SUMIFS (7:01)
COUNTIF and Excel Table (5:00)
COUNTIF - How to count if a value is less than certain number (2:50)
Amazing Excel Advanced Function - COUNTIF with Wild Card (5:08)
Conditional Formatting - Format according to your business requirement or certain Text value (3:09)
Advanced Conditional Formatting - Example 1 (3:11)
Advanced Conditional Formatting - Highlight Positive Change (4:27)
Interesting Case Study - Find duplicate value in another sheet (3:15)
Case Study - identify Product code if Last letter is G (3:51)
Case Study - Identify which membership expired using Conditional Formatting (4:38)

Part 2

Creating Your First Pivot Table (4:13)
Pivot Table - Create Multiple Column (Sales Total and Num of Trans) (5:58)
Create Pivot Chart (3:35)
Create Calculated Field (3:11)
Discovering the power of Grouping feature in Pivot Table (7:51)
Show Value As - % Different From and Difference From (4:41)
Show Value As - Column Total vs Row Total (2:23)
Show Value As % of Row Total and % of Column Total (3:36)
Show Value As - Percent of Column Total and Percent of Parent Row Total
Show Value As - Running Total (2:47)
Calculated Field Variance with arrow Up Down (5:24)
Pivot Table - Custom List - Create a list according to your own order Save Time (7:25)

Part 3

Excel Advanced Function - INDEX (4:09)
Advanced Function - leverage the strength of MATCH and INDEX (2:42)
INDEX and MATCH - Part 2 (8:36)
How to find the lowest supplier price Part 1 (3:42)
How to find the lowest supplier price Part 2 (5:05)
Excel Advanced Function - Variance Analysis using OFFSET and MATCH (4:09)
Date Related Excel Function (1:35)
Date Related Function - NETWORKDAY (3:35)
Nested IF (2:49)
Nested IF - Part 2 (2:50)
Excel Macro/VBA - Recording Your first Macro (5:56)
How to Save Your Workbook with Macro code (5:41)
Case Study - Generate Salary Slip, Invoice faster than you think using Macro (7:27)
Case Study - Generate Salary Slip, Invoice faster than you think using Macro Part 2 (6:55)
Search a Color in a list using SEARCH ISNUMBER XLookup (5:12)

Part 4

Data Table - Example 1 (4:30)
Data Table - Example 2 (6:30)
Data Table - Two Input Variables (6:42)
Goal Seek (4:15)
Using Wild Card in filtering data (4:54)
Named Range (6:39)
Case Study - Find out Gender based on Identification Number IC using Excel RIGHT function (4:13)

Teach online with

Data Table - Example 1

Download

03_Data_Table.xlsx

Complete and Continue