Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Microsoft 365 and SharePoint Online Cookbook
Microsoft 365 and SharePoint Online Cookbook

Microsoft 365 and SharePoint Online Cookbook: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more , Second Edition

Arrow left icon
Profile Icon Mahajan Profile Icon Scott Brewster Profile Icon Sudeep Ghatak Profile Icon Nate Chamberlain
Arrow right icon
Mex$656.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (22 Ratings)
eBook Feb 2024 640 pages 2nd Edition
eBook
Mex$656.99
Paperback
Mex$820.99
Subscription
Free Trial
Arrow left icon
Profile Icon Mahajan Profile Icon Scott Brewster Profile Icon Sudeep Ghatak Profile Icon Nate Chamberlain
Arrow right icon
Mex$656.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (22 Ratings)
eBook Feb 2024 640 pages 2nd Edition
eBook
Mex$656.99
Paperback
Mex$820.99
Subscription
Free Trial
eBook
Mex$656.99
Paperback
Mex$820.99
Subscription
Free Trial

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
Table of content icon View table of contents Preview book icon Preview Book

Microsoft 365 and SharePoint Online Cookbook

Introduction to SharePoint Online

SharePoint Online is part of the Microsoft 365 ecosystem that facilitates collaboration and productivity in organizations by empowering its users with tools to create and share content. At its core, SharePoint is a content management system that gives its users places, such as sites, lists, and libraries, where they can create and store documents and data. It also lets its users collaborate on this content by allowing it to be securely shared with others within or outside the organization. Users are also able to securely find this content through the powerful Microsoft Search capability.

Additionally, SharePoint enables an organization to effectively communicate through rich pages, engaging tools, and web parts. We will go over these areas in more detail throughout the book, first introducing them in Chapter 3, Modern Sites in SharePoint Online.

SharePoint integrates well with a lot of other tools within and outside of the Microsoft 365 ecosystem...

Getting to the SharePoint start page

The SharePoint start page is the central location that shows you relevant content from all the SharePoint sites that you have access to in your organization. From here, you can easily get to the sites that you are following, frequently visit, or have recently visited. This page also lets you search for content across all the SharePoint sites that you may have access to.

This recipe shows you how to log in to Microsoft 365 and then browse to the SharePoint Online home page from there.

Getting ready

To be able to browse to the SharePoint start page, your organization should have purchased one of the Microsoft 365 products that contain SharePoint. In addition, they should have assigned you a license to use SharePoint Online.

How to do it...

You can follow these steps to access the SharePoint Online home page:

  1. Browse to www.office.com and click the Sign in button.
  2. Log in using your email ID and password.
  3. You...

Creating a modern site

SharePoint provides various templates or site types so that you can create sites. These templates use similar building blocks but create slightly different sites in the end that help target different collaboration and communication goals. These templates differ from each other in various ways, such as how they store information, how they present it, and even the features that they offer.

This recipe shows you how to create a site using the Team site template, which is the most commonly used site template for team collaboration.

Getting ready

Your organization should do the following before you can create sites from the SharePoint start page:

  • Grant you access to SharePoint as part of the Microsoft 365 suite
  • Enable the creation of sites from the SharePoint start page
  • Enable the creation of modern sites in your Microsoft 365 environment

How to do it...

To create a new site from the SharePoint start page, follow these...

Viewing site contents

The Site contents page in SharePoint provides a one-stop view of all the lists, libraries, and other apps within the site. Any subsites within that site will also appear here. Provided you have appropriate access, you can also add new lists, libraries, pages, apps, and subsites to the site from this page.

Getting ready

You should have at least Read or View access to a site in order to be able to view the contents within that site.

How to do it...

To view the contents of your site, follow these steps:

  1. Browse to your site in SharePoint.
  2. Click on the settings icon in the top-right corner of any page on the site and then click Site contents, as shown in the following screenshot:

Figure 2.15: Opening the site settings to reach the Site contents page

  1. You will be directed to the Site contents page, as shown in the following screenshot:

Figure 2.16: Viewing Site contents from Site settings > Site...

Creating a list

