Book Image

Microsoft 365 Fundamentals Guide

By : Gustavo Moraes, Douglas Romao
Book Image

Microsoft 365 Fundamentals Guide

By: Gustavo Moraes, Douglas Romao

Overview of this book

With its extensive set of tools and features for improving productivity and collaboration, Microsoft 365 is being widely adopted by organizations worldwide. This book will help not only developers but also business people and those working with information to discover tips and tricks for making the most of the apps in the Microsoft 365 suite. The Microsoft 365 Fundamentals Guide is a compendium of best practices and tips to leverage M365 apps for effective collaboration and productivity. You'll find all that you need to work efficiently with the apps in the Microsoft 365 family in this complete, quick-start guide that takes you through the Microsoft 365 apps that you can use for your everyday activities. You'll learn how to boost your personal productivity with Microsoft Delve, MyAnalytics, Outlook, and OneNote. To enhance your communication and collaboration with teams, this book shows you how to make the best use of Microsoft OneDrive, Whiteboard, SharePoint, and Microsoft Teams. You'll also be able to be on top of your tasks and your team's activities, automating routines, forms, and apps with Microsoft Planner, To-Do, Power Automate, Power Apps, and Microsoft Forms. By the end of this book, you'll have understood the purpose of each Microsoft 365 app, when and how to use it, and learned tips and tricks to achieve more with M365.
Table of Contents (18 chapters)

Saving all responses in Microsoft Excel

Most surveys, after completion, will have the answers exported and the form deleted. So, how do we export these answers in an Excel sheet?

We can easily export the survey data in Excel (Figure 13.8). The data can be integrated into any system or serve as a source for a dashboard:

Figure 13.8 – Downloading the form responses in .xlsx format

As we have seen, forms are the gateway for external users, so there are surveys (such as onboarding for employees) that can stay open forever and have data integrated as soon as a new response is made. And for that, we once again rely on 365 integrations.

We are able to make an Excel-based form with this resource. The answers are completed in real time on a spreadsheet, and the best thing is that we can choose where we want to store the file, thus facilitating integration and consumption of filled data!

To do this, follow these steps:

  1. Create an Excel sheet...