LEADER 00000cam a2200637Ii 4500 001 on1135054359 003 OCoLC 005 20220114043859.0 006 m o d 007 cr cnu---unuuu 008 200107s2020 flu o 000 0 eng d 019 1135449419 020 9781615471539|q(electronic book) 020 1615471537|q(electronic book) 020 |z9781615470679 020 |z1615470670 035 (OCoLC)1135054359|z(OCoLC)1135449419 037 D0CF5B1E-5FA9-48C1-A799-ACDE45430462|bOverDrive, Inc. |nhttp://www.overdrive.com 040 N$T|beng|erda|epn|cN$T|dEBLCP|dN$T|dYDX|dOCLCF|dOCLCQ |dTEFOD 049 RIDW 050 4 HF5548.4.M523 082 04 005.54|223 090 HF5548.4.M523 245 00 Excel insights :|ba Microsoft MVP guide to the best parts of Excel. 264 1 Merritt Island, FL :|bHoly Macro! Books,|c2020. 300 1 online resource 336 text|btxt|2rdacontent 337 computer|bc|2rdamedia 338 online resource|bcr|2rdacarrier 340 |gpolychrome|2rdacc 347 text file|2rdaft 505 0 Intro -- Smart Uses of Custom Number Formatting -- Ctrl + Enter -- Auto-Magically Master INDEX MATCH (and Other Formulas) -- Relative Named Ranges -- When Named Ranges Go Walkabout -- An Introduction to Excel's New Data Types -- A Look to the Future -- Dynamic Arrays -- XLOOKUP Debuts in Excel -- Why the Love / Hate for Pie Charts? -- Intermediate Charting in Excel -- Creating Charts for Presentations -- Advanced Filter -- Power Query: Manipulate Your Data Like a Pro -- Combine All Files in a Folder -- Power Query M Code Approximate Match Lookup Formula 505 8 The Power Behind the Boringest Sentence in Excel -- Understanding Context in Power Pivot -- Thinking Through the Modelling of a Seating Chart -- Financial Modelling -- Creative Excel Model Development -- An Introduction to Simulation in Excel -- Staying out of Trouble -- Make Your Own VBA Worksheet Functions -- An Overview of Modern VBA Best Practices -- About the MVPs -- Index 588 0 Online resource; title from PDF title page (EBSCO, viewed January 16, 2020) 590 eBooks on EBSCOhost|bEBSCO eBook Subscription Academic Collection - North America 630 00 Microsoft Excel (Computer file)|0https://id.loc.gov/ authorities/names/n86025775 630 7 Microsoft Excel (Computer file)|2fast|0https:// id.worldcat.org/fast/1366659 630 07 Microsoft Excel (Computer file)|2fast|0https:// id.worldcat.org/fast/1366659 650 0 Business|xComputer programs.|0https://id.loc.gov/ authorities/subjects/sh85018263 650 0 Business intelligence|0https://id.loc.gov/authorities/ subjects/sh85018300|xComputer programs.|0https:// id.loc.gov/authorities/subjects/sh99005296 650 0 Knowledge management|0https://id.loc.gov/authorities/ subjects/sh97007353|xComputer programs.|0https:// id.loc.gov/authorities/subjects/sh99005296 650 0 Business|xData processing.|0https://id.loc.gov/authorities /subjects/sh85018264 650 7 Business|xComputer programs.|2fast|0https:// id.worldcat.org/fast/842283 650 7 Business intelligence.|2fast|0https://id.worldcat.org/fast /842723 650 7 Computer programs.|2fast|0https://id.worldcat.org/fast/ 872410 650 7 Knowledge management.|2fast|0https://id.worldcat.org/fast/ 988184 650 7 Business|xData processing.|2fast|0https://id.worldcat.org/ fast/842293 655 4 Electronic books. 776 08 |iPrint version:|tExcel insights.|dMerritt Island, FL : Holy Macro! Books, 2020|z1615470670|z9781615470679 |w(OCoLC)1120692496 856 40 |uhttps://rider.idm.oclc.org/login?url=https:// search.ebscohost.com/login.aspx?direct=true&scope=site& db=nlebk&AN=2346019|zOnline ebook via EBSCO. Access restricted to current Rider University students, faculty, and staff. 856 42 |3Instructions for reading/downloading the EBSCO version of this ebook|uhttp://guides.rider.edu/ebooks/ebsco 901 MARCIVE 20231220 948 |d20220127|cEBSCO|tEBSCOebooksacademic NEW 6019|lridw 994 92|bRID