Event photo

Excel Intermediate course

Event type

Information Technology

Event bookings can only be created between

06/01/2020 - 20/02/2020


Excel Intermediate course


Bite Size Lts

Course Documents


What are the benefits?

• This course explains about the count function, how to name cells and use them in calculations.
• It covers how to track data with Conditional Formatting and how to sort, filter data and convert a range of data to a Table.
• Charts and an understanding of how to print exactly what is needed are also included.

Topics covered include:

More functions
• Counta, Count, Countblank and CountIF
• IF Function

Cell and Range Names
• Creating named ranges
• Using & Managing Named Ranges

• VLOOKUP and HLOOKUP Functions

Working with Data
• Conditional Formatting including with formulas
• Sorting and Filtering Data

• Creating Charts
• Chart Formatting Options
• Sparklines

• Printing options
• Setting up Print Areas

Who should attend?

This course is aimed at those who have a basic knowledge of MS Excel and know how to modify data and formulas. They should understand which order calculations are performed in and the difference between relative and absolute formulas.

Occasions for this event

Details about the occasions for this event is shown below. To add or edit occasions click on edit event to the right.

Occasion(s) Weekday Location Location status
Confirmed19/02/2020 09:30 - 12:30 Wednesday Room 2B, 2nd floor, Library Confirmed