143,667 views
Have you always wanted to learn how to use Excel? In this MEGA TUTORIAL, I explain all the basics of the Office suite spreadsheet! In this free, comprehensive Excel training in French: 0:00:00 Getting started with Excel 0:00:39 The basics of Excel 0:08:41 Basic operations 0:10:40 Managing cells 0:16:54 The slider 0:20:14 Formatting cells 0:30:02 Formatting cells 0:36:12 Functions 0:49:36 Booleans 0:52:21 Conditional formulas 0:55:54 Nested if 0:59:28 Conditional formatting 01:04:38 COUNTIF 01:07:55 AND and OR functions 01:10:30 Exercise 1 on Excel 01:13:51 Solution to exercise 1 01:26:01 Data validation 01:30:47 Creating drop-down lists on Excel 01:32:57 Protecting cells 01:37:58 Comments 01:39:25 Sharing in real time 01:40:13 Creating charts 01:48:09 Cell reference 01:54:13 Naming cells 01:56:15 The home ribbon 01:57:07 Icons and 3D images 02:01:06 Exercise 2 02:03:34 Solution TP 2 02:11:13 Sorting data 02:15:41 Filtering data 02:19:24 Pivot table 02:24:28 XLOOKUP ex-VLOOKUP HLOOKUP Macros and VBA: • [TUTORIAL] The BASICS of macros and VB... In this free Excel course, we take things from the beginning, without judgment or pressure. We will discover the Excel interface together, understand the basics, and quickly move on to more advanced skills. No stress, no unnecessary complications! We firmly believe in practical learning. You will not just be a spectator, but an actor in your own learning. Practical exercises will help you immediately apply what you learn, thus consolidating your new knowledge in a sustainable way. In this free and complete tutorial, I suggest you learn Excel in an easy, free training in French! ______ My website: https://avecbertrand.tech My Facebook: / bourgybertrand My Insta: / tech_avecbertrand ____ #tutorial #excel #tutorial #french #beginner #free #training #exceltraining