Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. What is the problem? 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 “Year”. You …
Permanent link to this article: https://www.excel-exercise.com/3d/
Excel allows you to do all kinds of calculations and respect mathematical rules. We will see how to perform simple calculations (addition, subtraction, multiplication, division) and also how to perform operations that use several different operators without making any mistakes 😉 The = sign In Excel, all the calculations or formulas start with the = …
Permanent link to this article: https://www.excel-exercise.com/basic-calculation/
The cell reference is the code that identify a cell: A1, B3, C15, … BJ375. But in Excel, it’s not just reference, we have absolute, relative and mixed references (but what-is-this-stuff 😲🤔🤨) It is very important to understand this concept because very often in a spreadsheet, you have important data that must be used in your formulas: …
Permanent link to this article: https://www.excel-exercise.com/absolute-relative/
In Excel, it’s very easy to use the value of a cell. You just have to call the reference of a cell. What is the reference of a cell? In Excel, a cell is often called by its references. In other word, the intersection of a row and a column, like A1, B5, D8,… …
Permanent link to this article: https://www.excel-exercise.com/use-the-value-of-a-cell-in-excel/
Mixed reference A mixed reference is a reference that is fixed only on part of the reference: either the row or the column Before showing you an example of a calculation using mixed references, we will detail the use of the $ symbol in a reference. An absolute reference has two $. There is one …
Permanent link to this article: https://www.excel-exercise.com/mixed-reference/
What is the VAT? The VAT (Value Added Tax) is a tax that is added to any products or good. The tax is an official rate defines by countries or states and it is express by a percentage. For companies it is important to separate the prices with the taxes and the prices without taxes. …
Permanent link to this article: https://www.excel-exercise.com/the-formulas-to-include-or-exclude-tax/
