Log inFree budget
Home / Tricks

Excel and Google Sheets tricks

Every trick from the videos, written out with the formula to copy and the Sheets version.

// trick 047Formulas

Sum by month in one formula

=SOMMA.PIÙ.SE(C:C;A:A;">="&DATA(2027;3;1);A:A;"<"&DATA(2027;4;1))
Sheets: =SUMIFS(C:C;A:A;">="&DATE(2027;3…
In the template: Monthly Budget
// trick 046Formulas

XLOOKUP in 20 seconds

=CERCA.X(F2;A:A;C:C;"non trovato")
Sheets: =XLOOKUP(F2;A:A;C:C;"non trovato")
In the template: "Organize 2027" Bundle
// trick 045Charts

A progress bar without charts

=RIPETI("█";ARROTONDA(B2*10;0))&RIPETI("░";10-ARROTONDA(B2*10;0))
Sheets: =REPT("█";ROUND(B2*10;0))&REPT("…
In the template: 2027 Goals Planner
// trick 044Dates

Working days between two dates

=GIORNI.LAVORATIVI.TOT.INTL(A2;B2;1;Festività!A:A)
Sheets: =NETWORKDAYS.INTL(A2;B2;1;Festiv…
In the template: 2027 Leave and Attendance
// trick 043Shortcuts

A drop-down list in 20 seconds

Dati › Convalida dati › Consenti: Elenco › Origine: =$H$2:$H$8
Sheets: Dati › Convalida dei dati › Elen…
In the template: 2027 Goals Planner
// trick 042Formulas

Remove extra spaces

=ANNULLA.SPAZI(A2)
Sheets: =TRIM(A2)
In the template: "Organize 2027" Bundle
// trick 041Shortcuts

Ctrl + ; for today's date

Ctrl + ; (ora: Ctrl + Maiusc + ;)
Sheets: Ctrl + ; (anche su Mac: Cmd + ;)
In the template: Expense Report
// trick 040AI

The right prompt to ask AI for a formula

"Ho le date in A e gli importi in C. Scrivi la formula Excel in italiano, separatore punto e virgola, per sommare marzo 2027."
Sheets: Stesso prompt, ma chiedi "Google…
In the template: Monthly Budget
// trick 039Dates

Overdue dates turn red by themselves

=E($J2="No";$D2<OGGI())
Sheets: =AND($J2="No";$D2<TODAY())
In the template: "Organize 2027" Bundle