On Course for

0330 32 100 58

Courses

£149.00 for 12-months access. Home Page for Enrolment Link

This course is ideal for both new users to Excel 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.

Module 1 Introduction and Welcome
Lesson 1 Welcome Message  – Preview
Lesson 2 What you need  – Preview
Lesson 3 Let’s Get Started
Module 2 Basic Navigation and Formatting
Lesson 1 Entering
Lesson 2 Navigating Data
Lesson 3 Selecting Data
Lesson 4 Shortcuts and Key tips
Lesson 5 Ctrl Shortcuts
Lesson 6 Fill Handle
Lesson 7 Resizing Columns and Rows
Lesson 8 New Rows and Columns
Lesson 9 Formatting
Lesson 10 Merge Cells
Lesson 11 Orientation  – Preview
Lesson 12 Wrap Text
Lesson 13 Dates and Times
Lesson 14 Notes
Lesson 15 Move and Copy Worksheets
Lesson 16 Assignment
Module 3 Excel Formulas and Basic Maths
Lesson 1 Order of Calculations
Lesson 2 Basic Formulas
Lesson 3 Adding Ranges of Data
Lesson 4 Relative References
Lesson 5 Absolute References
Lesson 6 Assignment – Formulas-1
Lesson 7 Assignment – Formulas-2
Module 4 Basic Analysis
Lesson 1 Sort Data
Lesson 2 Filter
Lesson 3 Find
Lesson 4 Printing
Lesson 5 Show Formula
Lesson 6 Freeze Panes
Lesson 7 Aggregate Data
Lesson 8 Conditional Formatting
Lesson 9 Charts
Lesson 10 Final Assignment
Lesson 11 Completed

£149.00 for 12-months access. Home Page for Enrolment Link

£149.00 for 12-months access. Home Page for Enrolment Link

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.

Module 1 Introduction and Welcome
Lesson 1 Introduction to the course  – Preview
Lesson 2 What you need Excel 2
Lesson 3 Let’s Get Started
Module 2 Logic Functions
Lesson 1 Logic
Lesson 2 IF Function
Lesson 3 IF Return Number
Lesson 4 If Cell References
Lesson 5 IF Cell References 2
Lesson 6 IF With Formulas
Lesson 7 IF with Formulas 2
Lesson 8 IF Assignment
Module 3 New Functions
Lesson 1 Concatenate
Lesson 2 Unique Function
Lesson 3 Sort Function
Lesson 4 Sort an Array
Lesson 5 Unique Array Columns
Module 4 Logic Aggregate Functions
Lesson 1 Aggregate Functions
Lesson 2 CountIF
Lesson 3 SumIF and AverageIF
Lesson 4 Sumifs Averageifs Countifs
Module 5 Nested IF Functions
Lesson 1 Nested IF
Lesson 2 Nested IF Assignment Exam Results
Lesson 3 Nested IF Assignment Bonus Payment
Lesson 4 Nested IF Assignment Formula
Lesson 5 AND Function
Lesson 6 OR Function
Lesson 7 Not Function
Lesson 8 Assignment – Final Logic
Module 6 Dates and Times
Lesson 1 Date and Time Entries
Lesson 2 Date Calculations
Lesson 3 Date Function and Formats
Lesson 4 Year Month Day Functions
Lesson 5 Text Function
Lesson 6 Date Difference Function
Module 7 Custom Lists and Naming
Lesson 1 Custom Lists
Lesson 2 Naming
Module 8 Lookups
Lesson 1 VLookup
Lesson 2 VLookup Assignment
Lesson 3 HLookup
Lesson 4 HLookup Approximate Match
Lesson 5 Match Function
Lesson 6 Index Function
Lesson 7 Index and Match
Module 9 Lookups – Xlookup
Lesson 1 XLookup
Lesson 2 XLookup Array
Lesson 3 XLookup Horizontal
Lesson 4 XLookup Nested
Lesson 5 XLookup Filter
Lesson 6 XLookup SUM
Lesson 7 XLookup Search
Lesson 8 XLookup Wildcard
Lesson 9 XLookup Approximate Match
Lesson 10 Well Done Excel 2 Complete

£149.00 for 12-months access. Home Page for Enrolment Link

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.

