How to keep the leading 0 in a cell?
Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes
Excel tricks
3D Formula in Excel
In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.
Comma or Semicolon in an Excel formula
For your formulas, the separators for your formula's arguments could be the comma or the semi-colon. It depends of your widows setting 😮😉
Ctrl + D The Secret Revealed
Ctrl + D in Excel duplicates your graphic objects (chart, picture or icon). But also keep the position of your move. Discover the secret here.
Convert TRUE or FALSE to 1 or 0
When a test in Excel returns TRUE or FALSE, you can convert it to 1 or 0 with 2 different techniques. Discover these techniques in this article
Start Excel with your custom parameters
Learn how to start Excel with custom parameters. Step-by-step guide for beginners and experts to optimize your Excel experience.
Running Total in Excel
A running total is a very useful mathematical operation which is very simply to build in Excel.
Copy Paste -All Tricks
Discover all the secrets to copy easily in Excel text, number and formula
