Excel Power Pivot & Power Query for Dummies
(eBook)
Description
Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started. And that's where Dummies comes in. With step-by-step instructions-accompanied by ample screenshots-Excel PowerPivot & Power Query for Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization's data. Then use PowerPivot to model it in Excel. You'll also learn to: - Make use of databases to store large amounts of data - Use custom functions to extend and enhance Power Query - Add the functionality of formulas to PowerPivot and publish data to SharePoint If you're expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query for Dummies gives you the tools you need to get up to speed quickly.
More Details
Notes
Reviews from GoodReads
Citations
Alexander, M. (2022). Excel Power Pivot & Power Query for Dummies. Wiley.
Chicago / Turabian - Author Date Citation (style guide)Alexander, Michael. 2022. Excel Power Pivot & Power Query for Dummies. Wiley.
Chicago / Turabian - Humanities Citation (style guide)Alexander, Michael, Excel Power Pivot & Power Query for Dummies. Wiley, 2022.
MLA Citation (style guide)Alexander, Michael. Excel Power Pivot & Power Query for Dummies. Wiley, 2022.
Staff View
Hoopla Extract Information
| hooplaId | 14861908 |
|---|---|
| title | Excel Power Pivot & Power Query For Dummies |
| language | ENGLISH |
| kind | EBOOK |
| series | For Dummies (Wiley) |
| season | |
| publisher | Wiley |
| price | 1.49 |
| active | 1 |
| pa | |
| profanity | |
| children | |
| demo | |
| duration | |
| rating | |
| abridged | |
| fiction | |
| purchaseModel | INSTANT |
| dateLastUpdated | Aug 16, 2025 06:12:04 PM |
Record Information
| Last File Modification Time | Aug 02, 2025 10:49:25 PM |
|---|---|
| Last Grouped Work Modification Time | Aug 02, 2025 10:23:36 PM |
MARC Record
| LEADER | 02531nam a22004215i 4500 | ||
|---|---|---|---|
| 001 | MWT18102319 | ||
| 003 | MWT | ||
| 005 | 20250726065151.1 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 250726s2022 xxu eo 000 0 eng d | ||
| 020 | |a 9781119844501 |q (electronic bk.) | ||
| 020 | |a 1119844509 |q (electronic bk.) | ||
| 028 | 4 | 2 | |a MWT18102319 |
| 029 | |a https://d2snwnmzyr8jue.cloudfront.net/jws_9781119844501_180.jpeg | ||
| 037 | |a 18102319 |b Midwest Tape, LLC |n http://www.midwesttapes.com | ||
| 040 | |a Midwest |e rda | ||
| 099 | |a eBook hoopla | ||
| 100 | 1 | |a Alexander, Michael, |e author. | |
| 245 | 1 | 0 | |a Excel Power Pivot & Power Query for Dummies |h [electronic resource] / |c Michael Alexander. |
| 264 | 1 | |a [United States] : |b Wiley, |c 2022. | |
| 264 | 2 | |b Made available through hoopla | |
| 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 |2 rda | ||
| 490 | 0 | |a For Dummies (Wiley) ; | |
| 506 | |a Instant title available through hoopla. | ||
| 520 | |a Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft's Excel program can handle amazingly large data sets, but you'll need to get familiar with PowerPivot and Power Query to get started. And that's where Dummies comes in. With step-by-step instructions-accompanied by ample screenshots-Excel PowerPivot & Power Query for Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization's data. Then use PowerPivot to model it in Excel. You'll also learn to: - Make use of databases to store large amounts of data - Use custom functions to extend and enhance Power Query - Add the functionality of formulas to PowerPivot and publish data to SharePoint If you're expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query for Dummies gives you the tools you need to get up to speed quickly. | ||
| 538 | |a Mode of access: World Wide Web. | ||
| 650 | 0 | |a Business. | |
| 650 | 0 | |a Computers. | |
| 650 | 0 | |a Electronic spreadsheets. | |
| 650 | 0 | |a Electronic books. | |
| 710 | 2 | |a hoopla digital. | |
| 856 | 4 | 0 | |u https://www.hoopladigital.com/title/14861908?utm_source=MARC&Lid=hh4435 |z Instantly available on hoopla. |
| 856 | 4 | 2 | |z Cover image |u https://d2snwnmzyr8jue.cloudfront.net/jws_9781119844501_180.jpeg |