2. Celeigenschappen instellen in Excel
In deze les leer je een blad opmaken en werken met snelle analyse.
Setting cell properties
Recreate the table below:
Figure 2.1 Sponsored run
Make sure the Home tab is selected
Figure 2.2 Home tab
Select cells B5 to D11
Click the arrow 
behind the menu 
The Format Cells menu opens.
Figure 2.3 Format Cells
Select the Currency category
Figure 2.4 Cell properties currency
Make sure the euro symbol is selected and that the amount is displayed with 2 decimal places.
Type Total in A12
In B12, you enter a formula to calculate the total
Select cells B5 to B11
Figure 2.5 Selecting
Click the SUM button
Als je cel B12 selecteert, kun je de formule bekijken.
Calculate the totals for the other classes in the same way.
Figure 2.6 The totals in row 12
Quick Analysis
Select cells A4 to D11.Figure 2.7 Selecting
Figure 2.8 Right mouse button
Figure 2.9 Quick Analysis
Select A4 to D11 again.
Figure 2.10 Selecting
Figure 2.11 Chart
Figure 2.12 Resulting chart
Met Snelle analyse heb je meerdere manieren om gegevens inzichtelijk te maken.
Naast grafieken kun je ook sparklines toevoegen.
Make sure the data A4 to D11 is selected.
Again, use the right mouse button to choose Quick Analysis.
Now choose Sparklines; in this example, line has been selected.
Figure 2.13 Quick Analysis Sparkline
Figure 2.14 Result
