How to create a table in excel?
Highlight data range in worksheet
insert -> table ; Ctr. + T
Ok
What is the result of a tablet?
filter is added to title row
automatic table format
table border turns blue
structured cell references
How to insert a total row?
Highlight last row of a list
right mouse button
table -> total row
What means DCOUNT?
counts the number of cells with numeric entries in a field of the database that match the criteria you specify
What means DCOUNTA?
Counts the number of nonblank cells in a filed of the database that match the criteria you specify
What means DGET?
Extracts a single value form a record in the database that matches the criteria you specify.
If no record matches: #VALUE
If multiple records match: #NUM
What does DSTEV mean?
Estimates the standard deviation based on the sample of values in a field of the database that march the criteria you specify
What does DVAR and DVARP mean?
Estimates the variance based on the sample of values in a field of the database that match the criteria you specify
Estimates the variance based on the population of values in a field of the database that match the criteria ypu specify
How to create a pivot Tablet?
highlight data range
insert -> pivot table
ok
How to open the slicer?
pivot-table Tools
Analyze
Insert Slicer
How to change the design of a pivot table?
right mouse click on table
pivot table options
How to create a table?
Insert -> table, Ctr. + T
OK
How to custom sort a table?
home
editing
sort and filter
custom sort
How to select an entire column?
Ctr. + spacebar
How to select an entire row?
Shift + spacebar
If you enter data into a cell in the column to the right of the table, what happens to your table?
transforms automatically into a table
Why does this not work, if you enter data in the row below your table and how to do it?
because of the sum row
-> add row above or below
How does database functions work?
Funktion (Field, Kriterien (mehrere möglich, beginnend bei Field und passendes Kriterium))
Last changed2 years ago