MS Excel: let's advance to the next level
#0101-0109: Super Essential Keyboard Shortcuts -- #0201: Used in Financial Modeling and Tax Computation -- #0202: Used in Pricing Discovery Processes -- #0203-0204: For Rounding Numbers -- #0205: For Counting -- #0206-0207: For Weighted Average and Compounding/Discounting -- #0301-0302: Formatting T...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
New York, New York (222 East 46th Street, New York, NY 10017)
Business Expert Press
2017
|
| Ausgabe: | First edition |
| Schriftenreihe: | Quantitative approaches to decision making collection
|
| Schlagworte: | |
| Online-Zugang: | FHN01 FWS01 FWS02 UBY01 Volltext |
| Zusammenfassung: | #0101-0109: Super Essential Keyboard Shortcuts -- #0201: Used in Financial Modeling and Tax Computation -- #0202: Used in Pricing Discovery Processes -- #0203-0204: For Rounding Numbers -- #0205: For Counting -- #0206-0207: For Weighted Average and Compounding/Discounting -- #0301-0302: Formatting Tricks Incl. Special Custom Formats [Shortcut: Ctrl 1] -- #0303-#0304: Using CELL STYLES for Automating Formatting for MIS Reporting and Financial Models -- #0305-#0307: Cell Drag-n-Drop Auto Fill Options -- #0308 Paste Special- Transpose vs. TRANSPOSE() -- #0401-0402: Absolute and Relative Referencing Using This book is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. MS Excel offers to make life easier for a data analyst. Thus, it will be of relevance to students, academicians, the ones pursuing corporate careers as well as entrepreneurs preparing business plans for their startups. The book explains a wide array of complex functions, ranging from V-LOOKUP to MATCH/INDEX and Pivot Tables in very practical, simple, and implementable manner. Also the segments on Conditional Formatting and printing tricks will help you better present the output to stakeholders. Do try the features Excel has on offer for controlling data input as well as creating checks and balances to ensure cell/sheet/file-level security. You will get the most out of this book if you can use this as a workbook and simultaneously practice the functions on the computer. It is for this purpose that we have appended screenshots for each function. Take each function as a mini case study and try to analyze how you can apply it in making more sense of the enormous data at your disposal. Once you are through all the modules, I am sure, you will emerge as a more efficient person on the work-front |
| Beschreibung: | Includes index |
| Beschreibung: | Online-Ressource (xi, 87 pages) |
| ISBN: | 9781631579448 9781631579431 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV045876328 | ||
| 003 | DE-604 | ||
| 005 | 20240419 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 190514s2017 |||| o||u| ||||||eng d | ||
| 020 | |a 9781631579448 |9 978-1-63157-944-8 | ||
| 020 | |a 9781631579431 |9 978-1-63157-943-1 | ||
| 035 | |a (ZDB-191-BEX)11398740 | ||
| 035 | |a (OCoLC)992466985 | ||
| 035 | |a (DE-599)BVBBV045876328 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-863 |a DE-862 |a DE-92 |a DE-706 | ||
| 082 | 0 | |a 005.369 |2 23 | |
| 100 | 1 | |a Singal, Anurag |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a MS Excel |b let's advance to the next level |c Anurag Singal |
| 246 | 1 | 3 | |a Microsoft Excel |
| 250 | |a First edition | ||
| 264 | 1 | |a New York, New York (222 East 46th Street, New York, NY 10017) |b Business Expert Press |c 2017 | |
| 300 | |a Online-Ressource (xi, 87 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Quantitative approaches to decision making collection | |
| 500 | |a Includes index | ||
| 520 | |a #0101-0109: Super Essential Keyboard Shortcuts -- #0201: Used in Financial Modeling and Tax Computation -- #0202: Used in Pricing Discovery Processes -- #0203-0204: For Rounding Numbers -- #0205: For Counting -- #0206-0207: For Weighted Average and Compounding/Discounting -- #0301-0302: Formatting Tricks Incl. Special Custom Formats [Shortcut: Ctrl 1] -- #0303-#0304: Using CELL STYLES for Automating Formatting for MIS Reporting and Financial Models -- #0305-#0307: Cell Drag-n-Drop Auto Fill Options -- #0308 Paste Special- Transpose vs. TRANSPOSE() -- #0401-0402: Absolute and Relative Referencing Using | ||
| 520 | |a This book is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. MS Excel offers to make life easier for a data analyst. Thus, it will be of relevance to students, academicians, the ones pursuing corporate careers as well as entrepreneurs preparing business plans for their startups. The book explains a wide array of complex functions, ranging from V-LOOKUP to MATCH/INDEX and Pivot Tables in very practical, simple, and implementable manner. Also the segments on Conditional Formatting and printing tricks will help you better present the output to stakeholders. Do try the features Excel has on offer for controlling data input as well as creating checks and balances to ensure cell/sheet/file-level security. You will get the most out of this book if you can use this as a workbook and simultaneously practice the functions on the computer. It is for this purpose that we have appended screenshots for each function. Take each function as a mini case study and try to analyze how you can apply it in making more sense of the enormous data at your disposal. Once you are through all the modules, I am sure, you will emerge as a more efficient person on the work-front | ||
| 653 | |a Electronic books | ||
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781631579431 |
| 856 | 4 | 0 | |u http://portal.igpublish.com/iglibrary/search/BEPB0000625.html |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-191-BEX | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031259546 | ||
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/BEPB0000625.html |l FHN01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000625.html |l FWS01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000625.html |l FWS02 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000625.html |l UBY01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
Datensatz im Suchindex
| DE-BY-FWS_katkey | 724474 |
|---|---|
| _version_ | 1824554842668924928 |
| any_adam_object | |
| author | Singal, Anurag |
| author_facet | Singal, Anurag |
| author_role | aut |
| author_sort | Singal, Anurag |
| author_variant | a s as |
| building | Verbundindex |
| bvnumber | BV045876328 |
| collection | ZDB-191-BEX |
| ctrlnum | (ZDB-191-BEX)11398740 (OCoLC)992466985 (DE-599)BVBBV045876328 |
| dewey-full | 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.369 |
| dewey-search | 005.369 |
| dewey-sort | 15.369 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | First edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03770nmm a2200457zc 4500</leader><controlfield tag="001">BV045876328</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240419 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">190514s2017 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781631579448</subfield><subfield code="9">978-1-63157-944-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781631579431</subfield><subfield code="9">978-1-63157-943-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-191-BEX)11398740</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)992466985</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV045876328</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-863</subfield><subfield code="a">DE-862</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-706</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.369</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Singal, Anurag</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MS Excel</subfield><subfield code="b">let's advance to the next level</subfield><subfield code="c">Anurag Singal</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Microsoft Excel</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">First edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York, New York (222 East 46th Street, New York, NY 10017)</subfield><subfield code="b">Business Expert Press</subfield><subfield code="c">2017</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">Online-Ressource (xi, 87 pages)</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="490" ind1="0" ind2=" "><subfield code="a">Quantitative approaches to decision making collection</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">#0101-0109: Super Essential Keyboard Shortcuts -- #0201: Used in Financial Modeling and Tax Computation -- #0202: Used in Pricing Discovery Processes -- #0203-0204: For Rounding Numbers -- #0205: For Counting -- #0206-0207: For Weighted Average and Compounding/Discounting -- #0301-0302: Formatting Tricks Incl. Special Custom Formats [Shortcut: Ctrl 1] -- #0303-#0304: Using CELL STYLES for Automating Formatting for MIS Reporting and Financial Models -- #0305-#0307: Cell Drag-n-Drop Auto Fill Options -- #0308 Paste Special- Transpose vs. TRANSPOSE() -- #0401-0402: Absolute and Relative Referencing Using</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">This book is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. MS Excel offers to make life easier for a data analyst. Thus, it will be of relevance to students, academicians, the ones pursuing corporate careers as well as entrepreneurs preparing business plans for their startups. The book explains a wide array of complex functions, ranging from V-LOOKUP to MATCH/INDEX and Pivot Tables in very practical, simple, and implementable manner. Also the segments on Conditional Formatting and printing tricks will help you better present the output to stakeholders. Do try the features Excel has on offer for controlling data input as well as creating checks and balances to ensure cell/sheet/file-level security. You will get the most out of this book if you can use this as a workbook and simultaneously practice the functions on the computer. It is for this purpose that we have appended screenshots for each function. Take each function as a mini case study and try to analyze how you can apply it in making more sense of the enormous data at your disposal. Once you are through all the modules, I am sure, you will emerge as a more efficient person on the work-front</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Electronic books</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781631579431</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000625.html</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-191-BEX</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031259546</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/BEPB0000625.html</subfield><subfield code="l">FHN01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000625.html</subfield><subfield code="l">FWS01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000625.html</subfield><subfield code="l">FWS02</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000625.html</subfield><subfield code="l">UBY01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV045876328 |
| illustrated | Not Illustrated |
| indexdate | 2025-02-20T06:58:12Z |
| institution | BVB |
| isbn | 9781631579448 9781631579431 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031259546 |
| oclc_num | 992466985 |
| open_access_boolean | |
| owner | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-92 DE-706 |
| owner_facet | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-92 DE-706 |
| physical | Online-Ressource (xi, 87 pages) |
| psigel | ZDB-191-BEX |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Business Expert Press |
| record_format | marc |
| series2 | Quantitative approaches to decision making collection |
| spellingShingle | Singal, Anurag MS Excel let's advance to the next level |
| title | MS Excel let's advance to the next level |
| title_alt | Microsoft Excel |
| title_auth | MS Excel let's advance to the next level |
| title_exact_search | MS Excel let's advance to the next level |
| title_full | MS Excel let's advance to the next level Anurag Singal |
| title_fullStr | MS Excel let's advance to the next level Anurag Singal |
| title_full_unstemmed | MS Excel let's advance to the next level Anurag Singal |
| title_short | MS Excel |
| title_sort | ms excel let s advance to the next level |
| title_sub | let's advance to the next level |
| url | http://portal.igpublish.com/iglibrary/search/BEPB0000625.html |
| work_keys_str_mv | AT singalanurag msexcelletsadvancetothenextlevel AT singalanurag microsoftexcel |