Cargando…

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

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, dashboar...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Mehta, Mandeep
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [United States] : Apress, 2021.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

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