Welcome to IT Courses Live

Live online training Webinars

Join the face to face courses at Harben House Hotel, Newport Pagnell Remotely by Webinar

Social distancing by attending from home or work via webinar

Excel courses, Word Courses and PowerPoint Courses all live via webinar.

Number restrictions apply:

  • Face to Face – 2 attendees
  • Online – 4 attendees
  • Total 6 giving every delegate a chance to interact with the tutor.
Play Video

One-day Courses 6 hours

Attend an online course for Excel, PowerPoint, or Word. These courses are a live link webinar to an actual course. Face to face course numbers has been reduced to two, to allow greater social distancing.

£149.00

Short Courses 30-40 minutes

New short bite-size courses are now available. If you can’t allocate a day then try and find 30 to 40 minutes in your day to develop your skills and knowledge.

 

Prices range from £6.00

Download Zoho Showtime Viewer

Download Links

The price has been substantially reduced to help support your staff development during this difficult time.

Each delegate requires the use of a PC/Laptop with Microsoft Excel installed, a device to watch the live course e.g. a second monitor or PC/laptop or a tablet, Internet access and time to follow the course. 

Software Training Computer Courses

All InIT Learning’s one-day courses are now scheduled for on-line delivery LIVE. InIT Learning is a Milton Keynes, Buckinghamshire based training provider, specialising in Microsoft Office training courses for businesses and individuals.

If you (or your staff) need to learn or improve skills in Excel, Word, PowerPoint, or Outlook to manage your time and communication, then an InIT Learning one-day training courses can help.

Book now to learn the efficiencies of using the full power of  Microsoft Office (Excel, Word, PowerPoint, and Outlook).

It’s like being on a face to face course but at home

Play Video

Companies & Organisations

This is an ideal opportunity to offer your staff, training, and development; however, maintaining a social distance. There are Excel and PowerPoint courses available for your staff to attend from their own home or spread out at work rather than all being in a classroom situation.

Choose from short subject-specific (about 40-minutes) or one-day training courses from 10:00 to 16:30 (UK Time).

Individuals

Are you an individual looking to increase your computer skills to put you in a stronger position when applying for jobs? Maybe you have been furloughed and you want to make good use of the time. 

Join one of the available Excel or PowerPoint courses for either 40 minutes or for a normal day course from 10:00 to 16:30 (UK Time)

Online & On Course for Success

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

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

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