https://www.microsoftpressstore.com/store/rss/excel The latest titles from Microsoft Press Store en-us Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.Use this guide to automate virtually any routine Excel 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. 4/11/2022 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-vba-and-macros-office-2021-and-microsoft-9780137521524 Expert Paul McFedries helps you master key Excel tools for building more powerful spreadsheets.Use Excel core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. 4/9/2022 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-formulas-and-functions-office-2021-9780137559404 Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables.Use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical powerincluding valuable improvements in Excel and Excel in Office 365 12/17/2021 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-pivot-table-data-crunching-office-2021-9780137521838 Master business modeling and analysis techniques with Microsoft Excel and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. A lot has changed in Office 365 since the previous edition. This new edition covers new functions (STOCKHISTORY, LET, LAMBDA, XLOOKUP) and new array functions. 12/16/2021 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-data-analysis-and-business-modeling-9780137613663 The quick way to learn Microsoft Excel!This is learning made easy. Get more done quickly with Microsoft Excel. 12/16/2021 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-step-by-step-office-2021-and-microsoft-9780137564279 Conquer Microsoft Excel -- from the inside out!Dive into Microsoft Excel -- and really put your spreadsheet expertise to work. 12/16/2021 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-inside-out-office-2021-and-microsoft-9780137559534 Conquer Office apps in Microsoft 365 -- from the inside out!Dive into Microsoft Office and really put its productivity tools and services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds -- all you need to make the most of Office's most powerful tools for productivity and decision-making.Renowned Office expert Joe Habraken offers a complete tour, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, OneNote, and 12/16/2021 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-office-inside-out-office-2021-and-microsoft-9780137564095 7+ Hours of Video InstructionDiscover how you can use Power BI to help your organization to become more data driven. Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this video shows you how to use Microsoft Power BI with confidence.In this video, learn ways to import data from various sources as well as how to transform and cleanse data prior to loading it to a report-ready, self-service-enabled data model. 5/21/2021 12:00:00 AM https://www.microsoftpressstore.com/store/introduction-to-microsoft-power-bi-video-9780137456307 7+ Hours of Video InstructionThis video course takes youthe business user, business analyst, or data analystthrough an end-to-end solution for collecting, cleaning, importing, managing, and sharing data for operational and reporting purposes using Excel.A story-based approach is used to teach you the data and analytics lifecycle. Learn the how and why behind the options available to you in Excel. 12/23/2020 12:00:00 AM https://www.microsoftpressstore.com/store/data-analysis-fundamentals-with-excel-video-9780136915577 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 4/16/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/12/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. 11/29/2016 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-data-analysis-and-business-modeling-9781509304257 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