fbpx

Remote Training Course Topics

Remote Session Topics

Based on our most popular courses, we have put together some suggestions for remote learning. Each session runs for 2 hours. You can also pick and choose different topics and build your own custom session if preferred.

Microsoft Excel

Explore the range of Excel functions which will enable you to perform basic calculations using best practice methods. Learn how a formulas is structured along with using built-in fomrulas to allow division, multiplication, addition and subtraction. Learn how to calculate averages, find highest and lowest values, count values and solve common error messages.

In this session we explore the ways in which you can format your worksheets to give more meaning to your data. Explore the font and paragraph formatting features along with number formatting techniques and how to resize your worksheet to fit your data. 

Once we have the worksheet looking visually appealing, let’s look at techniques to enable you to print your data in the format you want. We look at print setup techniques and how to make our data fit into a specific page configuration.

In this session we will explore the time-saving techniques we can use in Excel to deal with a series of data and patterns. Learn how Excel can recreate number and text based patterns to save you time and effort when creating content. Explore the AutoFill tool and Flash Fill and see these amazing tools in action.

Once we have finished with patterns we will move into the ability to sort & filter data. By far a huge benefit of Excel we will explore how to sort data alphabetically and by values plus how to we can filter our specific information from a larger data set. We will explore the the number, date and text filters available along with lots of real-world tips on using these features.

In this session we will explore the world of Excel charts. Charts provide amazing ways to give a visual display of our data. Explore the different chart types available and how we can customise the look and feel to differentiate charts from others. 

We will then explore the mini chart world of Sparklines and we can seemlessly incorporate them into our worksheets.

Explore the next level of formulas available in Excel to to help you analyse your data. Explore absolute and relative cell references, named ranges, lookups, IF statements, date functions, sumif, and additional count functions.

In this session we will explore two amazing features of Excel. Explore how to use Conditional formatting to highlight important information based on criteria you have set. 

We will also explore how to create your own custom number formats so that infromation is displayed in the exact way you require. 

In this session we will further extend our knowledge with the use and functionality of Excel charts. We will then jump into the world of Excel Dashboards and learn how to create these amazing visual representations of our data.

In this session we explore the data protection functionality available in Excel. From password protection our worksheets or entire workbook, to allowing access to specific cell ranges only. 

We will then explore how to can link information from one location to allow to avoid entering the same information in multiple files or worksheets. Streamline your spreadsheets and ensure you are using the most accurate version of data using data linking.

In this session we will explore to use the Subtotals feature of Excel to quickly create subtotals, count, and highlight lowest or highest within a dataset. 

We will then explore the Scenarion Manager feature to allow us to switch our data values in the click of a button.

In this session we will explore the dynamic use of PivotTables. We will learn how to use Excels most powerful feature to extract specific information from large data sets. Explore trends based on your data all with a versatile user interface.

Learn how to format a PivotTable specific to your needs, how to create multiple PivotTables on the same worksheet, number formatting, use componded fields, group data, create your own calculated field and more.

We will also explore how to use the PivotChart function to provide a visual represetation of your data set.

Microsoft OneNote

In this session we will explore the basics of using Microsoft OneNote. Explore the OneNote screen, understand the different versions of OneNote, create a new notebook, create sections and pages, add notes, insert pictures and links. You will also explore different formatting options within your notes including bullets & numbering and styles.

In this session, we will explore some of the additional features of OneNote that you may not have used before. We will have a look at working with containers, including tables, add online videos, insert links, how to extract text from a picture plus how to send content to OneNote from other apps or your smartphone. 

We will also look at linked notes, using quick notes, how to create an outline, using drawing tools, how to tag notes, create a template plus how to protect or share your notebook.

Microsoft Outlook

In this session we will explore using Microsoft Outlook as an email client. Explore how to open an email, reply to or forward an email, include an attachment, create a signature, use the CC and BCC fields, and file email into folders.

In this session we will explore the Calendar functions in Microsoft Outlook. Learn how to create a meeting or appointment, set a location, set start and end dates or times, make an appointment an all day event, and schedule recurring events. We will also explore how to display multiple time zones in your calendar, use categories, print your calendar or a specific meeting and how to delete appointments.

Microsoft Teams

In this session we will explore the Teams environment and look at conversations including group or private chat, functionality within a chat, sending attachments, managing files, coauthoring, and working with tabs.

Microsoft Word

In this session we will explore the use of built-in templates plus how to create a document from scratch. Explore how to insert & format text, use numbered/bullet lists and include basic images.

