Floodlight uses cookies to ensure you get the best experience. Learn more GOT IT

>

Intermediate Microsoft Excel

Insight IT Training Limited

(5)

1 reviews
Reviews collected from IDP Connect

£170 PER DAY

What will I learn?

Course Duration - One Day (9.30am to 12.30am and 1.30pm to 4.30pm)

Benefits of Microsoft Excel Intermediate Course

This Intermediate course has been designed to improve the user’s knowledge of Microsoft Excel and develop the basic spreadsheet skills that trainees have already acquired. This course will benefit anyone wishing to develop their basic Excel knowledge. You will learn how to use Charts/Graphs, how to control the screen and use Excel internet features. So if you would like to be more proficient in using Excel, then check out our Intermediate course content for the full picture.

Our course is a one day, 100% hands-on led by highly skilled Microsoft Excel trainers who have a wealth of knowledge in the Microsoft product set. We give you practical exercises to practice the new skills as you learn them.

To get the best of out the Intermediate course, trainees should have attended the Introduction to Microsoft Excel course or have a basic knowledge of Microsoft Excel.

If you are interested in discussing bespoke training from Insight IT, please contact us to discuss this option further and we’ll get back to you with a recommended course outline customised to your needs.

Course Content

Excel Functions

  • Using the SUM, MAX, MIN, COUNT and AVERAGE functions
  • Understanding Absolute and Relative cell references

Excel Charts/Graphs

  • Creating a Chart
  • Formatting a Chart

Controlling the Screen

  • Freezing column and row titles
  • Using the Zoom feature
  • Using the Split Screen feature

Screenshot

  • Use the Screenshot and Screen Clipping features (2010+)

Use Excel Internet Features

  • Viewing a worksheet in a browser
  • Creating a hyperlink to a web site or other document

Naming Ranges in a Worksheet

  • Naming Ranges
  • Move to a Named Range
  • Use Named Ranges in formulae
  • Print a Named Range

Excel Databases

  • Use an Excel list as a Database
  • Setting up a new Database
  • Sorting records in a Database
  • Filtering records in a Database

Notes: -

Training available nationwide (same price, location does not matter!).

Computers are provided for training free of charge (one per person).

Beginner, Advanced and VBA courses in Excel also available.

The content can be tailored to meet your exact needs free of charge. It’s easy to do so!

What do I need to know?

Trainees should have attended the Introduction to Excel course or have a basic knowledge of Microsoft Excel.

Course info

closeIcon

Qualification Explained

No qualification

This means that the course doesn't come with any kind of qualification. You might do it for the experience or just to learn a skill

Certificate of attendance/completion/achievement (no assessment element)

This means you'll get a certificate at the end to prove you've completed the course. You won't have to do any exams, you'll just be given something to show you turned up and learnt something

Functional Skill

The Functional Skill qualification is awarded to people who have completed a course that shows them how to apply maths and/or English to real life situations. You will be assessed in order to achieve this

Basic skill

This essentially means you'll come away with a basic ability at literacy and numeracy. These qualifications and courses are often for adults who didn't reach a high enough level in these in school

Pre-apprenticeship at Level 1

Pre-apprenticeship courses are aimed at getting you ready to do an apprenticeship. If you hold one of these qualifications, it will help you take the next step when you're ready

NVQ Level 1 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 1 NVQs teach the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades D-G

SVQ Level 1 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 1 SVQs teach the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades D-G

Scottish National Qualification - Standard Grade

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This level is the first and most basic level of National you can do

Scottish National Qualification - Access 3

National qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This level is the first and most next level up from the most basic level of National qualification you can do

Scottish National Qualification - Intermediate 1-2

National qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'intermediate' level of National you can do

GCSE or equivalent

GCSE stands for General Certificate of Secondary Education and sit at levels 1 and 2 on the QCF. This means they give you a grounding in a subject that will prepare you for further education or work

Welsh Baccalaureate Diploma

Delivered by course providers in Wales, this qualification is at the same level as GCSEs and often chosen as an alternative

Vocational related qualification (VRQ)

This term encompasses any qualification that you can achieve that will be focused on preparing you for a specific workplace

Young Apprenticeship/Apprenticeship at Level 2

Intermediate apprenticeships are the equivalent to GCSEs grades A* to C. They are workplace-based qualifications where you learn by doing (and get paid too!) and only spend a short time in college

