Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
How to do a calculation or a formula in Excel? It's very simple but you have a few rules to know to avoid mistakes.
In Excel, a cell reference could be relative or absolute (written with dollars). It's important to understand both situations
In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.
The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
A mixed reference is a reference that is fixed only on part of the reference
When you start learning Excel, it's important to understand how you can reuse the content of other cells in your formula. It's very easy.
How to calculate VAT in Excel? It's very easy and doesn't need a specific function. Many examples in this article.
There are 2 ways to know the column number in Excel. One is an Excel option, and the other one is a function.
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.
How to move a cell with the mouse in Excel? It's very easy and much more efficient than doing a cut and paste.
What does mean the sign & in Excel? This sign is very important in many situation to link 2 cells together.
How to copy only the formula and not the formatting of your document? In Excel you have 3 different techniques to do the job.
Exercise to calculate the income of the week. You will see how to use the dollars in your calculation and create SUM formulae.
Learn how to move cells in Excel with the mouse quickly and easily, step-by-step. This guide is perfect for beginners and experts alike.