/

Intermediate Microsoft Excel

(5.0)1 review
Recent reviews of this course provider

Introduction to Microsoft Excel

Clare was a really helpful and funny trainer and made the course fly by it wasn'...more

See all reviews
Add to shortlistShortlisted by 36 people

https://www.hotcourses.com/courses-by-subject/Intermediate-Microsoft-Excel-courses/55660148/

Course description

Intermediate Microsoft Excel:

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!

Additional entry requirements

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

Training for employers

This course has been specifically designed for companies training their employees.

Course reference: MSEX2 (use this when contacting provider)

Course info
219 views

Location:

Basingstoke, RG21 3EE, Birmingham, B1 1BD, Brighton, BN1 1YR, Bristol, BS1 6EA, Cambridge, CB1 1BH + 32 more

Time:

During the day

Duration:

1 day

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

Level:

Beginner IntermediateAdvanced

From: £170

Summary of all course reviews for Insight IT Training Limited

1 review

(100%)

Average student ranking

Reviews of other courses at Insight IT Training Limited

insight-it-training

Introduction to Microsoft Excel
5 5
Hotcourses
by Tony - August 2017

Clare was a really helpful and funny trainer and made the course fly by it wasn't dull and was very engaging.

Was this review helpful? Yes No
1 Hotcourses user(s) found the following review helpful.

Please note reviews of Introduction to Microsoft Excel are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Intermediate Microsoft Excel by Insight IT Training Limited on Hotcourses

Ask a question

Get course info