In this session we will explore the different layout methods available in a document including tables, tab stops, page breaks, page setup, header & footers and printing techniques.

In this session, we will explore how to use the mail merge features in Word. Explore how to create your own data set, create a document from scratch, and create a letter mail merge. We will also look at using Mail Merge to send out bulk emails through Outlook.

In this session, we will explore how to create your own Word template. Streamline your messaging by providing staff with templates containing pre-defined information and allowing staff to “fill in the blanks” prior to sending out correspondence. Use the Word template file types to ensure your templates remain in their original state and avoid accidental overwrites.

In this session, we will explore the fun world of visual elements within Word. Lets look at effective ways to use Pictures including all the bult-in enhancement options. We will look at Shapes and how these can be used to create layered effects, SmartArt to create amazing flow charts or diagrams and working with text boxes.

In this session, we will explore some useful features which help when managing long documents. This includes styles, table of contents, indexes, footnotes and endnotes, bookmarks and cross-references.

In this session, we will see how to create interactive forms which allow users to complete information using fields, checkboxes, drop down menus. We will also look at how we can incorporate fields which automatically calculate within the document and then look at saving the document as a template.

WordPress Level 1

In this session, we will explore how to set up WordPress on a localhost computer. This offline configuration provides the flexibility to allow you to work with your website offline whilst making changes, experimenting with plugins or changing code, all without the worry of crashing your live website.

In this session, we will explore the world of WordPress themes and plugins. Get tips & tricks on the top theme and plugin developers, different types of themes and plugins, how to choose a theme or plugin and more. We will look at how to upload a theme or plugin manually, what is a child theme, and how to customise your theme. 

Note: participants will need a WordPress website to use during the session, preferably a localhost offline website.

In this session, we will explore the differences between posts and pages. We will look at the full set of WordPress blocks available in the latest version of WordPress and how these blocks can be customised. We will also look at the use of Categories and Tags within your blog posts.

Note: participants will need a WordPress website to use during the session, preferably a localhost offline website.

 

In this session, we will explore the world of WordPress media. Discover tips & tricks for how to ensure your media is optimised for your website, practical tips for managing your media library, adding media into a post or page and how to include media from other sources such as YouTube.

Note: participants will need a WordPress website to use during the session, preferably a localhost offline website.

In this session, we will explore how to manage your navigation structure. Your menu structure is one of the most vital components of your website so we will look at how to maximise the effectiveness of this navigation tool, how to use menus in different locations across your website.

We will also then explore your links. Both internal and external links play a huge part in your visitor’s ability to find information. 

Note: participants will need a WordPress website to use during the session, preferably a localhost offline website.

In this session, we will explore the WordPress widget options.  We will investigate the built-in Widget options and how to customise them whilst also looking at how to use custom widget types.

We will then look at the world of user accounts. You will gain understanding in the built-user user permissions, how to create new users, and create your own user permission levels.

Note: participants will need a WordPress website to use during the session, preferably a localhost offline website.

WordPress Level 2

In this session, we will explore best practices for securing your WordPress website along with running regular backups. Do not rely on just your web hosting provider for security & backup. We will install and configure popular plugins to provide these additional levels of protection.

In this session, we will explore options for creating online forms on your website. From contact forms, to surveys, to competition entries. We will look at popular plugins to allow you to collect information via your wbesite.

In this session, we will explore easy ways to integrate social media into your website. Whether you want to display social media icons, allow visitors to share your content, including a Facebook Like Box, embed a Twitter or Instagram feed, we’ll explore it all.

In this session, we will explore some basic SEO (search engine optimisation) techniques you can use on your WordPress website. In this session, we will install a popular SEO plugin and explore configuration options including meta titles and descriptions, XML sitemaps, content SEO and more. 

We will also look at some basic technical SEO techniques including speed testing.

In this session, we will explore how to create your own online store using a popular free WordPress plugin. We will configure our online shop including shipping options, add products including title, descriptions, image galleries, pricing and more. We will then look at payment gateway options and how to configure these.

In this session, we will explore the Elementor Page Builder plugin. Explore how to install and configure Elementor, how to convert existing content into Elementor, how to create a section and add widgets. We will look at blocks and templates and how some of the popular widgets can be styled and configured.

Ready to book?

If you are ready to book, complete your details below and we will be in touch.

Your Name*
Your Phone*
Your Email*
How did you find us?
Do you have a preferred date?
Which program(s) do you require training in?
Additional Questions
Please answer this simple question

Call Now Button