With Excel, you can extract a sub-string without writing formulas with the FlashFill. FlashFill is the first AI tool in Excel
The TRIM function of Excel is very useful to remove extra spaces in your cell and then, avoid tons of errors.
Learn how to move cells in Excel with the mouse quickly and easily, step-by-step. This guide is perfect for beginners and experts alike.
In Excel, there is a trick to highlight missing values without using formula. The trick is to use the conditional formatting tool.
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.
How to move a cell with the mouse in Excel? It's very easy and much more efficient than doing a cut and paste.
How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.
Excel can fill series of numbers or dates automatically. Three techniques can be used. Here are the explanations.
Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets
Easily identify and remove duplicate data in your Excel spreadsheets with these simple steps. Clean your data and improve accuracy.
How to do a calculation or a formula in Excel? It's very simple but you have a few rules to know to avoid mistakes.
The COUNTIF function of Excel returns the number of rows within a range according to a criterion. Learn how to use it in this article.
SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function
Discover the tips and tricks to move or copy a worksheet in the same workbook or in a new one. All explanations with animated gif.
In Excel, you can audit your formula with the shortcut F9 and analyse which part of your formula returns error. The best trick to know 😉