Results 1 to 3 of 3
- Microsoft Excel power pivot & power query / by Alexander, Michael,1972-Author(DLC)n 2005074553;
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.- Subjects: Microsoft Excel (Computer file); Microsoft PowerPivot (Computer file); Business;
- Available copies: 1 / Total copies: 1
-
unAPI
- Excel Power Pivot & Power Query / by Alexander, Michael,1972-author.(CARDINAL)475485;
"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."--- Subjects: Instructional and educational works.; Microsoft PowerPivot (Computer file); Microsoft Excel (Computer file); Querying (Computer science); Business; Business intelligence.;
- Available copies: 1 / Total copies: 3
-
unAPI
- Microsoft Excel step by step : (Office 2021 and Microsoft 365) / by Lambert, Joan,author(CARDINAL)591903; Frye, Curtis,1968-author(CARDINAL)659069;
"The quick way to learn Microsoft Excel! This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers- brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impact; perform calculations and find and correct errors; manage, filter, summarize, validate, reorder, and combine data; identify trends, illustrate processes and relationships, and dynamically analyze data; build sophisticated forecasts, key performance indicators (KPIs), and timelines; visualize data with customized charts, 3D maps, and other powerful tools; import, process, summarize, and analyze huge data sets with PowerPivot and Power Query; and use powerful Excel Data Models for advanced business intelligence."--- Subjects: Handbooks and manuals.; Microsoft Excel (Computer file); Business; Electronic spreadsheets.;
- Available copies: 8 / Total copies: 12
-
unAPI
Results 1 to 3 of 3