A SharePoint list is a table-like container that stores information similar to an Excel spreadsheet or a database table. A key difference between Excel files or database tables and lists is that the information in lists is automatically shared with and available to other users that have access to those lists.

This recipe shows you how to create a new list from scratch. For illustrative purposes, we will use this list to store details of the products from our company’s product line. This list will contain the following columns to store the product information:

  • Title
  • Code Name
  • Product Line
  • Date Released
  • Notes

Getting ready

You will need either Edit, Design, or Full Control permission on the site where you’d like to create the list. You will usually have this permission if you are part of the Site owners or Site members groups for the site where you would like to create the list.

How to do it...

...

Adding an item to a list

You can add items to lists in various ways. This recipe will show the most used method to add items to the representative list we created as part of the previous recipe. The other methods to add list items will be covered in greater detail in Chapter 4, Lists and Libraries in SharePoint Online. Even though this recipe uses the Products list as an example, the steps provided here can be used to add items to any list.

Getting ready

You will need Contribute permissions or higher for the list you would like to add the new item to. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the list.

How to do it...

To add a new item to a list, follow these steps:

  1. Browse to the list where you’d like to add the new item.

    You can also access the lists and libraries through the Site contents page. The Viewing site contents recipe earlier in this chapter shows...

Creating a document library

A library is a secure place in SharePoint where you can upload, create, edit, and manage files for online sharing and collaboration with your team. Just like lists, each library comes with key built-in columns that automatically store default information about each file, such as who created the file and when, and who last modified it and when. You can always add your own columns to the library, just as you would for a list. Each SharePoint site ships with one or more libraries to enable you to store files within the site. Libraries can be of different types. A document library is the most used type of library. As the name suggests, it is used to store, manage, and share documents. The Site pages library is used to store and manage pages and news items. The Inbuilt list and library templates topic of the Creating a list using a built-in list template recipe in Chapter 4, Lists and Libraries in SharePoint Online, provides a list of all the inbuilt templates...

Uploading documents to a library

SharePoint lets you create new documents directly within a library through the New menu. It also lets you upload documents that have been authored offline.

In this recipe, we are going to learn how to upload an existing document to a document library and then associate metadata to it. Even though this recipe uses the Marketing Collateral library, which we previously created as an example, the steps here work for any SharePoint library.

Getting ready

You will need Contribute permissions or higher to the library where you would like to upload the document. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the library.

How to do it...

Here’s how to upload a document to your document library:

  1. Browse to the library where you’d like to upload the document.
  2. Click Upload and then choose the Files option to open the file selection dialog...

Deleting and restoring a file

In this recipe, you will learn how to delete a SharePoint document and then restore it from your site’s recycle bin.

Getting ready

You will need to be able to access a document library in a SharePoint site for which you have at least Contribute permission or higher. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the library.

How to do it...

To delete a file:

  1. Select the ellipsis () next to a file, then Delete.

Figure 2.40: Deleting a file from an item’s context menu

  1. Confirm the deletion on the pop-up dialog by selecting Delete. Watch for the status notification in the upper-right corner letting you know the file was successfully deleted:

    Figure 2.41: Deletion notification

    To restore a file:

  1. Select Recycle Bin from the left-hand navigation menu (team sites only) or follow the Viewing...

Sharing a document

Once you’ve uploaded your document to SharePoint Online, you can simply use Share or Copy link to easily share it with your colleagues. This recipe shows you how to share a link to a document using the Share feature.

Getting ready

You should have at least Read access to the document you’d like to share.

How to do it...

