SheetRise
Benin · XOF
Display currency does not guarantee local payments. Final methods and charge confirmed by Chariow.
Sign inMy account
Tips & practical methods

Master spreadsheets.
Grow every day.

Explore shortcuts, formulas and workflows to work faster, reduce errors and make better decisions in Excel and Google Sheets.

📗 Excel📊 Google Sheets⚡ Formulas & productivity
SheetRise · Smart Tips● ● ●
A
B
C
D
1
Budget
2026
✓
2
Income
1 200
↗
3
Expenses
800
↘
4
Balance
400
✓
ƒx   =SOMME(B2:B3)
✨ One tip at a time
Your toolbox

24 practical tips to try today.

Shortcuts, formulas, automation, dashboards and collaboration.

24practical tips
⌨️Excel
01 / Raccourcis

Lock a reference with F4

In a formula select A1, then press F4 to cycle through relative, absolute and mixed references.

=$A$1*B2
⚡Excel
02 / Raccourcis

Toggle filters instantly

Select your table and press Ctrl + Shift + L to toggle filters.

Ctrl + Shift + L
📋Excel
03 / Données

Create a structured table

Ctrl + T converts a range into a table that expands as rows are added.

Ctrl + T
🧮Excel
04 / Formules

Sum with several criteria

SUMIFS totals sales matching several conditions.

=SOMME.SI.ENS(C2:C100;A2:A100;"Paris";B2:B100;"Payé")
🔎Excel
05 / Formules

Look up values with XLOOKUP

Look up a value in another column with an explicit not-found result.

=RECHERCHEX(E2;A2:A50;C2:C50;"Introuvable")
🌊Excel
06 / Formules

Filter data dynamically

FILTER returns only the rows matching a condition.

=FILTRE(A2:D100;D2:D100="En retard";"Aucun résultat")
🪄Excel
07 / Formules

Find unique values without deleting rows

UNIQUE returns a dynamic list of distinct values.

=UNIQUE(A2:A100)
↕️Excel
08 / Formules

Sort a list automatically

SORT updates a sorted list without editing the source.

=TRIER(A2:C50;2;-1)
🧠Excel
09 / Formules

Simplify calculations with LET

LET names intermediate calculations to make a formula easier to maintain.

=LET(total;SOMME(B2:B20);total*0,15)
📥Excel
10 / Données

Clean CSV files with Power Query

Data > From Text/CSV: import, transform and refresh recurring files.

Données → Obtenir des données
📈Excel
11 / Tableaux de bord

Summarize with a PivotTable

Insert > PivotTable to summarize rows by month, category or sales person.

Insertion → Tableau croisé dynamique
🎯Excel
12 / Données

Reduce typing errors

Data > Data Validation creates drop-down lists of allowed values.

Données → Validation des données
🚦Excel
13 / Tableaux de bord

Highlight overdue items

Use conditional formatting to flag overdue dates and pending statuses.

=$B2<AUJOURDHUI()
🧊Excel
14 / Raccourcis

Keep headers in view

View > Freeze Panes keeps headers visible while scrolling.

Affichage → Figer les volets
💰Excel
15 / Finances

Calculate gross margin

Divide gross profit by revenue and guard against zero revenue.

=SI(B2=0;0;(B2-C2)/B2)
📆Excel
16 / Finances

Calculate days overdue

Compare a due date to today without showing negative overdue days.

=MAX(0;AUJOURDHUI()-B2)
🔍Excel
17 / Raccourcis

Jump to a cell

Ctrl + G opens Go To to navigate to a named range or cell.

Ctrl + G
🛡️Excel
18 / Données

Protect important formulas

Unlock inputs, then use Review > Protect Sheet. It prevents accidental edits but does not secure confidential information.

Révision → Protéger la feuille
🔎Google Sheets
19 / Formules

Query a table with QUERY

Google Sheets QUERY lets you filter and aggregate rows with SQL-like syntax.

=QUERY(A1:D100;"select A, sum(D) group by A";1)
🔗Google Sheets
20 / Données

Link two Sheets files

IMPORTRANGE pulls a range from another spreadsheet after authorization.

=IMPORTRANGE("URL_DU_CLASSEUR";"Feuille1!A1:D20")
🧬Google Sheets
21 / Formules

Fill a column with ARRAYFORMULA

ARRAYFORMULA applies a calculation across multiple rows.

=ARRAYFORMULA(SI(A2:A="";"";B2:B*C2:C))
📉Google Sheets
22 / Tableaux de bord

Build an in-cell chart

SPARKLINE draws a mini-chart in a single cell.

=SPARKLINE(B2:G2)
🤝Google Sheets
23 / Données

Collaborate with comments

Use comments and mentions to request reviews without changing data.

Insertion → Commentaire
🧼Google Sheets
24 / Formules

Remove extra whitespace

TRIM removes excessive spaces after data imports.

=SUPPRESPACE(A2)

Function names and argument separators may vary by app language and locale.

A community space

What if your next breakthrough came from another user?

Join our public forum. Ask a question, share a formula or teach your favorite workflow.

Visit the forum ↗
Go further

Detailed SheetRise guides

All guides →