Module 1 Introduction and Welcome
Lesson 1 Welcome  – Preview
Lesson 2 What You Need
Module 2 Getting Started
Lesson 1 Let’s Get Started
Lesson 2 Developer Tab  – Preview
Lesson 3 Naming Ranges
Module 3 Form Controls
Lesson 1 Combo Box ActiveX Control
Lesson 2 VLookup and Date Difference
Lesson 3 Scroll Bar ActiveX Control
Lesson 4 Checkbox ActiveX Control
Lesson 5 Options Button Form Control
Module 4 What-If Analysis
Lesson 1 Scenario Manager
Lesson 2 Assignment – Scenario Manager
Lesson 3 Goal Seek
Lesson 4 The Payment Function – Loan Calculator
Lesson 5 Assignment – Goal Seek
Lesson 6 Solver
Module 5 Data Tools
Lesson 1 Data Validation
Lesson 2 Text to Columns
Lesson 3 Flash Fill
Module 6 Outline
Lesson 1 Subtotal
Lesson 2 Subtotal Assignments
Lesson 3 Auto Outline
Lesson 4 Grouping
Module 7 PivotTables
Lesson 1 The Basics
Lesson 2 The Basics Continued…
Lesson 3 Refresh Data
Lesson 4 Count
Lesson 5 Formatting Numbers
Lesson 6 Assignment – PivotTable
Lesson 7 Data Source Layout
Lesson 8 Convert Traditional to Tabular
Lesson 9 Remove Unwanted Spaces
Lesson 10 Using Tables
Lesson 11 Refresh and Refresh All
Lesson 12 PivotTable Drill-Down
Lesson 13 Blanks and Errors
Lesson 14 Grouping
Lesson 15 PivotTable Slicers
Lesson 16 PivotCharts
Module 8 Macros
Lesson 1 What are Macros
Lesson 2 Macro Security
Lesson 3 Saving Macro Workbooks
Lesson 4 Recording a Macro
Lesson 5 Edit a Macro
Lesson 6 Join Macros Together
Lesson 7 Assign a Shortcut
Lesson 8 Personal Macro run from QAT
Lesson 9 Macro to Filter Data
Lesson 10 Assign a Button
Lesson 11 Absolute and Relative Referenced Macros
Lesson 12 Non-Programmer Workarounds
Lesson 13 Changing Referencing Type
Lesson 14 VBA Code
Lesson 15 Dynamic Message Box
Lesson 16 VBA – Do While Loop
Lesson 17 Macro Assignment

 

Self-paced Video Courses

Your Responsibility

  • No social distancing to worry about apart from your own location
  • Register on the website first.
  • Once registered you can select the required course
  • After payment is received you will be able to start any time.
    • You have one year of access to the course content.
  • You must not share your login details with anyone else.
  • It’s always good to practice as you move through the course.
    • As you learn new things we always say ‘Use it or Lose it’, so practice helps you remember the topic.

What InIT Learning is doing.

  • Your progress will be monitored.
  • You will receive an email at the end of each module and the end of the course.
  • You will be able to download a certificate at the end of the course.
  • Further courses are being developed based on exactly the same courses that are delivered to companies and the scheduled courses.

Scheduled Live Webinar Courses

You can join the normally scheduled courses where the delegate numbers are limited to two. The class size of six will be made up of four remote delegates joining live. 

Your Responsibility

  • No Social Distancing to worry about apart from your own location.
  • Register for the course before the start (preferably one or more days before).
  • Log in to the course at least 15 minutes before the start
  • Download the course file onto your PC/Laptop
  • Share you screen with Quick Assist (Windows 10 only)
    • The ideal scenario (although not necessary) is to have an extended monitor or two devices. One to watch the lessons and the other to practice on. 
  • The Tutor screen will be shared with you through ZOHO Showtime
  • You may need to use headphones if the tutor receives delayed feedback of his own voice.

What InIT Learning is doing

  • Will only allow a maximum of four delegates to join remotely.
    • Four remote and two in the classroom.
  • Four laptops will be set up to share your screen, so if you have a question or an issue, the tutor can view your screen.
  • The tutor will give you live voice access, so if you have questions it will be just like you are there.
  • You will see the tutor’s screen and a small window will be available for you to view the tutor.
  • Once logged in you can download the working file
  • The one-day courses will have a couple of comfort breaks AM and PM and a 30-minute break for lunch. The short live courses will have no breaks.
  • The tutor will be available by phone before the start of the course to help if you need assistance setting-up.
  • If the tutor receives his own voice feeding back he will request you use headphones

Scheduled Courses - Newport Pagnell UK

Your Responsibility

  • All distancing rules should be followed while in Harben House
  • Hands should be washed regularly (as per Government guidelines)
  • Hand sanitiser should be used before each use of the InIT Learning keyboard and mouse
  • The course date should be changed if there is any sign (as laid down by the Government) of COVID-19 infection or if there has been any contact with someone who has COVID-19
  • Don’t offer to handshake and maintain the correct social distance from the tutor and other delegates.
  • Distancing should be maintained at break times.

What is InIT Learning doing to help?

  • Fewer delegates per course and more dates.
    • Reducing the maximum from 6 to 2 delegates per course.
  • Providing a clear sneeze screen between the two delegates.
  • Providing a clear sneeze screen between the tutor and delegates.
  • Providing hand sanitiser to use before and after using the keyboard and mouse.
  • Providing tissues just in case they are required.
  • All equipment will be cleaned before and after each course.

In-house Courses @ Your Office

How do we maintain a social distance?

Your responsibility:

  • As a business, you will have your own social distancing in place for staff and visitors, therefore the visiting tutor will follow your own requirements.
  • You will ensure the room has sufficient space for the tutor to set up each laptop, keyboard and mouse allowing for the recommended distance set by the Government and your own policy.
  • Delegates welcome to plug their own keyboard and mouse if you or they prefer.
  • There should be sufficient space (allowing for the recommended distance set by the Government and your own policy) for the tutor to set up his training laptop at the front and plug it into a projector or monitor for your staff to watch the demonstrations.
  • Lunch and snacks should not be eaten over the laptops or keyboards.

What is InIT Learning doing to help?

  • All equipment is provided for each delegate (1 to 8 maximum)
  • The Tutor should have access to the room at least one hour prior to  the start of the course in order to set up each laptop for the delegates
  • The keyboard and mouse are cleaned before and after each course.
    • You are welcome to plug your own keyboard and mouse if you prefer.
  • The tutor will have an extra monitor at the front, to switch to and view any of the delegates laptops, thus avoiding the need to get close to a delegate if they have a question or require help (it can all be done from the front).