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!

Ideal in the current climate.

Each session is focussed on topics of interest or need such as Getting Started with Microsoft Teams, Understanding Files in 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.

Tell us your business needs, and we’ll create a virtual classroom tailor made for your team. Click the Contact Us button below or give us a call.

virtual classroom

Workshop examples - "Power" Hour and 90 minutes

MS Teams - Getting Started

microsoft teams logo png
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 Excel – Getting Started

Excel
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

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

MS Excel – More functions

Excel
Intended for those who are familiar with the basic functions but want to extend their knowledge with others to make more use of Excel. Usingthe 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

Excel
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

Excel
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

Excel
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

Excel
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 - Macros

Excel
Intended for those who are at a good competent level of Excel and now want to automate tedious repetitive tasks.

MS Excel - Lookups

Excel
For those who need to refer to information that already exists in other places and have it automatically update. Whilst there are restrictions in using VLOOKUP’s, Index and Match are the most widely used tools in Excel for performing lookups. The INDEX and MATCH combo is very flexible and is the key to more advanced formulas in Excel.

MS Excel – Creating Dashboards

Excel
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 Word – Getting Started

Word
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

Word
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

Word
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

Word
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

Powerpoint
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

Powerpoint
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

Outlook
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

Outlook
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.

MS OneNote – Getting Started

Onenote
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.

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

Contact us today to find out more

Let Bite Size help you to create a live online learning experience that’s tailored to the needs of your staff.

bitsy

Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!