9 astuces pour être productif sur Google Sheets

Antoine Desferet April 11, 2022
Video Thumbnail

About

No channel description available.

Latest Posts

No results found. Try different keywords.

Video Description

Google Sheets n'est pas l'outil le plus fun, mais c'est souvent un passage obligatoire. La boite nouvelle, c'est que son utilisation est presque infinie et permet de faire un paquet de trucs incroyables. Je te partage tout ça dans cette vidéo. ➡️ Rejoins moi sur 4212 : www.4212.fr ➡️ Suis moi sur Insta : https://www.instagram.com/antoinedesferet.4212/ ⚡️RETROUVER MES ASTUCES GOOGLE SLIDES : 00:00 Introduction sur Google Sheets 00:30 Construire des dashboards 02:31 Créer des vues filtrées 03:57 Protéger des données 05:09 Voir l’historique de modification d’une cellule 06:05 Créer un organigramme sur Google Sheet 07:52 Couleurs alternées par ligne sur Google Sheet 08:38 Utiliser les checkbox 09:37 Convertir des devises automatiquement 10:50 Afficher une courbe de tendances dans une celulle ✌️QUI SUIS JE ? Je m'appelle Antoine et je suis entrepreneur. Après avoir travaillé chez OpenClassrooms, je crée Phoenix Mobility : une entreprise dans l'automobile. En parallèle, j'ai un podcast sur le vin qui me permet de découvrir des personnalités incroyables et faire de belles dégustations. Je suis passionné de productivité et partage donc toutes mes astuces dans mon autre podcast sur le sujet. Le podcast est d'ailleurs un média qui me passionne et je vous en partage également tous les secrets.

You May Also Like

Upgrade Your Game

AI-recommended products based on this video

Loading...
Beelink SER3 Mini Desktop PC with AMD Ryzen 3 3200U 2C/4T, 16GB DDR4 500GB PCIE3.0 X4 SSD, Dual Display Output, WiFi6/BT5.2 W-11 Pro Mini Gaming Computer

Beelink SER3 Mini Desktop PC with AMD Ryzen 3 3200U 2C/4T, 16GB DDR4 500GB PCIE3.0 X4 SSD, Dual Display Output, WiFi6/BT5.2 W-11 Pro Mini Gaming Computer

(239)
$459.00
FREE delivery Sat, Jan 3
Loading...
Beelink SER3 Mini PC, AMD Ryzen 3 3200U(14nm, 2C/4T) up to 3.5GHz, Mini Gaming Computer 16GB DDR4 RAM 500GB PCIE3.0 X4 SSD, Micro PC 4K@60Hz Dual Display, Mini Computer WiFi6/BT5.2/HTPC/W-11 Pro

Beelink SER3 Mini PC, AMD Ryzen 3 3200U(14nm, 2C/4T) up to 3.5GHz, Mini Gaming Computer 16GB DDR4 RAM 500GB PCIE3.0 X4 SSD, Micro PC 4K@60Hz Dual Display, Mini Computer WiFi6/BT5.2/HTPC/W-11 Pro

(1,251)
$329.00
FREE delivery Sat, Jan 3
Loading...
Beelink SER3 Mini PC, AMD Ryzen 3 3200U(up to 3.5GHz) 2C/4T, Mini Computer 16GB DDR4 RAM 500GB SSD, Mini Desktop Computer 4K@60Hz Dual HDMI Display WiFi6/BT5.2/WOL/HTPC/W-11 Pro

Beelink SER3 Mini PC, AMD Ryzen 3 3200U(up to 3.5GHz) 2C/4T, Mini Computer 16GB DDR4 RAM 500GB SSD, Mini Desktop Computer 4K@60Hz Dual HDMI Display WiFi6/BT5.2/WOL/HTPC/W-11 Pro

(815)
$329.00
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black
Best Seller

Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black

(16,675)
$112.99$101.69
FREE delivery Sun, Aug 10
500+ bought in past month
Loading...
GIGABYTE - AORUS Elite 16 Gaming Laptop - 165Hz 2560x1600 WQXGA - NVIDIA GeForce RTX 5070 - Intel Core Ultra 9 275HX - 1TB SSD with 32GB DDR5 RAM - Windows 11 Home AD (AORUS Elite 16 BWHC3USC64SH)

GIGABYTE - AORUS Elite 16 Gaming Laptop - 165Hz 2560x1600 WQXGA - NVIDIA GeForce RTX 5070 - Intel Core Ultra 9 275HX - 1TB SSD with 32GB DDR5 RAM - Windows 11 Home AD (AORUS Elite 16 BWHC3USC64SH)