To share a document with a member of your team, follow these steps:

  1. Browse to the document you’d like to share.
  2. Click the Share (Share option on the top menu bar, as shown in the following screenshot:

Figure 2.49: Icon for sharing an item on the right of the item name

  1. On the pop-up box that appears, click the gear icon on the right of the filename to open Sharing settings:

Figure 2.50: Opening Sharing settings with the icon to the right of the filename

  1. This will open the Sharing settings dialog, which allows you to select one of the following options...

Searching content

Search is a core part of the SharePoint user experience. It enables users to find relevant business information and documents more quickly and easily than ever before.

For this recipe, I am going to act as a marketing manager who would like to search for our visual design guide, which I remember is called “Branding Elements.”

Getting ready

All you need is Read access to the site where you will be performing your search. The results that SharePoint returns are security trimmed, which means you will only see content that you have access to through direct or indirect permissions.

How to do it...

To perform a search within a site, follow these steps:

  1. Browse to any page on the site where you’d like to perform the search. In our example, I will browse to my Sales and Marketing site.
  2. Start typing your search keywords to see the relevant results. In this case, we will start typing Branding Elements. We’ll notice...
Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Enhance collaboration and productivity using SharePoint, Teams, OneDrive, Viva, Planner, and Microsoft Forms
  • Automate processes, build apps, bots, and dashboards with Power Automate (with RPA), Power Apps, Copilot Studio, and Power BI
  • Harness Copilot, the new AI virtual assistant, for seamless support in your everyday tasks

Description

Microsoft 365 offers tools for content management, communication, process automation, and report creation. Microsoft 365 and SharePoint Online Cookbook maximizes workplace collaboration and productivity using SharePoint Online, Teams, OneDrive, Delve, M365 Search, Copilot, Power Platform, Viva, Planner, and Microsoft Forms. You will find thoroughly updated recipes for SharePoint Online, covering sites, lists, libraries, pages, web parts, and learn SharePoint Framework (SPFx) basics for building solutions. You will explore many Microsoft Teams recipes to prepare it to be your organization’s central collaboration hub. You will be able to unlock Power Platform potential with recipes for Power Apps to enable low-code/no-code app development and learn to automate tasks with Power Automate and Power Automate Desktop. The book teaches you data visualization with Power BI, and chatbot creation with Power Virtual Agents (Copilot Studio). Finally, you will also learn about the cutting-edge Copilot and Gen AI functionality in Microsoft 365 and Power Platform. By the end, you will be equipped with skills to effectively use Microsoft 365, SharePoint Online, and the Power Platform. Whether it's enhancing career prospects or improving business operations, this book is a perfect companion on your journey through the Microsoft Office 365 suite.

Who is this book for?

This cookbook caters to professionals stepping into the world of Microsoft 365 and SharePoint Online. It is tailored for a broad spectrum of skillsets including general business professionals, IT administrators, and enterprise architects who are newcomers to Microsoft 365, offering valuable insights for establishing a contemporary, digital workplace effectively.

What you will learn

  • Collaborate effectively with SharePoint, Teams, OneDrive, Delve, Search, and Viva
  • Boost creativity and productivity with Microsoft Copilot
  • Develop and deploy custom applications using Power Apps
  • Create custom bots using Power Virtual Agents (Copilot Studio)
  • Integrate with other apps, automate workflows and repetitive processes with Power Automate/Desktop (RPA)
  • Design reports and engaging dashboards with Power BI
  • Utilize Planner, To Do, and gather feedback with polls and surveys in Microsoft Forms
  • Experience seamless integration in the mobile platform

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Feb 29, 2024
Length: 640 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803247373
Vendor :
Microsoft

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning

Product Details

Publication date : Feb 29, 2024
Length: 640 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803247373
Vendor :
Microsoft

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Mex$85 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Mex$85 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total Mex$ 2,666.97
Microsoft 365 and SharePoint Online Cookbook
Mex$820.99
Mastering PowerShell Scripting
Mex$922.99
Learn Microsoft Power Apps
Mex$922.99
Total Mex$ 2,666.97 Stars icon

Table of Contents

14 Chapters
Overview of Microsoft 365 Chevron down icon Chevron up icon
Introduction to SharePoint Online Chevron down icon Chevron up icon
Modern Sites in SharePoint Online Chevron down icon Chevron up icon
Lists and Libraries in SharePoint Online Chevron down icon Chevron up icon
Document Management in SharePoint Online Chevron down icon Chevron up icon
OneDrive Chevron down icon Chevron up icon
Microsoft Teams Chevron down icon Chevron up icon
Power Automate (Microsoft Flow) Chevron down icon Chevron up icon
Creating Power Apps Chevron down icon Chevron up icon
Applying Power Apps Chevron down icon Chevron up icon
Power BI Chevron down icon Chevron up icon
Overview of Copilot in Microsoft 365 and Power Platform Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(22 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




bradley wyatt Apr 18, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book does a great job going into the details surrounding Microsoft SharePoint, Microsoft Teams, Power Platform, and CoPilot in M365 and the Power Platform. The pacing of the book stands out as it begins with discussing the platform(s), interfaces, and key words and then dives into configuration, permissions, etc.
Amazon Verified review Amazon
Adam Clifford Apr 19, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book makes it easy to find and perform common tasks in SharePoint, OneDrive, and Teams with some Copilot and power automate content added in as well.The recipe concept is great with each entry broken down into “Getting Ready”, “How to do it”, and “How it works” it’s an excellent go to reference to get additional info on configurations and I really appreciate they that take the time to explain why why’s and just not the how’s as so often is the case.This will definitely.l stay on my reference shelf for all future SharePoint projects!!
Amazon Verified review Amazon
Ayon Roy May 30, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
As a dedicated user of the Microsoft 365 ecosystem for my day-to-day activities, I was on the lookout for a comprehensive resource that combines the power of AI with the full potential of Microsoft 365. That's when I discovered the “Microsoft 365 and SharePoint Online Cookbook” by Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, and Scott Brewster.Reading through this book was an eye-opener! 🌟 The level of functionality within the Microsoft 365 ecosystem is astounding, and I realized I've only been scratching the surface. Here are some key takeaways from the book that blew me away:Microsoft 365 Ecosystem Overview: The book begins with a thorough overview of the ecosystem, highlighting the incredible capabilities of SharePoint. From creating sites and managing documents with ease to adding applications, creating subsites, and organizing everything through lists and libraries, SharePoint truly allows you to build your own mini-universe.Advanced Use of OneDrive and Teams: I learned advanced techniques for leveraging OneDrive and Teams. For instance, I added a GitHub connector to my Teams chat, making it super easy to track activities directly from my workspace.Power Automate: The step-by-step guide on Power Automate was particularly enlightening. This workflow engine helps you create automated workflows with existing services, simplifying daily tasks significantly.Power Apps: The book delves into building custom applications using Power Apps. The setup process in Power Apps Studio is straightforward, allowing you to connect to your business data effortlessly.Power BI: I also refreshed my knowledge of Power BI, learning how to harness its functionalities and embed reports on SharePoint pages seamlessly.AI Integration with Copilot: As an AI enthusiast, I was thrilled to explore how Copilot can enhance the Power Platform. The book provides valuable resources on using Copilot to build apps through conversations and generate/edit DAX in Power BI.Overall, this book is a fantastic guide for anyone looking to maximize their use of the Microsoft 365 ecosystem, enriched with powerful integrations and AI functionalities that can transform your daily workflow. Highly recommended for both beginners and advanced users looking to unlock the full potential of Microsoft 365!
Amazon Verified review Amazon
Gerry O. Brien Aug 18, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I've read many "cookbook" style books in the past only to be left less than satisfied with lack of real content. Sure, you can put together step-by-step instructions as a "recipe", but they don't offer much beyond simply following instructions.This book differs because it tells you about the feature first, why it is used and why it is important. Then you work through an exercise to implement the feature. Finally, the all important summarization of what you did, how you did it, and why you did it, completes the actual learning process.Highly recommended.
Amazon Verified review Amazon
Thomas Rice Apr 09, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The second edition of the "Microsoft 365 and SharePoint Online Cookbook" is highly praised and recommended for individuals engaged with SharePoint and the Power Platform. It is recognized as a crucial resource in the vast landscape of technology learning materials, particularly valuable for its practical guidance on using various Microsoft Office 365 applications. The book focuses on SharePoint Online, Power Platform, and Copilot, offering a straightforward and user-friendly approach. It provides a structured learning path, with early chapters dedicated to SharePoint, followed by sections on OneDrive, Teams, Power Automate, Power Apps, Power BI, and concluding with Copilot and the Power Platform. With 610 pages of content, this book is seen as a go-to reference that readers will continually find useful and is a cherished addition to my personal library.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.