Excel is Microsoft's spreadsheet application for data analysis and visualization. Keyboard shortcuts help perform tasks faster and more efficiently. Excel supports over 270 shortcuts for various operations
Error occurs when Excel workbook filename contains invalid square brackets. Range referenced in pivot table may not exist or be undefined. Error can appear when opening file from URL or email attachment
Heat map shows comparative view of dataset using color scale from green to red. Default color scheme assigns red to lowest values, green to highest
Excel 2013+ allows automatic distinct count calculation in pivot tables. Distinct Count option available under Value Field Settings. Formula-based approach using COUNTIFS can count unique values
Save spreadsheets as binary (.xslb) format instead of XML (.xslx). Set binary format as default in File > Options > Save. Save as binary if file is in SharePoint library
Pandas pivot_table() creates spreadsheet-style pivot tables for data analysis. Function requires index, columns, and values parameters. Default aggregation function is 'mean'