Betasoft provide tailor-made, instructor-led training services for Microsoft Office 365, SharePoint, Power Platforms and Azure.

Betasoft offer expert-led training options that can be delivered in our training centre, at our customers’ sites or virtually. All training is hands-on and lab-based with an expert on hand to explain and demonstrate.

  We are happy to put together custom training packages to suit your individual needs.
Training Packages start at £1,995 + VAT.

Travel expenses are charged where applicable. 

Book your training today Consultancy Services

Sharepoint Training Modules

  • Create a new Office 365 tenant and understand how domains work
  • SharePoint Online Overview
  • SharePoint Online vs On-premise
  • SharePoint Management Interface
  • User Identity and Permissions Management
  • User Management
  • Existing App lists (tasks, calendars, picture libraries, etc)
  • New custom lists
  • Create an App / Modern Apps

Module 2

Custom Built-in Apps (Lists)

  • Existing App lists (tasks, calendars, picture libraries, etc)
  • New custom lists
  • Excel-generated lists
  • Create an App
  • App Settings
  • Modern Apps

 

Module 3

Advanced Meta-Data Management

  • Column types
  • Meta-data creation options
  • The Term Store
  • Managed Meta-data
  • Meta-data integrity

 

 

Module 4

List and Library Views

  • Built-in View types
  • Create a new View
  • Managing Views

 

Module 5

Web Page Editing

  • Content pages
  • Site pages
  • Wiki pages
  • Adding pictures and media
  • Hyperlinks and emails
  • Adding Web Parts

 

 

Module 6

Workflows

  • Built-in Workflows
  • Enable Workflow Templates
  • Add a Workflow
  • Manually start a Workflow
  • View tuning Workflow history
  • Allow, retire or remove a Workflow

 

 

Module 7

Sharing

  • Configure external user sharing
  • Enable external user sharing
  • Enable per-site collections
  • Share with external users
  • Remove external user access using the Web UI and Windows PowerShell

 

Module 8

Office 365 Additional Service Integration

  • Microsoft Teams
  • Project Online
  • Yammer
  • PowerApps
  • LogicApps

Our Training Packages

Overview

This course will provide an introduction to the Microsoft Power Platform. You will learn about the value and capabilities of PowerApps. Understand how the Common Data Service allows you to delve into powerful, scalable data solutions in the cloud. Learn how to leverage Power Automate to improve business efficiency and productivity. Gain an appreciation of how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.

Prerequisites

There are no prerequisites for this course

Outline

Module 1: Introduction to Power Platform
Learn about the components of Power Platform, ways to connect data, and how organizations can leverage this technology to

Lessons

  • Power Platform Overview
  • Module Summary

After completing this module, students will be able to:

  • Identify when to use each Power Platform component application to create business solutions
  • Learn the value of using Power Platform to create business solutions
  • Learn the components and features of Power Platform

Module 2: Get Started with Power Apps
Learn about the value and capabilities of PowerApps, and ways other organizations have leverage this technology to build simple applications for their business.

Lessons

  • Power Apps Overview
  • How to Build an App Solution
  • Create Staff Canvas App
  • Complete the App

Lab : How to Build a Basic Canvas App 2

  • Create Security Canvas App

After completing this module, students will be able to:

  • Learn how other organizations digitize their processes using Power Apps
  • See Power Apps in action and learn options for making your first app
  • Learn about what Power Apps is and its business value

Module 3: Introduction to Common Data Service
The Common Data Service allows you to delve into powerful, scalable data solutions in the cloud. Learn what makes the Common Data Service tick and how it can work with the Power Platform to create unique and efficient business solutions.

Lessons

  • Common Data Service Overview
  • Module Summary

Lab : Data Modeling

  • Create Environment and Solution
  • Create Entities and Relationships
  • Import Data

After completing this module, students will be able to:

  • Descibe the difference between Common Data Service and Common Data Model
  • Explain use cases and limitations of business rules and process flows
  • Explain what environments, entities, fields, and relationships are in common data service

