https://www.microsoftpressstore.com/store/rss/excel The latest titles from Microsoft Press Store en-us Excel� 2019 PIVOT TABLE DATA CRUNCHINGCRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2019 PIVOT TABLES! Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what's going on in your business... take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power 1/8/2019 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-pivot-table-data-crunching-9781509307241 MASTER CORE EXCEL 2019 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it... capture data from anywhere, and use it anywhere.. 12/21/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-vba-and-macros-9781509306114 The quick way to learn Microsoft Excel 2019!This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots show you exactly what to do, step by step. 12/7/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-step-by-step-9781509307678 Did you know that there is a technology inside Excel, and Power BI, that allows you to create magic in your data, avoid repetitive manual work, and save you time and money? Using Excel and Power BI, you can: Save time by eliminating the pain of copying and pasting data into workbooks and then manually cleaning that data. Gain productivity by properly preparing data yourself, rather than relying on others to do it. 10/25/2018 12:00:00 AM https://www.microsoftpressstore.com/store/collect-combine-and-transform-data-using-power-query-9781509307951 You're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. 10/11/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-inside-out-9781509306022 Microsoft Power BI Dashboards Step by Step guides you through creating world-class business analysis dashboards that integrate today's most widely-used data sources, using any of Microsoft's Power BI platforms, including the new Power BI Premium. Author Errin O'Connor has worked with 70+ Fortune� 500 companies and led 450+ Power BI engagements: he is singularly well-qualified to guide you through successfully designing, architecting, and implementing Power BI in your organization. 10/5/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-power-bi-dashboards-step-by-step-9780134893952 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI certification exam. Exam Ref 70-778: Analyzing and Visualizing Data with Microsoft Power BI offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 6/12/2018 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-778-analyzing-and-visualizing-data-by-using-9781509307029 Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam. Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. 6/7/2018 12:00:00 AM https://www.microsoftpressstore.com/store/exam-ref-70-779-analyzing-and-visualizing-data-with-9781509308040 To get the right insights from your data, you need to model it right. From Power BI to Power Pivot for Excel, Microsoft offers extremely powerful and accessible tools for modeling data. Now, for the first time, there's a complete guide to building exceptionally effective models using Microsoft's tools. 4/19/2017 12:00:00 AM https://www.microsoftpressstore.com/store/analyzing-data-with-power-bi-and-power-pivot-for-excel-9781509302765 Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016's most valuable innovations for data analysis and business modeling. It's packed with realistic problems and solutions to help you gain mastery -- including over 150 that are new or revised. 12/9/2016 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-data-analysis-and-business-modeling-9781509304219 The MOS 2016 Study Guide for Microsoft Excel Expert covers Microsoft Excel 2016, specifically the skills required to pass the Excel 2016 Microsoft Office Specialist exam. 11/3/2016 12:00:00 AM https://www.microsoftpressstore.com/store/mos-2016-study-guide-for-microsoft-excel-expert-9780735699427 Advance your everyday proficiency with Excel 2016. 10/27/2016 12:00:00 AM https://www.microsoftpressstore.com/store/mos-2016-study-guide-for-microsoft-excel-9780735699434 The Definitive Guide to DAX is the most comprehensive and authoritative guide to Microsoft's DAX language for business intelligence and analytics. While other books cover only the basics, this guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques 10/13/2015 12:00:00 AM https://www.microsoftpressstore.com/store/definitive-guide-to-dax-business-intelligence-with-9780735698352 Now in full color! Easy lessons for essential tasks Big full-color visuals Skill-building practice files The quick way to learn Excel! This is learning made easy. Get productive fast with Excel 2016 and jump in wherever you need answers--brisk lessons and colorful screen shots show you exactly what to do, step by step. 10/8/2015 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2016-step-by-step-9780735698802 The smart way to learn Excel 2013--one step at a time! Experience learning made easy--and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace--building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook. 3/31/2014 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2013-step-by-step-9780735681019 Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables--and how to effectively build a relational data source inside an Excel workbook. 1/15/2014 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2013-data-analysis-and-business-modeling-9780735669130 Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Expert Microsoft Office Specialist (MOS) exams, this all-in-one study guide features: Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skills Hands-on practice tasks to apply what you've learned; files included Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office and earn the cre 9/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/mos-2013-study-guide-for-microsoft-excel-expert-9780735669215 Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Microsoft Office Specialist (MOS) exam, this all-in-one study guide features: Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skills Hands-on practice tasks to apply what you've learned; files included Use the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office--and earn the credential 8/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/mos-2013-study-guide-for-microsoft-excel-9780735669208 Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before 4/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2013-plain-simple-9780735672437 You're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel 2013--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. 4/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2013-inside-out-9780735674288 Your guide to quickly turn data into results. Transform your skills, data, and business--and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling 3/15/2013 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2013-building-data-models-with-powerpivot-9780735676343 Conquer Microsoft Excel formulas and functions--from the inside out! You're beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010--and challenge yourself to new levels of mastery. 12/22/2011 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2010-formulas-and-functions-inside-9780735658011 Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. 1/7/2011 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2010-data-analysis-and-business-modeling-9780735643369 Microsoft PowerPivot for Excel 2010: Give Your Data Meaning introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models. And with Microsoft Excel 2010: Data Analysis and Business Modeling, you'll learn the best ways to use Office Excel 2010 for data analysis and business modeling. 10/5/2010 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-powerpivot-for-excel-2010-give-your-data-9780735650930 You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. 8/31/2010 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2010-inside-out-9780735626881