Welcome to Spreadsheet Hacker, the blog dedicated to helping you find workarounds to data problems in everyone's favorite tool - the trusty spreadsheet. From Excel and Google Sheets hacks, and delving into newcomers like Smartsheet and Airtable, we're here to help. Let's dive in and share our top spreadsheet tips and tricks.
Got a question, suggestion or want to guest post? Contact us.
How to Create Pivot Tables in Databricks and Alternative Solutions for Excel Users
How to Open Machine-Readable Files (MRFs) in Excel
Tackling Large-Scale Pivot Tables in Spreadsheets: Workarounds for Big Data Analysis
Spreadsheets: The Ultimate Self-Service Analytics
Data Products and Spreadsheets: The Perfect Pair for Self-Service Analytics
Mastering Time Series Analysis in Excel: Techniques and Best Practices
How to Connect Excel to Snowflake: A Step-by-Step Guide
Why Ad-Hoc Data Analysis Beats Traditional BI Dashboards
Spreadsheet BI: Sigma Computing (and Competitors) for Business Analytics
Connecting Spreadsheets to Databricks Delta Lake
Automating Data Cleaning in Excel Using Power Query
Top 5 Excel Formulas For Data Analysts
Salesforce Report Exports and How To Exceed The Limits
Mastering Data Deduplication in Excel
5 Excel Hacks To Supercharge Your Data Analysis
Top 10 Google Sheets Formulas to Transform Your Data (and 3 things you can't do in Excel)
From Excel Chaos to Database Clarity: Your Guide to Making the Switch
Too Much for Sheets? Here's what to do when Google Sheets starts crashing.