Excel as a sports coach
Do you know that Excel can be your new sports coach? No? But in reality, it's very easy. Copy for free the code and you will have your coach at home
Expert
Take your Excel skills to the next level with our category dedicated to expert Excel users. Discover advanced techniques and complex formulas.
How to become Office Insider
Discover how to become an Office Insider in order to have the newest features of Office
Function XOR
The function XOR is a logical function to find exclusive OR. That's mean one and only one result (and not TRUE for both)
Explanation of the VBA code for the calendar
Each lines of the VBA code for the automatic calendar explain in detail.
Wildcard with COUNTIFS or SUMIFS
You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.The wildcards are specials characters to replace one or more characters in your string
How to make automatic calendar in Excel
This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.
Gantt Chart
A Gantt chart, helps you to visualize the time needed to realize actions. Learn how to build a Gantt chart with Excel steps by steps
Keep your Last Updated Data
Keep the last updated row Let's start from a file storing customer information. Some customers have multiple records in the file, as a new record was created each time they changed their address or phone number. How do you keep only the last updated row? 🤔🤨 Remove duplicates not applicable With a such file, you […]
1 2
