In which menu area do you find the commands for setting up the pages for printing by default?

Have you ever computed with Excel or created a formula yourself? For example, can you create a formula that calculates the shares (column D)?

Editing lists is an everyday work in Excel. A lot of time is spent scrolling to display columns and / or rows outside the screen. Can you fix the heading of a list so that it remains up when scrolling?

The print command, for example, hides by default in the backstage area (file). Microsoft offers the possibility to create 'its' commands in an individual toolbar called quick access toolbar. Can you customize the quick access Toolbar?

Excel formats cells by default after plausibility. You should be aware of the number format in Excel and use it actively. You can use the cell formatting to write a weekday in the date? (From ’06.03.2017’ will be ‘Monday, 6 March 2017’)

List processing takes a lot of time with Excel. Many users cannot put a list down on paper that suits your needs. Imagine you have a list that prints some lines on the 2nd page. Do you print the complete list on a page?

Absolute references (e.g., $ A $ 1) can often be replaced by names. Advantage: Better legibility, documentation and traceability. Do you work with names for cells?

Often you copy formulas to other cells. Sometimes you need to know the difference between relative and absolute references.

What is the formula in B4 if you want to calculate the list up to B9 by autofill?

                =A4-

If you want to work with more than one table at a time, you can use windowing or you can start a second Excel instance. So you always have the best overview of your data.

Can you arrange several tables next to each other?

Filtering and sorting are indispensable for list processing. Filter is activated via the menu commands or CTRL + SHIFT + L.

Do you know all the possibilities to filter or sort lists and also know what is not possible?