Guides for "spreadsheet formulas"
45 guides found
11:27How to use SUMIF and SUMIFS in Excel to add values by criteria
1:26How to add a Calculated Field to an Excel Pivot Table
1:13How to build an automatic expense tracker in Excel
1:22How to build a dynamic budget planner in Excel
15:49How to build a personal budget tracker in Microsoft Excel
10:30How to use Claude for Excel to clean data and build models
4:03How to build a budget tracker in Google Sheets with Gemini Build
27:09How to build an automated budget and expense tracker in Google Sheets
17:47How to build an income and expense tracker in Google Sheets
1:22How to build a dynamic invoice generator in Excel with Scribe
1:00How to use the SUMIF function in Excel to add matching values
18:18How to build a personal finance tracker in Excel with SUMIFS
5:11How to use the DGET function in Excel for lookups
2:38How to use INDEX MATCH in Excel for two-way lookups
5:32How to clean messy Excel data with TEXTAFTER and REGEXEXTRACT
10:29How to use Excel database functions instead of SUMIFS
8:37How to use SUMIFS with partial text matches and wildcards in Excel
10:05How to use SUMIFS in Excel with multiple conditions
14:04How to use SUMIFS, COUNTIFS and AVERAGEIFS in Excel
4:25How to use SUMIFS with multiple criteria in the same column in Excel
2:45