Spreadsheet Topics & Categories
Browse our complete library of spreadsheet articles separated by platform. Master formula syntax, automation scripts, and executive dashboards in Microsoft Excel or Google Sheets.
Microsoft Excel
Master modern dynamic arrays, formulas, VBA macro automations, pivot tables, and dashboard visuals.
Excel Functions & Formulas
VLOOKUP, XLOOKUP, INDEX MATCH, LAMBDA & logical calculations
Advanced Excel
Dynamic arrays, complex modeling, financial formulas & nested logic
Excel VBA
Automation scripts, procedures, user forms & custom functions
Excel Pivot Table
Summary reports, multi-table slicers, calculated fields & data models
Excel Charts
Executive dashboards, dynamic chart ranges & visualization tricks
Excel Pro Tips
Productivity shortcuts, interface hacks & spreadsheet best practices
Data Analysis with Excel
In-depth Microsoft Excel tutorials and practical spreadsheet examples.
Excel for Accounting
In-depth Microsoft Excel tutorials and practical spreadsheet examples.
Excel for Finance
In-depth Microsoft Excel tutorials and practical spreadsheet examples.
Excel for Statistics
In-depth Microsoft Excel tutorials and practical spreadsheet examples.
Google Sheets
Cloud-native spreadsheet functions, QUERY syntax, IMPORTRANGE, Apps Script, and live reporting.
Google Sheets Basics
Interface fundamentals, cloud collaboration & core setup
Google Sheets Functions
FILTER, SORT, UNIQUE, SPLIT & live web data functions
Google Sheets Formulas
QUERY syntax, ARRAYFORMULA, IMPORTRANGE & regex formulas
Google Sheets Intermediate Tutorials
Data cleaning, Pivot tables, dropdown validations & conditional styling
Charts in Google Sheets
Interactive cloud charts, team dashboards & embedded sparklines
Google Sheets Advanced Tutorials
Apps Script automation, webhook APIs & cloud spreadsheet workflows
Looking for Instant Calculations?
Skip manual formula writing with our 45 dedicated financial, accounting, and statistics calculators. Instant results with formulas explained.