Microsoft : excel power pivot and power query for dummies /
Alexander, Michael
Microsoft : excel power pivot and power query for dummies / Michael Alexander - 2nd edition. - ix, 275 pages : illustrations ; 24 cm.
Includes index.
pt.1 Supercharged reporting with power pivot -- ch.1 Thinking like a database -- ch.2 Power pivot -- ch.3 The pivotal pivot table -- ch.4 Using external data with power pivot -- ch.5 Working directly with the internal data model -- ch.6 Adding formulas to power pivot -- ch.7 Diving into dax -- pt.2 Wrangling data with power query -- ch.8 Power query -- ch.9 Power query connecting types -- ch.10 Transforming your way to better data -- ch.11 Making queries work together -- ch.12 Extending power query with custom functions -- pt.3 The part of tens -- ch.13 Ten ways to improve power pivot performance -- ch.14 Ten tips for working with power query.
9781119844488
Microsoft Excel (computer File)
SHS HF 5548.4 A44 2022
Microsoft : excel power pivot and power query for dummies / Michael Alexander - 2nd edition. - ix, 275 pages : illustrations ; 24 cm.
Includes index.
pt.1 Supercharged reporting with power pivot -- ch.1 Thinking like a database -- ch.2 Power pivot -- ch.3 The pivotal pivot table -- ch.4 Using external data with power pivot -- ch.5 Working directly with the internal data model -- ch.6 Adding formulas to power pivot -- ch.7 Diving into dax -- pt.2 Wrangling data with power query -- ch.8 Power query -- ch.9 Power query connecting types -- ch.10 Transforming your way to better data -- ch.11 Making queries work together -- ch.12 Extending power query with custom functions -- pt.3 The part of tens -- ch.13 Ten ways to improve power pivot performance -- ch.14 Ten tips for working with power query.
9781119844488
Microsoft Excel (computer File)
SHS HF 5548.4 A44 2022