Search results for:
No result found! Try with different keywords!
Users
Organizers
Events
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)

Advertisement

Excel Intermediate (1 day)


Introduction

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?

Advertisement