Microsoft Press Store :: Titles > Excel https://www.microsoftpressstore.com/store/rss/excel The latest titles from Microsoft Press Store en-us Title :: Python in Excel: Unlocking powerful data analysis and automation solutions Seasoned Experts Liam Bastick and Kathryn Newitt unveil a groundbreaking guide to mastering data analysis and automation with Python in Excel Python in Excel: Unlocking powerful data analysis and automation solutions is a hands-on, practical guide that leverages the authors decades of expertise to teach readers how to harness the newly integrated Python capabilities within Microsoft Excel, mapping familiar Excel concepts to Python foundations. 12/31/2025 12:00:00 AM https://www.microsoftpressstore.com/store/python-in-excel-unlocking-powerful-data-analysis-and-9780135437971 Title :: Microsoft Power BI Step by Step Are you ready to turn your data into powerful insights and make smarter business decisions? Microsoft Power BI Step by Step is your hands-on guide to mastering one of todays most in-demand business intelligence tools. 12/24/2025 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-power-bi-step-by-step-9780135468326 Title :: Microsoft Copilot Studio Step by Step: Customizing Copilot and creating agents Renowned Microsoft AI authority Lisa Crosbie unveils an essential guide to mastering agent building and business process automation with Microsoft Copilot Studio Microsoft Copilot Studio Step by Step: Customizing Copilot and creating agents is the definitive, hands-on guide for professionals seeking to master Microsofts low-code agent-building platform 12/15/2025 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-copilot-studio-step-by-step-customizing-copilot-9780135491508 Title :: GitHub Copilot Step by Step: Navigating AI-driven software development Microsoft MVP and MCT Community Lead Dr. Gomathi S. delivers the ultimate hands-on guide to mastering AI-powered coding with GitHub Copilot GitHub Copilot Step by Step: Navigating AI-driven software development is a practical, hands-on guide for developers seeking to master AI-powered coding with GitHub Copilot. Blending clear reference material with step-by-step tutorials, this book makes advanced AI coding concepts accessible to developers and technology enthusiasts at all levels. 12/15/2025 12:00:00 AM https://www.microsoftpressstore.com/store/github-copilot-step-by-step-navigating-ai-driven-software-9780135493045 Title :: The Definitive Guide to DAX: Mastering the semantic model expression language for Microsoft Power BI, Fabric, and Excel Unlock the full potential of your data with this new edition of The Definitive Guide to DAX by Alberto Ferrari and Marco Russo, the ultimate resource for mastering the DAX language used in Microsoft Power BI, SQL Server Analysis Services, and Excel. Whether you're a BI professional or an Excel power user, this comprehensive guide will transform the way you approach data modeling and analysis. 12/8/2025 12:00:00 AM https://www.microsoftpressstore.com/store/definitive-guide-to-dax-mastering-the-semantic-model-9780138244729 Title :: Microsoft Power BI Visual Calculations: Simplifying DAX Unlock the full potential of your data with Visual Calculations in Power BI: Simplifying DAX, the essential guide for anyone looking to harness the power of visual calculations. Authored by Jeroen ter Heerdt, Marc Lelijveld, and Madzy Stikkelorum, this book is your gateway to mastering one of Power BI's most transformative features. Whether you're a business executive, manager, or data enthusiast, this book will demystify the complexities of DAX, making it accessible and easy to use. 11/18/2025 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-power-bi-visual-calculations-simplifying-9780135396926 Title :: Microsoft Excel VBA and Macros: Your guide to efficient automation 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 wont find anywhere else, and create automated reports that are amazingly powerful. 9/15/2025 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-vba-and-macros-your-guide-to-efficient-9780135410233 Title :: Mastering Business Intelligence with DAX, Power BI and Excel (Video) Over 9 hours of video content In this course, Michiel Rozema and Madzy Stikkelorum help you understand the core concepts of DAX and how to design, build, debug, and optimize DAX calculations. Overview: Since its launch, Power BI has quickly become the leading platform for business intelligence. With powerful self-service capabilities and integrated data preparation, analytics, and visualization features, Power BI enables business users to gain insights like no other. 8/5/2025 12:00:00 AM https://www.microsoftpressstore.com/store/mastering-business-intelligence-with-dax-power-bi-and-9780135407042 Title :: Copilot with Microsoft Excel: Achieve More with Your AI Assistant (Video) Get ahead of the curve with Copilot for Excel to maximize productivity and extract meaningful data insights. Overview: Copilot is Microsoft's AI-powered assistant designed to help users with a wide range of tasks. Within Excel, Copilot enhances productivity and data analysis capabilities and helps with key tasks such as generating formulas, data insights, data formatting, advance analysis, natural language queries, etc. 6/18/2025 12:00:00 AM https://www.microsoftpressstore.com/store/copilot-with-microsoft-excel-achieve-more-with-your-9780135459171 Title :: ChatGPT with Excel: Leverage ChatGPT for Data Success (Video) Learn ChatGPT with Excel to enhance productivity, and leverage AI for smarter business decisions. Overview: ChatGPT, Open AI's chatbot launched in Nov 2022, is the most popular AI in the market. It can assist in automating tasks, generating insights, and enhancing data manipulation processes. As data-driven decision-making becomes more prevalent, the ability to use AI tools like ChatGPT within Excel is a game-changer 12/10/2024 12:00:00 AM https://www.microsoftpressstore.com/store/chatgpt-with-excel-leverage-chatgpt-for-data-success-9780135398463 Title :: Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if youve never created a pivot table before, this book will help you leverage their flexibility and analytical powerand includes exploration of new array functions and Copilot capabilities in analysis creation. 12/5/2024 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-pivot-table-data-crunching-including-9780135408797 Title :: Collect, Combine, and Transform Data Using Power Query in Power BI and Excel Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether youre using Power BI, Excel, or other Microsoft products, Power Querys capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. 11/22/2024 12:00:00 AM https://www.microsoftpressstore.com/store/collect-combine-and-transform-data-using-power-query-9780138115791 Title :: Microsoft Office Step by Step (Office 2021 and Microsoft 365) This is learning made easy. Get more done quickly with Office 365. 6/2/2022 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-office-step-by-step-office-2021-and-microsoft-9780137544769 Title :: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) 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 Title :: Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) 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 Title :: Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) 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 Title :: Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) 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 Title :: Microsoft Excel Step by Step (Office 2021 and Microsoft 365) 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 Title :: Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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 Title :: Microsoft Office Inside Out (Office 2021 and Microsoft 365) 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 Title :: Data Analysis Fundamentals with Excel (Video) 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 Title :: MOS Study Guide for Microsoft Excel Exam MO-200 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 Title :: MOS Study Guide for Microsoft Excel Expert Exam MO-201 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 Title :: Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel 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 Title :: Microsoft Excel 2019 Formulas and Functions 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