Please ensure Javascript is enabled for purposes of website accessibility

Look up function

The search function facilitates data processing, especially when there is a lot of data. In the video example, a function is created that retrieves the price of the product when the product is searched for by its name....

Excel template

The video goes over how to create your own template in Excel and how the template can be used as a basis for Excel files in the future....

Dropdown list

Sometimes in the file you want to give the filler only certain possible choices, then it is possible to create a drop-down list....

Using formulas and conditional formatting

In this video, we go through a comprehensive overview of how formulas can be used. In the example of the video, you can find, among other things, how to format values, how to write the formula yourself and how to use the ready-made formula. In addition, the video...

Nested functions

The video goes through the use of nested functions in a formula....