Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Office 365 User Guide
  • Table Of Contents Toc
  • Feedback & Rating feedback
Office 365 User Guide

Office 365 User Guide

By : Nikkia Carter
2.3 (3)
close
close
Office 365 User Guide

Office 365 User Guide

2.3 (3)
By: Nikkia Carter

Overview of this book

Microsoft Office 365 combines the popular Office suite with next-generation cloud computing capabilities. With this user guide, you'll be able to implement its software features for effective business communication and collaboration. This book begins by providing you with a quick introduction to the user interface (UI) and the most commonly used features of Office 365. After covering the core aspects of this suite, you'll learn how to perform various email functions via Exchange. Next, you will learn how to communicate using Skype for Business and Microsoft Teams. To boost your productivity, this book will help you learn everything from using instant messaging to conducting audio and web conferences, and even accessing business information from any location. In the final chapters, you will learn to work in a systematic style using file management and collaboration with OneDrive for Business using SharePoint. By the end of this book, you'll be equipped with the knowledge you need to take full advantage of Office 365 and level up your organization's productivity.
Table of Contents (23 chapters)
close
close
Free Chapter
1
Section 1: Understanding Office 365
4
Section 2: Managing Microsoft Exchange
10
Section 3: Skype for Business and Microsoft Teams
14
Section 4: OneDrive for Business
17
Section 5: Collaboration Using SharePoint

Exporting to Excel

You can export a list or a library to Excel. This can be very useful for reporting purposes.

In the Classic Experience, in the List or Library tab, click on the Export to Excel button:

In the Modern Experience, in the action bar, click Export to Excel:

If you are prompted to confirm the operation, click OK.

In the File Download dialog box, click Open:

You may be prompted to enable data connections on your computer. If you think the connection is safe, click Enable.

There are few things to note here:

  • I recommend exporting the All items view and then filtering the list or removing columns in Excel.
  • An Excel table is created with a data connection based on a web query file (.iqy). Save the file as a .csv or .xslx file to prevent issues that can arise from the .iqy file type.
  • The columns in the export are determined by the current list view.
  • Filters will not...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY