-
Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond
Author Abbott Ira Katz
Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows ho....
Release Date 2022/12 -
Exploring Microsoft Excel's Hidden Treasures
Author David Ringstrom
Discover timesaving features, accessibility and internal control approaches, data integrity improvements, and spreadsheet automation techniques by exploring Excel shortcuts and nuances in Microsoft 365, Excel versions till 2021Key FeaturesGet hands-on experience by carrying out techniques in detaile....
Release Date 2022/09 -
Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Author Alan Murray
Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is ....
Release Date 2022/08 -
Working Smarter with Microsoft Outlook
Author Staci Warne
Written by a Microsoft Office Master Instructor, this book helps you transform into a productivity ninja by adopting highly efficient ways of managing Outlook in your daily lifeKey FeaturesLearn smart ways to customize Outlook for a highly productive daily routineAutomate mundane tasks using powerfu....
Release Date 2022/08 -
Microsoft Office Step by Step (Office 2021 and Microsoft 365)
Author Joan Lambert , Curtis Frye
The quick way to learn popular Microsoft 365 apps!This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step.Discover new time-savers and usab....
Release Date 2022/06 -
Teach Yourself VISUALLY Microsoft 365
Author Paul McFedries
A fast-paced, useful, and easy introduction to Microsoft 365For those who need the show as well as the tell, Teach Yourself VISUALLY Microsoft 365 is the visual walkthrough to Microsoft’s latest suite of office products that will get you up-to-speed faster than any other resource on the market. This....
Release Date 2022/05 -
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Author Bill Jelen , Tracy Syrstad
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever.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 te....
Release Date 2022/04 -
Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
Author Paul McFedries
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 functi....
Release Date 2022/03 -
Author Michael Alexander , Dick Kusleika
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intellige....
Release Date 2022/03 -
Excel Macros For Dummies, 3rd Edition
Author Dick Kusleika
Save time and become an Excel wizard with the world’s leading Excel macro guideDo you love Excel and all the things you can do with it, but wish you could just work…faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you’ll....
Release Date 2022/03 -
Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
Author Cindy Lewis , Curtis Frye , Joan Lambert
The quick way to learn Microsoft Excel!This is learning made easy. Get more done quickly with Microsoft Excel. Jump in wherever you need answers-brisk lessons and detailed screenshots show you exactly what to do, step by step.Quickly set up workbooks, enter data, and format it for easier viewingPerf....
Release Date 2021/12 -
Author Dan Gookin
Write on with Microsoft Word!If you create professional-looking documents on a regular basis, you require a mighty word processor that offers all the power and capabilities to create them. Enter Microsoft Word! Pair it with Word For Dummies to hone all your word-processing skills. The book is filled....
Release Date 2021/12 -
Author Paul McFedries , Greg Harvey
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft ExcelMicrosoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than....
Release Date 2021/12 -
Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis
Author Hong Zhou
Master Excel in less than two weeks with this unique project-based book! Let’s face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an exper....
Release Date 2021/11 -
Author Felix Zumstein
While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language—in fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix ....
Release Date 2021/07 -
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide
MCA Microsoft Office Specialist Study Guide: PowerPoint Associate Exam MO-300 is your roadmap to preparing for taking the MO-300 exam and earning the PowerPoint Associate (PowerPoint and PowerPoint 2019) certification. The following objectives are covered:Manage presentationsManage sl.... -
MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide
Master one of the most essential skill sets for the contemporary office As Microsoft Office becomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricacies is more important than ever. Now you can set yourself apart .... -
Beginning Microsoft 365 Collaboration Apps: Working in the Microsoft Cloud
Start making the most of the latest collaboration tools in Microsoft 365—including Teams, SharePoint, Power Apps, Power BI, Power Automate, Microsoft Groups, Office ProPlus, Yammer, Planner, Stream, Forms, and OneDrive. Integrate these collaboration tools into your team’s projects to boost productiv.... -
MOS Study Guide for Microsoft Outlook Exam MO-400
Advance your proficiency with Outlook. And earn the credential that proves it!Demonstrate your expertise with Microsoft Outlook (Microsoft 365 Apps and Office 2019)! Designed to help you practice and prepare for Microsoft Office Specialist: Outlook Associate (Exam MO-400) certification, this officia.... -
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, das.... -
Advanced Excel Success: A Practical Guide to Mastering Excel
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel.Advanced Excel Success starts with a few useful data tools in Excel followed by advanc.... -
MOS Study Guide for Microsoft PowerPoint Exam MO-300
Author Joan Lambert
Advance your everyday proficiency with PowerPoint, and earn the credential that proves it!Demonstrate your expertise with Microsoft PowerPoint 2019 and PowerPoint for Office 365! Designed to help you practice and prepare for Microsoft Office Specialist: PowerPoint Associa....
Release Date 2020/09 -
Predictive Analytics for Healthcare
Author Jaquie Finn , Gavin Troughton , Paul Baxter
Before the onset of COVID-19, the healthcare community was already moving to meet the challenges of a growing global population. By collecting record amounts of clinical data electronically and making significant progress on neural network-based AI approaches, the industr....
Release Date 2020/09 -
VBA Automation for Excel 2019 Cookbook
Author Mike Van Niekerk
A comprehensive guide to gaining a 360-degree overview of the VBA programming language and learning how to build your own programs for automating routine tasksKey FeaturesExtend the capabilities of Excel and other Office applications with the help of Microsoft VBATake you....
Release Date 2020/09 -
Microsoft Office 365 Administration Cookbook
Make the most out of your investment in Office 365 apps and services with this Microsoft Office cookbookKey FeaturesLearn how to manage and secure the entire Office 365 stack in addition to specific servicesDelve into newer and frequently shifting areas such as Power Platform, Microsoft Teams, and M.... -
Teach Yourself VISUALLY Word 2019
Author Guy Hart-Davis
Master one of the most popular word processors ever with this essential, visual reference Teach Yourself VISUALLY: Word 2019 provides readers with a thorough and visual exploration of the 2019 edition of Microsoft Word. Written by the celebrated author of over 1....
Release Date 2020/07 -
Author Adam Aspin
Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of ....
Release Date 2020/07 -
Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods
Author Hong Zhou
Use popular data mining techniques in Microsoft Excel to better understand machine learning methods.Software tools and programming language packages take data input and deliver data mining results directly, presenting no insight on working mechanics and creating a chasm b....
Release Date 2020/06 -
MOS Study Guide for Microsoft Word Exam MO-100
Author Joan Lambert
Advance your proficiency with Word. And earn the credential that proves it! Demonstrate your expertise with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist: Word Associate (Word and Word 2019) certification, this official Stu....
Release Date 2020/05