(0)
$9,050.69
FREE delivery Aug 28 - Sep 8Only 3 left in stock.
Loading...
Gigabyte AERO 16 Gaming & Entertainment Laptop (Intel i7-12700H 14-Core, 16.0" 60Hz 4K (3840x2400), GeForce RTX 3070 Ti, 32GB RAM, 4TB PCIe SSD, Backlit KB, WiFi, USB 3.2, Win 11 Pro)

Gigabyte AERO 16 Gaming & Entertainment Laptop (Intel i7-12700H 14-Core, 16.0" 60Hz 4K (3840x2400), GeForce RTX 3070 Ti, 32GB RAM, 4TB PCIe SSD, Backlit KB, WiFi, USB 3.2, Win 11 Pro)

(0)
$11,403.11
FREE delivery Jun 23 - Jul 3
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White

CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White

(17)
$379.99
FREE delivery Sun, Aug 24
Loading...
CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White

CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White

(56)
$149.99$125.33
FREE delivery Sun, Aug 24
Loading...
CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans

CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans

(235)
$879.99
FREE delivery Sun, Aug 24
Loading...
KAMRUI Mini PC E3B, Mini Computer AMD Ryzen 5 7430U (6C/12T, Up to 4.3GHz), 16GB DDR4 512GB M.2 SSD Mini Gaming Pc W11 PRO, 4K Triple Display/WiFi 6/BT5.2/USB3.2 for Home/Business Mini Desktop PC Global Recycled Standard

KAMRUI Mini PC E3B, Mini Computer AMD Ryzen 5 7430U (6C/12T, Up to 4.3GHz), 16GB DDR4 512GB M.2 SSD Mini Gaming Pc W11 PRO, 4K Triple Display/WiFi 6/BT5.2/USB3.2 for Home/Business Mini Desktop PC Global Recycled Standard

(227)
$499.00
FREE delivery Sun, Jan 4Only 8 left in stock.
Loading...
wo-we P8 Mini PC AMD Ryzen 5 7640HS (Max 5.0GHz) 6C/12T Gaming PC, 32GB DDR5 RAM 1TB PCIe4.0 SSD, USB4 Support 8K, Dual 2.5GbE LAN WIFI6E/BT5.2,HDMI,DP, Radeon 760M Micro PC,Business,Home

wo-we P8 Mini PC AMD Ryzen 5 7640HS (Max 5.0GHz) 6C/12T Gaming PC, 32GB DDR5 RAM 1TB PCIe4.0 SSD, USB4 Support 8K, Dual 2.5GbE LAN WIFI6E/BT5.2,HDMI,DP, Radeon 760M Micro PC,Business,Home

(38)
$749.00
FREE delivery Sat, Jan 3
Loading...
Beelink EQR5 Mini PC, AMD Ryzen 5 5650U(7nm, 6C/12T) up to 4.2GHz, Mini Computer 32GB DDR4 RAM 1TB PCIe3.0x4 SSD, Micro PC 4K@60Hz Dual HDMI Display/WiFi6/BT5.2/Office/Home/HTPC/W-11 Pro

Beelink EQR5 Mini PC, AMD Ryzen 5 5650U(7nm, 6C/12T) up to 4.2GHz, Mini Computer 32GB DDR4 RAM 1TB PCIe3.0x4 SSD, Micro PC 4K@60Hz Dual HDMI Display/WiFi6/BT5.2/Office/Home/HTPC/W-11 Pro

(425)
$419.00
FREE delivery Sun, Aug 10
Loading...
BOSGAME E2 Mini PC AMD Ryzen 5 3550H, 16GB DDR4 RAM 512GB SSD, Mini Desktop Computer Support 4K Dual HDMI Display/WiFi5/BT5/Gigabit Ethernet for Home/Office

BOSGAME E2 Mini PC AMD Ryzen 5 3550H, 16GB DDR4 RAM 512GB SSD, Mini Desktop Computer Support 4K Dual HDMI Display/WiFi5/BT5/Gigabit Ethernet for Home/Office

(79)
$236.00
FREE delivery Sun, Aug 10
Loading...
Asus ROG Strix B550-F Gaming WiFi II AMD AM4 (3rd Gen Ryzen) ATX Motherboard (PCIe 4.0,WiFi 6E, 2.5Gb LAN, BIOS Flashback, HDMI 2.1, Addressable Gen 2 RGB Header and Aura Sync)

Asus ROG Strix B550-F Gaming WiFi II AMD AM4 (3rd Gen Ryzen) ATX Motherboard (PCIe 4.0,WiFi 6E, 2.5Gb LAN, BIOS Flashback, HDMI 2.1, Addressable Gen 2 RGB Header and Aura Sync)

(12,062)
$239.91$169.99
FREE delivery Jan 19 - 28
100+ bought in past month
Loading...
MSI Aegis R2 (Tower) Gaming Desktop, AMD R7-8700F, GeForce RTX 5060, 16GB DDR5 Memory, 2TB M.2 NVM SSD,Air Cooling,650W USB Type-C, VR-Ready, Windows 11 Home

MSI Aegis R2 (Tower) Gaming Desktop, AMD R7-8700F, GeForce RTX 5060, 16GB DDR5 Memory, 2TB M.2 NVM SSD,Air Cooling,650W USB Type-C, VR-Ready, Windows 11 Home

(0)
$1,599.00
FREE delivery Sat, Jan 3
Loading...
MSI Ultra-Slim Thin 15 VR-Ready High FPS Gaming Laptop, 15.6 FHD 144Hz, Intel Core i5-13420H, NVIDIA GeForce RTX 4060, 32GB RAM, 2TB SSD, Backlit KB, Wi-Fi 6, Bundle with PCO Notebook Fold Radiator

MSI Ultra-Slim Thin 15 VR-Ready High FPS Gaming Laptop, 15.6 FHD 144Hz, Intel Core i5-13420H, NVIDIA GeForce RTX 4060, 32GB RAM, 2TB SSD, Backlit KB, Wi-Fi 6, Bundle with PCO Notebook Fold Radiator

(0)
$4,697.44
FREE delivery Jun 23 - Jul 3Only 3 left in stock.