Frédéric LE GUEN

Most commented posts

  1. How to make automatic calendar in Excel — 36 comments
  2. Date Format in Excel — 11 comments
  3. Split Time and Date — 6 comments
  4. Pivot Table – Generate multi-worksheets — 4 comments
  5. NOW & TODAY — 4 comments

Author's posts

How does Excel deal with hours over 24

Excel doesn’t display hours over 24 by default. But, if you change one option in the number format, you can display hours over 24. Difference between hours and days in Excel Rule 1 : A whole number is a day Rule 2 : A decimal number, between 0 and 1, is a time Let’s consider …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/excel-hours-over-24/

Formulas to include or exclude tax

What is VAT? VAT (Value Added Tax) is a tax that is often added to goods or services. Each country or state defines it’s own VAT rates (in percent). For companies it is important to separate the price including and excluding VAT. Basic calculations in Excel If you have some problems with percentage calculations, have …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/the-formulas-to-include-or-exclude-tax/

First day – Last day in Excel

On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/first-day-last-day-in-excel/

Comma or Semicolon in an Excel formula

Why does Excel expect commas or semicolons to separate the parameters in a formula? The answer can be found in this article. Comma or semicolon ? If you read this article, it’s because one day you noticed that the separator between the parameters in any function is the comma sign or the semicolon. Sometimes the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/comma-or-semicolon-in-excel-formula/

Calculate Percentage Increase with Excel

Calculating the percentage increase between 2 values is very easy with Excel and doesn’t require a specific Excel function. Context to calculate percentage increase Let’s say you have your total sales for each month. The values look OK but you want to calculate the percentage increase (or decrease) between each month. Method to calculate the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/calculate-percentage-increase-with-excel/

Displaying Negative Numbers in Parentheses – Excel

Negative numbers in Excel In Excel, the basic way to format negative numbers is to use the Accounting number format. This option will display your negative number in red. But for some reports, negative numbers must be displayed with parenthesis. Let’s see how to do that. Customize your number format To display your negative numbers …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/negative-numbers-with-parenthesis-excel/

Pivot Table – Presentation

A Pivot Table is a powerful tool which calculates or aggregates data very easily. For many people, a pivot table is a complex tool for advanced users. But not at all. It’s really simple and all the calculations are made by the tool itself. You just have to drag an drop your data. 😎😃😍 Before creating …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/pivot-table-presentation/

Gantt Chart

What is a Gantt chart? A Gantt chart helps you to visualize your project schedule containing different tasks and their deadlines. Your data To create a Gantt chart, you must have a table with: Task names Start dates Effort (number of days needed to carry out each task) Step 1: Return the End Date (based …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/gantt-chart/

Time Formats in Excel

In Excel, working with the time is not difficult but you need to know a few rules to avoid big mistakes. In this article you will learn these rules and how to manage time formats. Difference between date and time in Excel In Excel, hours are always a fraction of a day. So it uses …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/time-format-in-excel/

Dynamic SUM in Excel

Creating a SUM is very easy to do in Excel. But when you want to add only specific cells and not all of them, the formula is not as easy. But it’s possible! Let’s see how to create a dynamic SUM. Insert your data into a Table But before we explain how to create the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/dynamic-sum-in-excel/