Building Business Solutions with Office 365 and SharePoint Online

Audience:End User / Power User, Business Executive
Duration:3.00 day(s)

Price: £1,275.00
Accommodation: £330 (UK Midlands only)

About this course

This fast paced 3-day workshop will teach you how to build powerful SharePoint business solutions without having to engage in any custom development. You will be amazed exactly how far you can take things with Office 365 and SharePoint Online just using the out-of-the-box features and functionality. This course has been specifically designed for the experienced business users who wants to re-engineer parts of their business process in the Office 365 environment. You will complete all lab exercises for this course using the browser, SharePoint Designer 2013, InfoPath 2013 and other no-code tools, such as Microsoft Flow and PowerApps.

The first day of the course introduces you to Office 365 services and revises SharePoint Online functionality, in particular, how to customize lists and documents libraries by creating and adding site columns and contents types, and the use of Document sets. You will end the first day by reviewing the current list of no-code tools, including an introduction into the use of Windows PowerShell.

You will learn how to use InfoPath 2013 and PowerApps to customize the forms to display and manipulate data from SharePoint list and other data sources, as well as introducing you to Microsoft Forms. You will learn about the workflow architecture in SharePoint Online and discover a new sense of power when creating custom workflows with SharePoint Designer 2013 and Microsoft Flow.

You will learn how to visualize your business data on top of services that are included in Office 365 such as Power BI and Excel Services and the course concludes with an examination of the techniques and strategies to expose content on pages you find in Office 365.

Meet your trainer

Choose a date

All Combined Knowledge courses can be delivered privately online or at a site of your choice.
Contact us to arrange private delivery of a course or to find out more.

Written and developed by Penny Coventry, MVP

Book a private delivery of this course

There are currently no dates scheduled for this course, but all of our courses can be delivered privately at a site of your choice.

Our private on-site / online training can provide your business with the following benefits:

  • Substantial savings on travel and expense costs
  • Group learning – ensuring a consistent transfer of knowledge
  • Open discussions focused on specific business requirements
  • Ability to ‘cherry pick’ modules and tailor course content to your specific needs.
  • Multiple delivery and set-up methods

Contact us to arrange private delivery of a course or to find out more.

Course Syllabus

This fast paced 3-day workshop will teach you how to build powerful SharePoint business solutions without having to engage in any custom development. You will be amazed exactly how far you can take things with Office 365 and SharePoint Online just using the out-of-the-box features and functionality. This course has been specifically designed for the experienced business users who wants to re-engineer parts of their business process in the Office 365 environment. You will complete all lab exercises for this course using the browser, SharePoint Designer 2013, InfoPath 2013 and other no-code tools, such as Microsoft Flow and PowerApps.
The first day of the course introduces you to Office 365 services and revises SharePoint Online functionality, in particular, how to customize lists and documents libraries by creating and adding site columns and contents types, and the use of Document sets. You will end the first day by reviewing the current list of no-code tools, including an introduction into the use of Windows PowerShell.
You will learn how to use InfoPath 2013 and PowerApps to customize the forms to display and manipulate data from SharePoint list and other data sources, as well as introducing you to Microsoft Forms. You will learn about the workflow architecture in SharePoint Online and discover a new sense of power when creating custom workflows with SharePoint Designer 2013 and Microsoft Flow.
You will learn how to visualize your business data on top of services that are included in Office 365 such as Power BI and Excel Services and the course concludes with an examination of the techniques and strategies to expose content on pages you find in Office 365.

Modules

 
Module 1: Introducing Office 365 Services
Module 2: SharePoint Online: a quick revision
Module 3: Strategies and tools to build no-code solutions
Module 4: Creating custom forms using InfoPath 2013
Module 5: Introducing Microsoft Forms and building PowerApps
Module 6: Workflows in SharePoint Online
Module 7: Working with Microsoft Flow
Module 8: Visualizing data: Excel Services and Power BI
Module 9: Exposing content on Office 365 pages  

Student Prerequisites

 
Before attending this course, students must:

  • Understand and have used the browser to work with SharePoint site components, including, Lists, Libraries, Content Types, Site Columns, and Permissions. The course expects students to be able to create and manage SharePoint components using the browser with minimal instructions, including the creation of content in a variety of list and library types.
  • Have experience of identifying aspects of their organisation’s requirements to a collection of activities and tasks that map to specific business processes.
  • Ideally, students would have previously used a business process mapping tool and experience of programming logic, such as, you might find in Microsoft Excel.

Students will have previously attended the SharePoint Online Power End User, or the equivalent SharePoint Online courses or have equivalent knowledge. Note: Throughout this course, we refer to no-code solutions. By no-code, we mean no complex programming languages such as .NET languages or code compilation. However, to help demonstrate the extensibility of Office 365 and SharePoint Online, we do not exclude discussion of or use of Cascading Style Sheet (CSS) scripting/class, Extensible Stylesheet Language (XSLT), Extensible Markup Language (XML), XML Path Language (XPath), JavaScript or existing page code

Courses related to Building Business Solutions with Office 365 and SharePoint Online

Over many years, we have come to understand and love a suite of Microsoft products including products like Outlook and Excel; most of these products have been with us for over ten years and often make the work we do possible.

Office 365 has introduced a range of new products causing much excitement and more than a little confusion. This class will help you to understand two of these newer products, Office 365 Groups and Teams.

We cover the specific details of how to use Groups and Teams, while also looking at the bigger picture to help you understand how you might use them in the real world to improve the way you share files and communicate as a business.

Finally, we discuss the administration process for Groups and Teams, with a review of the management options including security and controlling who can use the tools.

View course

For users with 6 - 12 months' experience with Power BI, this Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to distribute those solutions to a wide audience using app workspaces and the Power Bi app model.

View course

This 1-day course is designed for companies looking to make a smooth transition to Office 365. The course explains what Office 365 is and how it will benefit individuals and the company as a whole. The course removes the mystery of Office 365 showing practical uses for all of the Office 365 components from SharePoint Online to Delve. This course is a workshop where students will follow the instructor’s demonstrations.

View course

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

View course

This 3-day course provides detailed hands-on experience for companies looking to make the most of their Office 365 licenses and the data they hold. This course looks at the different parts of Office 365, including some that you may not be aware of. It shows how you can utilise all these tools to get the full benefit of 365 as individuals and as a business. We will cover everything from the more familiar Office Apps and collaborate with colleagues to the building of automated processes.

View course