Microsoft Excel Functions and Formulas: With Excel 2021 / Microsoft 365
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Herndon, VA
Mercury Learning & Information
2022
|
| Ausgabe: | 6th ed |
| Schlagworte: | |
| Online-Zugang: | DE-2070s |
| Beschreibung: | Description based on publisher supplied metadata and other sources |
| Beschreibung: | 1 Online-Ressource (569 Seiten) |
| ISBN: | 9781683928522 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV050102132 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 241218s2022 xx o|||| 00||| eng d | ||
| 020 | |a 9781683928522 |9 978-1-68392-852-2 | ||
| 035 | |a (ZDB-30-PQE)EBC30807784 | ||
| 035 | |a (ZDB-30-PAD)EBC30807784 | ||
| 035 | |a (ZDB-89-EBL)EBL30807784 | ||
| 035 | |a (OCoLC)1372504352 | ||
| 035 | |a (DE-599)BVBBV050102132 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 005.54 | |
| 100 | 1 | |a Moriarty, Brian |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Microsoft Excel Functions and Formulas |b With Excel 2021 / Microsoft 365 |
| 250 | |a 6th ed | ||
| 264 | 1 | |a Herndon, VA |b Mercury Learning & Information |c 2022 | |
| 264 | 4 | |c ©2022 | |
| 300 | |a 1 Online-Ressource (569 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Cover -- Half-Title -- Title -- Copyright -- Contents -- Acknowledgments -- Introduction -- Chapter 1: Formulas in Excel -- Calculate production per hour -- Calculate the age of a person in days -- Calculate a price reduction -- Convert currency -- Convert from hours to minutes -- Determine fuel consumption -- Calculate your ideal and recommended weights -- The quick calendar -- Design your own to-do list -- Increment row numbers -- Convert negative values to positive -- Calculate sales taxes -- Combine text and numbers -- Combine text and date -- Combine text and time -- Generate a special ranking list -- Determine average output -- Determine stock gains and losses -- Evaluate profitability -- Determine percentage of completion -- Convert miles per hour to kilometers per hour -- Convert feet per minute to meters per second -- Convert liters to barrels, gallons, quarts, and pints -- Convert from Fahrenheit to Celsius -- Convert from Celsius to Fahrenheit -- Calculate total with percentage -- Monitor the daily production plan -- Calculate the number of hours between two dates -- Determine the price per pound -- Determine how many pieces to put in a box -- Calculate the number of employees required for a project -- Distribute sales -- Calculate your net income -- Calculate the percentage of price reduction -- Divide and double every three hours -- Calculate the average speed -- Calculate number of characters in a string -- Chapter 2: Logical Functions -- Use the AND function to compare two columns -- Use the AND function to show sales for a specific period of time -- Use the OR function to check cells for text -- Use the OR function to check cells for numbers -- Use the XOR function to check for mutually exclusive conditions -- Use the IF function to compare columns and return a specific result | |
| 505 | 8 | |a Use the IF function to check for larger, equivalent, or smaller values -- Combine IF with AND to check several conditions -- Use the IF function to determine the quarter of a year -- Use the IF function to check cells in worksheets and workbooks -- Use the IF function to calculate with different tax rates -- Use the IF function to calculate the commissions for individual sales -- Use the IFS function to calculate the commissions for individual sales -- Use the IF function to compare two cells -- Use the IFS function to compare two cells -- Use the SWITCH function to compare two cells -- Use the INT function with the IF function -- Use the TYPE function to check for invalid values -- Use nested IF functions to cover multiple possibilities -- Use IFS function to cover multiple possibilities -- Use SWITCH function to cover multiple possibilities -- Use the IF function to check whether a date is in the past or the future -- Use the IF function to create your own timesheet -- Use the IFERROR function to display a default -- Chapter 3: Text Functions -- Use the LEFT and RIGHT functions to separate a text string of numbers -- Use the LEFT function to convert invalid numbers to valid numbers -- Use the SEARCH function to separate first name from last name -- Use the MID function to separate last name from first name -- Use the MID function to sum the digits of a number -- Use the EXACT function to compare two columns -- Use the SUBSTITUTE function to substitute characters -- Use the SUBSTITUTE function to substitute parts of a cell -- Use the SUBSTITUTE function to convert numbers to words -- Use the SUBSTITUTE function to remove word wrapping in cells -- Use the SUBSTITUTE function to combine and separate columns -- Use the REPLACE function to replace and calculate -- Use the FIND function to combine text and date | |
| 505 | 8 | |a Use the UPPER function to convert text from lowercase to uppercase -- Use the LOWER function to convert text from uppercase to lowercase -- Use the PROPER function to convert initial characters from lowercase to uppercase -- Use the FIXED function to round and convert numbers to text -- Use the TRIM function to delete spaces -- Use the TRIM function to convert "text-numbers" to real numbers -- Use the CLEAN function to remove all non-printable characters -- Use the REPT function to show data in graphic mode -- Use the REPT function to show data in a chart -- Use the CHAR function to check your fonts -- Use the CHAR function to determine special characters -- Use the CODE function to determine the numeric code of a character -- Use the UNICHAR function to determine the Unicode character from a number -- Use the UNICODE function to determine the numeric Unicode value of a character -- Use the DOLLAR function to convert numbers to currency in text format -- Use the T function to check for valid numbers -- Use the TEXT function to combine and format text -- Use CONCATENATE function to combine text -- Use CONCAT function to combine text -- Use TEXTJOIN function to combine text -- Use ARRAYTOTEXT function to combine text -- Use VALUETOTEXT function to display text from any cell value -- Chapter 4: Date and Time Functions -- Use custom formatting to display the day of the week -- Use the WEEKDAY function to determine the weekend -- Use the TODAY function to check for future dates -- Use the TEXT function to calculate with the TODAY function -- Use the NOW function to show the current time -- Use the NOW function to calculate time -- Use the DATE function to combine columns with date parts -- Use the LEFT, MID, and RIGHT functions to extract date parts -- Use the TEXT function to extract date parts | |
| 505 | 8 | |a Use the DATEVALUE function to recalculate dates formatted as text -- Use the YEAR function to extract the year part of a date -- Use the MONTH function to extract the month part of a date -- Use the DAY function to extract the day part of a date -- Use the MONTH and DAY functions to sort birthdays by month -- Use the DATE function to add months to a date -- Use the EOMONTH function to determine the last day of a month -- Use the DAYS360 function to calculate with a 360-day year -- Use the WEEKDAY function to calculate with different hourly pay rates -- Use the WEEKNUM function to determine the week number -- Use the EDATE function to calculate months -- Use the WORKDAY function to calculate workdays -- Use the NETWORKDAYS function to determine the number of workdays -- Use the YEARFRAC function to calculate ages of employees -- Use the DATEDIF function to calculate ages of employees -- Use the WEEKDAY function to calculate the weeks of Advent -- Use the TIMEVALUE function to convert text to time -- Use a custom format to create a time format -- Use the HOUR function to calculate with 100-minute hours -- Use the TIME function to combine single time parts -- Chapter 5: Basic Statistical Functions -- Use the MAX function to determine the largest value in a range -- Use the MIN function to discover the lowest sales volume for a month -- Use the MINIFS function to discover the lowest sales volume for a month based on criteria -- Use the MAXIFS function to discover the highest sales volume for a month based on criteria -- Use the MIN function to detect the smallest value in a column -- Use the SMALL function to find the smallest values in a list -- Use the LARGE function to find the highest values -- Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson | |
| 505 | 8 | |a Use the SMALL function to compare prices and select the cheapest offer -- Use the AVERAGE function to calculate the average output -- Use the SUBTOTAL function to sum a filtered list -- Use the COUNT function to count cells containing numeric data -- Use the COUNTA function to count cells containing data -- Use the COUNTA function to count cells containing text -- Use the COUNTBLANK function to count empty cells -- Use the COUNTA function to determine the last filled row -- Use the SUBTOTAL function to count rows in filtered lists -- Use the RANK, RANK.EQ, RANK.AVG functions to determine the rank of sales -- Use the MEDIAN function to calculate the median sales -- Use the QUARTILE, QUARTILE.INC, QUARTILE.EXC functions to calculate quartiles -- Use the STDEV, STDEV.S, STDEV.P functions to determine the standard deviation -- Use the FORECAST.LINEAR function to determine future values -- Use the FORECAST.ETS function to determine future values -- Use the FORECAST.ETS.CONFINT function to determine confidence in future values -- Use the FORECAST.ETS.SEASONALITY function to future value patterns -- Use the CORREL function to determine data correlation -- Use the AVERAGE, GEOMEAN, HARMEAN, TRIMMEAN to determine meaningful averages -- Chapter 6: Mathematical Functions -- Use the SUM function to sum a range -- Use the SUM function to sum several ranges -- Use the SUMIF function to determine sales of a team -- Use the SUMIF function to sum costs higher than 1,000 -- Use the SUMIF function to sum costs up to a certain date -- Use the COUNTIF function to count phases that cost more than 1,000 -- Use the COUNTIF function to calculate an attendance list -- Use the SUMPRODUCT function to calculate the value of the inventory -- Use the SUMPRODUCT function to sum sales of a team -- Use the SUMPRODUCT function to multiply and sum at the same time | |
| 505 | 8 | |a Use the ROUND function to round numbers | |
| 650 | 4 | |a Electronic spreadsheets | |
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 650 | 4 | |a Visual programming (Computer science) | |
| 700 | 1 | |a Held, Bernd |e Sonstige |4 oth | |
| 700 | 1 | |a Richardson, Theodor |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Moriarty, Brian |t Microsoft Excel Functions and Formulas |d Herndon, VA : Mercury Learning & Information,c2022 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035439294 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=30807784 |l DE-2070s |p ZDB-30-PQE |q HWR_PDA_PQE |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1818806144491061248 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Moriarty, Brian |
| author_facet | Moriarty, Brian |
| author_role | aut |
| author_sort | Moriarty, Brian |
| author_variant | b m bm |
| building | Verbundindex |
| bvnumber | BV050102132 |
| collection | ZDB-30-PQE |
| contents | Cover -- Half-Title -- Title -- Copyright -- Contents -- Acknowledgments -- Introduction -- Chapter 1: Formulas in Excel -- Calculate production per hour -- Calculate the age of a person in days -- Calculate a price reduction -- Convert currency -- Convert from hours to minutes -- Determine fuel consumption -- Calculate your ideal and recommended weights -- The quick calendar -- Design your own to-do list -- Increment row numbers -- Convert negative values to positive -- Calculate sales taxes -- Combine text and numbers -- Combine text and date -- Combine text and time -- Generate a special ranking list -- Determine average output -- Determine stock gains and losses -- Evaluate profitability -- Determine percentage of completion -- Convert miles per hour to kilometers per hour -- Convert feet per minute to meters per second -- Convert liters to barrels, gallons, quarts, and pints -- Convert from Fahrenheit to Celsius -- Convert from Celsius to Fahrenheit -- Calculate total with percentage -- Monitor the daily production plan -- Calculate the number of hours between two dates -- Determine the price per pound -- Determine how many pieces to put in a box -- Calculate the number of employees required for a project -- Distribute sales -- Calculate your net income -- Calculate the percentage of price reduction -- Divide and double every three hours -- Calculate the average speed -- Calculate number of characters in a string -- Chapter 2: Logical Functions -- Use the AND function to compare two columns -- Use the AND function to show sales for a specific period of time -- Use the OR function to check cells for text -- Use the OR function to check cells for numbers -- Use the XOR function to check for mutually exclusive conditions -- Use the IF function to compare columns and return a specific result Use the IF function to check for larger, equivalent, or smaller values -- Combine IF with AND to check several conditions -- Use the IF function to determine the quarter of a year -- Use the IF function to check cells in worksheets and workbooks -- Use the IF function to calculate with different tax rates -- Use the IF function to calculate the commissions for individual sales -- Use the IFS function to calculate the commissions for individual sales -- Use the IF function to compare two cells -- Use the IFS function to compare two cells -- Use the SWITCH function to compare two cells -- Use the INT function with the IF function -- Use the TYPE function to check for invalid values -- Use nested IF functions to cover multiple possibilities -- Use IFS function to cover multiple possibilities -- Use SWITCH function to cover multiple possibilities -- Use the IF function to check whether a date is in the past or the future -- Use the IF function to create your own timesheet -- Use the IFERROR function to display a default -- Chapter 3: Text Functions -- Use the LEFT and RIGHT functions to separate a text string of numbers -- Use the LEFT function to convert invalid numbers to valid numbers -- Use the SEARCH function to separate first name from last name -- Use the MID function to separate last name from first name -- Use the MID function to sum the digits of a number -- Use the EXACT function to compare two columns -- Use the SUBSTITUTE function to substitute characters -- Use the SUBSTITUTE function to substitute parts of a cell -- Use the SUBSTITUTE function to convert numbers to words -- Use the SUBSTITUTE function to remove word wrapping in cells -- Use the SUBSTITUTE function to combine and separate columns -- Use the REPLACE function to replace and calculate -- Use the FIND function to combine text and date Use the UPPER function to convert text from lowercase to uppercase -- Use the LOWER function to convert text from uppercase to lowercase -- Use the PROPER function to convert initial characters from lowercase to uppercase -- Use the FIXED function to round and convert numbers to text -- Use the TRIM function to delete spaces -- Use the TRIM function to convert "text-numbers" to real numbers -- Use the CLEAN function to remove all non-printable characters -- Use the REPT function to show data in graphic mode -- Use the REPT function to show data in a chart -- Use the CHAR function to check your fonts -- Use the CHAR function to determine special characters -- Use the CODE function to determine the numeric code of a character -- Use the UNICHAR function to determine the Unicode character from a number -- Use the UNICODE function to determine the numeric Unicode value of a character -- Use the DOLLAR function to convert numbers to currency in text format -- Use the T function to check for valid numbers -- Use the TEXT function to combine and format text -- Use CONCATENATE function to combine text -- Use CONCAT function to combine text -- Use TEXTJOIN function to combine text -- Use ARRAYTOTEXT function to combine text -- Use VALUETOTEXT function to display text from any cell value -- Chapter 4: Date and Time Functions -- Use custom formatting to display the day of the week -- Use the WEEKDAY function to determine the weekend -- Use the TODAY function to check for future dates -- Use the TEXT function to calculate with the TODAY function -- Use the NOW function to show the current time -- Use the NOW function to calculate time -- Use the DATE function to combine columns with date parts -- Use the LEFT, MID, and RIGHT functions to extract date parts -- Use the TEXT function to extract date parts Use the DATEVALUE function to recalculate dates formatted as text -- Use the YEAR function to extract the year part of a date -- Use the MONTH function to extract the month part of a date -- Use the DAY function to extract the day part of a date -- Use the MONTH and DAY functions to sort birthdays by month -- Use the DATE function to add months to a date -- Use the EOMONTH function to determine the last day of a month -- Use the DAYS360 function to calculate with a 360-day year -- Use the WEEKDAY function to calculate with different hourly pay rates -- Use the WEEKNUM function to determine the week number -- Use the EDATE function to calculate months -- Use the WORKDAY function to calculate workdays -- Use the NETWORKDAYS function to determine the number of workdays -- Use the YEARFRAC function to calculate ages of employees -- Use the DATEDIF function to calculate ages of employees -- Use the WEEKDAY function to calculate the weeks of Advent -- Use the TIMEVALUE function to convert text to time -- Use a custom format to create a time format -- Use the HOUR function to calculate with 100-minute hours -- Use the TIME function to combine single time parts -- Chapter 5: Basic Statistical Functions -- Use the MAX function to determine the largest value in a range -- Use the MIN function to discover the lowest sales volume for a month -- Use the MINIFS function to discover the lowest sales volume for a month based on criteria -- Use the MAXIFS function to discover the highest sales volume for a month based on criteria -- Use the MIN function to detect the smallest value in a column -- Use the SMALL function to find the smallest values in a list -- Use the LARGE function to find the highest values -- Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson Use the SMALL function to compare prices and select the cheapest offer -- Use the AVERAGE function to calculate the average output -- Use the SUBTOTAL function to sum a filtered list -- Use the COUNT function to count cells containing numeric data -- Use the COUNTA function to count cells containing data -- Use the COUNTA function to count cells containing text -- Use the COUNTBLANK function to count empty cells -- Use the COUNTA function to determine the last filled row -- Use the SUBTOTAL function to count rows in filtered lists -- Use the RANK, RANK.EQ, RANK.AVG functions to determine the rank of sales -- Use the MEDIAN function to calculate the median sales -- Use the QUARTILE, QUARTILE.INC, QUARTILE.EXC functions to calculate quartiles -- Use the STDEV, STDEV.S, STDEV.P functions to determine the standard deviation -- Use the FORECAST.LINEAR function to determine future values -- Use the FORECAST.ETS function to determine future values -- Use the FORECAST.ETS.CONFINT function to determine confidence in future values -- Use the FORECAST.ETS.SEASONALITY function to future value patterns -- Use the CORREL function to determine data correlation -- Use the AVERAGE, GEOMEAN, HARMEAN, TRIMMEAN to determine meaningful averages -- Chapter 6: Mathematical Functions -- Use the SUM function to sum a range -- Use the SUM function to sum several ranges -- Use the SUMIF function to determine sales of a team -- Use the SUMIF function to sum costs higher than 1,000 -- Use the SUMIF function to sum costs up to a certain date -- Use the COUNTIF function to count phases that cost more than 1,000 -- Use the COUNTIF function to calculate an attendance list -- Use the SUMPRODUCT function to calculate the value of the inventory -- Use the SUMPRODUCT function to sum sales of a team -- Use the SUMPRODUCT function to multiply and sum at the same time Use the ROUND function to round numbers |
| ctrlnum | (ZDB-30-PQE)EBC30807784 (ZDB-30-PAD)EBC30807784 (ZDB-89-EBL)EBL30807784 (OCoLC)1372504352 (DE-599)BVBBV050102132 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 6th ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000zc 4500</leader><controlfield tag="001">BV050102132</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">241218s2022 xx o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781683928522</subfield><subfield code="9">978-1-68392-852-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC30807784</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC30807784</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL30807784</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1372504352</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV050102132</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-2070s</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Moriarty, Brian</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Excel Functions and Formulas</subfield><subfield code="b">With Excel 2021 / Microsoft 365</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">6th ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Herndon, VA</subfield><subfield code="b">Mercury Learning & Information</subfield><subfield code="c">2022</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2022</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (569 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Half-Title -- Title -- Copyright -- Contents -- Acknowledgments -- Introduction -- Chapter 1: Formulas in Excel -- Calculate production per hour -- Calculate the age of a person in days -- Calculate a price reduction -- Convert currency -- Convert from hours to minutes -- Determine fuel consumption -- Calculate your ideal and recommended weights -- The quick calendar -- Design your own to-do list -- Increment row numbers -- Convert negative values to positive -- Calculate sales taxes -- Combine text and numbers -- Combine text and date -- Combine text and time -- Generate a special ranking list -- Determine average output -- Determine stock gains and losses -- Evaluate profitability -- Determine percentage of completion -- Convert miles per hour to kilometers per hour -- Convert feet per minute to meters per second -- Convert liters to barrels, gallons, quarts, and pints -- Convert from Fahrenheit to Celsius -- Convert from Celsius to Fahrenheit -- Calculate total with percentage -- Monitor the daily production plan -- Calculate the number of hours between two dates -- Determine the price per pound -- Determine how many pieces to put in a box -- Calculate the number of employees required for a project -- Distribute sales -- Calculate your net income -- Calculate the percentage of price reduction -- Divide and double every three hours -- Calculate the average speed -- Calculate number of characters in a string -- Chapter 2: Logical Functions -- Use the AND function to compare two columns -- Use the AND function to show sales for a specific period of time -- Use the OR function to check cells for text -- Use the OR function to check cells for numbers -- Use the XOR function to check for mutually exclusive conditions -- Use the IF function to compare columns and return a specific result</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Use the IF function to check for larger, equivalent, or smaller values -- Combine IF with AND to check several conditions -- Use the IF function to determine the quarter of a year -- Use the IF function to check cells in worksheets and workbooks -- Use the IF function to calculate with different tax rates -- Use the IF function to calculate the commissions for individual sales -- Use the IFS function to calculate the commissions for individual sales -- Use the IF function to compare two cells -- Use the IFS function to compare two cells -- Use the SWITCH function to compare two cells -- Use the INT function with the IF function -- Use the TYPE function to check for invalid values -- Use nested IF functions to cover multiple possibilities -- Use IFS function to cover multiple possibilities -- Use SWITCH function to cover multiple possibilities -- Use the IF function to check whether a date is in the past or the future -- Use the IF function to create your own timesheet -- Use the IFERROR function to display a default -- Chapter 3: Text Functions -- Use the LEFT and RIGHT functions to separate a text string of numbers -- Use the LEFT function to convert invalid numbers to valid numbers -- Use the SEARCH function to separate first name from last name -- Use the MID function to separate last name from first name -- Use the MID function to sum the digits of a number -- Use the EXACT function to compare two columns -- Use the SUBSTITUTE function to substitute characters -- Use the SUBSTITUTE function to substitute parts of a cell -- Use the SUBSTITUTE function to convert numbers to words -- Use the SUBSTITUTE function to remove word wrapping in cells -- Use the SUBSTITUTE function to combine and separate columns -- Use the REPLACE function to replace and calculate -- Use the FIND function to combine text and date</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Use the UPPER function to convert text from lowercase to uppercase -- Use the LOWER function to convert text from uppercase to lowercase -- Use the PROPER function to convert initial characters from lowercase to uppercase -- Use the FIXED function to round and convert numbers to text -- Use the TRIM function to delete spaces -- Use the TRIM function to convert "text-numbers" to real numbers -- Use the CLEAN function to remove all non-printable characters -- Use the REPT function to show data in graphic mode -- Use the REPT function to show data in a chart -- Use the CHAR function to check your fonts -- Use the CHAR function to determine special characters -- Use the CODE function to determine the numeric code of a character -- Use the UNICHAR function to determine the Unicode character from a number -- Use the UNICODE function to determine the numeric Unicode value of a character -- Use the DOLLAR function to convert numbers to currency in text format -- Use the T function to check for valid numbers -- Use the TEXT function to combine and format text -- Use CONCATENATE function to combine text -- Use CONCAT function to combine text -- Use TEXTJOIN function to combine text -- Use ARRAYTOTEXT function to combine text -- Use VALUETOTEXT function to display text from any cell value -- Chapter 4: Date and Time Functions -- Use custom formatting to display the day of the week -- Use the WEEKDAY function to determine the weekend -- Use the TODAY function to check for future dates -- Use the TEXT function to calculate with the TODAY function -- Use the NOW function to show the current time -- Use the NOW function to calculate time -- Use the DATE function to combine columns with date parts -- Use the LEFT, MID, and RIGHT functions to extract date parts -- Use the TEXT function to extract date parts</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Use the DATEVALUE function to recalculate dates formatted as text -- Use the YEAR function to extract the year part of a date -- Use the MONTH function to extract the month part of a date -- Use the DAY function to extract the day part of a date -- Use the MONTH and DAY functions to sort birthdays by month -- Use the DATE function to add months to a date -- Use the EOMONTH function to determine the last day of a month -- Use the DAYS360 function to calculate with a 360-day year -- Use the WEEKDAY function to calculate with different hourly pay rates -- Use the WEEKNUM function to determine the week number -- Use the EDATE function to calculate months -- Use the WORKDAY function to calculate workdays -- Use the NETWORKDAYS function to determine the number of workdays -- Use the YEARFRAC function to calculate ages of employees -- Use the DATEDIF function to calculate ages of employees -- Use the WEEKDAY function to calculate the weeks of Advent -- Use the TIMEVALUE function to convert text to time -- Use a custom format to create a time format -- Use the HOUR function to calculate with 100-minute hours -- Use the TIME function to combine single time parts -- Chapter 5: Basic Statistical Functions -- Use the MAX function to determine the largest value in a range -- Use the MIN function to discover the lowest sales volume for a month -- Use the MINIFS function to discover the lowest sales volume for a month based on criteria -- Use the MAXIFS function to discover the highest sales volume for a month based on criteria -- Use the MIN function to detect the smallest value in a column -- Use the SMALL function to find the smallest values in a list -- Use the LARGE function to find the highest values -- Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Use the SMALL function to compare prices and select the cheapest offer -- Use the AVERAGE function to calculate the average output -- Use the SUBTOTAL function to sum a filtered list -- Use the COUNT function to count cells containing numeric data -- Use the COUNTA function to count cells containing data -- Use the COUNTA function to count cells containing text -- Use the COUNTBLANK function to count empty cells -- Use the COUNTA function to determine the last filled row -- Use the SUBTOTAL function to count rows in filtered lists -- Use the RANK, RANK.EQ, RANK.AVG functions to determine the rank of sales -- Use the MEDIAN function to calculate the median sales -- Use the QUARTILE, QUARTILE.INC, QUARTILE.EXC functions to calculate quartiles -- Use the STDEV, STDEV.S, STDEV.P functions to determine the standard deviation -- Use the FORECAST.LINEAR function to determine future values -- Use the FORECAST.ETS function to determine future values -- Use the FORECAST.ETS.CONFINT function to determine confidence in future values -- Use the FORECAST.ETS.SEASONALITY function to future value patterns -- Use the CORREL function to determine data correlation -- Use the AVERAGE, GEOMEAN, HARMEAN, TRIMMEAN to determine meaningful averages -- Chapter 6: Mathematical Functions -- Use the SUM function to sum a range -- Use the SUM function to sum several ranges -- Use the SUMIF function to determine sales of a team -- Use the SUMIF function to sum costs higher than 1,000 -- Use the SUMIF function to sum costs up to a certain date -- Use the COUNTIF function to count phases that cost more than 1,000 -- Use the COUNTIF function to calculate an attendance list -- Use the SUMPRODUCT function to calculate the value of the inventory -- Use the SUMPRODUCT function to sum sales of a team -- Use the SUMPRODUCT function to multiply and sum at the same time</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Use the ROUND function to round numbers</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Visual programming (Computer science)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Held, Bernd</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Richardson, Theodor</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Moriarty, Brian</subfield><subfield code="t">Microsoft Excel Functions and Formulas</subfield><subfield code="d">Herndon, VA : Mercury Learning & Information,c2022</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-035439294</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=30807784</subfield><subfield code="l">DE-2070s</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">HWR_PDA_PQE</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV050102132 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-18T19:05:06Z |
| institution | BVB |
| isbn | 9781683928522 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035439294 |
| oclc_num | 1372504352 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | 1 Online-Ressource (569 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE HWR_PDA_PQE |
| publishDate | 2022 |
| publishDateSearch | 2022 |
| publishDateSort | 2022 |
| publisher | Mercury Learning & Information |
| record_format | marc |
| spelling | Moriarty, Brian Verfasser aut Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 6th ed Herndon, VA Mercury Learning & Information 2022 ©2022 1 Online-Ressource (569 Seiten) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources Cover -- Half-Title -- Title -- Copyright -- Contents -- Acknowledgments -- Introduction -- Chapter 1: Formulas in Excel -- Calculate production per hour -- Calculate the age of a person in days -- Calculate a price reduction -- Convert currency -- Convert from hours to minutes -- Determine fuel consumption -- Calculate your ideal and recommended weights -- The quick calendar -- Design your own to-do list -- Increment row numbers -- Convert negative values to positive -- Calculate sales taxes -- Combine text and numbers -- Combine text and date -- Combine text and time -- Generate a special ranking list -- Determine average output -- Determine stock gains and losses -- Evaluate profitability -- Determine percentage of completion -- Convert miles per hour to kilometers per hour -- Convert feet per minute to meters per second -- Convert liters to barrels, gallons, quarts, and pints -- Convert from Fahrenheit to Celsius -- Convert from Celsius to Fahrenheit -- Calculate total with percentage -- Monitor the daily production plan -- Calculate the number of hours between two dates -- Determine the price per pound -- Determine how many pieces to put in a box -- Calculate the number of employees required for a project -- Distribute sales -- Calculate your net income -- Calculate the percentage of price reduction -- Divide and double every three hours -- Calculate the average speed -- Calculate number of characters in a string -- Chapter 2: Logical Functions -- Use the AND function to compare two columns -- Use the AND function to show sales for a specific period of time -- Use the OR function to check cells for text -- Use the OR function to check cells for numbers -- Use the XOR function to check for mutually exclusive conditions -- Use the IF function to compare columns and return a specific result Use the IF function to check for larger, equivalent, or smaller values -- Combine IF with AND to check several conditions -- Use the IF function to determine the quarter of a year -- Use the IF function to check cells in worksheets and workbooks -- Use the IF function to calculate with different tax rates -- Use the IF function to calculate the commissions for individual sales -- Use the IFS function to calculate the commissions for individual sales -- Use the IF function to compare two cells -- Use the IFS function to compare two cells -- Use the SWITCH function to compare two cells -- Use the INT function with the IF function -- Use the TYPE function to check for invalid values -- Use nested IF functions to cover multiple possibilities -- Use IFS function to cover multiple possibilities -- Use SWITCH function to cover multiple possibilities -- Use the IF function to check whether a date is in the past or the future -- Use the IF function to create your own timesheet -- Use the IFERROR function to display a default -- Chapter 3: Text Functions -- Use the LEFT and RIGHT functions to separate a text string of numbers -- Use the LEFT function to convert invalid numbers to valid numbers -- Use the SEARCH function to separate first name from last name -- Use the MID function to separate last name from first name -- Use the MID function to sum the digits of a number -- Use the EXACT function to compare two columns -- Use the SUBSTITUTE function to substitute characters -- Use the SUBSTITUTE function to substitute parts of a cell -- Use the SUBSTITUTE function to convert numbers to words -- Use the SUBSTITUTE function to remove word wrapping in cells -- Use the SUBSTITUTE function to combine and separate columns -- Use the REPLACE function to replace and calculate -- Use the FIND function to combine text and date Use the UPPER function to convert text from lowercase to uppercase -- Use the LOWER function to convert text from uppercase to lowercase -- Use the PROPER function to convert initial characters from lowercase to uppercase -- Use the FIXED function to round and convert numbers to text -- Use the TRIM function to delete spaces -- Use the TRIM function to convert "text-numbers" to real numbers -- Use the CLEAN function to remove all non-printable characters -- Use the REPT function to show data in graphic mode -- Use the REPT function to show data in a chart -- Use the CHAR function to check your fonts -- Use the CHAR function to determine special characters -- Use the CODE function to determine the numeric code of a character -- Use the UNICHAR function to determine the Unicode character from a number -- Use the UNICODE function to determine the numeric Unicode value of a character -- Use the DOLLAR function to convert numbers to currency in text format -- Use the T function to check for valid numbers -- Use the TEXT function to combine and format text -- Use CONCATENATE function to combine text -- Use CONCAT function to combine text -- Use TEXTJOIN function to combine text -- Use ARRAYTOTEXT function to combine text -- Use VALUETOTEXT function to display text from any cell value -- Chapter 4: Date and Time Functions -- Use custom formatting to display the day of the week -- Use the WEEKDAY function to determine the weekend -- Use the TODAY function to check for future dates -- Use the TEXT function to calculate with the TODAY function -- Use the NOW function to show the current time -- Use the NOW function to calculate time -- Use the DATE function to combine columns with date parts -- Use the LEFT, MID, and RIGHT functions to extract date parts -- Use the TEXT function to extract date parts Use the DATEVALUE function to recalculate dates formatted as text -- Use the YEAR function to extract the year part of a date -- Use the MONTH function to extract the month part of a date -- Use the DAY function to extract the day part of a date -- Use the MONTH and DAY functions to sort birthdays by month -- Use the DATE function to add months to a date -- Use the EOMONTH function to determine the last day of a month -- Use the DAYS360 function to calculate with a 360-day year -- Use the WEEKDAY function to calculate with different hourly pay rates -- Use the WEEKNUM function to determine the week number -- Use the EDATE function to calculate months -- Use the WORKDAY function to calculate workdays -- Use the NETWORKDAYS function to determine the number of workdays -- Use the YEARFRAC function to calculate ages of employees -- Use the DATEDIF function to calculate ages of employees -- Use the WEEKDAY function to calculate the weeks of Advent -- Use the TIMEVALUE function to convert text to time -- Use a custom format to create a time format -- Use the HOUR function to calculate with 100-minute hours -- Use the TIME function to combine single time parts -- Chapter 5: Basic Statistical Functions -- Use the MAX function to determine the largest value in a range -- Use the MIN function to discover the lowest sales volume for a month -- Use the MINIFS function to discover the lowest sales volume for a month based on criteria -- Use the MAXIFS function to discover the highest sales volume for a month based on criteria -- Use the MIN function to detect the smallest value in a column -- Use the SMALL function to find the smallest values in a list -- Use the LARGE function to find the highest values -- Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson Use the SMALL function to compare prices and select the cheapest offer -- Use the AVERAGE function to calculate the average output -- Use the SUBTOTAL function to sum a filtered list -- Use the COUNT function to count cells containing numeric data -- Use the COUNTA function to count cells containing data -- Use the COUNTA function to count cells containing text -- Use the COUNTBLANK function to count empty cells -- Use the COUNTA function to determine the last filled row -- Use the SUBTOTAL function to count rows in filtered lists -- Use the RANK, RANK.EQ, RANK.AVG functions to determine the rank of sales -- Use the MEDIAN function to calculate the median sales -- Use the QUARTILE, QUARTILE.INC, QUARTILE.EXC functions to calculate quartiles -- Use the STDEV, STDEV.S, STDEV.P functions to determine the standard deviation -- Use the FORECAST.LINEAR function to determine future values -- Use the FORECAST.ETS function to determine future values -- Use the FORECAST.ETS.CONFINT function to determine confidence in future values -- Use the FORECAST.ETS.SEASONALITY function to future value patterns -- Use the CORREL function to determine data correlation -- Use the AVERAGE, GEOMEAN, HARMEAN, TRIMMEAN to determine meaningful averages -- Chapter 6: Mathematical Functions -- Use the SUM function to sum a range -- Use the SUM function to sum several ranges -- Use the SUMIF function to determine sales of a team -- Use the SUMIF function to sum costs higher than 1,000 -- Use the SUMIF function to sum costs up to a certain date -- Use the COUNTIF function to count phases that cost more than 1,000 -- Use the COUNTIF function to calculate an attendance list -- Use the SUMPRODUCT function to calculate the value of the inventory -- Use the SUMPRODUCT function to sum sales of a team -- Use the SUMPRODUCT function to multiply and sum at the same time Use the ROUND function to round numbers Electronic spreadsheets Microsoft Excel (Computer file) Visual programming (Computer science) Held, Bernd Sonstige oth Richardson, Theodor Sonstige oth Erscheint auch als Druck-Ausgabe Moriarty, Brian Microsoft Excel Functions and Formulas Herndon, VA : Mercury Learning & Information,c2022 |
| spellingShingle | Moriarty, Brian Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 Cover -- Half-Title -- Title -- Copyright -- Contents -- Acknowledgments -- Introduction -- Chapter 1: Formulas in Excel -- Calculate production per hour -- Calculate the age of a person in days -- Calculate a price reduction -- Convert currency -- Convert from hours to minutes -- Determine fuel consumption -- Calculate your ideal and recommended weights -- The quick calendar -- Design your own to-do list -- Increment row numbers -- Convert negative values to positive -- Calculate sales taxes -- Combine text and numbers -- Combine text and date -- Combine text and time -- Generate a special ranking list -- Determine average output -- Determine stock gains and losses -- Evaluate profitability -- Determine percentage of completion -- Convert miles per hour to kilometers per hour -- Convert feet per minute to meters per second -- Convert liters to barrels, gallons, quarts, and pints -- Convert from Fahrenheit to Celsius -- Convert from Celsius to Fahrenheit -- Calculate total with percentage -- Monitor the daily production plan -- Calculate the number of hours between two dates -- Determine the price per pound -- Determine how many pieces to put in a box -- Calculate the number of employees required for a project -- Distribute sales -- Calculate your net income -- Calculate the percentage of price reduction -- Divide and double every three hours -- Calculate the average speed -- Calculate number of characters in a string -- Chapter 2: Logical Functions -- Use the AND function to compare two columns -- Use the AND function to show sales for a specific period of time -- Use the OR function to check cells for text -- Use the OR function to check cells for numbers -- Use the XOR function to check for mutually exclusive conditions -- Use the IF function to compare columns and return a specific result Use the IF function to check for larger, equivalent, or smaller values -- Combine IF with AND to check several conditions -- Use the IF function to determine the quarter of a year -- Use the IF function to check cells in worksheets and workbooks -- Use the IF function to calculate with different tax rates -- Use the IF function to calculate the commissions for individual sales -- Use the IFS function to calculate the commissions for individual sales -- Use the IF function to compare two cells -- Use the IFS function to compare two cells -- Use the SWITCH function to compare two cells -- Use the INT function with the IF function -- Use the TYPE function to check for invalid values -- Use nested IF functions to cover multiple possibilities -- Use IFS function to cover multiple possibilities -- Use SWITCH function to cover multiple possibilities -- Use the IF function to check whether a date is in the past or the future -- Use the IF function to create your own timesheet -- Use the IFERROR function to display a default -- Chapter 3: Text Functions -- Use the LEFT and RIGHT functions to separate a text string of numbers -- Use the LEFT function to convert invalid numbers to valid numbers -- Use the SEARCH function to separate first name from last name -- Use the MID function to separate last name from first name -- Use the MID function to sum the digits of a number -- Use the EXACT function to compare two columns -- Use the SUBSTITUTE function to substitute characters -- Use the SUBSTITUTE function to substitute parts of a cell -- Use the SUBSTITUTE function to convert numbers to words -- Use the SUBSTITUTE function to remove word wrapping in cells -- Use the SUBSTITUTE function to combine and separate columns -- Use the REPLACE function to replace and calculate -- Use the FIND function to combine text and date Use the UPPER function to convert text from lowercase to uppercase -- Use the LOWER function to convert text from uppercase to lowercase -- Use the PROPER function to convert initial characters from lowercase to uppercase -- Use the FIXED function to round and convert numbers to text -- Use the TRIM function to delete spaces -- Use the TRIM function to convert "text-numbers" to real numbers -- Use the CLEAN function to remove all non-printable characters -- Use the REPT function to show data in graphic mode -- Use the REPT function to show data in a chart -- Use the CHAR function to check your fonts -- Use the CHAR function to determine special characters -- Use the CODE function to determine the numeric code of a character -- Use the UNICHAR function to determine the Unicode character from a number -- Use the UNICODE function to determine the numeric Unicode value of a character -- Use the DOLLAR function to convert numbers to currency in text format -- Use the T function to check for valid numbers -- Use the TEXT function to combine and format text -- Use CONCATENATE function to combine text -- Use CONCAT function to combine text -- Use TEXTJOIN function to combine text -- Use ARRAYTOTEXT function to combine text -- Use VALUETOTEXT function to display text from any cell value -- Chapter 4: Date and Time Functions -- Use custom formatting to display the day of the week -- Use the WEEKDAY function to determine the weekend -- Use the TODAY function to check for future dates -- Use the TEXT function to calculate with the TODAY function -- Use the NOW function to show the current time -- Use the NOW function to calculate time -- Use the DATE function to combine columns with date parts -- Use the LEFT, MID, and RIGHT functions to extract date parts -- Use the TEXT function to extract date parts Use the DATEVALUE function to recalculate dates formatted as text -- Use the YEAR function to extract the year part of a date -- Use the MONTH function to extract the month part of a date -- Use the DAY function to extract the day part of a date -- Use the MONTH and DAY functions to sort birthdays by month -- Use the DATE function to add months to a date -- Use the EOMONTH function to determine the last day of a month -- Use the DAYS360 function to calculate with a 360-day year -- Use the WEEKDAY function to calculate with different hourly pay rates -- Use the WEEKNUM function to determine the week number -- Use the EDATE function to calculate months -- Use the WORKDAY function to calculate workdays -- Use the NETWORKDAYS function to determine the number of workdays -- Use the YEARFRAC function to calculate ages of employees -- Use the DATEDIF function to calculate ages of employees -- Use the WEEKDAY function to calculate the weeks of Advent -- Use the TIMEVALUE function to convert text to time -- Use a custom format to create a time format -- Use the HOUR function to calculate with 100-minute hours -- Use the TIME function to combine single time parts -- Chapter 5: Basic Statistical Functions -- Use the MAX function to determine the largest value in a range -- Use the MIN function to discover the lowest sales volume for a month -- Use the MINIFS function to discover the lowest sales volume for a month based on criteria -- Use the MAXIFS function to discover the highest sales volume for a month based on criteria -- Use the MIN function to detect the smallest value in a column -- Use the SMALL function to find the smallest values in a list -- Use the LARGE function to find the highest values -- Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson Use the SMALL function to compare prices and select the cheapest offer -- Use the AVERAGE function to calculate the average output -- Use the SUBTOTAL function to sum a filtered list -- Use the COUNT function to count cells containing numeric data -- Use the COUNTA function to count cells containing data -- Use the COUNTA function to count cells containing text -- Use the COUNTBLANK function to count empty cells -- Use the COUNTA function to determine the last filled row -- Use the SUBTOTAL function to count rows in filtered lists -- Use the RANK, RANK.EQ, RANK.AVG functions to determine the rank of sales -- Use the MEDIAN function to calculate the median sales -- Use the QUARTILE, QUARTILE.INC, QUARTILE.EXC functions to calculate quartiles -- Use the STDEV, STDEV.S, STDEV.P functions to determine the standard deviation -- Use the FORECAST.LINEAR function to determine future values -- Use the FORECAST.ETS function to determine future values -- Use the FORECAST.ETS.CONFINT function to determine confidence in future values -- Use the FORECAST.ETS.SEASONALITY function to future value patterns -- Use the CORREL function to determine data correlation -- Use the AVERAGE, GEOMEAN, HARMEAN, TRIMMEAN to determine meaningful averages -- Chapter 6: Mathematical Functions -- Use the SUM function to sum a range -- Use the SUM function to sum several ranges -- Use the SUMIF function to determine sales of a team -- Use the SUMIF function to sum costs higher than 1,000 -- Use the SUMIF function to sum costs up to a certain date -- Use the COUNTIF function to count phases that cost more than 1,000 -- Use the COUNTIF function to calculate an attendance list -- Use the SUMPRODUCT function to calculate the value of the inventory -- Use the SUMPRODUCT function to sum sales of a team -- Use the SUMPRODUCT function to multiply and sum at the same time Use the ROUND function to round numbers Electronic spreadsheets Microsoft Excel (Computer file) Visual programming (Computer science) |
| title | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_auth | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_exact_search | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_full | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_fullStr | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_full_unstemmed | Microsoft Excel Functions and Formulas With Excel 2021 / Microsoft 365 |
| title_short | Microsoft Excel Functions and Formulas |
| title_sort | microsoft excel functions and formulas with excel 2021 microsoft 365 |
| title_sub | With Excel 2021 / Microsoft 365 |
| topic | Electronic spreadsheets Microsoft Excel (Computer file) Visual programming (Computer science) |
| topic_facet | Electronic spreadsheets Microsoft Excel (Computer file) Visual programming (Computer science) |
| work_keys_str_mv | AT moriartybrian microsoftexcelfunctionsandformulaswithexcel2021microsoft365 AT heldbernd microsoftexcelfunctionsandformulaswithexcel2021microsoft365 AT richardsontheodor microsoftexcelfunctionsandformulaswithexcel2021microsoft365 |