Search results for:
No result found! Try with different keywords!
The event you are looking at is a past event. Check out this upcoming event Excel Intermediate (1 day) happening on Tue Jul 02 2019 at 09:30 am at Canterbury College, New Dover Road, Canterbury, United Kingdom

Excel Intermediate (1 day)


Excel Intermediate (1 day)


The course is intended to provide learners with the confidence and ability to use a wide range of Excel features to get the most out of a complex and powerful tool.

Learners will create calculations, use functions and formula, create dynamic charts and graphs, analyse data, use Pivot Tables, work with multiple worksheets, link files and data, use lookup functions and learn lots of tips, tricks and shortcuts before completing assessments to gain a nationally recognized qualification.

The course offers great skills to learners of all backgrounds and job role and will focus on hands on skills to maximize the learning experience.

Who is it for?

Learners should be familiar with the Windows and Microsoft Office environment and comfortable using a mouse. Learners should have some familiarity with Excel and should be able to enter and edit data, be familiar with cell references and simple calculations and be aware of features such as AutoSum and number formatting.

You will gain the following skills

Using date and time formulas

Using names to simplify spreadsheet formula

Use functions such as average, minimum and maximum to create statistical information

Using more complex formulas and functions to manipulate or summarise data

Use Conditional Formatting to visually enhance your data analysis

Using Paste Special effectively to link to Word or PowerPoint

Using conditional functions such as IF and COUNTIF

Working with multiple worksheets using grouping

Linking formulas across multiple worksheets

Use the Consolidate feature to summarise multiple sheets of data

Protecting worksheets

Create a basic Pivot Table to summarise large sets of data easily

The College has a no refund policy. This does not affect your statutory rights to a refund within 14 days of purchase, and before the course commences.Please submit, in writing, any requests for refunds.The College reserves the right to cancel courses at any time. Please see our Fees Policy for more information.

You may also like the following events from EKC WorkHigher:

Map Canterbury College, New Dover Road, Canterbury, United Kingdom
Event details from Report a problem

Are you going to this event?