Microsoft Press Store :: Titles > Microsoft Office https://www.microsoftpressstore.com/store/rss/microsoft-office 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 Copilot Pro Step by Step Copilot Pro enables you to be more creative and productive, but using generative AI requires a whole new way of thinkingmost users try once or twice, get poor results and give up. This book teaches them what they don't know and helps them get started with the right skills. 11/13/2024 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-copilot-pro-step-by-step-9780135369425 Title :: Microsoft Word Step by Step (Office 2021 and Microsoft 365) The quick way to learn Word for Office 365!This is learning made easy. Get more done quickly with Word for Office 365. 5/11/2023 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-word-step-by-step-office-2021-and-microsoft-9780137522729 Title :: Microsoft Project Step by Step: Planning for successful project management (Video) Over 5 Hours of Video Instruction Overview: This Microsoft Project Step by Step video is designed to guide you, step-by-step, in planning for successful project management 4/26/2023 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-project-step-by-step-planning-for-successful-9780138166779 Title :: Microsoft 365 Administration Inside Out Conquer Microsoft 365 administration, from the inside out! Dive into Microsoft 365 administration and harness the full power of cloud scaling, automation, and availability in Microsoft 365! This supremely well-organized reference packs hundreds of time-saving solutions, tips, and workarounds; all you need to continually enhance organizational agility, productivity, and security. 1/18/2023 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-365-administration-inside-out-9780137908851 Title :: Microsoft Teams Step by Step Microsoft Teams is a collaborative experience that brings together people, conversations, and content -- along with the tools that teams need -- so they can achieve more. Naturally integrated with the familiar Office 365 experience, it is built on the Office 365 global, secure cloud. This is an easy, step-by-step guide to making the most of Teams, and quickly adopting it within your organization. 8/17/2022 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-teams-step-by-step-9780137522187 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 Project Step by Step (covering Project Online Desktop Client) The quick way to learn Microsoft Project!This is learning made easy. Get more done quickly with Microsoft Project. 4/14/2022 12:00:00 AM https://www.microsoftpressstore.com/store/microsoft-project-step-by-step-covering-project-online-9780137565054 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 :: MOS Study Guide for Microsoft Outlook Exam MO-400 The MOS 2019 Study Guide for Microsoft Outlook covers Microsoft Outlook 2019, specifically the skills required to pass the Outlook 2019 Microsoft Office Specialist exam.Demonstrate your expertise with Microsoft Outlook! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Outlook 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 w 2/23/2021 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-outlook-exam-mo-400-9780136628637 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 PowerPoint Exam MO-300 Advance your everyday proficiency with PowerPoint 2019, and earn the credential that proves it!Demonstrate your expertise with Microsoft PowerPoint! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): PowerPoint 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 learnedPractice files and sample solutionsSharpen the ski 10/1/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-powerpoint-exam-mo-300-9780136628101 Title :: MOS Study Guide for Microsoft Word Exam MO-100 Advance your everyday proficiency with Word 2019, and earn the credential that proves it!Demonstrate your expertise with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Word 2019 Core 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 learnedReady-made practice filesSolution files for the practice tasksS 5/26/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-word-exam-mo-100-9780136628040 Title :: MOS Study Guide for Microsoft Access Expert Exam MO-500 Advance your everyday proficiency with Access 2019. 5/14/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-access-expert-exam-mo-9780136628323 Title :: MOS Study Guide for Microsoft Word Expert Exam MO-101 Advance your expert skills in Word 2019. 5/5/2020 12:00:00 AM https://www.microsoftpressstore.com/store/mos-study-guide-for-microsoft-word-expert-exam-mo-101-9780136628378 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