Module 4: Get Started with Power Automate
Learn how users can leverage Power Automate to improve business efficiency and productivity.

Lessons

  • Power Automate Overview
  • How to Build an Automated Solution

Lab : Build a Simple Flow

  • Create Visit Notification Flow
  • Create Security Sweep Flow

After completing this module, students will be able to:

  • See how Power Automate works and looks from the user’s perspective
  • Build a simple flow
  • Learn the business value and features of Power Automate

Module 5: Get Started with Power BI
Learn how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.

Lessons

  • Power BI Overview
  • How to Build a Simple Dashboard

Lab : Build a Power BI Report

After completing this module, students will be able to:

  • See how Power BI works and looks from the user’s perspective
  • Learn how to build a simple Power BI dashboard
  • Describe the business value and features of Power BI

Read more

Overview

Power Apps is a core part of the Office 365 suite and provides a platform for creating online forms, desktop and mobile apps that connect to your business data. This course is an introduction to PowerApps focusing on the creation and distribution of canvas Apps.

This course can be used to gain the pre-requisite knowledge required for course QAMPAPPS – Mastering Power Apps, which is a more technical in-depth look at creating Power Apps

Target audience

Anybody who wishes to create an online business app.

Prerequisites

The following prerequisites are recommended before attending:

  • A basic understanding of Windows 7 or later versions
  • Experience using Internet Explorer or equivalent browser
  • A general knowledge of using Office 365
  • A basic knowledge of using functions in Excel or a similar program
  • Some basic programming knowledge is useful but not essential

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Delegates will learn how to

After attending this course, delegates will be able to:

  • Understand the function of Power Apps and understand how it fits with the Power Platform
  • Create Apps from scratch, from templates or from existing data
  • Save and publish apps
  • Work with versions
  • Work with: Screens, Controls and set properties
  • Understand navigation between screens
  • Understand and use variables
  • Work with data sources
  • Work with tables and galleries
  • Use functions and formulas
  • Work with data forms for viewing and editing data

Outline

Overview of Power Apps

This module introduces Power Apps, what you can do with Power Apps and how Power Apps fits with the rest of the Power Platform. It also contains and exercise that will prepare the student environment for working with and creating Power Apps.

The Power Apps Studio

This module starts with an explanation on how to launch and use the Power Apps studio for creating, editing and running apps. There is also a section on the other ways that apps can be run by users. The module will also look at how apps can be saved, published and shared with other users as well as investigating the versioning system of Power Apps. The three main ways of creating apps are introduced and there is an exercise where students will create, save and publish an app from a template.

Screens, controls and navigation

In this module students will examine the core building blocks of Power Apps, namely Screens and Controls. As part of this the naming of these objects and a discussion on naming conventions will be covered. This module will also look at setting properties including the use of relative and linked properties. There will also be an examination of the properties that can be used to invoke change.

Variables and functions

The module will introduce students to the use of functions in Power Apps and will focus on commonly used functions including Navigate, Text and Value as well as exploring how multiple functions can be used together. Variables and the functions used to manipulate them are also introduced. There is an exercise to bring together all the skills introduced so far in the course.

Working with data – galleries

In this module, students will be introduced to data and tables including data sources and records. The main ways of displaying multiple records are introduced, namely the table and gallery controls. The use of searching and the sum function within data tables is also introduced and there is an exercise to practice theses skills.

Working with data – forms

The final module of this course looks at using forms to view and edit individual records from the data sources. The module also introduces data cards, the sub-components of forms and shows their importance when creating apps. Finally, the functions used with forms to create and update records are introduced. This module has two exercises, the first to cement learning from the module, the second to investigate publishing and versions which was not possible earlier in the course due to lack of data.

Read more

Overview

Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analysed visually.

This course covers the use of existing Power BI Desktop or Power BI reports and dashboards. It will identify core features, terminology and processes applicable when using reports or dashboards. Its principal aim is to provide the skills to enable a delegate to work with the reports and dashboards effectively.

