David Ludlow

David Ludlow is the founder, owner and trainer of InIT Learning. 

IT Courses Live has been developed as a result of the current COVID-19 crises.

David will be delivering the same courses delivered on-site and off-site through live online webinars.

This is an ideal opportunity for individuals and staff to attend the courses remotely. 

All the courses and levels will be delivered live-online.

David has many years of experience in the training business and especially passionate when it comes to IT. David has a very thorough and patient approach to training. You will not be disappointed and will learn many tricks and tips during the training session.

About - Meet David

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.


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

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


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.


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


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


  • 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.
    • Logic Functions
    • TRUE – FALSE
    • SumIF
    • SumIFs
    • AverageIF
    • AverageIFs
    • CountIF
    • CountIFs
    • IF
    • Nested IF
    • 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.
    • 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