Microsoft Products Books

Hundreds of how-tos and tips for Word, Excel, Access, SharePoint, Project, and all your other Microsoft favorites.

Microsoft Products Books

page 1
page 2
page 3
page 4
page 5
page 6
page 7
63 results
63 results
book image

Office 2021 for Macs For Dummies

Published 04-25-2022

This handy guide will show you how to master the essentials of all the key apps that make Office 2021 such a productivity booster. Among many, this includes Word, Excel, and PowerPoint. You'll also discover brand-new features, like an improved dark mode, better accessibility capabilities, how to share documents directly in a collaborative setting, and much more.

Explore Book

book image

Excel Dashboards & Reports For Dummies

Published 04-05-2022

It’s time for some truly “Excel-lent” spreadsheet reporting

Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru?

It’s easy. You grab a copy of the newest edition of Excel Dashboards & Reports For Dummies and get ready to blow the pants off your next presentation audience!

With this book, you’ll learn how to transform those rows and columns of data into dynamic reports, dashboards, and visualizations. You’ll draw powerful new insights from your company’s numbers to share with your colleagues – and seem like the smartest person in the room while you’re doing it.

Excel Dashboards & Reports For Dummies offers:

  • Complete coverage of the latest version of Microsoft Excel provided in the Microsoft 365 subscription
  • Strategies to automate your reporting so you don’t have to manually crunch the numbers every week, month, quarter, or year
  • Ways to get new perspectives on old data, visualizing it so you can find solutions no one else has seen before

If you’re ready to make your company’s numbers and spreadsheets dance, it’s time to get the book that’ll have them moving to your tune in no time. Get Excel Dashboards & Reports For Dummies today.

Explore Book

book image

Excel Macros For Dummies

Published 03-22-2022

Save time and become an Excel wizard with the world’s leading Excel macro guide

Do 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 learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer!

Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you’ll find:

  • Automations that take your Excel productivity to the next level, and beyond
  • Fully updated macros compatible with the newest version of Excel included in Microsoft 365
  • Careful explanations of the basics as well as tips for the advanced user

With something for everyone, Excel Macros For Dummies is the productivity supercharger you’ve been waiting for. Grab a copy today!

Explore Book

book image

Excel Power Pivot & Power Query For Dummies

Published 03-02-2022

Learn to crunch huge amounts of data with PowerPivot and Power Query

Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started.

And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to:

  • Make use of databases to store large amounts of data
  • Use custom functions to extend and enhance Power Query
  • Add the functionality of formulas to PowerPivot and publish data to SharePoint

If you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

Explore Book

book image

Microsoft 365 For Dummies

Published 03-02-2022

Amp up your collaboration skills and rock the modern workplace by harnessing the power of Microsoft 365 with this one-stop guide to the world's leading productivity platform 

The Microsoft 365 productivity solution for the workplace is a cloud-based service with many features for effective and secure collaboration virtually or in person. Whether you start your day with meetings in Teams, respond to Outlook emails, create documents with Office apps, or even automate your work with artificial intelligence, Microsoft 365 has you covered. But first, you must unlock the potential of this powerful solution to showcase your ability to keep up with the modern workplace and make an impact in your organization. To do that, you need Microsoft 365 For Dummies

This book walks you through the steps to get your work done anytime, anywhere, on any device, with Microsoft Teams as the central hub.  Discover how to chat online in real time; conduct online meetings; co-author documents in the cloud; develop no-code applications; and even prioritize your well-being. The insights and step-by-step guidance in Microsoft 365 For Dummies will help you stay connected and engaged with your colleagues. 

  • Level up your teamwork game with the latest meeting and collaboration best practices from Microsoft Teams 
  • Stretch your use of Office apps (Word, Excel, PowerPoint, Outlook, and OneNote) by infusing artificial intelligence into your everyday tasks 
  • Save time (and look really smart) by automating your work with the Power Platform apps 
  • Take a break from work and focus on your health and well-being at home or in the office 

Whether you’re a Microsoft 365 newbie or a superuser looking for details on what's new, Microsoft 365 For Dummies is the friendly and authoritative how-to book you need. Discover the benefits of cloud technology today!  

Explore Book

book image

Office 2021 All-in-One For Dummies

Published 02-23-2022

Say hello to Office productivity with this one-stop reference

With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk.

How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office.

  • Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams
  • Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations
  • Get better at working collaboratively with file sharing options and other neat features
  • Do more, faster with expert tips and guidance on the full suite of Office software for 2021

Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.

Explore Book

book image

Excel Data Analysis For Dummies

Published 02-15-2022

Turn jumbles of numbers into graphics, insights, and answers with Excel

With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions—it's all in here, with examples and ideas for Excel users of all skill levels.

This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice—and Dummies is the best choice for learning how to make those numbers sing.

  • Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data
  • Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers
  • Clean up large datasets and identify statistical operations that will answer your questions
  • Perform financial calculations, database operations, and more—without leaving Excel

Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

Explore Book

book image

Microsoft Project For Dummies

Published 02-15-2022

Blow past the jargon and get hands-on, practical guidance on managing any project with Microsoft Project 

Lean. Agile. Hybrid. It seems that project management these days comes with more confusing buzzwords than ever. But you can make managing your next project simple and straightforward with help from Microsoft Project For Dummies. 

This book unpacks Microsoft’s bestselling project management platform and walks you through every important feature, step-by-step, until you’re ready to take on virtually any project, no matter the size. From getting set up for the first time to creating tasks, managing resources and working with time management features, you’ll learn everything you need to know about managing a project in Microsoft’s iconic software. 

You’ll also find: 

  • Totally updated guidance that applies to both the desktop version and Microsoft’s new subscription-based Microsoft Project Online 
  • Helpful information on integrating Agile practices and techniques into your project 
  • “Golden rules” that keep a project on-track and on-time 
  • Ways to effectively manage your resources with Microsoft Project’s built-in functionality 

Managing a project, big or small, is no easy task. Luckily, Microsoft Project For Dummies can take a lot of the hassle out of your day-to-day life. Learn how to take advantage of this powerful software today! 

Explore Book

book image

Excel VBA Programming For Dummies

Published 02-02-2022

Find out what Excel is capable of with this step-by-step guide to VBA

Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software.

Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to:

  • Understand the basic tools and operations of Visual Basic for Applications
  • Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets
  • Deal with errors and exceptions and eliminate the bugs in your code

Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.

Explore Book

book image

Financial Modeling in Excel For Dummies

Published 01-19-2022

Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel 

Interested in learning how to build practical financial models and forecasts but concerned that you don’t have the math skills or technical know-how? We’ve got you covered! Financial decision-making has never been easier than with Financial Modeling in Excel For Dummies. Whether you work at a mom-and-pop retail store or a multinational corporation, you can learn how to build budgets, project your profits into the future, model capital depreciation, value your assets, and more. 

You’ll learn by doing as this book walks you through practical, hands-on exercises to help you build powerful models using just a regular version of Excel, which you’ve probably already got on your PC. You’ll also: 

  • Master the tools and strategies that help you draw insights from numbers and data you’ve already got 
  • Build a successful financial model from scratch, or work with and modify an existing one to your liking 
  • Create new and unexpected business strategies with the ideas and conclusions you generate with scenario analysis 

Don’t go buying specialized software or hiring that expensive consultant when you don’t need either one. If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time! 

Explore Book

page 1
page 2
page 3
page 4
page 5
page 6
page 7