LIBREOFFICE CALC : Fini les formules compliquées ! (Tuto Débutants Table Dynamique ou croisée)
Tired of manually calculating sums or writing long formulas? Discover the power of PivotTables in LibreOffice Calc! In this beginner's tutorial, I'll show you how to analyze a family budget in just a few clicks, without any mathematical formulas. 📂 Download the exercise file: https://drive.google.com/file/d/1qLOK... In this video, you'll learn how to: ✅ Create a pivot table from scratch. ✅ Find out who spends the most and in which category. ✅ Automatically group dates by MONTH (a brilliant tip!). ✅ Filter the data to see a single shopper. ⚠️ IMPORTANT (A pitfall to avoid): At the end of the video, I explain why your figures don't change when you modify the table! This is the number one mistake: you must remember to REFRESH your table (Right-click Refresh) every time you add data. In this video: 0:00 - Why use dynamic tables? 0:38 - Properly preparing your table (Golden rule) 1:04 - Creating your first dynamic table 1:58 - Analyzing expenses per person 2:28 - Deleting and changing fields (analysis by category) 3:35 - The trick to grouping dates by MONTH 4:41 - ⚠️ WARNING: How to refresh the data (Essential!) Conclusion If this tutorial helped you master LibreOffice, give it a thumbs up 👍 and subscribe so you don't miss the next tips! #LibreOffice #Calc #Tutorial #OfficeSoftware #PivotTable #Budget #Productivity
![[ TUTO ] LibreOffice Calc : les BASES en 30 minutes ! ( Tutorial / cours en français )](https://i.ytimg.com/vi/2ET0w2BRVME/hqdefault.jpg?sqp=-oaymwEnCNACELwBSFryq4qpAxkIARUAAAAAGAElAADIQj0AgKJDeAG4AvMY&rs=AOn4CLBr3Q2IAminfPLGUai_k0XsdvZPeA&usqp=CCY)
[ TUTO ] LibreOffice Calc : les BASES en 30 minutes ! ( Tutorial / cours en français )

10 Mind Blowing Excel Tricks I Wish I Knew Earlier

Présentation fichier de recouvrement de créances avec Microsoft excel sous vba

The 10 Excel formulas you ABSOLUTELY MUST know!

Excel : obtenez le tableau de bord PARFAIT pour gérer VOS FINANCES : complet, simple et dynamique !

Les bases de LibreOffice Calc

Publipostage avec plusieurs lignes : de Calc à LibreOffice Base - regrouper (relation 1 à plusieurs)

Stop Sending Ugly Pivot Tables to Your Boss

So funktioniert POWER PIVOT in Excel | KOMPLETTE GRUNDLAGEN

Creating and Improving a Chart with Excel - Method and Practical Examples

Vintage Spring TV Art Painting Screensaver | Framed Art TV | Art For TV Screen

3-Hour Serene Yellow & Orange Gradient - Uplift and Relax Your Space

LibreOffice Calc #7 - Automatically format a table

The Magic Operator That Automatically Updates Your Excel Formulas (No More Copy-Paste!)

Pink Ombre Aura Screen | 3 Hours and 1 Second | No Sound

Create a spreadsheet with LibreOffice Calc

Excel Power User Tutorial

Tuto vidéo : Utiliser les tables dynamiques dans LibreOffice Calc

EXCEL - Maîtriser les Tableaux Croisés Dynamiques | GUIDE COMPLET 2026

