Custom Column Technique to Preserve Context
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic1-Custom-Column-Technique-to-Preserve-Context.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Normalization Approach
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic3-Normalization-Approach.odt” comments=”true” SVG=”true”] You can download your data files here C04E04 – Conversion Table
Combining tables with mismatched columns with a large number of columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic2-Combining-tables-with-mismatched-columns-with-a-large-number-of-columns.odt” comments=”true” SVG=”true”]
Combining tables with mismatched columns manual approach
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic1-Combining-tables-with-mismatched-columns-manual-approach.odt” comments=”true” SVG=”true”] You can download your data files here C04E04 – Products
Appending worksheets from a workbook
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic4-Appending-worksheets-from-a-workbook..odt” comments=”true” SVG=”true”] You can download your data files here C03E01 – Accessories C03E01 – Bikes
Append forth table using the formula bar
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic3-Append-forth-table-using-the-formula-bar..odt” comments=”true” SVG=”true”] You can download your data files here C03E01 – Clothing
Appending three or more tables
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic2-Appending-three-or-more-tables.odt” comments=”true” SVG=”true”] You can download your data files here C03E04 – Year per Worksheet
Append two tables into a single table
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses3_topic1-Append-two-tables-into-a-single-table.odt” comments=”true” SVG=”true”] You can download your data files from here C03E01 – Components C03E01 – Bikes C03E01 – Accessories
Comparing Multiple Pages
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses12-topic4-Coomparing-Multiple-Pages.odt” comments=”true” SVG=”true”]
Analyzing User Engagement by Counting Comments and Shares
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses12_topic3-Analyzing-User-Engagement-by-Counting-Comments-and-Shares.odt” comments=”true” SVG=”true”]