Oppiskele Yleiskatsaus | Haku ja Viittaus

Onnittelut Excel-kaavojen suorittamisesta! 🎉


	Matemaattiset kaavat
SUM		`=SUM(range)` - Adds all the numbers in a range of cells
MULTIPLY		`=A1 * B1` - Multiplies the values in cells A1 and B1
SUBTRACT		`=A1 - B1` - Subtracts the value in cell B1 from the value in cell A1
DIVIDE		`=A1 / B1` - Divides the value in cell A1 by the value in cell B1
	Tilastolliset kaavat
MEAN		`=AVERAGE(range)` - Calculates the average of a range of numbers
MAX		`=MAX(range)` - Returns the maximum value in a range of numbers
MIN		`=MIN(range)` - Returns the minimum value in a range of numbers
AVERAGE		`=AVERAGE(range)` - Calculates the average of a range of numbers
MEDIAN		`=MEDIAN(range)` - Returns the median of a range of numbers
	Haku- ja viitekaavat
MATCH		`=MATCH(lookup_value, lookup_array, [match_type])` - Finds the position of a value in a range
CHOOSE		`=CHOOSE(index_num, value1, [value2], ...)` - Chooses a value from a list based on an index number
INDIRECT		`=INDIRECT(ref_text, [a1])` - Returns the reference specified by a text string
VLOOKUP		`=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])` - Looks up a value in the first column of a table and returns a value in the same row from a specified column
XLOOKUP		`=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])` - Searches a range or an array, and returns an item corresponding to the first match it finds
	Array-kaavat
UNIQUE		`=UNIQUE(range)` - Extracts unique values from a range
SORT		`=SORT(range)` - Sorts the contents of a range
FILTER		`=FILTER(range, condition)` - Filters a range based on a condition
TRANSPOSE		`=TRANSPOSE(range)` - Transposes the rows and columns of a range

Tämä ei tietenkään ole kaikki, mitä Excel voi tarjota, mutta nyt olet oppinut kaavojen perusteet sekä suosituimmat kaavat ja niiden toiminnan. Näillä pystyt ratkaisemaan 80 % ongelmista ja päivittäisistä tehtävistä.

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 5

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Awesome!

Completion rate improved to 6.67

Pyyhkäise näyttääksesi valikon

Onnittelut Excel-kaavojen suorittamisesta! 🎉


	Matemaattiset kaavat
SUM		`=SUM(range)` - Adds all the numbers in a range of cells
MULTIPLY		`=A1 * B1` - Multiplies the values in cells A1 and B1
SUBTRACT		`=A1 - B1` - Subtracts the value in cell B1 from the value in cell A1
DIVIDE		`=A1 / B1` - Divides the value in cell A1 by the value in cell B1
	Tilastolliset kaavat
MEAN		`=AVERAGE(range)` - Calculates the average of a range of numbers
MAX		`=MAX(range)` - Returns the maximum value in a range of numbers
MIN		`=MIN(range)` - Returns the minimum value in a range of numbers
AVERAGE		`=AVERAGE(range)` - Calculates the average of a range of numbers
MEDIAN		`=MEDIAN(range)` - Returns the median of a range of numbers
	Haku- ja viitekaavat
MATCH		`=MATCH(lookup_value, lookup_array, [match_type])` - Finds the position of a value in a range
CHOOSE		`=CHOOSE(index_num, value1, [value2], ...)` - Chooses a value from a list based on an index number
INDIRECT		`=INDIRECT(ref_text, [a1])` - Returns the reference specified by a text string
VLOOKUP		`=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])` - Looks up a value in the first column of a table and returns a value in the same row from a specified column
XLOOKUP		`=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])` - Searches a range or an array, and returns an item corresponding to the first match it finds
	Array-kaavat
UNIQUE		`=UNIQUE(range)` - Extracts unique values from a range
SORT		`=SORT(range)` - Sorts the contents of a range
FILTER		`=FILTER(range, condition)` - Filters a range based on a condition
TRANSPOSE		`=TRANSPOSE(range)` - Transposes the rows and columns of a range

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 5