Virtual Classrooms – Microsoft Office - Bite Size, Minutes of Learning Saving You Time Forever

Boost performance by learning just what you need with short virtual online classes

No need to wait for a day’s face to face Microsoft Office course. Our short, focussed interactive on-line classes will help raise skill levels in the applications your staff use everyday, delivered through our team of qualified Microsoft Office trainers, without even having to leave their desk!

Each session is focussed on topics of interest or need such as Getting Started with Microsoft Teams, Understanding SharePoint, Getting to grips with Pivot Tables in MS Excel, Mail Merge in MS Word or Getting the most out of MS Outlook. We can tailor make a virtual class to suit your needs – just ask. It can be one-to-one sessions, or a department or group session bringing everyone together and up to speed in 90 minutes online, wherever they are located.

Ideal in the current climate to support your staff with focussed IT training. All our sessions include detailed feedback. Scroll down and take a look at some of our Virtual Classes.

GOT A QUESTION? GET IN TOUCH

What do our Learners say?

Current Customer Projects : Power BI – Introduction and Intermediate; MS Teams – Getting Started; Getting the most out of MS Teams; MS Excel – Pivots, Dashboards, Lookups, Timesavers and Getting more out of Functions; MS PowerPoint – Striking Presentations, Animating and Transitions – plus lots more. How can we support you?

This is great training for anyone who uses or needs to use MS Project and the trainer was very good at explaining. I loved the exercise element of it and think it is so important to put into practice what we are learning. Great course, great trainer.

MS Project - Introduction Course

All great content. The presenters were really engaging- liked how they named us during the session to provide feedback. I thought it was better than a face to face session as easier to follow and ask questions.

MS PowerPoint - Virtual Class

The Bite Size team were impactful, supportive and brilliant to work alongside. They supported our deployment on MS SharePoint and Teams across our European offices. As the Covid19 pandemic crisis came, Bite Size pivoted quickly and effectively to training virtually. Our staff were reluctant at first but with the expertise of the Bite Size team, we have adapted with ease and are using SharePoint and Teams with success throughout our business. The learning platform provides staff with an opportunity to learn at their own pace and on relevant topics. We look forward to working with Bite Size in the future

HR Manager – Financial Services Sector

You couldn’t ask for a more dedicated team, determined to make sure you and your employees have the best experience they can possibly provide. The quality of MS Office training and the price makes it accessible for any SME

L&D Manager – Transportation Sector

The trainers were excellent. Friendly and approachable, their technique was excellent very straight forward especially for someone who isn't confident with moving around a spreadsheet

MS Excel - Time Saver topics

Both trainers were really friendly, approachable and no question considered too silly. They were very good at building confidence and allowing you space to make and correct errors with assistance

MS Excel - Pivot Tables

Stuart’s SharePoint online session was very well received. Thank you. One person saying ‘best online training he’d ever had!

SharePoint Training via Microsoft Teams

I was apprehensive about the virtual training, but found it worked well, and the group size was just right. Would be happy to have more training this way.

It was very useful and I really enjoyed it. It was just the right length to hold my attention.

MS Excel - Advanced topics

For a beginner it was useful and was taught well

MS Excel - Getting Started topics

Loved it as I didn't even have to leave my desk

MS Word - Paragraph Style topics

Workshop examples - "Power" Hour and 90 minutes

MS Teams - Getting Started

This workshop takes a learner with no prior knowledge of MS Teams to being able to start conversations, calls and meetings, understand how to work with files, notifications, alerts and presence. The aim is to get staff up to speed with using this collaborative tool. The course can also be delivered virtually, bespoke to your Teams set up and can be expanded to include SharePoint and Office 365 online too.

MS Teams - Attending Meetings

During this workshop we explain how to accept and attend a meeting. We talk through the etiquette that should be observed such as muting yourself, use of video, raising your hand, use of Live Captions and how to join a meeting on different devices and what differences to expect.

MS Teams - Managing Meetings

This workshop shows how to set up a meeting and how to create an agenda. We also cover which Meeting options should be considered i.e. mute all, wait in lobby, download register, spotlight attendees and what options might be included at the start of the meeting such as Meeting Notes, role of the Meeting Facilitator, how to sharing files during the meeting the differences between sharing a desktop vs an application. Lastly, we cover the use of whiteboard.

