Instruction: Given a dataset with over 100,000 rows, optimize the spreadsheet for efficient data manipulation and analysis. Implement techniques to reduce file size and computation load without compromising data integrity. Additionally, use advanced charting techniques to visually summarize key insights from the data.
Context: This question tests the candidate's ability to handle and optimize large datasets in Excel, a common requirement in data-heavy roles at tech companies. Candidates need to demonstrate knowledge of Excel's performance optimization techniques, such as enabling manual calculation mode, using efficient formulas, and compressing data. Additionally, the ability to create advanced charts (e.g., waterfall, Pareto, sunburst) to extract and present data insights effectively is evaluated.