How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
Take your Excel skills to the next level. Explore advanced formulas, data analysis techniques, pivot tables, conditional formatting, and more.
Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
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.
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets
Discover all the tips and tricks you can do with all the copy-paste special
How to change the language of Excel? It's easy but it depends on your version of Office. Read this step-by-step tutorial.
Understand the difference between XLS and XLSX file formats in Excel. Learn how to convert and save files for optimal compatibility.
With the cloud technology, you can create a survey with Excel OnLine and share it to your audience easily. Survey made with Excel Click on the following picture to visualize an exemple of survey made with Excel Online Create a survey There is 2 ways to create a survey. But, you must open your personal OneDrive […]
The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH
A mixed reference is a reference that is fixed only on part of the reference
A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.
For your formulas, the separators for your formula's arguments could be the comma or the semi-colon. It depends of your widows setting 😮😉
It's easy to build a mortgage calculator with Excel and the function PMT
With the new feature of Office 365, Data Type, you can easily collect the last Exchange Rate between 2 currencies