MS Teams - Breakout Rooms

Breakout rooms are a way to separate participants into smaller meetings, either randomly or by organising them yourself – they are great for brainstorming. During this workshop we cover how to create and rename a Breakout Room, how to add extra Breakout Rooms and how to delete them. We will explain how to set participants to be sent to rooms, how to open them and how to switch participants between rooms. We will cover how to send an Announcement to all Breakout Rooms so everyone in all rooms are informed of changes or news during their breakout sessions. We will show how the organiser can jump between rooms and record them and what attendees can and cannot do in a Breakout room. Lastly we’ll show you how to close your Breakout Rooms.

MS Teams - Collaborating on files

In this workshop we show learners how to upload files into a Channel and how to create new ones. We edit files in various ways - direct in Teams, in a browser and in the app. We demonstrate collaboration on files and its benefits.

MS Teams - Setting up Live Events

Teams Live Events is an extension of Teams meetings, enabling users to broadcast video and meeting content to a large online audience. During this workshop we will cover Live Event roles, how to schedule Live Events, produce Live Events, present within Live Events and Event Recording and Reporting.

MS Teams - Forms, Surveys and Polls

Included in this workshop is an overview of Forms and how to create, edit and design a Form. We also create a Quiz and add an existing Form to Teams. We look at the Form and Quiz Settings and Options and Response Options. We also create a Team poll.

Getting started with SharePoint

This workshop is aimed at those who are new to MS SharePoint Environment and explains how it relates to the old world of network shared drives. This course explains about Permissions, Documents, Libraries and Lists and how to add content to Document Libraries. It covers how to check documents in and out, versioning, the Recycle Bin.

Getting started with OneDrive

This workshop is aimed at those who are new to using OneDrive. It will explain what OneDrive is used for and how to open it. It then explains how to navigate around, use the Office online apps, how to create and save documents, connect MS Office to OneDrive, how to work collaboratively and work with version history.

Getting started with Forms, Surveys and Quizzes

This workshop is aimed at those who are new to creating Forms, Surveys and Quizzes in Office 365. It explains how to work with the Setting Options. It covers how to create a quiz and how to share and collate responses.

Getting started with Delve

This workshop is aimed at those who are new to Delve and educates them on how the algorithm continually analyses which people work together. It explains how to manage their Office 365 profile and how documents are analysed and helps users find people and relevant content fast.

Microsoft Planner

This workshop takes a learner with no prior knowledge of MS Planner to being able to create a plan and create and assign tasks. They will learn how to use labels, use check lists and how to filter tasks and upload files, add comments. Lastly they will learn how to capture data for reporting purposes. The course can also be delivered virtually, bespoke to your Teams set up and can be expanded to include other Office 365 apps too.

Getting started with Sway

This workshop is aimed at those who are new to MS Sway. It explains how it is different to PowerPoint and shows how to create Cards, add text and media. It covers how to work with Card elements as well as group cards. It covers navigating, working with Design. It demonstrates how to play, preview, remix and lastly how to share and collaborate

MS OneNote – Getting Started

Stop writing notes on scraps of paper – use OneNote and keep track of your thoughts and ideas all in one place. The workshop objective is for delegates to become more confident to create electronic notes rather than on yellow sticky notes or handwritten pads.

Power BI - Introduction Level

This workshop takes a learner with no prior knowledge of Power BI to being able to import data to be analysed and published from a variety of sources. It is aimed at anyone who is familiar with Microsoft Office applications and who needs to work with data to be able to connect, process and analyse the data to produce suitable output at all levels. It is assumed that attendees on the course are already familiar with charts and PivotTable concepts. The course can also be delivered virtually, bespoke to your Teams set up and can be expanded to include other Office 365 apps too.

Power BI - Intermediate Level

This workshop is aimed at those who have a good knowledge of Power BI and want to take their skills to the next level learning about DAX formulas. It is assumed that attendees on the course are already familiar with Power BI. The course can also be delivered virtually, bespoke to your Teams set up and can be expanded to include other Office 365 apps too.

MS Excel – Getting Started

