Microsoft Press Store :: Titles > Excel https://www.microsoftpressstore.com/store/rss/excel The latest titles from Microsoft Press Store en-us 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/24/2025 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-excel-vba-and-macros-your-guide-to-efficient-9780135410233 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 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 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 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 Title :: Microsoft Excel 2019 Data Analysis and Business Modeling 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 Title :: Microsoft Excel 2019 Pivot Table Data Crunching 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 Title :: Microsoft Excel 2019 VBA and Macros 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 Title :: Microsoft Excel 2019 Step by Step 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 Title :: Microsoft Office 2019 Step by Step This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. 12/7/2018 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-office-2019-step-by-step-9781509307685 Title :: Microsoft Power BI Dashboards Step by Step 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 Title :: Collect, Combine, and Transform Data Using Power Query in Excel and Power BI 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 Title :: Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI 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