https://www.microsoftpressstore.com/store/rss/excel The latest titles from Microsoft Press Store en-us Advance your everyday proficiency with Excel 2019, and earn the credential that proves it!Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2019 certification, this official Study Guide delivers:In-depth preparation for each MOS objectiveDetailed procedures to help build the skills measured by the examHands-on tasks to practice what you've learnedSample files for practice tasks Solutions files so you can check 3/30/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-excel-exam-mo-200-9780136627159 Hone your advanced Excel 2019 skills 3/16/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-excel-expert-exam-mo-9780136627524 This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. 7/20/2019 12:00:00 AM https://www.microsoftpressstore.com/store/definitive-guide-to-dax-business-intelligence-for-microsoft-9781509306978 Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel's newest functions. 4/25/2019 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-formulas-and-functions-9781509306190 Master business modeling and analysis techniques with Microsoft Excel 2019, 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 workboo 4/15/2019 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-data-analysis-and-business-modeling-9781509305889 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/28/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 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. 11/21/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-power-bi-dashboards-step-by-step-9781509308033 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. 11/20/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-2019-inside-out-9781509307692 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 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 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