This workshop takes a learner with no prior knowledge of Excel to being able to perform simple calculations such as addition, subtraction, multiplication and division and add up a column or row of data. It also covers how to work out the minimum, maximum and average in a range of cells. This session covers the importance of understanding which order calculations are performed in. It explains how to centre headings, format numbers and understand about fixing cells. Lastly it covers viewing and amending page breaks.

MS Excel – Working with Worksheets and Workbooks

This workshop is a follow on from the Getting Started session and shows learners how to manipulate worksheets, how to format multiple worksheets as well as perform calculations across them. Learners will also learn how to perform calculations across workbooks.

MS Excel – More functions

Intended for those who are familiar with the basic functions but want to extend their knowledge with others to make more use of Excel. Using the IF functions to nest formulas to perform calculations if certain criteria are met i.e. if the total exceeds £3,000 then give a 2% bonus otherwise give 0. Learning how to count up contents in cells, using criteria. Other useful functions included are how to join cell contents together, amend the case of text i.e. change from lowercase to proper or upper. Delegates will also learn how to future proof calculations to avoid errors showing. Delegates will also learn how to always round down and also learn how to keep an eye on a total cell that is out of sight. Learning about the DSUM, DMIN, DMAX and DCOUNT allows you to be selective about which items you include i.e. if your list contains hundreds of entries you might ask DSUM to only add up those entries in January.

MS Excel – Manipulating & Analysing Data

It covers how to visually format data to stand out showing trends, how to protect and prevent data from being edited in certain cells and also adding validation to only allow certain entries i.e. certain dates or only from a list of entries. Great if you need to share a spreadsheet and but need control over what is allowed.

MS Excel – Pivot Tables and Charts

For those who work with large amounts of data and need to be able to summarise and cut and slice the information quickly. It also covers how to create Pivot charts to allow the data to be changed at the click of your mouse.

MS Excel – Charts

For those who need to visually display information rather than looking at numbers. Also includes how to save time by linking charts into other applications which will automatically update when the workbook is changed.

MS Excel - Timesavers

Aimed at those who are at an introduction level or self-taught and want to learn new skills to make working with Excel quicker and easier. This workshop covers how to name cells to make formulas easier to read, how to create a list to avoid retyping entries that are frequently used. It also includes how to format ranges of data as well as creating a master spreadsheet that can be used over and over. Lastly how to summarise data from various workbooks is also covered.

MS Excel - Data Validation and Conditional Formatting - NEW

This workshop shows how Conditional formatting can help make patterns and trends in your data more apparent i.e. red is applied to numbers over 100, format cells with dates in, use formulas with conditional formatting and even highlight blank cells and entire rows. We also cover how to you can use Data Validation to restrict the input of data, lock and unlock cells, protect worksheets and use input messages and error alerts.

MS Excel - Macros

Intended for those who are at a competent level of Excel and now want to automate tedious repetitive tasks. This workshop includes what you should be considering before starting a recording, planning your steps, starting the recording, running the recording back and assigning it to the Quick Access Toolbar or a button in your workbook.

MS Excel - LOOKUPS

For those who need to refer to information that already exists in other places and have it automatically update. VLOOKUPS and HLOOKUPS are covered in this virtual class as well as INDEX and MATCH. We also explore the new benefits of using XLOOKUP which is a new function within the LOOKUP series and highlights the advantages of using it.

MS Excel – Creating Dashboards

Aimed at those who are familiar with pivots and working with large amounts of data but now would like to be able to summarise it as an overview page. Having learnt different topics in Excel this workshop brings together different options into one place to dynamically show high level overviews,

MS Excel - Working with Dynamic Arrays - NEW

Imagine having a spreadsheet with lots of data where you need to extract certain fields of information. If you are already familiar with using functions, we now take you to a new level and work with dynamic array formulas (formulas that can return arrays of variable size are called dynamic array formulas) which allow you to perform multiple calculations on one or more items in an array. We will explore functions like Small and Large, Unique, Filter and Sort and see how they spill to return values to neighbouring cells. Delegates must have a good working knowledge of using functions before attending this workshop.

MS Excel – Working with Tables - NEW

This workshop will change the way you work with data in MS Excel. It’s aimed at those who are already familiar with the basics of Excel and are ready to take their knowledge to the next level. We will explore topics such as rules before creating a table, formatting your table, adding new rows and columns, Filtering and Sorting, adding Slicers, Pivot Table/Charts, data validation (dropdown lists), Conditional Formatting, differences in the Desktop app and web and understanding Structured References.

