Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
()
About this ebook
Get more out of your data with step-by-step tutorials for the Excel features you need to know
Excel is still the most popular tool for organizing and analyzing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools like Pivot Tables, PowerQuery, and PowerPivot can help you manage and report on data the way you need to. Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot offers a fresh look at how these tools can help you. Author and Microsoft Certified Trainer Thomas Fragale breaks down the topics into easy-to-use steps and screenshots, so you'll be able to put your advanced Excel skills into practice right away.
Using Pivot Tables, PowerQuery, and PowerPivot, you can import, sort, transform, summarize, and present your data, all without having to be a programmer. This book takes the technical jargon out of using these features, so you can do your job more efficiently, bring value to your teams, and advance your career. The plain-English instructions inside will help anyone learn to get quick, meaningful results from your data, without having a degree in computing.
- Get easy-to-understand walkthroughs for analyzing data and creating dashboards in Microsoft Excel
- Learn how to organize data in Excel and use advanced features to find patterns and insights
- Summarize any kind of data faster and easier, leaving you more time for other tasks
- Turn raw numbers into new knowledge, reports, and charts that tell coworkers and customers what they need to know
This book is great for anybody who has tons of raw data and needs to make sense of it. Managers, salespeople, finance professionals, marketers—along with anyone else who works with large amounts of data—will love this quick and easy guide to Pivot Tables, PowerQuery, and PowerPivot.
Related to Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
Related ebooks
Data Analytics & Visualization All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2003 Formulas Rating: 4 out of 5 stars4/5Excel Power Pivot & Power Query For Dummies Rating: 0 out of 5 stars0 ratingsAccess 2010 Bible Rating: 5 out of 5 stars5/5Python Machine Learning Rating: 5 out of 5 stars5/5Pivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsData Smart: Using Data Science to Transform Information into Insight Rating: 4 out of 5 stars4/5Mastering VBA for Microsoft Office 2016 Rating: 5 out of 5 stars5/5Business Forecasting: The Emerging Role of Artificial Intelligence and Machine Learning Rating: 0 out of 5 stars0 ratingsApplied Microsoft Business Intelligence Rating: 3 out of 5 stars3/5Excel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA Rating: 3 out of 5 stars3/5Excel Insights: A Microsoft MVP guide to the best parts of Excel Rating: 0 out of 5 stars0 ratingsSQL Server Functions and tutorials 50 examples Rating: 1 out of 5 stars1/5Managing Your Firm's 401(k) Plan: A Complete Roadmap to Managing Today's Retirement Plans Rating: 0 out of 5 stars0 ratingsExcel Formulas & Functions For Dummies Rating: 0 out of 5 stars0 ratings200+ Excel Formulas and Functions: The go-to-guide to master Microsoft Excel's many capabilities (English Edition) Rating: 0 out of 5 stars0 ratingsData Visualization with Python: Exploring Matplotlib, Seaborn, and Bokeh for Interactive Visualizations (English Edition) Rating: 0 out of 5 stars0 ratingsPower BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data (English Edition) Rating: 0 out of 5 stars0 ratingsSelf-Service AI with Power BI Desktop: Machine Learning Insights for Business Rating: 0 out of 5 stars0 ratingsSecrets of Statistical Data Analysis and Management Science! Rating: 0 out of 5 stars0 ratingsPension Finance: Putting the Risks and Costs of Defined Benefit Plans Back Under Your Control Rating: 0 out of 5 stars0 ratingsSQL All-in-One For Dummies Rating: 4 out of 5 stars4/5Your Excel Survival Kit 2nd Edition: Your Guide to Surviving and Thriving in an Excel World Rating: 0 out of 5 stars0 ratingsPerformance Dashboards and Analysis for Value Creation Rating: 3 out of 5 stars3/5Excel and VBA Boosting Performance with Best Practices Rating: 0 out of 5 stars0 ratings
Programming For You
Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5PYTHON: Practical Python Programming For Beginners & Experts With Hands-on Project Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Python Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5Coding All-in-One For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Learn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS Rating: 0 out of 5 stars0 ratingsC# 7.0 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsC++ Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsSQL: For Beginners: Your Guide To Easily Learn SQL Programming in 7 Days Rating: 5 out of 5 stars5/5Java for Beginners: A Crash Course to Learn Java Programming in 1 Week Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Hacking: Ultimate Beginner's Guide for Computer Hacking in 2018 and Beyond: Hacking in 2018, #1 Rating: 4 out of 5 stars4/5Python: For Beginners A Crash Course Guide To Learn Python in 1 Week Rating: 4 out of 5 stars4/5C# Programming from Zero to Proficiency (Introduction): C# from Zero to Proficiency, #0 Rating: 0 out of 5 stars0 ratingsSQL All-in-One For Dummies Rating: 3 out of 5 stars3/5Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5Game Development with Unreal Engine 5: Learn the Basics of Game Development in Unreal Engine 5 (English Edition) Rating: 0 out of 5 stars0 ratingsC++ Programming Language Rating: 0 out of 5 stars0 ratingsData Structures and Algorithm Analysis in Java, Third Edition Rating: 4 out of 5 stars4/5
Reviews for Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
0 ratings0 reviews