Loading video…
All breakouts
4.2App DemoOther hookEducation
Hook
Avant demain matin : Calculer les ventes par client
@lexcelerateur
31.7K followers · usually 4.8K views a post
Views
19.7K
Likes
998
Comments
21
Shares
125
Why it worked
The video provides a practical and efficient solution to a common data analysis problem using a specific Excel function, making it highly valuable for users looking to improve their spreadsheet skills.
Summary
This video demonstrates how to use the Excel `GROUPER.PAR` function to consolidate sales data by client. It shows how to select the client column for grouping and the sales column for summation, resulting in a table with unique clients and their total sales.
Structure
- 1Introduce the problem: sales data with duplicate clients.
- 2Explain the goal: consolidate sales by unique client.
- 3Introduce the `GROUPER.PAR` function.
- 4
Original caption
Cette formule crée un TCD sans en faire un ! Vous connaissez GROUPERPAR ? 👀 C'est la formule qui fait ce qu'un TCD fait, mais en une seule ligne, directement dans votre feuille. Ventes par client, automatiquement regroupées, sans cliquer sur Insérer un tableau croisé. 🔥 #excel #exceltips #exceltricks #tuto #creator
More from @lexcelerateur
More breakout videos from this creator.