First Certificate/Diploma

These qualifications, though usually based in a college or school, prepare you for the workplace by teaching you relevant practical skills alongside theory. They are equivalent to GCSEs

NVQ Level 2 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 2 NVQs will require you have some knowledge in the subject and will take basic skills a little further. They're equivalent to GCSEs grades A*-C

SVQ Level 2 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ Level 2 build on the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades A*-C

Advanced Apprenticeship at Level 3

Advanced apprenticeships are the equivalent to A Levels. They are workplace-based qualifications where you learn by doing (and get paid too!) and only spend a short time in college

GCE AS Level or equivalent

These are academic qualifications aimed at giving you higher expertise in certain subjects, preparing you for work or for further education

GCE A Level or equivalent

These are academic qualifications aimed at giving you higher expertise in certain subjects, preparing you for work or for further education

International Baccalaureate Diploma

This qualification is recognised worldwide and is equivalent to GCSEs. It covers a range of subjects

National Certificate/Diploma

These qualifications, though usually based in a college or school, prepare you for the workplace by teaching you relevant practical skills alongside theory. They are equivalent to A Levels

NVQ Level 3 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 3 NVQs will require you have some knowledge in the subject and will take your learning to a higher level. They're equivalent to A Levels

SVQ Level 3 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. They're equivalent to A Levels

Scottish National Qualification - Higher

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'higher' level of National qualification you can do

Scottish National Qualification - Advanced Higher

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'advanced higher' level of National qualification you can do

Access to Higher Education

This is a qualification aimed at preparing you for university if you don't have the traditional A Level/GCSE level of study. Usually focused on a specific subject it will get you ready to take a degree in that area on finishing

Foundation Art and Design

This qualification is aimed at getting you ready to take a degree in a creative subject. It is equivalent to a foundation degree

NVQ Level 4 and relevant components

NVQ Level 4 and relevant components

SVQ Level 4 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 4 takes your learning to a much higher level. They're equivalent to undergraduate degrees

Higher Apprenticeship at Level 4

Higher apprenticeships are the equivalent to a foundation degree. They are workplace-based qualifications where you learn by doing (and get paid too!) and will only spend a short time in college

NVQ Level 5 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 5 NVQs are usually for experienced managers in the workplace. They're equivalent to undergraduate degrees

SVQ Level 5 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 5 SVQs take your learning to a much higher level - often for experienced managers. They're equivalent to undergraduate degrees

Nationally recognised qualification

This means the qualification you gain can be transferred to other locations in the UK and employers will be familiar with the level you've studied at

Professional or Industry Specific qualification

This term encompasses qualifications that you can use in the workplace of a particular industry. Usually awarded by professional and industry-based organisations, these qualifications will be familiar to employers in certain areas of work

Other External Awarded Qualification

This means the qualification is awarded by an external body. It may therefore include an assessed element

Course Provider Diploma/Certificate/Award (this must include an assessed element)

This means the qualification is awarded by the course provider but that you do get a real qualification at the end, it's just that they award it in-house. There will be an assessment to get this

Qualification

Certificate of Attendance/Completion/Achievement (no assessment element)

Study mode

Personalised

Level

Intermediate

37 course options

Sort: Start date
Start date
Filter by: Location
Duration
Price

Who runs this course?

INSIGHT IT TRAINING

INSIGHT IT TRAINING

(5)

Insight IT Training provide high quality and flexible IT and Business Skills training courses (standard or tailored) and training solutions nationwide. We can come to you or you can come to us! We offer a different approach. By only providing private training we can work with you to deliver flexible, innovative and cost-effective training solutions in an easy and stress-free way. We will help you all the way from the initial enquiry through to delivery and, if needed, with post training support. We offer you great value because the training will be relevant to the trainee's needs and will meet their objectives by focusing on the topics that will be most relevant to their job roles. At the end of the training your staff will

Three things to check before you take a course
closeIcon

Three things to check before you take a course

Great! You've found a course. Still have a few questions? Here are the top three things you should ask the course provider before booking:

  1. What will I be able to do when I've completed the course?
  2. Do I need any previous experience or qualifications to take this course?
  3. Will I need any special equipment or clothing in order to complete it?

They'll also be able to help you with questions around payment plans, flexible learning, start dates and more.

Click the green 'GET COURSE INFO' button to get in touch with the them directly.