|
|
|
|
LEADER |
00000cam a2200000 a 4500 |
001 |
OR_on1229972874 |
003 |
OCoLC |
005 |
20231017213018.0 |
006 |
m o d |
007 |
cr |n||||||||| |
008 |
210110s2021 xxu o 001 0 eng d |
040 |
|
|
|a YDX
|b eng
|e pn
|c YDX
|d EBLCP
|d TOH
|d GW5XE
|d ERF
|d LDP
|d DCT
|d OCLCO
|d N$T
|d OCLCF
|d UKAHL
|d K6U
|d OCLCQ
|d OCLCO
|d OCLCQ
|d OCLCO
|
019 |
|
|
|a 1231611114
|a 1238201281
|a 1238205187
|a 1238205337
|
020 |
|
|
|a 9781484266137
|q (electronic bk.)
|
020 |
|
|
|a 1484266137
|q (electronic bk.)
|
020 |
|
|
|z 1484266129
|
020 |
|
|
|z 9781484266120
|
024 |
7 |
|
|a 10.1007/978-1-4842-6613-7
|2 doi
|
029 |
1 |
|
|a AU@
|b 000068589186
|
029 |
1 |
|
|a AU@
|b 000068857182
|
029 |
1 |
|
|a AU@
|b 000070277799
|
035 |
|
|
|a (OCoLC)1229972874
|z (OCoLC)1231611114
|z (OCoLC)1238201281
|z (OCoLC)1238205187
|z (OCoLC)1238205337
|
037 |
|
|
|b Springer
|
050 |
|
4 |
|a HF5548.4.M523
|
072 |
|
7 |
|a COM051380
|2 bisacsh
|
072 |
|
7 |
|a UMP.
|2 bicssc
|
072 |
|
7 |
|a UMP.
|2 thema
|
082 |
0 |
4 |
|a 005.54
|2 23
|
049 |
|
|
|a UAMI
|
100 |
1 |
|
|a Mehta, Mandeep.
|
245 |
1 |
0 |
|a Microsoft Excel functions quick reference :
|b for high-quality data analysis, dashboards, and more /
|c Mandeep Mehta.
|
260 |
|
|
|a [United States] :
|b Apress,
|c 2021.
|
300 |
|
|
|a 1 online resource
|
336 |
|
|
|a text
|b txt
|2 rdacontent
|
337 |
|
|
|a computer
|b c
|2 rdamedia
|
338 |
|
|
|a online resource
|b cr
|2 rdacarrier
|
347 |
|
|
|a text file
|
347 |
|
|
|b PDF
|
505 |
0 |
|
|a Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Chapter 1: What Is an Excel Function? -- What Is an Excel Function? -- How to Use Excel Functions -- Types of Excel Functions -- Categories of Excel Functions -- Summary -- Chapter 2: Text Functions -- LEFT Function -- Syntax -- Example -- RIGHT Function -- Syntax -- Example -- MID Function -- Syntax -- Example -- UPPER Function -- Syntax -- Example -- LOWER Function -- Syntax -- Example -- PROPER Function -- Syntax -- Example -- TRIM Function -- Syntax -- Example
|
505 |
8 |
|
|a LEN Function -- Syntax -- Example -- FIND Function -- Syntax -- Example -- SEARCH Function -- Syntax -- Example -- CONCATENATE/ & Function -- Syntax -- Example -- VALUE Function -- Syntax -- Example -- TEXT Function -- Syntax -- Example -- EXACT Function -- Syntax -- Example -- REPLACE Function -- Syntax -- Example -- SUBSTITUTE Function -- Syntax -- Examples -- REPT Function -- Syntax -- Example -- T Function -- Syntax -- Example -- TEXTJOIN Function -- Syntax -- Example -- Summary -- Chapter 3: Date Functions -- TODAY Function -- Syntax -- Example -- DAY Function -- Syntax -- Example
|
505 |
8 |
|
|a MONTH Function -- Syntax -- Example -- YEAR Function -- Syntax -- Example -- EDATE Function -- Syntax -- Example -- EOMONTH Function -- Syntax -- Example -- WEEKDAY Function -- Syntax -- Example -- WEEKNUM Function -- Syntax -- Example -- DATE Function -- Syntax -- Example -- DATEVALUE Function -- Syntax -- Example -- WORKDAY Function -- Syntax -- Example -- NETWORKDAYS Function -- Syntax -- Example -- DATEDIF Function -- Syntax -- Example -- Summary -- Chapter 4: Time Functions -- NOW Function -- Syntax -- Example -- HOUR Function -- Syntax -- Example -- MINUTE Function -- Syntax -- Example
|
505 |
8 |
|
|a SECOND Function -- Syntax -- Example -- TIME Function -- Syntax -- Example -- TIMEVALUE Function -- Syntax -- Example -- Summary -- Chapter 5: Named Ranges and Excel Tables -- Named Ranges -- Advantages of Named Ranges -- Create a Named Range -- Rules for Creating Names -- Benefits of Named Ranges -- Excel Tables -- Benefits of Using Excel Tables -- Creating a Table -- Styling a Table -- Renaming a Table -- Adding a Reference to Another Table -- Adding a Total Row to the Table -- Summary -- Chapter 6: Lookup & Reference Functions -- VLOOKUP Function -- Limitations of VLOOKUP -- Syntax
|
505 |
8 |
|
|a Possible Causes of Value Not Found by VLOOKUP -- Example -- HLOOKUP Function -- Syntax -- Example -- MATCH Function -- Syntax -- Example -- INDEX Function -- Syntax -- Example -- CHOOSE Function -- Syntax -- Example -- FORMULATEXT Function -- Syntax -- Example -- ADDRESS Function -- Syntax -- Note About Reference Style -- A1 Reference Style -- R1C1 Reference Style -- Example -- COLUMN Function -- Syntax -- Example -- COLUMNS Function -- Syntax -- Example -- ROW Function -- Syntax -- Example -- ROWS Function -- Syntax -- Example -- INDIRECT Function -- Syntax -- Example
|
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. What You Will Learn Work with basic Excel functions Use the LOOKUP function Take advantage of new functions in information functions Create a mega formula Who This Book Is For Administrators, analysts, and anyone else working with Microsoft Excel.
|
500 |
|
|
|a Includes index.
|
588 |
0 |
|
|a Online resource; title from PDF title page (SpringerLink, viewed March 12, 2021).
|
590 |
|
|
|a O'Reilly
|b O'Reilly Online Learning: Academic/Public Library Edition
|
630 |
0 |
0 |
|a Microsoft Excel (Computer file)
|
630 |
0 |
7 |
|a Microsoft Excel (Computer file)
|2 fast
|
650 |
|
0 |
|a Electronic spreadsheets.
|
650 |
|
6 |
|a Tableurs.
|
650 |
|
7 |
|a Electronic spreadsheets
|2 fast
|
776 |
0 |
8 |
|i Print version:
|z 1484266129
|z 9781484266120
|w (OCoLC)1199330077
|
856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781484266137/?ar
|z Texto completo (Requiere registro previo con correo institucional)
|
938 |
|
|
|a Askews and Holts Library Services
|b ASKH
|n AH38714807
|
938 |
|
|
|a ProQuest Ebook Central
|b EBLB
|n EBL6452456
|
938 |
|
|
|a EBSCOhost
|b EBSC
|n 2723198
|
938 |
|
|
|a YBP Library Services
|b YANK
|n 301864198
|
994 |
|
|
|a 92
|b IZTAP
|