Calculate Quarter with Excel
How to calculate the first day of a Quarter or the Quarter Number in Excel? All the formulae in this article.
Function
The Excel functions explained
Power Query Split Date and Time
This step-by-step guide will walk you through the process of split your date and time data with Power Query.
Excel negative hours
Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.
Calculate Monday Previous Week with Excel
Formula to calculate Monday for the previous week with Excel, from TODAY or any date.
Calculate the Previous Monday with Excel
Formula to calculate the previous Monday with Excel, from TODAY or any date.
Calculate Monday in 2 weeks with Excel
Formula to calculate Monday in 2 weeks with Excel, from TODAY or any date.
Calculate the Next Monday with Excel
Formula to calculate the next Monday with Excel, from TODAY or any date.
Formula First Monday of the month with Excel
Formula to calculate the first Monday of the month with Excel
Calculate Monday 2 weeks ago with Excel
Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.
Calendar in Excel with Data Saving
Calendar with saving of the data created with Excel. Download this file to follow the activity of your employees
Formula to Remove the VAT in Excel
How to remove VAT? To solve this, you don't need a specific Excel function. A combination of additions and divisions do the job.
Build a Logical Test in Excel
A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.
Convert a Text Date to Numeric Date
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.
How to find duplicate values in Excel?
You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF
How to do a Cube Root in Excel?
There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.
