Microsoft Excel Functions and Formulas, Sixth Edition : With Excel 2021 / Microsoft 365 /
In this completely updated edition covering Excel 2021, Microsoft 365, and previous versions, Microsoft Excel Functions and Formulas Sixth Edition demonstrates the secrets of Excel through the use of practical anduseful examples in a quick reference format. --
Saved in:
| Online Access: |
Full text (MCPHS users only) |
|---|---|
| Main Author: | |
| Other Authors: | , |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
[Place of publication not identified] :
Mercury Learning,
2022
|
| Edition: | Sixth Edition. |
| Series: | Office Essentials collection
|
| Subjects: | |
| Local Note: | ProQuest Ebook Central |
MARC
| LEADER | 00000cam a2200000ui 4500 | ||
|---|---|---|---|
| 001 | in00000149748 | ||
| 006 | m o d | ||
| 007 | cr mn |||||||| | ||
| 008 | 221116s2022 xx a ob 00| 0 eng d | ||
| 005 | 20240701204449.2 | ||
| 019 | |a 1336402018 |a 1370242908 | ||
| 020 | |z 9781683928539 | ||
| 020 | |z 1683928539 | ||
| 020 | |a 9781683928522 | ||
| 020 | |a 1683928520 | ||
| 020 | |a 9781683928515 |q (e-book) | ||
| 020 | |a 1683928512 | ||
| 035 | |a (OCoLC)1372504352 |z (OCoLC)1336402018 |z (OCoLC)1370242908 | ||
| 035 | |a (OCoLC)on1372504352 | ||
| 040 | |a K6U |b eng |e rda |e pn |c K6U |d OCLCF |d EBLCP |d UKAHL |d OCLCO |d OCLCQ | ||
| 050 | 1 | 4 | |a HF5548.4.M523 |b .M67 2022 |
| 082 | 0 | 4 | |a 005.54 |2 23 |
| 100 | 1 | |a Moriarty, Brian, |e author. | |
| 245 | 1 | 0 | |a Microsoft Excel Functions and Formulas, Sixth Edition : |b With Excel 2021 / Microsoft 365 / |c by Brian Moriarty, Bernd Held, Theodor Richardson. |
| 250 | |a Sixth Edition. | ||
| 264 | 1 | |a [Place of publication not identified] : |b Mercury Learning, |c 2022. | |
| 300 | |a 1 online resource (538 pages) : |b illustrations. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 0 | |a Office Essentials collection | |
| 504 | |a Includes bibliographical references. | ||
| 505 | 0 | |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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a In this completely updated edition covering Excel 2021, Microsoft 365, and previous versions, Microsoft Excel Functions and Formulas Sixth Edition demonstrates the secrets of Excel through the use of practical anduseful examples in a quick reference format. -- |c Edited summary from book. | ||
| 588 | 0 | |a Online resource; title from title screen (Skillsoft Books). | |
| 590 | |a ProQuest Ebook Central |b Ebook Central College Complete | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Electronic spreadsheets. | |
| 650 | 0 | |a Visual programming (Computer science) | |
| 700 | 1 | |a Held, Bernd. | |
| 700 | 1 | |a Richardson, Theodor. | |
| 776 | 0 | 8 | |i Print version: |a Moriarty, Brian |t Microsoft Excel Functions and Formulas |d Bloomfield : Mercury Learning & Information,c2022 |z 9781683928539 |
| 852 | |b E-Collections |h ProQuest | ||
| 856 | 4 | 0 | |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=7025295 |z Full text (MCPHS users only) |t 0 |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL30807784 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL7025295 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH40900839 | ||
| 947 | |a FLO |x pq-ebc-base | ||
| 999 | f | f | |s 505ff49f-9912-495d-9f60-73f8f3e1336c |i b0bcd2c4-bcd9-4965-835e-db259d8dbb4b |t 0 |
| 952 | f | f | |a Massachusetts College of Pharmacy and Health Sciences |b Online |c Online |d E-Collections |t 0 |e ProQuest |h Other scheme |
| 856 | 4 | 0 | |t 0 |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=7025295 |y Full text (MCPHS users only) |
