Category: Beginner

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/