Discover all the shortcuts with the Ctrl Key in Excel. There is more than 50 shortcuts with this key. Do you know all of them?
Tips and tricks
The function keys in Excel (or the f key) are very useful and save a lot of time in many situations. Here is the list of the action you can do
All the shortcuts with the Alt key.
Do you know the trick to draw your Excel borders in no time? You can draw them with a basic drag and drop of the mouse
Easily identify and remove duplicate data in your Excel spreadsheets with these simple steps. Clean your data and improve accuracy.
Excel can fill series of numbers or dates automatically. Three techniques can be used. Here are the explanations.
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.
You can split your report to many sub-reports automatically with a pivot table options. When you use the filter, you can spilt your report 😉
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 😉
Learn the trick to update your chart series automatically when you add new data to your source. No formula is needed.
One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.
In Excel 2013 and later, you can extract text without a formula using Flash Fill.FlashFill is a tool integrated into Excel, that runs in the background continuously.
Discover how you can easily create a dynamic dropdown list (data validation) when your source of data will be updated with Tables
You can unstack data from 1 column to many with the function TRANSPOSE and INDIRECT. Explanation is this article.
How to add a slicer for your pivot table with Excel Online? There is two techniques, exactly like with Excel desktop