Identifying Context from Cell Proximity

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic5-Identifying-Context-from-Cell-Proximity.odt” comments=”true” SVG=”true”]       You can download your data files here C06E01

Handling sub totals

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic5-handling-sub-totals.odt” comments=”true” SVG=”true”]

Unpivot 2×2 levels of Hierarchy

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic4-unpivot-2×2-levels-of-Hierarchy.odt” comments=”true” SVG=”true”]       You can download your data files here C06E05

Normalization using M language method

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic4-Normalization-using-M-language-method.odt” comments=”true” SVG=”true”]       You can download your data files here C05E02 – Bikes

Using an Index Column as a Cue

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic4-Using-an-Index-Column-as-a-Cue.odt” comments=”true” SVG=”true”]       You can download your data files here C05E04 – Products

Post-Append Preservation of Titles

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic3-Post-Append-Preservation-of-Titles.odt” comments=”true” SVG=”true”]       You can download your data files here C05E04 – Products

Unpivot other columns

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic1-unpivot-other-columns.odt” comments=”true” SVG=”true”]       You can download your data files here C06E02

Unpivot Grand totals

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic3-unpivot-Grand-totals.odt” comments=”true” SVG=”true”]       You can download your data files here C06E05

Pre-Append Preservation of Titles

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic2-Pre-Append-Preservation-of-Titles.odt” comments=”true” SVG=”true”]       You can download your data files here C05E02 – Bikes

Unpivot selected columns

[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic2-unpivot-selected-columns.odt” comments=”true” SVG=”true”]       You can download your data files here C06E03