40 Minute IT Courses Live

Short 30 to 45 Minute Webinars

Don’t have time for an all-day course then try one of the very short and sharp to the point courses as a live webinar. These short webinar courses mean all you have to do is find between 30 minutes to an hour of your time. More courses are being added so keep an eye on this page.

Excel Dates & Times

A quick introduction to Using Dates and Times in an Excel spreadsheet. This 40-minute webinar covers entering, formatting, functions and calculating dates and times.

Book Now - £10.00

Understanding the Maths

This short webinar takes a look at the maths behind the spreadsheet. How does the spreadsheet carry out calculations, what order and why! We’ll go back before computers.

Book Now £6.00

Excel XLOOKUP

A quick introduction to the new exciting XLOOKUP function in Microsoft 365 that is set to replace the VLOOKUP, HLOOKUP and INDEX & MATCH.

Book Now - £10.00

Short Training Webinars

These short 30 to 60 minute training course webinars are an ideal way to keep your skills and knowledge up to date without losing too much time. Keep an eye out for more titles.

Online Courses

Excel Dates and Times - 40 Minute Webinar

This quick 40-minute webinar gives you a quick insight to using dates and times in your Excel spreadsheet. We take a look at straight forward calculations using Dates and Times and how to format the cells so you see the results in the correct format.

  • Entering Dates and Times
  • Dynamic and Static Dates and Times
  • Calculations
  • DATE Function
  • YEAR Function
  • MONTH Function
  • DAY Function
  • TEXT Function with Dates
  • Hidden Secret Function!!!!
  • CONCATENATE Date Results
  • 30 day End of Month Calculations
  • Calculating a Fraction of a Year
  • Time Formats
  • Difference between Times

Maths for Excel

Understanding the Maths

This short webinar takes a look at the maths behind the spreadsheet. How does the spreadsheet carry out calculations, what order and why! We’ll go back before computers were used, maybe a few thousand years. This is really crucial to understand if you are going to create formulas on a spreadsheet.

  • Order of Calculations
  • Why is there an order
  • Examples
  • Have a go yourself (don’t worry only primary level)

Excel XLOOKUP Function - 40 Minute Webinar

Get a good understanding of how the new XLOOKUP function works and more importantly how to use it different scenarios.

Content

  • XLookup
  • XLookup Array
  • XLookup Horizontal
  • XLookup Nested
  • XLookup Filter
  • XLookup SUM
  • XLookup Search
  • XLookup Wildcard
  • XLookup Approximate Match

PowerPoint

Who is the Course for?

This course is designed for users who either have no knowledge of PowerPoint or have some knowledge and wish to learn more about its features. The course is also suitable for users who would like a refresher of the basics. A general understanding of the personal computer and Windows would be useful.

The aim of this course is to look at all the features of PowerPoint and how to produce memorable slides to help the audience remember what the presenter is delivering. Don’t make do with basic Microsoft templates when you can easily create stunning corporate presentations yourself. This is a practical hands-on course, where you get the opportunity to practice creating stunning slides and not just a bullet point type presentation.

Content

  • Introduction
  • PowerPoint Views
  • Planning a Presentation
  • Create a Presentation
  • Slide Layouts
  • Working with Tables
  • Working with Images
  • Charts
  • Changing Slide Layouts
  • Font Formatting
  • Apply WordArt
  • Slide Master
  • SmartArt
  • SmartArt – Adding Shapes
  • SmartArt – Layout, and Styles
  • Shapes
  • Slide Sorter
  • Notes and Printing
  • Slide Transitions
  • Animation
  • Motion Paths
  • Audio Clips
  • Video Clips
  • Action Buttons & Hyperlinks
  • Saving and Printing

Excel Power Pivot

Who is the Course for?
This course is ideal for experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas.

Content

    • Introduction to Excel Power Business Intelligence
    • Enable Power Pivot
    • Import and reshape CSV files & more
    • Power Query
    • Power Query Editor
    • Query Editor Tools
    • Loading Data
    • Pivoting and Unpivoting
  • Merging Queries
  • Appending Queries
  • Data Model Views
  • Database Normalisation
  • Data and Lookup Tables
  • Power Pivot
  • DAX Measures
  • Data Analysis Expressions (DAX)
  • Basic Measures
  • SWITCH and SWITCH(TRUE) Functions
  • Date and Time Functions (Basic)

Excel Level Three

Who is the Course for?
This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

Content

  • Excel Forms
  • Scenario Manager
  • Goal Seek
  • Installing Solver
  • Solver
  • Subtotals
  • Grouping & Outlining
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • Tables
  • Cleansing Data
  • Excel Macros
  • Macro Security
  • Saving a Macro Workbook
  • Recording & Running a Macro
  • Relative Cell References (Macros)
  • Viewing & Editing a Macro
  • Assigning Macros
  • Global Macros
  • Object to run Macros
  • VBA Code

Excel Two

Who is the Course for?
This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.
Content
    • Logic Functions
    • TRUE – FALSE
    • SumIF
    • SumIFs
    • AverageIF
    • AverageIFs
    • CountIF
    • CountIFs
    • IF
    • Nested IF
    • IFERROR
    • AND
    • OR
    • NOT
    • Naming Cells & Ranges
    • Managing Names
    • Using Names
    • Lookup Functions
    • Including the new Lookup function
    • Sort and Unique
    • Custom Fill
    • Static Dates and Times
    • Custom Date Formats
    • Custom Time Formats
    • Dynamic Dates and Times
    • Basic Date Calculations
    • Date Functions
    • Times
    • Handy Shortcuts

Excel Level One

Who is the Course for?
This course is ideal for both new and long term users who have had no formal training (often self-taught) and would like to make sure they are prepared for further levels. A general understanding of the personal computer and Windows would be useful. There are lots of useful time-saving tips.
Content
    • Introduction to Spreadsheets
    • Data Entry
    • The Ribbon Bar
    • Formatting
    • Basic Maths
    • Resizing
    • Basic Calculations
    • Sum
    • Copy & Fill
    • Absolute & Relative Referencing
    • Percentage
    • Sorting Data
    • Filter Data
    • Find Data
    • Selecting Data
    • Selecting Multiple Ranges
    • Insert New Columns and Rows
    • Date and Time Entries & Functions
    • Comments
    • Working with Multiple Worksheets
    • Printing
    • Page Setup
    • Show Formulas
    • Freeze Panes
    • Average, Maximum, Minimum
    • Conditional Formatting
    • Basic Charts
    • Embedded Chart
    • Handy Shortcuts