Bite Size Learning
Webinars, Seminars & Hybrid Training
Let’s face it. Sometimes, you can’t manage a feast. Sometimes, all you want is a snack. It’s the same with training: it doesn’t always suit to dedicate a full day to training.
Bite-size learning is all about training a large number of staff in a short period of time, so it’s cost effective and efficient. We take the most popular topics and condense them down, and your staff get new skills that they can use right away.
We can train right there in your offices or arrange a local venue – it’s all about maximum benefit and minimum impact on your day.
Which suits you best – Webinars (online), Seminars (face-to-face), or Hybrid (a combination)?
Our Bite Size Learning Options:
Choose from our most popular range of webinars. Run either one or two webinars in a day.
Our Course List
General Courses
Office Migration – Learn what’s new in Microsoft 365
Have you recently upgraded to the latest version of office and don’t want to waste time scrolling all the different tutorials on what’s new?
In this fast-paced learning session, you’ll learn:
What’s new in:
- Excel
- Word
- PowerPoint
- Outlook
Microsoft365 Power User Skills - Tips and Tricks
With every new version of Office, Microsoft adds even more features that make working with your Office files even easier to work with day-to-day. Whether you’re talking about tools that help you work more efficiently or helping you to present data on screen more effectively, Office has what you need.
In this course, you’ll learn how to work faster and more efficiently using Microsoft365 by mastering time-saving techniques and learning tips, tricks and shortcuts for Word, Excel, PowerPoint and Outlook.
Excel Courses
Microsoft Excel - Top Tips
- Be in Ctrl With 10 Cool Shortcuts
- Gain Quick Access to All Your Favourites
- Free Movement of Data!
- Quickly Remove Your Blanks!
- Reuse Data to Build Data
- Resizing Secrets
- Format Painter- Again and Again!
- Manipulating Text to Suit Yourself
- The Power of Grouping
- Date Trickery
- 5 Functions You Can’t Function Without
- Why is Flash Fill Awesome?
- Table Magic
Excel Formulas – A Beginners Guide to Microsoft Excel
Formulas play a big part in working with Excel.
So, to take your formula knowledge to the next stage you need to have a good understanding of the basics. After that, everything becomes easier.
You will learn about:
- The mathematical symbols used in formulas
- Priority of operators
- Writing formulas and understanding the structure
- Using Basic Functions (Sum, Min, Max, Average etc)
- Using Relative and Absolute Referencing
Cleaning Data with Formulas in Excel
One of the important parts of working with Excel is your data. Get your data in a more workable format and everything becomes easier in Excel.
In this course, you’ll learn to “clean up” your data by using such functions as; TRIM, PROPER, and CLEAN functions to remove extra spaces, non-printable characters, and fix the capitalization of words.
Getting Started with PivotTables
If you find yourself buried under an avalanche of data and need to produce reports easily and efficiently, then allow Excel PivotTables to come to your rescue! PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to you, your boss and your company’s specific needs.
In this fast-paced learning session, you’ll learn:
- What is an Excel PivotTable?
- Creating a PivotTable
- Formatting and modifying a PivotTable
- Summarizing data
- Exploring PivotTable options
- Sorting and filtering in a PivotTable
- Refreshing data
- Visualising your data with Pivot Charts
- Adding a Slicer to filter data
In-depth analysis with Pivot Tables in Excel
In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently, create multiple customized reports in a few easy steps, and gain a powerful new tool to help you make better business decisions. Led by an Excel expert, this training event concentrates solely on PivotTables, what they are and how they can make your life much easier!
In this fast-paced learning session, you’ll learn:
- Why PivotTables are the “hidden gems” inside Excel
- How to create multiple PivotTables so you can analyse large data sets from a different business perspective
- How to easily group and view data in a spreadsheet
- The secrets to converting PivotTables into easy-to-read charts instantly
- Steps for creating a macro that keeps your PivotTable data automatically updated
- How to group date-related data into months, quarters and years and perform ad hoc grouping in 2 quick steps
- Creating calculations in a pivot table
An Alternative to Pivot Tables – Using Countifs, Sumifs and Averageifs
These functions can be a useful alternative to PivotTables. Both the PivotTable and stated functions have their pros and cons. In this session, both will be discussed.
Sumifs and Countifs are advanced forms of Sumif and Countif functions respectively. They can work with single as well as multiple conditions.
In this fast-paced learning session, you’ll learn:
- Countifs/Sumifs vs PivotTables
- Countifs
- Sumifs
- Averageifs
- Maxifs and Minifs (Office 365)
Modern Data Analysis - Get & Transform and Power Pivot
With Get & Transform and Power Pivot in Excel, you’ll spend less time manipulating data, and more time driving impact. Whether it’s small data sets or large ones with up to millions of rows, you can connect, clean, analyse, and share your data faster.
Power Pivot allows you to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. You can use the Data Model and a collection of tables to create relationships stored as part of the workbook. The Data Model integrates deeply with other features in Excel, such as tables and PivotTables, to provide a seamless analytics experience.
Everything you need to know to master the VLOOKUP on Excel
When you want to pull information from a table, the VLOOKUP on Excel function is a great solution. The ability to dynamically lookup and retrieve information from a table is a game-changer for many users, and you’ll find VLOOKUP everywhere.
In this fast-paced learning session, you’ll learn:
- What is a Lookup
- The Syntax of the Lookup
- How does it work
- Different types V vs H
- Lookups and Tables
The Alternative to the LOOKUP – Index and Match
Apart from VLOOKUP, INDEX and MATCH are the most widely used tools in Excel for performing lookups. The INDEX and MATCH combo is potent and flexible, and you’ll see it used in all kinds of formulas, from basic to very advanced.
However, while VLOOKUP allows you to perform lookups with a single function, INDEX and MATCH requires two functions, one nested inside another. Many users find this confusing, because they aren’t used to combining functions in Excel, so they avoid INDEX and MATCH.
This Webinar explains in simple terms how to use INDEX and MATCH together to perform lookups. It takes a step-by-step approach, first explaining INDEX, then MATCH, then showing you how to combine the two functions together to create a dynamic two-way lookup.
In this fast-paced learning session, you’ll learn:
- Lookup vs Index and Match
- Match Function
- Index Function
- Index and Match together
- Creating a 2-way lookup
Automating Excel
Automate tasks with the power of Excel Macros. Learn to record and re-use Macros in Excel, manipulate recorded Macros thereby saving hours and even days of work.
Everyone has those repetitive tasks they have to perform day to day in Excel. Whether it’s importing data and having to tidy up the same rows and columns or format the same areas, learn to create basic macros that can take that repetitive side away.
PowerPoint Courses
Creating & Designing Effective PowerPoint Presentations
Learn about all the amazing tools and new features of PowerPoint. Let us help you take your presentations to the next level, by showing you how to create professional, modern, sleek and on-brand presentations.
Gain some invaluable tips and tricks on how to use PowerPoint more effectively during your presentations including:
- How to give a good presentation
- Planning & Preparing
- Designing your Presentation
- Enriching your Content
- Automatic Design Ideas
- Animations & Transitions
- Using the Slide Master
- Creating your own Templates
- Creating Videos from your presentations
- Using Media in your presentations
- The Power of Smart Art
Outlook Courses
Unlocking the Secrets of Outlook’s Time Management
Microsoft’s Outlook has continued to develop and now offers a multitude of new features, but most business users still only use a small fraction of what the application can be used for. If your business does a lot of project scheduling, or you need to better manage your time, Outlook can become an essential companion. Work with Outlook to become more productive and unlock the secrets of Outlook’s time management and powerful features and tools. In this 1 hour webinar, you will discover the hidden power of Outlook… coupled with all the features and functions that will help you become more efficient and more effective! Spend less time in your inbox!
In this fast-paced session:
- Discover the 4 D’s that will save your hours
- Unleash the power of Quick Steps in email
- How to never write the same email twice
- Schedule emails to send when you’re away from your desk
- Automate recurring tasks to simplify your day
- Create calendar events automatically
- Find that email thread in seconds
Visio Courses
Getting started with Visio – A quick introduction
In this fast-paced learning session, you’ll learn:
- Introducing Visio
- Working with Stencils
- Creating simple diagrams
- Creating organisation charts
- Creating Flow/Process Charts
Interested in booking a course?
Tell us a little bit about what you’re looking for and we will contact you as soon as possible!