Excel Courses Milton Keynes

Excel Intermediate - Level 2

Level 2 - Intermediate

1: 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. Please make sure you can carry out at least 80% of the Level 1 content and be able to enter formulas to carry out calculations.

2: The Course

Courses delivered by InIT Learning are tutor-led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment, the tutor will give one to one support as required.


  • Use Logic Functions
  • Use Lookup Functions
  • Understand and use Nested Functions
  • Using Dates and Times
  • Now includes some new function available in the 365 version

4: Certificates

Each delegate will receive a manual and a certificate of attendance.

5: Course Content

  • Logic Functions
  • SumIF
  • AverageIF
  • IF
  • Nested IF
  • Naming Cells & Ranges
  • Managing Names
  • Using Names
  • Lookup Functions
  • Custom Fill
  • Static Dates and Times
  • Custom Date Formats
  • Custom Time Formats
  • Dynamic Dates and Times
  • Basic Date Calculations
  • Date Functions
  • Times
  • The new XLookup, Sort, and Unique functions
  • Handy Shortcuts

Check Availability and Book>>>

Ready for Action?

Are you ready to check dates and book? Then take action now and click below.
Check Classroom DatesCheck Online Dates

Suite 163
Milton Keynes Business Centre
Foxhunter Drive
Linford Wood
Milton Keynes
MK14 6GD

Tel: 01908 92 50 58
        0330 32 100 58
(Calls may be recorded for quality purposes) 

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.