Please note – this course does not cover creating reports or dashboards.

Target Audience

Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards.

It is assumed that attendees on the course are familiar with charts.

Attendees who wish to learn how to create Power BI Reports should attend the QA course Microsoft Power BI Desktop QAPBIDT3.

Read more

Prerequisites

  • Please note that this course is not suitable for new Excel users
  • Ability to create charts
  • Ability to use filters in data

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Learning Outcomes

Delegates will learn:

  • Power BI concepts and main features
  • How a report is created
  • Navigating reports and dashboards
  • How to apply filters and slicers
  • To use Insights, Analytics and Natural Language Queries

Course Outline

Module 1: Getting Started with Power BI

  • Power BI Concepts and Versions
  • Introduction to Main Features:
    • Jargon buster
    • From Data to Reports and Dashboards
    • Visualizations Overview
    • Visualizations Available
    • Visualizations as Filter
    • Reports and Dashboards Similarities and Differences

Module 2: Understanding what you are looking at

  • What do the visuals show me?
  • Refreshing a report

Module 3: Using a Report in Power BI

  • Filters, sorting and using slicers
  • See the actual data
    • See Data and See Records
    • Drill visualizations
    • Q & A Ask a question
  • Off the shelf data analysis
    • Quick Conditional Formatting
    • Analytics lines
    • Use Insight for Increases and Decreases
    • Forecast Analytics
    • Changing calculations and Show As

Module 4: Working with Dashboards

  • Dashboards in Power BI Defined
  • How is a dashboard different from a report?
  • Working in the Dashboard window
  • Using Q & A with natural language queries

QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.

Example Training Packages

Create your own Training Packages - From £1,995+VAT

Microsoft Office 365 Overview

  • 2 days
  • Cloud service models.
  • Plan for migration to Microsoft Office 365 services.
  • Enterprise mobility in Microsoft Office 365.
  • Teamwork in Microsoft Office 365
  • Identity Management, including cloud, on-premise, and hybrid.
  • Cloud device management and protection, covers Intune.
  • Data protection, delivered through Azure Information Protection.
  • Compliance features in Microsoft 365.
  • Microsoft Office 365 subscriptions, licenses, billing, and support

SharePoint Admin Intro

  • 3 days
  • Create a new Office 365 tenant and understand how domains work
  • SharePoint Online Overview & vs On-premise
  • SharePoint Management Interface
  • User Identity and Permissions Management
  • Onboarding users
  • Synchronise users from Azure AD
  • Advanced Meta-Data Management
  • List and Library Views
  • Web Page Editing
  • Workflows
  • Sharing

PowerApps Essentials

  • 3 days
  • Introduction and Overview
  • Create Apps from scratch, from templates or from existing data
  • Work with: Screens, Controls and set properties
  • Navigation between screens
  • Use of variables
  • Understand data sources, tables and galleries
  • Use functions and formulas
  • Learn to use data forms for viewing and editing data

Power Automate Essentials

  • 2 days
  • Introduction
  • How does Power Automate fit in to 365
  • Use templates to get started
  • Modify existing templates
  • Running a workflow
  • Create your own from scratch
  • Understand Triggers
  • Controls, Actions and Variables
  • Understand Approval workflows
  • Implement your own complex workflows

PowerBI Essentials

  • 1 day
  • Introduction andOverview
  • PowerBI architecture and place within 365
  • How are reports created
  • Navigation
  • How to use filters and slicers
  • Learn to use Insights, Analytics and Natural Language Queries
  • How to visualise your data
  • Compare Reports and Dashboards
  • Understanding your output

Azure Fundamentals

  • 1 day
  • Overview and Architecture: Public, Private, and Hybrid cloud models
  • Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS)
  • Competitors of Azure
  • General cloud computing concepts
  • Core services available with Microsoft Azure
  • Ssecurity, privacy, compliance and trust with Microsoft Azure
  • Pricing and support models available with Microsoft