東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

Microsoft Excel functions quick refe...

Mehta, Mandeep.

Linked to FindBook

Google Book

Amazon

博客來

Microsoft Excel functions quick reference = for high-quality data analysis, dashboards, and more /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Microsoft Excel functions quick reference/ by Mandeep Mehta.
Reminder of title:	for high-quality data analysis, dashboards, and more /
Author:	Mehta, Mandeep.
Published:	Berkeley, CA :Apress : : 2021.,
Description:	xxix, 255 p. :ill., digital ;24 cm.
[NT 15003449]:	Chapter 1: What is an Excel function? -- Chapter 2: TEXT functions -- Chapter 3: DATE functions -- Chapter 4: TIME functions -- Chapter 5: Named Ranges and Excel Tables -- Chapter 6: LOOKUP & functions -- Chapter 7: AGGREGATE functions -- Chapter 8: LOGICAL functions -- Chapter 9: Maths functions -- Chapter 10: INFORMATION functions -- Chapter 11: Finance functions -- Chapter 12: Error Handling -- Chapter 13: Megaformulas -- Chapter 14: Array formula. Appendix A: Formula ready reckoner.
Contained By:	Springer Nature eBook
Subject:	Electronic spreadsheets. -
Online resource:	https://doi.org/10.1007/978-1-4842-6613-7
ISBN:	9781484266137

Microsoft Excel functions quick reference = for high-quality data analysis, dashboards, and more /
Mehta, Mandeep.

Microsoft Excel functions quick referencefor high-quality data analysis, dashboards, and more /[electronic resource] :by Mandeep Mehta. - Berkeley, CA :Apress :2021. - xxix, 255 p. :ill., digital ;24 cm.

Chapter 1: What is an Excel function? -- Chapter 2: TEXT functions -- Chapter 3: DATE functions -- Chapter 4: TIME functions -- Chapter 5: Named Ranges and Excel Tables -- Chapter 6: LOOKUP & functions -- Chapter 7: AGGREGATE functions -- Chapter 8: LOGICAL functions -- Chapter 9: Maths functions -- Chapter 10: INFORMATION functions -- Chapter 11: Finance functions -- Chapter 12: Error Handling -- Chapter 13: Megaformulas -- Chapter 14: Array formula. Appendix A: Formula ready reckoner.

This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates. The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples. With this book by your side, you'll always have the answer to your Excel function syntax questions. You will: Work with basic Excel functions Use the LOOKUP function Take advantage of new functions in information functions Create a mega formula.

ISBN: 9781484266137

Standard No.: 10.1007/978-1-4842-6613-7doiSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

533209
Electronic spreadsheets.

LC Class. No.: HF5548.4.M523 / M448 2021

Dewey Class. No.: 005.54

Microsoft Excel functions quick reference = for high-quality data analysis, dashboards, and more /
LDR:02774nmm a2200325 a 4500 001 2237778
003 DE-He213
005 20210630164149.0
006 m d
007 cr nn 008maaau
008 211111s2021 cau s 0 eng d
020 $a 9781484266137 $q (electronic bk.)
020 $a 9781484266120 $q (paper)
024 7 $a 10.1007/978-1-4842-6613-7 $2 doi
035 $a 978-1-4842-6613-7
040 $a GP $c GP
041 0 $a eng
050 4 $a HF5548.4.M523 $b M448 2021
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.54 $2 23
090 $a HF5548.4.M523 $b M498 2021
100 1 $a Mehta, Mandeep. $3 3490301
245 1 0 $a Microsoft Excel functions quick reference $h [electronic resource] : $b for high-quality data analysis, dashboards, and more / $c by Mandeep Mehta.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2021.
300 $a xxix, 255 p. : $b ill., digital ; $c 24 cm.
505 0 $a Chapter 1: What is an Excel function? -- Chapter 2: TEXT functions -- Chapter 3: DATE functions -- Chapter 4: TIME functions -- Chapter 5: Named Ranges and Excel Tables -- Chapter 6: LOOKUP & functions -- Chapter 7: AGGREGATE functions -- Chapter 8: LOGICAL functions -- Chapter 9: Maths functions -- Chapter 10: INFORMATION functions -- Chapter 11: Finance functions -- Chapter 12: Error Handling -- Chapter 13: Megaformulas -- Chapter 14: Array formula. Appendix A: Formula ready reckoner.
520 $a This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates. The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrated by helpful, illuminating examples. With this book by your side, you'll always have the answer to your Excel function syntax questions. You will: Work with basic Excel functions Use the LOOKUP function Take advantage of new functions in information functions Create a mega formula.
630 0 0 $a Microsoft Excel (Computer file) $3 543656 $3 543656
650 0 $a Electronic spreadsheets. $3 533209
650 1 4 $a Microsoft and .NET. $3 3134847
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-6613-7
950 $a Professional and Applied Computing (SpringerNature-12059)