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

Function SUM

This is the most commonly formula used and also the simplest to use. We will see in this page, different methods to perform a SUM in Excel. Presentation of the SUM function To perform a SUM function in Excel You simply start with the = sign in your cell Then, you enter the word SUM Then …

Continue reading

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

3D Function

Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. A 3D formula simplifies your writing Say you have a workbook that contains one sheet per month. You want to create a worksheet that will synthesize all these month in a worksheet …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/3d/