Learn by doing
Instructor-Led: Remote Training Courses
Get all your questions answered and learn by doing.
Excel with Allison
My name is Allison Kennedy and I am a Microsoft Certified Trainer.
You'll walk away from my courses with timesaving techniques, best practice tips and of course technical how to guidance. All classes are tailored to fit each student's needs to ensure you excel with whatever your immediate requirements may be.
Courses are:
1 hour to 6 hours in length
one-off up-skill or weekly consultations available
held virtually from the comfort of your own home or office
private or small group (max 6 students per public course)
from $180 (USD) / half day training
contact me for daily and corporate rates
Microsoft Training Courses
Below are a few of the more popular instructor-led courses I have written. Click on a Course Title below to view more details about the courses I have written.
If you don't see exactly what you're looking for in the descriptions below, custom training sessions are also available. Contact me to learn more and to check availability for instructor-led remote training sessions.
Power BI Essential Skills
1 day
How Big data can help your business. Self-service business intelligence. Data visualization for easy snapshots. Real-time analytics.
So much data and so many buzz words, but what does it all mean? As data gets easier to come by, we find ourselves with more data than we know what to do with and need to analyse it quickly and effectively. We don’t have time to wait for the data scientists to come back with a robust report, we need answers now.
This workshop will introduce you to Microsoft’s Power BI tool for analyzing and visualizing data, bringing business intelligence capabilities into your hands. In this hands on workshop, you will explore the capabilities of Power BI and discover how it can help your company get real insights and valuable information from your data.
Power BI Next Level
1 day
Do you love the dynamic reporting capabilities of Power BI? Have you created a few Power BI reports, but unsure of how to take your reporting to the next level? This course will highlight some of the intermediate to advanced features of Power BI, as well as provide you with some pro tips that will save you time and frustration when building Power BI reports.
Microsoft 365 Overview
1/2 day
Who knew Microsoft had so many handy applications! You’ll walk away from this course with a high level understanding of what Microsoft 365 has to offer. The next step is deciding which applications will be most useful to you.
Microsoft Forms
We’ll start with a quick and easy survey to introduce you to the Microsoft 365 suite of applications and get to know a bit more about you.
Sway
Using Microsoft’s online presentation tool, we’ll quickly cover off some important things to know about Microsoft 365, the course outline, and the all too important question of when will I get a break?
Power Apps
That Microsoft Forms was great for quick surveys, but if you want something with a bit more pizazz then try Power Apps. We’ll take this opportunity to have you order your preferred beverage (to be prepared by you during the tea break).
Kaizala
From our online presentation, we can link seamlessly to other web content, including videos that we can post on Microsoft Stream. We’ll watch a quick video about Microsoft’s secure messaging app which uses your mobile phone number to identify you.
Stream
How was that video created? We’ll jump into Stream and see where your videos are stored, how they’re organised how people can interact with them.
Teams
One of the most common uses for Microsoft Stream is for storing recordings of Teams meetings. Really handy way to review something that you zoned out for or to include employees who couldn’t make it. Teams is truly the hub of Microsoft 365 and brings all the applications together, so when we’re done with meetings, we will look at how we can integrate other apps into Teams.
Calendar
Meetings can be scheduled from Teams or Outlook, but both end up in the same place – your Office 365 calendar. We’ll setup a meeting and check out the new functionality we have for scheduling meetings within Microsoft Teams (Meeting Options, Meet in Channel).
OneNote
Teams has a built in meeting notes feature using the Teams Wiki, but OneNote is still a great way to take personal and Team notes. We’ll have a go!
Power Automate / Flow
Ready for that beverage you ordered earlier? Power Automate can help cut down on manual paperwork and automate regular processes or approvals you do daily, giving you more time to focus on the important stuff, or the time to take a much needed break. We’ll have a look at the Power Automate web page where your instructor will (hopefully) approve your request for a much deserved tea break.
SharePoint – Lists
What’s the most popular beverage order? Where do people order from? Who sells the most orders? All this information is easy to access just by using SharePoint lists and views.
Excel or Power BI
Remember that survey you filled in at the start? Well we’ve already got the results. We can view them at a glance in Forms, get line by line detail in Excel, or develop a Dashboard in Power BI or Excel that updates automatically as new results flow through.
SharePoint - Files
Ok, so where is that Excel file saved? What happens if I want to make changes? SharePoint is the back-end system Microsoft use to store shared files in Teams. We’ll have a go at creating and editing some files and see how multiple people can work on the same file at once.
OneDrive
OneDrive stores your private documents, or things you only want to share with 1 or 2 people. We’ll jump into the Teams chat and see how we can work with 1 person privately.
Planner/Tasks
Is your brain swimming with all this new information? Delegate some tasks to your colleagues or just write things down so you can action them later. Microsoft have integrated their Outlook Tasks with a few apps to help make it easier for you to manage small projects or even your own workload.
Delve
Looking for more? Delve shows you what you’ve missed and what other people in your organisation have been working on.
Microsoft Teams Best Practice
1/2 day
Microsoft Teams promotes team work. It is a completely customisable workspace to focus your attention where it needs to be and increase collaboration. Learn how to use Microsoft Teams effectively, no matter how it has been customised for your business. Chat, share files and information, have meetings and get the important updates and notifications that you need to collaborate and increase productivity
Microsoft Planner
1/2 day
By the end of the course you will know your way around the Planner interface. Stop wasting your time looking for that project file or finding an available team member to complete a request, Planner makes it easy to organise everything in one place! In this interactive session, you will:
Create a new plan in Microsoft Planner
Organise your plan and customise views to see overall progress and health of the plan
Update tasks with detailed information, documents and assignments
Communicate with other team members in the plan
Link Planner with other Office 365 apps that you already use on a daily basis
I am a Microsoft Certified Trainer since 2017. I offer private and small group remote training sessions for end users at all levels in the following subjects:
Power BI
Excel
Microsoft Teams
Office 365 (including Planner/Tasks, Forms, OneDrive, Word, PowerPoint, OneNote, Visio, Outlook)
Power Apps and Power Automate (formerly Microsoft Flow)
Sharepoint
MS Project
Transact SQL
Azure