MS Excel – Recording and Playing Macros - NEW

This workshop is designed for those who have tasks in Microsoft Excel that are frequently repeated and want to make it quicker and eliminate errors. A macro is an action or a set of actions that you can run as many times as you want to record your mouse clicks and keystrokes. We will explore topics such as Macros explained, scripting, trust settings, developer tab, recording and naming Macros, Absolute v Relative Macros, creating buttons to play Macros and looking at the code.

MS Excel – Cleansing Data - NEW

The data you use in Excel is of paramount importance. Things can easily go wrong be it the structure, placement, formatting or extra spaces. This workshop is designed for those who need to manipulate and extract data by using various Excel tools. To attend you should have a good basic knowledge of Excel and must be conversant with creating basic formulas. We will explore topics such as trim, removing duplicates, text to columns, working with blank cells, Conditional Formatting to find errors, clearing all formatting, find/replace and convert numbers stored as text.

MS Excel – Managing large Worksheets - NEW

What prints isn’t necessarily what you see on the screen. We look at everything to do with setting up spreadsheets for printing, as well as different views and settings to help you when working with larger spreadsheets. We will explore topics such as Workbook views, printing selection, page break preview, freezing and splitting panes, arranging windows, inserting/editing/printing notes, creating/editing a named range, page setup options including header & footers, scaling, margins, printing gridlines, setting print titles, setting print areas/print selection and saving as a PDF.

Excel 2016 Introduction to Visual Basic for Applications

This workshop is designed for those who need to know how to write macros using VB code. It covers how to record a macro using the Macro Recorder, record a macro using relative and absolute cell references. It also covers where to store the macro, how to assign it to a shortcut key and how to delete macros. It then goes on to show how to use VB to create and edit Macros and the concepts of storing macros. Also covered is how to use the VB Editor and access help. It also shows how to close the Editor and understand about Macro Security. How to work with Procedures and Functions, Objects and Dialog Boxes, use Expressions, Variables and Intrinsic Functions, Control Program Execution, User Forms and Controls, Work with the PivotTable Object, Work with External Files, Interact with other applications, Code debugging and Error Handling Duration 1 or 2 days depending on content.

MS Word – Getting Started

This workshop takes a learner with little or no prior knowledge of Word and helps them understand the environment to enable them to create, save and open documents. Basic character formatting techniques are covered.

MS Word – Paragraph Formatting

Aimed at those who need to work more efficiently with Word to save time formatting. This workshop covers how to work with paragraphs quickly and easily without doing tasks the long way round.

MS Word – Document Formatting

Intended for those who need to format documents efficiently and take advantage of the options that Word has to offer to make documents look professional. It covers how to add page borders and shading and how to quickly change from portrait to landscape. Delegates will learn how to control pagination and page numbering. Also covered is how to work with Section Breaks to enable the document layout to be altered. Lastly adding tables is also included to control the flow of text.

MS Word – Mail Merge

For those who need to send letters out to multiple recipients. Learning how to work with mail merge will enable delegates to create letters, labels and lists from single sets of source data.

MS PowerPoint – Animating and Transitions

Aimed at those who want to liven up presentations with movement. Learning how to animate lists and objects and controlling effects on the page. Changing the transition effects between slides is also covered as well as understanding about how to produce speaker notes and handouts.

MS PowerPoint – Creating striking presentations

First impressions count and grabbing your audience attention is of vital importance. We have all sat through boring presentations – no more. By attending this presentation you will learn some creative and fresh ideas to visually liven up your presentations.

MS Outlook – Making the most of it

We all use Outlook everyday and probably it takes up a large proportion of your day so it’s important you use the features available to you and save yourself time.

MS Outlook – Calendars

It’s vital everyone uses their calendar correctly and keeps it up to date. This workshop will explain about the different types of appointments, events and schedule meetings with colleagues.

View and Download our Catalogue

Bite Size Virtual and Face to Face Workshops - examples

Let Bite Size help you to create a live online learning experience

Tell us your business needs, and we’ll create a virtual classroom tailor made for your team. Take a look at some of our sample workshops and give us a call.

Virtual Classrooms – Microsoft Office