Learn how to compare uneven group sizes with PivotTables and charts in Excel. Not all data sets are balanced—sometimes one subgroup is much larger than another. In this Data Survival Skills session, Robin shows how to analyze analysts vs. non-analysts by building PivotTables and transforming the results into 100% stacked charts. By restructuring the data,…
Read More
Learn how to uncover the real impact behind a single number with Excel’s loan amortization tools. A monthly payment might look affordable at first glance—but what about the total cost over time? In this Data Survival Skills session, Robin shows how to use Excel’s built-in loan amortization calculator to break down a $250,000, 30-year loan…
Read More
Learn how to clean and restructure survey data to uncover insights about tool usage across different groups. In this Data Survival Skills session, Robin demonstrates how to transform messy survey exports by selecting the right columns, handling null values, and renaming fields for clarity. By walking through step-by-step examples, she shows how to unpivot multi-select…
Read More