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

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 or in the office

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, or you have been made redundant and looking for your next opportunity. 

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 

How to Share your Windows 10 Screen

While attending a computer course remotely it is very handy for the tutor to view your screen, so you can have instant support just as if you were attending in the classroom.

This quick video shows you how to get set up. 

You will be set up on one of the delegate computers as if you were attending in person. You screen will appear on that delegate PC so the Tutor can view and answer questions and give you support.

Remember, at the same time you will be seeing and hearing the Tutor who will give you mic access so you can take part as though you are there.

 

Outlook

Who is the Course for?

This course is designed for users who have some knowledge of Microsoft Outlook and are keen to extend their understanding and knowledge beyond basic email use.

This course will help the delegate use time more effectively & productively by using more features of Outlook.

The Basics

  • Outlook Basics (Help, Menus, Dialog Boxes)
  • Navigating in Outlook & Creating Folders
  • Customising Views
  • Creating Messages
  • Using Attributes (Bold, Colour, etc.)
  • Justification
  • Bullet Lists
  • Copying/Moving Text
  • Changing Fonts & Point size
  • Indenting
  • Signature Blocks
  • Using the Spell Checker
  • Using Stationary
  • Outlook Options

Managing Emails

  • Delivering/Getting Messages
  • Deleting/Printing
  • Working with Attachments
  • Flagging Messages
  • Using Rules
  • Handling Junk Mail
  • Organising Messages
  • The Address Book
  • Common Emoticons/Acronyms
  • Reading Messages
  • Replying/Forwarding Messages
  • Creating a Contact List
  • Sorting/Grouping Contacts
  • Deleting Contacts
  • Saving a v Card

Managing Time

  • Organising Tasks
  • Completing/Deleting Tasks
  • Accept, Decline and Delegate Tasks
  • Creating Appointments
  • Recurring Appointments
  • Scheduling Meetings
  • Creating/Editing/Deleting Events
  • Creating Notes
  • Sending Contact Info
  • Adding Folder Shortcuts
  • Editing/Moving Appointments
  • Deleting Appointments
  • Printing/Publishing Your Schedule
  • Creating a To-Do List
  • Editing/Moving Tasks
  • Recurring Tasks

Word Level Two

Who is the Course for?

This course is designed for delegates who have knowledge of Microsoft Word and are keen to extend their skills beyond basic document creation.

This level will help the delegate to use more productive word processing techniques at work.

Content

  • Refresher to Word
  • The Ribbon Bar
  • The Word Window
  • Managing Word
  • Version Control
  • Document Views
  • Navigating the Document
  • Pages and Sections
  • Working with Text and Tables
  • Text to Tables
  • Tabs and Indents
  • Working with Word Art
  • Headers and Footers
  • Working with Styles
  • Creating New Templates
  • Symbols and Dates
  • Charts and Objects
  • Hyperlinks
  • Importing Data
  • Linking Information from another source
  • Mail Merge
  • Graphics Positioning and Text
  • Tasks and Assignments Included

Word Level One

Who is the Course for?

This course is designed for people who have little or no knowledge of Microsoft Word. A general understanding of the personal computer and Windows would be useful.

This course is aimed at the beginner; however, many current users of Word find it a useful refresher and learn many new tips to increase their productivity and prepares them for the next level.

Content

  • Introduction to Word
  • The Ribbon Bar
  • The Word Window
  • Managing Word
  • Document Views
  • Navigating the Document
  • Working with Text
  • Fonts and House Style
  • Creating New Documents
  • Cut Copy and Paste
  • Margins and Orientation
  • Headers and Footers
  • Bullets and Borders
  • Tables
  • Inserting Graphics
  • Working with Columns
  • Tabs
  • Paragraph and Line Spacing
  • Spelling and Grammar
  • Printing
  • Tasks and Assignments Included

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